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 '%kamahana%') AND sleeps>=1 order by rating desc LIMIT 0, 15
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 your ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Princeville
Kamahana 3 is a spacious two bedroom, very private condominium offering 1260 square feet that feels more like a house than a condo. This ground floor unit features extra-high vaulted ceilings and three private lanais. This condo is unique ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
HI> 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 ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
HI> Princeville