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 '%Plantation Hale%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Enjoy the ultimate Poipu vacation experience at Kiahuna Plantation Hale, located on the fourth fairway of the Kiahuna Plantation Golf Course in lovely Wainani at Poipu. This stunning home boasts gorgeous mountain views, a split air conditioning ...
- 3 bedroom
- 4 bathroom
- Sleeps 6
HI> Koloa
Plantation Hale Suites Unit K5. Kauai Vacation Rental in the heart of Kapaa Town. The perfect Kauai vacation rental for the budget minded traveler. All vacation rental units have spacious bedrooms, are non-smoking, air conditioned, and fully ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kapaa
Plantation Hale Suites Unit B13
Royal Coconut Coast, Wailua
Kauai Vacation Rental.
We have implemented enhanced cleaning and disinfecting guidelines as well as infection prevention advice provided by the CDC.
*One bedroom, 1 bath 2nd floor ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kapaa
Ready to relax, soak up the sunshine and let the sunrise be your alarm clock for a change? Located on Kauai's famous Coconut Coast, this second floor unit overlooks one of three pools, is surrounded by swaying palm trees, and has a partial ocean...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kapaa
Plantation Hale Suites Unit H-7, Central Air Conditioning.
Royal Coconut Coast, Wailua, Kauai Vacation Rental.
We have implemented enhanced cleaning and disinfecting guidelines as well as infection prevention advice provided by the CDC.
*Two ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kapaa
New Listing! Located right on the Royal Coconut Coast, you’re in a perfect central location at Plantation Hale, Kapaa. Walk across the street to the Coconut Plantation Marketplace to shop at any of the boutiques or pick up groceries. Walk 50 ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Kapaa
Welcome to one of our favorite spots! This is a one bedroom condo in Kapaa on the island of Kauai. It has a luxurious King size bed in the bedroom and a double sleeper sofa in the living room. That means it comfortably sleeps up to 4. The condo ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kapaa
Plantation Hale H12 Sleeping Giant Mountain View Condo with AC!
One of the Best Decor at Plantation Hale! Enjoy this newly remodeled 1 bedroom Mountain View condo at Plantation Hale! Experience the view of Sleeping Giant (Nounou Mountain) ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kapaa
Welcome to our beautiful coconut coast condo! This is a one bedroom condo in Kapaa on the island of Kauai. It has a King size bed in the bedroom and a double sleeper sofa in the living room. That means it comfortably sleeps up to 4. The condo ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kapaa
Please review and understand our cancellation policy before booking. We strongly suggest you to buy Travel Insurance to protect yourself in the situation where you are not entitled to receive any refund if you cancel.
Plantation Hale is located...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kapaa
Plantation Hale Suite B6 , Air Conditioned One Bedroom, One Bath with Full Kitchen and Private Lanai.
Royal Coconut Coast, Wailua, Kauai Vacation Rental.
We have implemented enhanced cleaning and disinfecting guidelines as well as infection ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kapaa
Plantation Hale A5!
Garden View Condo with NEW AC in bedroom! NEW stove/oven! And, NEW refinished Tub and Shower!
Plantation "Orchid Hale"! Enjoy this 1 bedroom Garden View condo at Plantation Hale! Sleep well in the double beds in the ...
- 1 bedroom
- 1 bathroom
- Sleeps 6
HI> Kapaa
Plantation Hale Suites Unit G5
Ground Floor, NEW Upgraded Split System Air Conditioned Unit in Living Room AND Bedroom!
We have implemented enhanced cleaning and disinfecting guidelines as well as infection prevention advice provided by the ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kapaa
Plantation Sunny Hale - Redecorated Living Room and new Air Conditioning!
3 Pools, 2 Hot Tubs, Shared BBQ's
Free Parking Free Wi-Fi No Resort Fee
Sunny Hale A-1 at Plantation Hale in the Coconut Marketplace! Bright and sunny living room ...
- 1 bedroom
- 1 bathroom
- Sleeps 6
HI> Kapaa
Plantation Hale K10, a 1-bd/1-ba second floor condo is located just 15 minutes from Lihue Airport in the lovely town of Kapaa. Enjoy mountain views and swaying palms from your private lanai. The bedroom has two double beds, a flat screen TV, and...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kapaa
