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 Estates%') AND sleeps>=1 order by rating desc LIMIT 0, 15
For safety and cleaning purposes we have decided to leave a minimum of five days between all rentals. If two or more inquiries are received that would not allow such an interval I will discuss that with the parties making the inquiries. Thank ...
- 3 bedroom
- 4 bathroom
- Sleeps 8
HI> Kailua-Kona
Come see for yourself why the Big Island is the best kept secret in Hawaii. The largest island in the chain, it is the quintessential tropical paradise with something for everyone.
This completely renovated 3,500 square foot, five-bedroom ...
- 5 bedroom
- 4 bathroom
- Sleeps 12
HI> Kailua-Kona
Keauhou Estates Hale Kuhinanui Way is a Luxury Home located within the gated community of the prestigious Keauhou Estates. Enjoy the gorgeous view of the Pacific Blue from this home while relaxing at your private pool. The pool area is equipped ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
HI> Kailua Kona
Make lasting memories while luxuriating on your dream vacation in this custom built, eco-friendly, solar home in beautiful and secure Keauhou Estates on the Island of Hawaii. Hawaii ( also called the Big Island) has been hailed as the world's ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
HI> Kailua Kona