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, 20
Clean, modern 1 bedroom, (King bed + queen sofa sleeper), 1 bathroom condo with assigned parking, pool, hot tub, and bbqs on site.
Close to beaches, shopping, dining, golf, hiking, parks and more. Located in Sandpiper Village, which is ...
- 1 bedroom
- 1 bathroom
- Sleeps 6
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
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
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, ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Princeville