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 '%Royal Kahili%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Updated 2 bedroom and 2 bath condo sleeps 6. Located near popular Banyons surf area on Alii Drive. Ocean and pool view from the 4th floor lanai. (Elevator) Full kitchen with everything you need to prepare meals. Outdoor grills near pool and hot...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kailua-Kona
We are renting the unit at this time, in accordance with the Governor's rules of vacation rentals. The pool area is now open again. Please be aware of the travel restrictions when coming to Hawaii, a valid, negative Covid test is required in ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kailua-Kona
Beautiful Ocean Views of Lyman's Bay await you from the lanai of this two bedroom, two bath remodeled vacation home. Comfortably furnished and generously equipped you will ease into the relaxed island lifestyle in no time as you plan your day's ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kailua-Kona