select * from (Select a.`postalCode`,a.`uniturl`, `region`, `bathrooms`, `bedrooms`,`registration_number`, `sleeps`,en_US_VRBO as href, `thumbnailUrl`, `headline`, description, `state`, `city`, `country`, `source`, `property_type`, `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, rewritten_description,
(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 and b.blocked=0 ) 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, 50
Welcome to the Royal Kahili! This is our home for 3-4 months out of the year, so it is comfortable and well appointed for your stay.
Extensive renovations to the unit. It is gorgeous! New kitchen and guest bath, fresh paint and
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kailua-Kona
Royal Kahili B202
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Set in the Royal Kahili complex, this condo is just half a mile from a
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua-Kona
Welcome to Royal Kahili 401A by Gather
Discover oceanfront luxury at its finest with Royal Kahili 401A by Gather, a stunning 2-bedroom, 2-bathroom top-floor corner suite in Kailua-Kona. Thoughtfully designed for travelers seeking elegance
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kailua Kona
