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 (city = 'Hanalei' OR postalCode = 'Hanalei' OR region like '%|Hanalei|%') AND sleeps>=1 order by rating desc LIMIT 0, 50
Capture the magic of this romantic cottage. Large picture windows, open beam ceilings and sky lights bring views of lush tropical gardens with towering Cook pines. Two covered lanais for pupus, mai-tais and outside dining. After an ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Hanalei
Totally remodeled, updated - all new furniture, fixtures, finishes.
TVNC - 5119
This vacation rental is located in Hanalei which is in the tsunami evacuation zone.
The house is in the quintessential beach town of Hanalei. ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Hanalei
Just across the street from the sand, Hale Hoku is a 5 bedroom/4 bathroom beach cottage with a sunny and open floor plan. Built up on post and pier, it is as if you are residing in your own private and breezy treehouse!
Three master ...
- 5 bedroom
- 4 bathroom
- Sleeps 12
Hawaii> Hanalei
Welcome to your dream retreat in Hanalei, Kauai, nestled on the iconic Weke Road mere moments away from renowned surf spots like Pinetrees, Hanalei Pavilion, and Hanalei Pier. This two-story haven boasts four bedrooms and three full baths, ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Hanalei
Wake up in a Hanalei postcard setting at this extraordinary 3-bedroom, 2-bathroom beach home.
You may think you’re dreaming when you open your eyes to picture-perfect views of Hanalei’s lush greenery and vivid blue skies outside your...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Hanalei
Indulge all your senses from this ocean-view, 3-bedroom, 2-bath Hanalei beach home.
If you were any closer to the waves of Hanalei Bay, you’d need flippers. You’ll hear the surf from every room in this three-bedroom, two-bath beach ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Hanalei
Located in the quaint and historic beach community of Hanalei Bay, this comfortable Kauai vacation home offers its guests a spacious and relaxing place to settle in and enjoy beach life. Hale O’Kale is walking distance to all of Hanalei town ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Hanalei
Hokulele Hale is a three-bedroom two bath single family home.
This home is located at the end of a quiet cul-de-sac just 125 yards from the famous Hanalei Bay Beach. The property is set back from the street on a flag lot and is adjacent to ...
- 4 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Hanalei
Upgraded in 2019, Hale Ka Mahina isn't your average vacation rental, Hale Ka Mahina is tucked away on a side street between Hanalei Bay and Hanalei town. Easily walk or ride bikes to the beach and town when you want to check the surf or grab a ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Hanalei
We've provided all the comforts of home on 'The Garden Island' of Kauai, one of the world's most spectacular settings. This charmingly furnished house, with traditional Hawaiiana decor and lanais, is surrounded by a lush tropical garden. The ...
- 5 bedroom
- 4 bathroom
- Sleeps 10
Hawaii> Hanalei
Note: Our transient vacation home is located in a Tsunami Evacuation Zone. In an event of a Tidal Wave, evacuate to higher grounds. We also incur occasional bridge closer due to flooding of Hanalei roads. Access to our vacation home may be ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Hanalei
If you are staying on Kauai there is not a better location then right in Hanalei. Voted one of the top beaches in the world it truly is one of the most beautiful places you will ever visit. As for homes in Hanalei, you will not find any home ...
- 4 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Hanalei
This newly remodeled beach house is a minute walk to the beach. It revolves around a great room of kitchen, living room and dining room. It's perfect for eating, drinking and hanging out after a day at the beach. There is also a very large ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Hanalei
TVNCU number # 5150
Wailele Ikena (The Simpson House)... Hanalei Bay, Kauai, Hawaii. Hanalei has it all! Breathtaking views of dozens of cascading waterfalls, sheer cliff, ancient volcanic mountains covered with vegetation, and one of the ...
- 5 bedroom
- 4 bathroom
- Sleeps 10
Hawaii> Hanalei
*TVR Registration #TVNC 5132 *
*Take a MUST SEE DRONE TOUR for the whole experience... https://youtu.be/9anBVNOjN-A
Welcome to The Guest House at River Estate….
The River Estate...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Hanalei
Mana Kauai Island Vacations Presents Holo Makani!
The gated estate of Holo Makani is located in the sand on a dramatically beautiful and pristine beach on Kauai's North Shore coast line. Enjoy the lull of the ocean and the gentle trade winds...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Hanalei
Exclusive Luxury Beachfront Home located around the point from Tunnel’s Beach.
More secluded not so populated gorgeous beach which is just a beach walk from Tunnels.
Imagine an island, a lush green paradise in the far-off reaches of ...
- 5 bedroom
- 6 bathroom
- Sleeps 12
Hawaii> Hanalei
Mana Kauai Island Vacations presents the charming Palaka Cottage!
Recapturing bygone days, the completely renovated 2 bedroom 1 bath "Palaka" Vacation Cottage draws one back to the days of the sugar industry's plantation cottages. With ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Hanalei
NOTE: This transient vacation home is located in the tsunami evacuation zone.
TVNC-1198 / TMK: 5-5-01002067R-4/ Tax ID# TA-140-845-6704-01/TA-005-027-2256-01/GE-140-845-6704-01/GE-005-027-2256-01: Walking distance to beautiful Hanalei Bay...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Hanalei
The Old Style is a stand alone beach house just steps from the sand as seen above (Standard occupancy is 2*). There is lots of light, great views & a very restful feeling. Single wall redwood was the preferred building style back in the day. It ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Hanalei
Na Hoku is the upstairs of a beach house duplex. There are two bedrooms, one bath, a kitchen, dining area and living room (Standard Occupancy is 4*). There is a good sized covered lanai and great ocean views from the living room and the lanai. ...
- 3 bedroom
- 1 bathroom
- Sleeps 5
Hawaii> Hanalei
Hale Kanani is NEWLY renovated inside and out! With fresh paint, brand new cabinetry, vanities, quartz countertops and flooring throughout, as well as a new high-performance washer and dryer, on-demand water heater and dishwasher, this ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Hanalei
Just a three minute walk to the beach and town. Two-bedroom, two-bath, vacation home is located on a quiet cul-de-sac in the quaint beach town of Hanalei on Kauai's beautiful rural North Shore. It features natural wood ceilings and walls, one ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Hanalei
Mana Kauai Island Vacations present the charming Umetsu Cottage!
Welcome to our idyllic one bedroom, one and a half bath cottage at the Hanalei Bay. This remodeled beach cottage reflects the era of Old Hawaii. Located steps from the iconic ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Hanalei
*TVR Registration #TVNC 1279 *
*Take a MUST SEE DRONE TOUR for the whole experience... https://youtu.be/9anBVNOjN-A
Welcome to The Riverhouse at River Estate….
The River Estate ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Hanalei
TVNCU-1105 - TA# 168-945-4592-01
Enjoy watching the surf, sunsets and a view of Hanalei Pier from the deck of this great family-friendly oceanfront location. This is a special heritage Hanalei home, steeped in history, reflecting a taste of ...
- 6 bedroom
- 3 bathroom
- Sleeps 10
Hawaii> Hanalei
TVNCU-1226 TA #189-999-3088-01 - "Heavenly Rose"
Lokelani is a spacious and unique home with 3 bedrooms and 3 full baths, sleeping up to 6 people comfortably. The open plan living area sweeps from the kitchen, past the living room (with wall...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Hanalei
Paulele is a beautiful Hawaiian-style home right on the closest beach road (Weke Rd.) on breathtaking Hanalei Bay! This tasteful and comfortable home has four bedrooms, five baths, a fully-equipped kitchen, and it comes with everything you’ll ...
- 4 bedroom
- 5 bathroom
- Sleeps 8
Hawaii> Hanalei
This amazing and completely refurbished home is situated on a stunningly beautiful one-acre, gated OCEANFRONT estate property, right in the middle of magical Hanalei Bay. It is, in fact, one of the ONLY vacation rental cottages on beachfront ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Hanalei
Hale Huna ('Hidden House') is a wonderful cottage on a hillside near the end of the road on the North Shore of Kauai. Located on hill and a quiet cul-de-sac with only a few other local houses. Very private and peaceful (It is NOT on/near the ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Hanalei
A relaxing Hanalei Vacation can be yours at Hale Ylang Ylang. Steps to the beach and near the heart of Hanalei, this luxury two bedroom townhome has views of the ocean and our north shore mountains.
Relax in this comfortable home in...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Hanalei
Kuuipo Hale is the Sweetheart of Hanalei! This 3 bedroom/2 bath plantation style home is a super cute, beach house located right in Hanalei - a super short walk to the beach and just a few blocks to town. Bedding configuration is: 1 King, 1 ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Hanalei
Vacation 'Hawaiian Style' with Beautiful Naue Beach right outside your door. This home has a premium ocean/beachfront location right at Naue Beach. You are surrounded by North Shore beauty. No parking worries for you. It is perfect for ...
- 4 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Hanalei
One Hanalei
Permitted Vacation Rental Property - TVNC#1168
Transient vacation rental is located in the tsunami evacuation zone
One, meaning Sand in Hawaiian, is a family beach house, named after the owner’s mother Sandy and the ...
- 4 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Hanalei
TVNCU#1059 - TA# 121-109-0944-01 - "House with the Cooling Breeze"
A true oasis, Hale Koaniani is a meticulously cared for three bedroom, two and a half bath home and a rare find on Kauai's spectacular North Shore. It’s elegantly ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Hanalei
Welcome to your dream getaway at Hale Maile in Hanalei—an adorable two-bedroom, two-bath home nestled in the heart of Hanalei, a paradise on the island of Kauai. Prepare to be enchanted by the undeniable charm, comfort, and beauty that awaits ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Hanalei
Enjoying a prized location among the closest legal vacation rentals to picturesque Tunnels Beach, Hallor Hale is situated on a quiet cul-de-sac, surrounded by a large lawn and tropical vegetation. Within this tranquil setting on Kauai's ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Hanalei
Step back in time in this charming cottage by the beach. Built in the 1920's, this plantation style home will give you a true Hanalei experience. Just steps to the beach and a short stroll or bike ride to many restaurants and shopping. This is ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Hanalei
Hawaiian Island Beachfront cottage with an incredible location on the North Shore of Kauai in between Hanalei and Haena close to Tunnels. The 3/4 acre property features a large sandy beach point. Some of the islands best snorkeling and shelling ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Hanalei
TVNC-1238
A classic Hawaiian style home, this Haena beach house, known as Hale Pulelehu'a (The Butterfly House), is a wonderful place for your family & friends to experience the island lifestyle on the North Shore of Kauai. Immaculately cared...
- 5 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Hanalei
Located across from Hanalei Bay, is the magical Kauikeolani Estate. Mature gardens, expansive lawns, and an ancient Hawaiian fishpond are just a taste of the treasures which awaits you! The home is on the National Register of Historic Places. ...
- 6 bedroom
- 6 bathroom
- Sleeps 12
Hawaii> Hanalei
LOCATED IN A QUIET NEIGHBORHOOD OF HANALEI TOWN. (TVR #: 5109, TAT #: TA-052-564-9408-01, Tsunami Evacuation Zone.)
Great location. Close to beach and village. Amazing views of the mountains.
The Ohana house is a charming 5 ...
- 5 bedroom
- 5 bathroom
- Sleeps 12
Hawaii> Hanalei
Renovated and expanded in July 2011 to include 7 bedrooms! Hanalei's classic property sits on over one acre of land. The largest oceanfront rental property in Hanalei Bay!
The residence and guesthouse have been upgraded throughout. New...
- 7 bedroom
- 7 bathroom
- Sleeps 10
Hawaii> Hanalei
TVRNC Permit #1020
The Hibiscus is a beautiful 3BR 2BA Hawaiian-style home just one block from the stunning two-mile crescent beach at world-renowned Hanalei Bay.
The furnishings, amenities, and setting make it a wonderful vacation...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Hanalei
Nalu Hanalei – your ultimate Hawaiian getaway! Located just steps away from the world-renowned Hanalei Bay, this luxurious 4-bedroom, 3-bathroom property offers the perfect combination of comfort, convenience, and breathtaking ocean ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Hanalei
Hanalei Happy Place Bungalow
Permitted Vacation Rental Property - TVNC#4339
Transient vacation rental is located in the tsunami evacuation zone
Charming bungalow studio with jungle views close to the beach!
Nestled between ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Hanalei
This beautiful beachfront Hanalei Bay home is located steps from the sand on Kauai's majestic North Shore. Enjoy the best views of the pier, surf, mountains, and sunsets over Mt. Makana the north shore has to offer. This modern updated cottage ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Hanalei
Welcome to the Makana Nui, located on the famous Weke Road in Hanalei. This home sits directly on the beach and is just a short walk through your private lawn to the sand. The picturesque Hanalei coastline remains relatively undeveloped and ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Hanalei
Aloha,
You will love our 3 bedroom, 3 bath HANALEI GETAWAY Vacation Rental home that is perfectly situated in the heart of Hanalei Bay, Kaua'i. At your vacation home you will experience the views of numerous breathtaking waterfalls and the ...
- 5 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Hanalei
TVNCU #1146 - A gated entrance leads you through a 6 foot lava rock wall toward the rear, ground level peaceful house. Privately tucked away, on the Mauka (mountain) side of the road, behind a front house (where the housekeepers live), the ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Hanalei
