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 '%kamahana%') AND sleeps>=1 order by rating desc LIMIT 0, 20
Completely remodeled two bed, two bath private condo. It is aspected towards the golf course and feels more like a home than a condo. Open main living area with incredible tradewind breezes and a a large covered lanai. The kitchen boasts modern ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Princeville
Kamahana #7 is a spacious home, ground floor, end unit with garden views. There is no other condo in Princeville that will offer you the joy of sunrises, the bluff top beauty, the green space of the Makai golf course, and albatross and Nene ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Princeville