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 '%launiupoko%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Kalapana is truly “Privacy in Paradise” as the home is surrounded by 1.5 acres of lush tropical gardens and fruit trees, in the beautiful neighborhood of Launiupoko, Lahaina. This luxury home is fully air-conditioned, and features an ...
- 3 bedroom
- 4 bathroom
- Sleeps 6
HI> Lahaina
One of West Maui's most exclusive legally permitted rental properties, the Makena Aloha Estate offers exceptional ocean and mountain views, with gated exclusive privacy and seclusion. With 4,400 square feet of interior dwelling space, this ...
- 4 bedroom
- 4 bathroom
- Sleeps 10
HI> Lahaina
