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 '%Sandpiper%') AND sleeps>=1 order by rating desc LIMIT 0, 15
This newly renovated spacious 1 BdRm condo with Master bedroom and 1.5 bathroom plus loft is located in the Resort Community of Princeville. Relax with your morning coffee on the large lanai before heading out to enjoy your Kauai day. This condo...
- 1 bedroom
- 2 bathroom
- Sleeps 2
HI> Princeville
Sandpiper #116
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Perfect for families or couples vacationing together, this unit combines both units A & B ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Princeville
Welcome to Sandpiper Village . Located up on the beautiful North Shore. Its located within walking distance to Swimming, Snorkel and Surfing Beaches, Golf courses and Tennis courts, Resturants and Shopping. Inside you will enjoy the King Sized ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Princeville
Studio with queen bed (and twin air mattress available upon request). Totally renovated in 2018 with new floors, new tiled shower, new vanity, new interior paint, new ceiling fan, new furniture (from Pier1). Studio has small refrigerator, ...
- 0 bedroom
- 1 bathroom
- Sleeps 3
HI> Princeville
Aloha from the spectacular North Shore of Kauai, The Garden Island! Our multi-story tropical retreat features a light filled living room/dining and loft with vaulted ceiling, fully appointed kitchen, furnished lanai with outdoor dining, king ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
HI> Princeville
SandPiper #116a
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Enjoy all Kauai has to offer in this well-located condo at the entrance of the Princeville...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Princeville
Our 1Bdr/1Ba- #212-B (PRIVATE ENTRANCE and RESERVED PARKING SPACE, AIR CONDITIONING) w/cathedral ceilings is newly renovated with TILE floors (light&bright!), deep stainless steel sink w/ granite counter top, 40"flat screen w/blu ray, dvd, ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Princeville
Beautifully updated (Summer 2021) one bedroom one bathroom condo. New floors, paint, shower, counter tops, ceiling fans. New solid wood bedroom set. Modern, clean, with all the comforts of home. It has a (California) king bed and a queen ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Princeville
The 1Bed/1Bath (A) Unit sleeps 2 people. It comes with with a king bed, fully equipped kitchen, washer and dryer, TV with cable, And free WIFI. We supply bath and beach towels. There is a dedicated parking space, a newly renovated pool/jacuzzi ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Princeville
Our 1BR condo is beautifully appointed giving guests a wonderfully tropical 'sense of place' to help renew, refresh and relax one's mind and body. Featuring one bedroom (Cal King) with flat screen TV, en suite bathroom, lanai, full kitchen, ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Princeville
Sandpiper #105b
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Stay with simplicity at this cozy studio located in the heart of Princeville. Spend your ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Princeville
The Studio Unit sleeps 2 people and has a brand new renovated shower. It is furnished with a king bed, table and chairs inside and on the private lanai, small fridge, microwave, coffee pot, TV with Cable, WiFi, dishes, and bath and beach ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Princeville
Please stay informed about KAUA'i "Safe Travel", constantly changing, pre-trip testing, travel and quarantine policies!
Our lovely second, floor, one bedroom studio unit (as with many other units in our price range) doesnʻt provide A/C. We've...
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Princeville
Discounts available based on length of stay. The condo has ceramic tile flooring throughout and walk-in porcelain tiled showers in both bathrooms, with the kitchen counter and master bath vanity tops tiled as well. Kitchen appliances include ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Princeville
Sandpiper #116b
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Plan a fun getaway at this cozy studio tucked into the front of Princeville. You'll have ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> Princeville
