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 '%icc%') AND sleeps>=1 order by rating desc LIMIT 0, 15
International Colony Club 20 is a charming, rustic plantation style cottage in Kaanapali is the perfect place to completely unplug and relax or treat as your home base for all the daytime and nighttime activities of West Maui! With a ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
International Colony Club 34 is a charming and quiet cottage just a short walk to the beach! This quaint vacation home comes equipped with a fully equipped kitchen great for cooking meals to enjoy with the family at the large dining table or ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Lahaina
Imagine a day filled with sun, surf and snorkeling at one of the best spots on Maui, just minutes from your private beach bungalow. After a full day of adventures, retreat to your appointed cottage reminiscent of Maui's "old style" of living. A ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina