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, rewritten_description,
(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 (`propertyName` like '%Kamalii%') AND sleeps>=1 order by rating desc LIMIT 0, 50
This bright, spacious three-bedroom, three-bathroom townhome is located at Villas of Kamalii, in the prestigious resort community of Princevile. Perched on the highest part of world-famous Makai Golf Course, enjoy stunning mountain and waterfall
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Princeville
Professional photos coming soon.
Located in the resort community of Princeville are the Villas of Kamalii, a gated complex located across from the Makai Golf Club. Enjoy lush garden, mountain and waterfall views from Villa #29, an end
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Princeville
Welcome to your dream vacation home at Villas of Kamali'i #27, a luxurious tri-level townhome nestled within a private and gated community on the stunning island of Kauai. This newly updated and elegant air-conditioned villa is in an upscale
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Princeville
Overlook the lush greens and fairways of the Makai Golf Course from the many large windows or step out to the lanai to enjoy this beautiful view amid gentle trade winds.
This home is beautifully furnished for your comfort and enjoyment.
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Princeville
Discover the ultimate in island living at this meticulously maintained 3-bedroom, 3-bathroom townhome in the exclusive, gated Villas of Kamalii. Presented by Hawaii Life Real Estate Services, this residence offers a rare blend of luxury and
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Princeville
Tucked in the resort community of Princeville are the Villas of Kamalii, a gated complex located across from the Makai Golf Club. Enjoy lush garden, mountain and waterfall views from Villa #23, an end unit, split-level townhouse with over 1,800
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Princeville
Important Notice: Scheduled Water Shutoff
The second and final valve replacement is scheduled for January 29th, 2025, from 8:00 AM to 4:00 PM. Water service will be temporarily unavailable during this time, so please plan ahead by filling
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Princeville
