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 '%Hanalei Bay Villas%') AND sleeps>=1 order by rating desc LIMIT 0, 15
All travelers are responsible for investigating all travel restrictions to Kauai. Travelers are advised that travel restrictions to Kauai may be different than travel requirements to the State of Hawaii.
Hanalei Bay Villas #17 is a recently ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
HI> Princeville
Enhanced COVID cleaning and disinfecting procedures for every check-in.
Hanalei Bay Villa 26 is one of our most popular Kauai vacation rentals with its great views, short walk to beach, and updated interior. Bail Hai sunset views are just steps...
- 2 bedroom
- 3 bathroom
- Sleeps 4
HI> Princeville