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 (`headline` like '%kauai%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Embrace privacy in this 961sf suite with Pacific framed by tropical foliage. Prep a fresh catch in the kitchen to share on the lanai or dining area with floor-to-ceiling ocean view. Perks include hardwood floors, WiFi, flat screens, ceiling fans...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> LIHUE
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
Beautiful Princeville Resort that will allow you to enjoy beautiful Kauai in style! With everything, you could want in a resort Bali Hai offers that home away from home with all the extra perks! A comfortable 2BDRM Delux unit that sleeps up ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Princeville
Energy flows from the tropical-decor living area onto the lanai and across expansive lawns of this 739 sq. ft. ground floor villa with beautiful ocean view. Dine in with meals prepped in the full kitchen. Other touches include ceiling fans, flat...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> LIHUE
Gaze at Pacific surf from the lanai of this 150 sf tropical suite at the ocean’s edge. Floor-to-ceiling sliders bring paradise into the open living area and kitchen for “at home” dining pleasure. Touches include cool tile floors, ceiling ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> LIHUE
KrellersGetaway has been renting units at the Islander on the Beach complex since 2005! Just listed each on VRBO, so for 300+ reviews collected over the years, please see HomeAway 960067.
Also, if not all of your dates are open for this unit ...
- 0 bedroom
- 1 bathroom
- Sleeps 4
HI> Kapaa
GOOD NEWS! Hawaii is open for travelers! Make sure you get a negative covid test within 72 hours of arrival and check all of the details on the Hawaii.gov website so you can have a safe an successful trip to Kaua'i.
PROPERTY DESCRIPTION
You've...
- 2 bedroom
- 1 bathroom
- Sleeps 6
HI> Kapaa
At the Mokihana House Kauai, you will enjoy taking in the views of mountain waterfalls, rainbows and sunsets from the living room, dining room and lanai. You will enjoy our 6 new air conditioning units - one in every bedroom and a large unit in...
- 5 bedroom
- 5 bathroom
- Sleeps 10
HI> Princeville
Prep farmer’s market fare in the full kitchen to share on the private lanai unfolding to gorgeous plumeria, bougainvillea and hibiscus. Then explore your lush surroundings. This 690sf home away from home appeals with WiFi, flat screens, ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> KOLOA
Entire Townhouse 1,100 sq. ft. end unit Newly Remodeled With 2 Bedrooms:
1 king, 1 queen and a Den with 2 Full baths, Relaxing atmosphere Townhome with beautiful foliage and mountain views from every window. A mile stroll to a secluded lush ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Princeville
One of the best kept secrets in the Poipu Beach Resort area, Waikomo Stream Villas is a lush garden resort with 60 Kauai condos located on the sunny side of Kauai. Centrally located and across the road from Kauai’s premier retail destination ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Koloa
Offering one of the newest retreats in Princeville, these luxurious air conditioned Kauai vacation rentals offer spacious layouts, covered lanais, a private resort swimming pool, multiple community BBQs, an on-site fitness room, a small meeting ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Princeville
Nestled among a championship golf course, Pili Mai is set in an ideal location on the island of Kauai’s south shore in Poipu Beach. This is Kauai's newest resort development and has a choice of two, three, and four bedroom luxury condominiums....
- 2 bedroom
- 3 bathroom
- Sleeps 4
HI> Koloa
The best views on the Island! Your own private porch that looks onto the beautiful Bali Hai peninsula and Hanalei bay. Fully refurbished and equipped 2 bedroom condo, each room has it's own bathroom, plus large living, dining, kitchen area. ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
HI> Princeville
This unique Poipu townhome is situated on the same property with the spacious and spectacular Villa Kailani oceanfront estate. This recently renovated property is located within a short walk to Poipu Beach State Park which is one of the premier ...
- 2 bedroom
- 3 bathroom
- Sleeps 4
HI> Koloa