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 Mansions%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Please review and understand our cancellation policy before booking. We strongly suggest you to buy Travel Insurance to protect yourself in the situation where you are not entitled to receive any refund if you cancel.
Situated in central ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
HI> Kailua-Kona
Craving ocean views that whisk you away from the hustle and bustle of your day-to-day life? Longing to wake up with a cup of freshly brewed Kona coffee with sights of breaching humpback whales and jumping spinner dolphins in the distance? When ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kailua-Kona
Knutson & Associates is proud to be newly representing a spectacular new addition to our Vacation Rental Inventory.
Kona Mansions#229 is a wonderfully appointed property that has a phenomenal location.
Stunning ocean views, just steps from ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kailua Kona
