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 (`propertyName` like '%Kamalii%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Villas of Kamalii #27, Princeville
Nestled in the resort community of Princeville are the Villas of Kamalii, a gated complex located across from the Makai Golf Club. Enjoy panoramic mountain and waterfall views from Villa #27, a split-level ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
HI> Princeville
Enhanced COVID cleaning and disinfecting procedures for every check-in.
Villas of Kamalii 40: elegant air-conditioned villa with pool, walking distance to golf, beautifully updated inside, all the amenities you could wish for. The Villas of ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
HI> Princeville
A vision in white, this airy and bright Princeville condominium boasts 3 bedrooms and 3 baths accommodating five guests (K,K,T) in a multi-level configuration, making it an ideal property for couples or families traveling together. Enter and be ...
- 3 bedroom
- 3 bathroom
- Sleeps 5
HI> Princeville
The Villas of Kamali`i at Princeville is a luxury townhouse style resort located at Princeville Resort on Kauai’s lush North Shore. Very similar in design to the Villas on the Prince, these two and three bedroom townhouse style units are ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
HI> Princeville
Villas of Kamalii is a new, quality constructed, premier gated community in Princeville. Villa #47 has unobstructable waterfall and mountain views that will simply amaze. The Mokihana floor plan is an 1825sf split-level layout featuring a ...
- 3 bedroom
- 3 bathroom
- Sleeps 7
HI> Princeville
The Villas of Kamali`i at Princeville is a luxury townhouse style resort located at Princeville Resort on Kauai’s lush North Shore. Very similar in design to the Villas on the Prince, these two and three bedroom townhouse style units are ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
HI> Princeville
The Villas of Kamali`i at Princeville is a luxury townhouse style resort located at Princeville Resort on Kauai’s lush North Shore. Very similar in design to the Villas on the Prince, these two and three bedroom townhouse style units are ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
HI> Princeville
The Villas of Kamali`i at Princeville is a luxury townhouse style resort located at Princeville Resort on Kauai’s lush North Shore. Very similar in design to the Villas on the Prince, these two and three bedroom townhouse style units are ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
HI> Princeville
The Villas of Kamali`i at Princeville is a luxury townhouse style resort located at Princeville Resort on Kauai’s lush North Shore. Very similar in design to the Villas on the Prince, these two and three bedroom townhouse style units are ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
HI> Princeville
Enhanced COVID cleaning and disinfecting procedures for every check-in.
Villas of Kamalii 37 offers elegance, convenience, and amenities. This 1800sf townhouse is a golfer's paradise, adjacent to the Makai course and just a couple minutes walk ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Princeville
The Villas of Kamali`i at Princeville is a luxury townhouse style resort located at Princeville Resort on Kauai’s lush North Shore. Very similar in design to the Villas on the Prince, these two and three bedroom townhouse style units are ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
HI> Princeville
Enjoy relaxed elegance and serene mountain views at the lovely Villa of Kamalii #35! This spacious three-bedroom, three-bath townhouse-style condo in Villas of Kamalii provides the perfect setting for a tranquil Hawaiian getaway.
Villa #35 ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
HI> Princeville
