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 '%Wyndham Ka%') AND sleeps>=1 order by rating desc LIMIT 0, 15
2br 2ba condo in peaceful complex. Wyndham Kai Eo Kai. Very nice property, comfortable units fully equipped for family vacation.
Registration will require ID at check-in and credit card to cover Hawaii lodging tax ($9/pn)....
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Princeville
Concierge Realty is proud to present luxury villas at this beautiful location.
ARRIVALS ARE FRIDAY, SATURDAY, SUNDAY AND MONDAY ONLY. RESERVATIONS AVAILABLE IN SEVEN NIGHT INCREMENTS ONLY.
Overlooking Anini Bay, Wyndham Ka Eo Kai perfectly ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Princeville
