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 = 'haena' OR postalCode = 'haena' OR region like '%|haena|%') AND sleeps>=1 order by rating desc LIMIT 0, 15
This is a legal permitted vacation rental. Permit #TVNC-5151.
See the actual cancellation policy and refund policy in "house rules" and on the rental agreement. Please send us the ages of all the people that will be staying at the house in ...
2 bedroom
2 bathroom
Sleeps 6
HI> Haena
Hale Kahakai - TVNCU# 5146
Come experience the beautiful garden isle of Kauai at Hale Kahakai! Hale Kahakai; which means house by the seashore, is a beachfront home that features spectacular ocean views from the Lanai. Experience the leisure of...
3 bedroom
2 bathroom
Sleeps 6
HI> Haena
Please inquire about The State of Hawai‘i Safe Travels Hawai‘i program and the requirements for traveling to Kauai as it does change.
This 3+ bedroom beach home sits on a beautiful sandy north shore beach just around the corner from famous...
3 bedroom
2 bathroom
Sleeps 8
HI> Haena
Kauai's North Shore has been a frequent backdrop for countless movies due to its incredibly lush beauty and phenomenal beaches. Nestled within this gorgeous, pristine expanse, lies Haena Kai. Set back just thirty paces from a soft, deserted, ...
3 bedroom
2 bathroom
Sleeps 7
HI> Haena
This is a legal permitted vacation rental. Permit #TVNC-1058
Please see our rental agreement for ACTUAL CANCELLATION POLICY and REFUNDS.
Please send us the ages of all the people in the party, including children in your inquiry.
We prefer ...
3 bedroom
2 bathroom
Sleeps 5
HI> Haena
Hale Pua Kai ... TVNCU #1218
This cozy and comfortable Hawaiian style redwood home is just a short walk to miles of sandy beach. The house is surrounded by lush, tropical gardens. Two lanais let you enjoy paradise in comfort and privacy. A ...
1 bedroom
2 bathroom
Sleeps 2
HI> Haena
Haena Sunrise ... TVNCU #5136
Live the ultimate Kauai experience in this luxe and spacious 3-bedroom, 2-bath airy tropical house
Designed from the ground up as the ultimate tropical vacation home, this three-bedroom, two-bathroom home in the ...
3 bedroom
3 bathroom
Sleeps 6
HI> Haena
Kepuhi Hale
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Come experience paradise at Hale Kepuhi! you will definitely get your fill of salty air and ...
3 bedroom
3 bathroom
Sleeps 6
HI> Haena
TVNC #4291
TMK # 5-8-8-21
This Classic Hawaiian Hale (home) is less than a minute walk to Kepuhi Beach…very close. Enjoy your vacation and experience a timeless era long gone when there was a sense of peace and tranquility and the sounds are...
4 bedroom
4 bathroom
Sleeps 9
HI> Haena
Please inquire about The State of Hawai‘i Safe Travels Hawai‘i program and the requirements for traveling to Kauai as it does change.
Step back in time to a slower pace at Hale Ho’olapanai . This 2-bedroom beach cottage sits on a one-acre...
2 bedroom
1 bathroom
Sleeps 4
HI> Haena
Enjoy the very best at Hale o?Mahina at Ha?ena (The House of the Moon at Ha?ena) This upgraded home with Koa wood and Bamboo accents, is nestled on a quiet street with ocean and mountain views. Step outside your door and walk to one of the most ...
3 bedroom
3 bathroom
Sleeps 6
HI> Haena
Waiohonu ... TVNCU #1144
Lush, tropical foliage and spacious grounds surround this delightful, beachfront home. It exemplifies the tranquility for which Kauai's north shore has long been valued. Vaulted ceilings add a spacious feel to the large...
2 bedroom
2 bathroom
Sleeps 4
HI> HAENA
Enjoy the very best at Ha?ena Place, one of the North Shores hidden gems! Tucked away on a quiet cul-de-sac, and short walk to Kauai's best beaches, this private home has everything you need for the perfect island escape! Iconic surf and ...
2 bedroom
1 bathroom
Sleeps 4
HI> Haena
