select * from (Select a.`postalCode`,a.`uniturl`, `region`, `bathrooms`, `bedrooms`,`registration_number`, `sleeps`,en_US_VRBO as href, `thumbnailUrl`, `headline`, description, `state`, `city`, `country`, `source`, `property_type`, `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 and b.blocked=0 ) 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, 20
Enjoy spectacular 180-degree ocean views from this 3 bedroom, 3700 square foot luxury home in Keauhou Estates on the Big Island of Hawaii. The house has an open floor plan, marble floors throughout most of the main living spaces, and large ...
- 3 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Kailua-Kona
Discover the unique beauty of Hawai’i here at the luxurious Pineapple House. This 3 Bedroom 2 Bathroom home is furnished in true Hawaiian decor and sleeps up to 6 guests for a heavenly tropical vacation. With a multitude of soaring high ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua Kona
