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 '%Kamalii%') AND sleeps>=1 order by rating desc LIMIT 0, 15
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
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