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 (city = 'Wainiha' OR postalCode = 'Wainiha' OR region like '%|Wainiha|%') 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 Colony Resort # G1 condominium ...
1 bedroom
2 bathroom
Sleeps 4
HI> Wainiha
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.
Hale Kalani is a Beachfront, 2 bedroom, ...
2 bedroom
2 bathroom
Sleeps 4
HI> Wainiha
**As of November, 2017 Kauai Tree House has a new dining room table, Master bedroom set, livingroom sectional and newly painted rooms.
This 3 bedroom home is fully furnished including linens, games, videos and music, with I-pod friendly stereo ...
3 bedroom
2 bathroom
Sleeps 7
HI> Wainiha
Traveling north past Hanalei, you enter the dense jungle and intense blue waters of Kauai's far north shore. There are no words that can describe nature's beauty in this region. Many beaches, including tunnels and ke'e, are in the area. Trail ...
3 bedroom
2 bathroom
Sleeps 6
HI> Wainiha
Your Kaua'i adventure awaits! Private north shore home, steps from beach. This 3 bedroom, 3.5 bathroom vacation home is light, spacious, and comfortable with everything you will need for a relaxing and enjoyable Kaua'i vacation. All bedrooms ...
3 bedroom
4 bathroom
Sleeps 6
HI> Wainiha
