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 (`propertyName` like '%Bali Hai%') AND sleeps>=1 order by rating desc LIMIT 0, 15
A comfortable 2BDRM Delux unit that sleeps up to 6. The Wyndham Bali Hai Villas Resort is located on the North Shore of Kauai. This beautiful unit is great for a couple get-away, families or a group of friends who want to share comfortable ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Princeville
Wyndham Bali Hai Villas are 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 Bay is just...
- 3 bedroom
- 2 bathroom
- Sleeps 10
HI> 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 truly ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> 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
HI> 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 truly...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Princeville
A comfortable 2Bedroom 2 bathroom unit that can sleep up to 8. The Wyndham Bali Hai Villas Resort is located on the North Shore of Kauai. This unit is great for families or a group of friends who want to have comfortable accommodation with all...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Princeville
State of Hawaii Transient Accommodations Tax License #TA-208-987-1360-01. County of Maui Short-Term Rental License #Hotel Zoned Resort. Tax Map Key #210080910088
Bali Hai Pool Villa F102 is located on Maui island, ranked #1 Best Luxury ...
- 3 bedroom
- 4 bathroom
- Sleeps 6
HI> Wailea
BALIHAI GETAWAY is a spectacular hawaiiana condo located beachfront. Pali Ke Kua is a 22-acre resort condominium located on the north shore of Kauai in Princeville. It sits on a bluff 200 feet above the ocean and has breathtaking views of the ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Princeville
*** Please Note: These reservations are non-cancelable/non-refundable. ***
*** Reservations ARE insurable, but are not refundable in all circumstances. Please check with your travel insurance company for details/exclusions. ***
The Wyndham ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Princeville
Alii Kai II 12D Kauai condo is located in Princeville on Kauai's beautiful North Shore.
Enjoy the sunset from your Kauai condo facing the "Bali Hai" Na Pali mountain range.
What recent guests are saying: "This property was beautiful! The ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Princeville
Calm Kaua‘i Delights. Located in the leading resort community of Princeville, Kauai, Wyndham Bali Hai Villas truly captures the splendor of Hawaii. Princeville and the neighboring town of Hanalei offers an abundance of restaurants, beaches, ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> 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
HI> Princeville
2 Bedroom Condo with King in Master and Queen or 2 Doubles in 2nd Bedroom. Full Kitchen/Balcony/Deck Washer/Dryer Whirlpool Tub Wireless Internet. No A/C - ceiling fans only
Located in the leading resort community of Princeville, Kauai, ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Princeville
Due to high demand this year I am not able to keep my VRBO calendar up-to-date since resort openings are changing by the minute. If you are interested in staying and my calendar shows it as unavailable, please reach out to me with the dates you ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Princeville
2 Bedroom Condo with King in Master and Queen or 2 Doubles in 2nd Bedroom. Full Kitchen/Balcony/Deck Washer/Dryer Whirlpool Tub Wireless Internet. No A/C - ceiling fans only
Located in the leading resort community of Princeville, Kauai, Wyndham...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Princeville
