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 (`propertyName` like '%Sandpiper%') AND sleeps>=1 order by rating desc LIMIT 0, 30
Clean, modern 1 bedroom, (King bed + queen sofa sleeper + queen air mattress), 1 bathroom condo with assigned parking, pool, hot tub, and bbqs on site. Condo was renovated in 2018 - retiled, cabinets painted, new floors, new interior paint, new ...
- 1 bedroom
- 1 bathroom
- Sleeps 6
Hawaii> Princeville
You will not share the space with anyone else. Private entrance and private Lanai. A first floor level Studio sleeps 2 guests. There is a queen size bed with Bamboo Sheets. All linens are provided and there are plenty of them!!
Princeville is...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> 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
Hawaii> 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
Hawaii> Princeville
Clean, modern, studio with kitchenette. Completely renovated December 2018 - everything is new including floors, cabinets, interior paint, shower, vanity, fixtures, ceiling fan, furniture...
There is a comfortable queen bed and an air ...
- 0 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Princeville
Our lovely second floor studio unit now provides A/C. We've installed a high-velocity ceiling fan that seems to do the trick when AC isn't needed! The covered lanai has a view of the mountains and lush tropical plantings. Free, limited, ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Princeville
Enhanced COVID cleaning and disinfecting procedures for every check-in.
Sandpiper 120A, as seen on HGTV's "Hawaii Life": Enjoy a quiet retreat in this attractively decorated, ground floor condo in Sandpiper Village Princeville. This Kauai...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Princeville
Enhanced COVID cleaning and disinfecting procedures for every check-in.
As seen on HGTV's "Hawaii Life," Sandpiper 120B is a charming - and affordable - Kauai vacation rental studio with a private garden-level lanai surrounded by tropical...
- 0 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Princeville