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 (`propertyName` like '%Bali Hai%') AND sleeps>=1 order by rating desc LIMIT 0, 50
Welcome to the North Shore Oasis!
Like the nicest hotels, the Oasis has a magical indoor/outdoor Hawaiian vibe. The open-air home let's you live among the tropical breeze. For your comfort, all three bedrooms have A/C.
The Oasis ...
- 3 bedroom
- 4 bathroom
- Sleeps 7
Hawaii> Princeville
Welcome. From the moment you enter the gate and are surrounded by the garden and pool you may never want to leave.
Walk inside your home away from home and enjoy. Take in the mountain view from upstairs from Namolokama unobstructed to ...
- 5 bedroom
- 4 bathroom
- Sleeps 10
Hawaii> Princeville
ALOHA! WELCOM TO KAUAI.
Tranquil and tropical setting on the edge of Hanalei Ridge. Three bedroom Duplex, that sleeps six in a small peaceful complex. All brand new, fully remodeled, clean, fresh, bright, and welcoming filled with the ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Princeville
Our Oceanfront, Mountain and Sunset view is THE most famous on all of Kaua'i!!!
Newly renovated with A/C throughout unit. 4 split Mitsubishi units: one in each bedroom , one in kitchen/dining area and one in living room/atrium ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Princeville
Welcome to Hale Mahina! Long hidden as a luxury private residence, this Princeville pearl is now yours to enjoy. All one level, Hale Mahina offers unobstructed expansive views of the bejeweled Nanolokama Mountains and Bali Hai across Lake Mahina...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Princeville
1 Bedroom Condo with King in Master, Sleeper Sofa in Living Room. Full Kitchen/Balcony/Deck Washer/Dryer/Wireless Internet. No A/C - ceiling fans only
Located in the leading resort community of Princeville, Kauai, Wyndham Bali Hai Villas ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Princeville
1 Bedroom Condo with King in Master, Sleeper Sofa in Living Room. Full Kitchen/Balcony/Deck Washer/Dryer/Wireless Internet. No A/C - ceiling fans only
Located in the leading resort community of Princeville, Kauai, Wyndham Bali Hai Villas ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Princeville
1 Bedroom Condo with King in Master, Sleeper Sofa in Living Room. Full Kitchen/Balcony/Deck Washer/Dryer/Wireless Internet. No A/C - ceiling fans only
Located in the leading resort community of Princeville, Kauai, Wyndham Bali Hai Villas...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Princeville
2 Bedrooms, 2 Baths, plus Murphy Bed: Sleeps 8
This Unit is Available: by the week 7/11/25-7/18/25, 7/18/25-7/25/25, and 7/25/25-8/1/25
One of the best 2-bedroom views at Hanalei Bay Resort, Units 8221-2 have great views of ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Princeville
**2025 Discounted Rates**
Book 7 consecutive nights or more through June 1, 2025 and receive 10% off the nightly rate.
Welcome to Hale Honu Aloha ("Home of Turtle Love") at Puu Poa, an updated two-bedroom, two-bath condo on the Puu ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Princeville
Near the edge of a bluff overlooking the ocean, this ground-floor condominium offers fabulous ocean and coastline views. Bali Hai, the landmark mountain made famous in "South Pacific," is just one of the awesome sights that guests enjoy here. ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Princeville
Welcome to Hale `Ikena Kai ("home of mystical ocean") at Pali Ke Kua, a unique home vacation experience on Kauai’s stunning North Shore!
This intimate one-bedroom condo at Pali Ke Kua is perched high on the Princeville ocean bluff and ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
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
Experience spectacular ocean views and dazzling sunsets, in your private luxury vacation residence. This condo is on the second level six steps down with ocean and mountain views. A/C in all rooms, both bedrooms and the open concept kitchen ...
- 3 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Princeville
(Please note that we refurnished our home in November 2023. While the photos reflect the new furnishings and decor, the video shows the pre-November 2023 furnishings. Also please note that we changed the beds in the guest bedroom from a queen ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
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
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
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. This large one bedroom condo, complete with full size kitchen with washer and dryer, dining room and spacious living...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Princeville
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
Hanalei Bay Resort 8233
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Admire unobstructed views of the Pacific Ocean, the mountains, and ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Princeville
Wyndham Bali Hai Villas 1 Bedroom Sleeps 4
***PLEASE DO NOT PUT IN A RESERVATION REQUEST USING THE “REQUEST TO BOOK” FEATURE***
Book our Amazing Luxury Villa & let The Timeshare Brokers, LLC make the booking process ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Princeville
Club Wyndham Bali Hai Villas nestled high into the cliff terrain of Princeville near the challenging Makai golf course, Kauai's leading resort community blends natural and man-made pleasures into magnificent harmony between the lush, tropical ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Princeville
Hale Lani Lanai
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
An extraordinary amount of space - both inside and out - awaits at this ...
- 3 bedroom
- 5 bathroom
- Sleeps 8
Hawaii> Princeville
Hanalei Bay Resort is on the beautiful island of Kauai's Northshore. It is a luxury beachfront resort that overlooks Hanalei Bay. Offering exquisite Ocean and Mountain views with lush Hawaiian Gardens across 22 acres. It boasts 4 Tennis courts, ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Princeville
See our 5-STAR reviews on AirBnB.
You will feel welcome, comfortable and instantly relaxed here. Our home is one level with an immaculately landscaped yard. There are 3 lanais, 2 of which face the Makai golf course. Sit in our Adirondack ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Princeville
Indulge in breathtaking ocean, mountain, and Bali Hai vistas from this meticulously renovated (2022) Hawaiian-style Two-Story Loft. Step onto one of the two furnished lanais, where gentle tropical trade winds whisper tales of the sea. Listen ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Princeville
The Wyndham Bali Hai Villas Resort is located on the beautiful North Shore of Kauai. This prime area is close to world-renowned beaches, hiking, shopping, golf courses, snorkeling, day spas, live entertainment and fine dining. Gorgeous Hanalei ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Princeville
1 bedroom, 1 bathroom corner unit offering a cozy bamboo motif that resonates with old Hawaii and when times were simple. The idyllic getaway from the fast-paced crowds, and ultra-modern world of hotel rooms. Ocean views from every room. Curl up...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Princeville
At Pali Ke Kua 212, you will enjoy gorgeous views of Bali Hai and the beautiful Pacific Ocean. Sit out on your private lanai to enjoy this scenic panorama while the palms trees sway in the breezes. You will want to watch for frolicking dolphins ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Princeville
Pali Ke Kua 223 COMPLETELY REMODELED.
Right on a bluff overlooking the the beautiful ocean and Bali Hai mountain views! The condo is split level with stairs down to the living area and first bedroom and stairs up to the second bedroom, ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Princeville
Hanalei Bay Resort, #3106
One-of-a-kind studio unit with a stunning view overlooking Hanalei Bay and beautiful Bali Hai. Located at Hanalei Bay Resort - 22 acres of Hawaiian paradise only minutes away from one of Hawaii’s most beautiful...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Princeville
Princeville's Sh'Zen is a luxurious three bedroom, three bath home on a very private third of an acre of lush tropical gardens and pool. . Spectacular endless ocean views over the seventh tee and sixth green of the world famous and newly ...
- 3 bedroom
- 3 bathroom
- Sleeps 4
Hawaii> Princeville
https://www.youtube.com/watch?v=t2empvqbOT4
Whale Hale is a spacious 5 bedroom, 4.5 bath home proudly perched on the bluff above Queens Bath in Princeville, Kauai' where you can see and hear the ocean. From the grand entry staircase to ...
- 5 bedroom
- 5 bathroom
- Sleeps 10
Hawaii> Princeville
Lovely and romantic, this popular honeymoon destination condo overlooks Bali Hai and Hanalei Bay. The room boasts a comfortable, four poster king size bed with designer bedding, large remodeled bathroom, a small sofa sleeper, and large slate...
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Princeville
Welcome to the Kamalani Lodge! Our newly renovated 3BR/2BA house has floor-to-ceiling louvered windows to maximize tropical breezes throughout the house, a fully equipped kitchen with quartz countertops and SS appliances, and resort-quality king...
- 4 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Princeville
A fabulous ocean vista awaits you at this delightful, impeccably furnished condo. Magnificent views of Bali Hai and the blue Pacific are easily enjoyed from the living room as well as the dining area where the panoramic effect is especially ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Princeville
Pali Ke Kua #105 is a perfect honeymoon or couple's romantic getaway! A Kauai vacation condo with beautiful interior design, featuring spectacular panoramic views of the ocean and legendary Bali Hai. Ground floor unit with easy access to the ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Princeville
This beautiful ground floor condo has undergone a COMPLETE REMODEL!
The beautiful remodel features Quartzite counters. All new cabinets, Kitchen Aid stainless steel oven and dishwasher, along with a Café refrigerator. Beautiful new ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Princeville
Comfortably furnished with great attention to detail, this first-floor condo with stairs to entry, is truly fabulous. Near the edge of a bluff overlooking the beautiful Pacific Ocean, this condo also commands spectacular views Bali Hai, the ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Princeville
Pali Ke Kua #102
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
We invite you to be our guests in our “Iki Māhele O Ka Lani…Little Slice...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Princeville
Pali Ke Kua 202 boasts spectacular and unbeatable ocean and Bali Hai mountain views!! This Hawaiian Style unit features 2 bedrooms and 2 full baths, comfortable living room area and a fully equipped kitchen. The lanai looks out to the ocean and ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Princeville
Perched on the spectacular Princeville ocean bluff, Pali Ke Kua 216 offers one of the best 180-degree panoramic view of the breathtaking Bali Hai and the picturesque Hanalei Bay and pristine beaches below. This fantastic condo is an idyllic ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Pinceville
Panoramic Ocean Views at Pu'u Poa 212
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Pu’u Poa Unit 212 in Princeville, Kauai, has unequaled...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Princeville
Hanalei Bay Resort 6222
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Take in gorgeous views of Hanalei Bay and Bali Hai, and relax in this ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Princeville
Welcome to Alii Kai II 12D, your ideal Kauai vacation condo located in Princeville on the stunning North Shore of Kauai. Enjoy beautiful mountan views and sunsets from your Kauai condo facing the "Bali Hai" Na Pali mountain range.
Condo ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Princeville
Named by Condé Nast Traveler as one of the top tropical resorts in the world. This is truly the Hawaii of your dreams.
Hanalei Bay Resort is a scenic paradise with awe inspiring views. You'll be surrounded by cascading waterfalls and ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Princeville
Rich Brazilian cherry wood flooring mixed with natural stone tiles throughout the kitchen, entry foyer, and bathrooms. Ipe wood decking on the exterior lanais intertwine with the inside living space seamlessly, thus extending the interior into a...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Princeville
With the best views on the island, this 1-bedroom bottom-floor condo is located in the Pali Ke Kua resort, which lies on a bluff facing the ocean and the landmark north shore mountain, Bali Hai. Watch gorgeous ocean sunsets from your private ...
- 2 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Princeville
The moment you arrive at Wyndham Bali Hai Villas you'll know that your long awaited travel desires have given way to reality. The Wyndham Bali Hai is located in the leading resort community of Princeville, Kauai. Princeville and the neighboring ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Princeville
