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 '%Keauhou Akahi%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Keauhou Akahi is a small complex near the village of Kailua-Kona on the Big Island of Hawaii. This one bedroom, third floor condo has a beautiful ocean view and overlooks the ninth tee of the Kona Country Club and Keauhou Bay. The condo is ...
- 1 bedroom
- 2 bathroom
- Sleeps 5
HI> Kailua Kona
This Keauhou Akahi condo with beautiful sweeping ocean views overlooks the newly resurfaced Akahi swimming pool and 9th tee of the famous Kona Country Club Golf Course. Accommodated with flat-screen HD Cable TV, high-speed internet, ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Kailua-Kona
Welcome to Keauhou Akahi, a spacious condo with beautiful, sweeping ocean views overlooking the renowned Kona Country Club Golf Course. Appointed with a large lanai, living area, and sleeping accommodations for up to 6 guests, there is plentiful...
- 1 bedroom
- 2 bathroom
- Sleeps 6
HI> Kailua Kona