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, 30
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
This two bedroom, two full bath, Kauai vacation rental in the intimate and tranquil Kamahana Princeville Kauai complex offers ground floor convenience and the privacy of an end unit. Kamahana 23 features ocean, mountain, and golf course views, ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Princeville
Enhanced COVID cleaning and disinfecting procedures for every check-in.
This two bedroom, two full bath, upper floor end unit at the edge of the Kamahana complex features ocean, mountain, and golf course views from each room. As you end ...
- 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