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,
(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 (`headline` like '%Plantation at Princeville%') AND sleeps>=1 order by rating desc LIMIT 0, 50
First time on the vacation rental market!!this lovingly maintained & well appointed family home is the perfect spot for your island vacation!
Bright and airy, ground level condo with attached one-car garage in the desirable Plantation ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Princeville
Nestled between mountains and sea on Kauai’s spectacular north shore, our family's air conditioned condo welcomes you. Savor the Polynesian elegance and comfort of this charming & spacious townhouse, where you’ll enjoy lush, tropical ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> 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
Hawaii> Princeville
The Plantations at Princeville Resort is a gem on Kauai’s North Shore! Within walking distance to beaches, restaurants, shopping, and world-class golf, it’s just a short drive to picturesque Hanalei Bay. This peaceful complex features ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> 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 ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Princeville