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 '%Kona Bay Estates%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Ocean Front Villa featuring popular, island comfort, furnishings with unobstructed ocean views. The latest and best in design, style and fixtures are found throughout the villa. Enjoy fresh island produce and seafood in your well stocked ...
- 4 bedroom
- 4 bathroom
- Sleeps 8
HI> Kailua-Kona
This amazing Ocean Front 3 bedroom, 2.5 bath Home in Kona Bay Estates, is located on Keiki Beach.
When you come to Hawaii you want to be on the ocean and be able to get into the water. Our luxury 3,070 square foot home is located on the most ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
HI> kailua-kona
This vintage Hawaiian beach house is nestled in a private gated community of Kona Bay Estates. The simple seaside style will melt all of your cares away as you sip on your Mai Tai in the cool shade of the deep, covered lanai. Experience the feel...
- 3 bedroom
- 3 bathroom
- Sleeps 8
HI> Kailua-Kona
