select * from (Select a.`postalCode`,a.`uniturl`, `bathrooms`, `bedrooms`,`registration_number`, `sleeps`,en_US_VRBO as href, `thumbnailUrl`, `headline`, description, `state`, `city`, `country`, `region`, `source`, `property_type`, `location_type`, `suitability`, `features`, `address`,round(price) as price,minimum_nights, `rating`, `review_count`,`latitude`, `longitude`,case when propertyName='' then trim(address) else CONCAT(CONCAT(propertyName,'(',trim(address)),'',')') end as addre,propertyName,
(6371 *
acos(
cos( radians( 21.2759167 ) ) *
cos( radians( `latitude` ) ) *
cos(
radians( `longitude` ) - radians( -157.8233677 )
) +
sin(radians(21.2759167)) *
sin(radians(`latitude`))
)
) as distance from `vacationrentalindex` a inner join vacationrentalindexfeed b on a.uniturl=b.unitUrl and a.headline!='' and a.thumbnailUrl!='' and b.enabled=1) as vw where 1 and round(price)>0 and bedrooms>=0 AND (`headline` like '%Kapalua Resort Villa%') AND sleeps>=1 order by rating desc LIMIT 0, 15
E Komo Mai. O Kou Hale Kou Hale
Welcome to our Kapalua Resort Villa with panoramic ocean and sunset views! The Ocean Views are breathtaking from the moment you enter the front door. Explore one of the best beaches in the world and wonderful ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Kapalua
Enjoy the inherent richness of beauty and culture that embellishes what we know today as the Kapalua Resort. From snorkeling with the sea turtles in white sandy beaches with pristine waters, or taking in the beautiful views while whale watching ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Lahaina
