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 Punahele%') AND sleeps>=1 order by rating desc LIMIT 0, 15
WOW! Incredible Upgrades made in 2021! The owners put a lot of love into this unit.
Keauhou Punahele#E-102 is a beautiful ground floor 2 bedroom, 2 bathroom condo with approximately 1200 interior sq feet. It sits right on Keauhou Country Club ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kailua Kona
Hawaii, Big Island, Kona, Keauhou Punahele, golf course with the ocean in the background. The condo is located close to Keauhou Bay, Keauhou shopping center (with cinema) and snorkel/surfing beaches.
We have owned this top floor 3 bedroom/3 ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
HI> Kailua-Kona
The key to your amazing tropical getaway awaits! This 2 bedroom 2 bath unit is the ideal spot for your family or small group. With beautiful views of the surrounding Kona Country Club and ocean beyond, never forget where you are in your own ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kailua Kona
