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 (`headline` like '%hanalei bay%') AND sleeps>=1 order by rating desc LIMIT 0, 50
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
Awaken to views of waterfalls, palm trees and Hanalei Bay while the scent of jasmine wafts through your window on an island breeze. 3 king bedrooms all with en-suite dual vanity master baths. 1200 sqft lanai with private access from each ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Princeville
As seen on Kauai-TV this is an amazing 5 bedrooms, 4 Full Bathrooms. That’s 3 Master Bedrooms and 2 Guest Suites.
One full kitchen, one kitchenette, three living areas, and 5 lanais. And Aloha Glore!
From the moment you enter ...
- 5 bedroom
- 4 bathroom
- Sleeps 10
Hawaii> Princeville
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
A top floor luxury condo, with one king bedroom PLUS LOFT. The majestic 180 degree ocean to mountain views overlook Hanalei Bay, Bali Hai, and the surrounding mountains that hug the coastline. This privately owned condo has vaulted ceilings ...
- 2 bedroom
- 1 bathroom
- Sleeps 6
Hawaii> Princeville
Fantastic views of Hanalei Bay, Bali Hai, and the surrounding mountains and ocean help make this top floor, 2 bedroom plus loft condo perfect for enjoying the beauty of Kauai. The 2 bedrooms each have King beds and the loft provides 2 Queen beds...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Princeville
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
Come to the charming town of Hanalei and experience the Jones House, a spacious oceanfront home on spectacular Hanalei Bay. Steps away from the beach with breathtaking views of Hanalei Bay, the Jones House is sure to delight. Swim, surf, ...
- 3 bedroom
- 2 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
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
TVRNC Permit #1020
Maluhia Hanalei is a beautiful Hawaiian-style home just one block from the magnificent two-mile crescent beach at world-renowned Hanalei Bay.
The furnishings, amenities, and setting make it a wonderful vacation ...
- 6 bedroom
- 3 bathroom
- Sleeps 10
Hawaii> Hanlei
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
PLEASE CONTACT ME PRIOR TO BOOKING TO CONFIRM AVAILABILITY.
Sweeping views from the North Shore of Hanalei to Bali Hai in the center. Pali Ke Kua 221 is a two bedroom, 2baths fully furnished vacation condo in Princeville. The master ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Princeville
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
The Muxlow's Hanalei Home
Upon waking up you feel the sea breeze brush your face through the open lanai, at the same time the sound of the ocean sends its rhythmic music to soothe you. Hanalei's beauty has already touched you and your ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Princeville
NEWLY REMODELED Studio!!!
One of the best locations on Kauai’s lush North Shore fronting the white sands of Hanalei Bay with amazing views of tropical sunsets, lush green mountains and the sparkling blue waters of the Pacific Ocean. ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Princeville
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
NEWLY REMODELED Studio!!!
One of the best locations on Kauai’s lush North Shore fronting the white sands of Hanalei Bay with amazing views of tropical sunsets, lush green mountains and the sparkling blue waters of the Pacific Ocean. ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Princeville
Views, Ocean, Sunset, Mountains, Jungle, Rainbows, Waterfalls, Views and Refreshing Breezes!
Within the Hanalei Bay Villas, this individual family home is 'Haleakamanu' - the house of the birds. It is situated within walking distance of ...
- 2 bedroom
- 3 bathroom
- Sleeps 4
Hawaii> Princeville
Hanalei Bay Villas #17 is a beautifully remodeled stand-alone condominium. This luxurious bungalow already had panoramic views of Hanalei Bay and the Hanalei Mountains and the interior reflects the beauty of its surroundings. Beautiful ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Princeville
One of two full oceanfront views of Hanalei Bay with private lanais and grass lawn looking over the breathtaking views of Hanalei Bay and Bali Hai. Enjoy an amazing sunrise breakfast and cup of coffee as you overlook the bay as the sun wakes up...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Princeville
**HBR is performing roof repairs from Sept 9th for about 8 weeks. The repairs will be from 9-5, Monday-Friday only and scattered through out the resort. Rates have been adjusted for this time period. **
One of the best locations on ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Princeville
New! Welcome to Hale Hui Pu, our recently renovated charming home. Conveniently located in Princeville, Kauai. Large living and dining area with outdoor BBQ space. It's a beautiful and comfortable space that is perfect for families.
The ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Princeville
Hanalei Bay Villas #36 is a spacious three bedroom, two and a half bath, two story stand-alone condominium. Beach access is available past the newly renovated 1 Hotel Hanalei Bay next door. Views include the Hanalei Mountains and the open ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Princeville
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
Welcome to your Hanalei Bay Hideaway, at one of the best locations Hanalei Bay Resort has to offer. This suite includes amazing views of the tropical sunsets, lush green mountains and the sparkling blue waters of the Pacific Ocean. These condo's...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Princeville
*Please review the current quarantine requirements on Kauai at: https://www.kauai.gov/covid-19 before booking.
Hanalei Bay Villas #10 - Look no further - 'Paradise Found'
So whether you are honeymooning or just looking for a very ...
- 2 bedroom
- 3 bathroom
- Sleeps 4
Hawaii> Princeville
This Luxury Pool & Spa Estate has it all! Panoramic Views of Hanalei Bay, Lumahai Beach, Bali Hai, Mountains, Waterfalls, Rainbows, backing to hundreds of tropical acres and fruit trees! 5 Bedrooms, 5.5 Baths, Separate Living Room with 85" ...
- 6 bedroom
- 7 bathroom
- Sleeps 14
Hawaii> Princeville
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
Hanalei Bay Villas #22 is a spacious two bedroom, two and a half bath, two story stand-alone condominium. With an additional queen size sleeper sofa, this unit sleeps six comfortably. Beach access is available past the 1 Hotel Hanalei Bay next ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Princeville
Kauai’s Most Breathtaking Views at Hanalei Bay Resort
Welcome to your Kauai Paradise. Unit 9201 is located in the renowned Bamboo building which features the most stunning views of Hanalei Bay and Bali Hai.
This recently ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Princeville
Kauai’s Most Breathtaking Views at Hanalei Bay Resort
Welcome to your Kauai paradise. Unit 9202 is located in the renowned Bamboo building which features the most stunning views of Hanalei Bay and Bali Hai.
This large fully air ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Princeville
UNIT 9201/2
Kauai’s Most Breathtaking Views at Hanalei Bay Resort
Welcome to your Kauai paradise. Units 9201/2 are located in the renowned Bamboo building which features the most stunning views of Hanalei Bay and Bali Hai. ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Princeville
Kauai’s Most Breathtaking Views at Hanalei Bay Resort
Welcome to our North Shore paradise. Unit 9201/9202/9203 is located in the renowned Bamboo building which features the most stunning views of Hanalei Bay and Bali Hai.
This ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Princeville
Hanalei Bay Resort unit 7101-2 is a privately owned and cared for two bedroom suite featuring countless amenities to please every guest. The condo features 1,324 square feet of spacious living area, with quality furnishings, with the living room...
- 2 bedroom
- 2 bathroom
- Sleeps 7
Hawaii> Princeville
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Upcoming Availability:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Lovely and romantic, this popular honeymoon destination condo overlooks Bali Hai and Hanalei Bay. The room boasts a ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Princeville
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Upcoming Availability:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From the moment you walk into 4222 and see Bali Hai and Hanalei Bay directly in front of you, you will know you are in paradise. ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Princeville
Hanalei Bay Resort 1305 & 6: This beautiful spacious studio with an adjoining hotel room is located on the top floor with high open-beam ceilings. It is surrounded by tropical foliage and spectacular views of Hanalei Bay and Bali Hai. On your ...
- 2 bedroom
- 4 bathroom
- Sleeps 4
Hawaii> Princeville
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 ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Hanalei
From the moment you walk into 4221/4222 and see Bali Hai and Hanalei Bay directly in front of you, you will know you are in paradise. Enjoy the sunsets from the slate covered lanai and hear the waves of Hanalei Bay below. This 2 bedroom, 2 bath,...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Princeville
Enjoy the very best of the North Shore at this luxury private retreat in Princeville! Located on a cul de sac in the exclusive quiet Princeville community with stunning views of the Makai Golf Course and Bali Hai Mountains! Overlooking the 9th ...
- 4 bedroom
- 4 bathroom
- Sleeps 10
Hawaii> Princeville
Hanalei Bay Resort 9205 six
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Hanalei Bay Resort 9205/6 is a combination vacation rental ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Princeville
Hanalei Bay Resort 4205 six
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Hanalei Bay Resort 4205/6 is an air-conditioned condo, featuring ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Princeville
A charming beachfront oasis on the famous Hanalei Bay, this beautiful traditional home offers four bedrooms and four bathrooms with ample living space inside and out. With breathtaking views of Hanalei Bay ringed by emerald mountains and ...
- 4 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Hanalei
This beautiful beachfront Hanalei Bay home is located steps from the sand on Kauai's majestic north shore. It offers panoramic views of an iconic beach and its surrounding mountains within a quick walk to the Hanalei Pier for surfing and ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Hanalei
Locally-crafted Décor, Spacious Chambers, with Natural Wood Trim. Beautiful Two-Story Air-Conditioned Retreat …serenaded in the song of jungle birds!
Meticulously thought-out kitchen, accessories, games and endless amenities. For our ...
- 6 bedroom
- 4 bathroom
- Sleeps 15
Hawaii> Princeville
Greetings and welcome to Akai Palms, our exquisite residence situated in Princeville on the captivating North Shore of Kauai. We extend a warm invitation to you and your entire family to experience the abundant space for leisure and enjoyment ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Princeville
Spectacular views from living room, two lanais, king and queen bedrooms. The whole house is light and bright, recently updated with new paint, flooring, light fixtures and all new furniture, high-end mattresses and linens. Cook's kitchen is ...
- 3 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Princeville
