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 '%Plantation at Princeville%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Offering one of the newest retreats in Princeville, these luxurious air conditioned Kauai vacation rentals offer spacious layouts, covered lanais, a private resort swimming pool, multiple community BBQs, an on-site fitness room, a small meeting ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Princeville
Aloha & welcome to Hale Kai Lani, #1511, our slice of paradise! Located on the North Shore, Princeville is the perfect spot for your Kauai vacation.
This ground level end unit is homey, comfortable and serene. Our condo has a unique ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Princeville
Nestled between mountains and sea on Kauai’s spectacular north shore, our family's condo welcomes you. Savor the Polynesian elegance and comfort of this charming & spacious townhouse, where you’ll enjoy lush, tropical surroundings with ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Princeville
Offering one of the newest retreats in Princeville, these luxurious air conditioned Kauai vacation rentals offer spacious layouts, covered lanais, a private resort swimming pool, multiple community BBQs, an on-site fitness room, a small meeting ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
HI> Princeville
Offering one of the newest retreats in Princeville, these luxurious air conditioned Kauai vacation rentals offer spacious layouts, covered lanais, a private resort swimming pool, multiple community BBQs, an on-site fitness room, a small meeting ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
HI> Princeville
Offering one of the newest retreats in Princeville, these luxurious air conditioned Kauai vacation rentals offer spacious layouts, covered lanais, a private resort swimming pool, multiple community BBQs, an on-site fitness room, a small meeting ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Princeville
Come stay at the coveted North Shore of Kauai!
This is a 3 Bedroom 3 Bathroom highly sought after condo at the Plantation at Princeville.
Our unit is air conditioned throughout.
The master bedroom includes a king bed and a spacious on-suite ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
HI> Princeville
