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 '%Kailua Bay Resort%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Centrally located in the heart of downtown Kona, never be far from the fun with this beautiful 2nd floor unit in Kailua Bay Resort. This 1 bed 1 bath unit has everything you need to make your trip to the Big Island memorable. Just a short walk ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Kailua-Kona
Say “aloha” to unbeatable ocean views from your private lanai at this Kailua-Kona vacation rental condo! Nestled in the heart of Kona town, this 2-bedroom, 2-bath unit offers up to 5 guests a prime location just a short walk from ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
HI> Kailua Kona
