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 '%Plantation Hale%') AND sleeps>=1 order by rating desc LIMIT 0, 20
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
Hawaii> Koloa
Plantation Hale Suite F7 located in Kapa`a, Kaua'i, Hawaii on the Royal Coconut Coast. Walk to the beach, shops, restaurants, grocery stores, and more! Unit F7 is a relaxing location to view morning sunrises and some distant ocean ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kapaa
Welcome to Plantation Hale C5 :
This garden level, corner unit condo is just steps away from the closest gated pool and jacuzzi area. Both the living area and the bedroom open onto the spacious, pool view lanai with direct access to the ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> KAPAA
Welcome to Plantation Hale Suites Unit H7 on the beautiful island of Kauai!
Experience the best of Kauai at our newly remodeled vacation rental, centrally located on the Royal Coconut Coast in Wailua. Whether you're here for relaxation or ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapaa
Plantation Hale Suites D11, Royal Coconut Coast Kaua`i, Wailua, Kauai Vacation Rental.
*One-bedroom, one-bath, 2nd floor end-unit wit a King bed.
*Private lanai and balcony overlooking resort grounds and the pool ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kapaa
Plantation Hale Suite H15, Top/2nd Floor (walk-up) unit with peek-a-boo ocean views from the outside lanai. Kapa`a, Hawaii, Royal Coconut Coast. Walk to the beach, shops, restaurants, grocery stores, and more!
Wailua, Kauai Vacation ...
- 2 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Kapaa
No Resort Fees! 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 ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> 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...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapaa
"Just Beachy" at Plantation Hale D7 a Garden View with AC
E komo mai i kēia Plantation Hale! ! Welcome to this beautiful renovated garden view one bedroom, a tranquil and modern hale on the Royal Coconut Coast of Kauai. Enjoy the ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapaa
New Remodel! Beautiful and Tasteful Updates Throughout!
Plantation Hale Suite J8, Ground Floor, Ocean facing (no ocean-view), end-unit. Kapa`a, Hawaii, Royal Coconut Coast. Walk to the beach, shops, restaurants, grocery stores, and ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapaa
Plantation Hale Suites Unit B13, Royal Coconut Coast, Wailua, Kauai Vacation Rental.
*One bedroom, 1 bath 2nd floor end unit with 2 Full size beds and a Queen sofa sleeper couch, making it perfect for families or couples
*Private lanai...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapaa
Plantation Hale Suites Unit J-16, Royal Coconut Coast, Wailua, Kauai Vacation Rental.
*Carpet has been removed and replaced with new vinyl flooring
*One bedroom, 1 bath, 2nd floor end unit with a King bed and a queen sofa sleeper
*Faces...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapaa
Plantation Hale Suite B6 , Air Conditioned One Bedroom, One Bath with Full Kitchen and Private Lanai.
Royal Coconut Coast, Wailua, Kauai Vacation Rental.
*Cal King bed and Full sofa sleeper. Air mattress available upon request only ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapaa
Plantation Hale Suites Unit G5, Kapaa, Central Kauai Vacation Rental near the Coconut Market Place.
Ground Floor, Upgraded Split System Air Conditioned Unit throughout unit! Engineered hardwood flooring in the living room and bedroom. This ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> 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 ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapaa
Plantation Hale Pool and Tropical Garden View - 1 bdm, Area AC*
Plantation Hale Suites is situated in Kapaa town and close to everything you came to experience from the most convenient home base. C16 has balcony views to one of the ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kapaa
Plantation Hale J11
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Nestled amongst all of Kapaa's natural wonders and local attractions, ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapaa
Plantation Sunny Hale - Area 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 with wonderful ...
- 1 bedroom
- 1 bathroom
- Sleeps 6
Hawaii> Kapaa
Garden View Condo with AC in bedroom! new stove/oven! And, 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 bedroom, complete with a ...
- 1 bedroom
- 1 bathroom
- Sleeps 6
Hawaii> Kapaa
E Komo Mai, Welcome to Plantation Hale K10!
1-bedroom/1-bathroom 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 a ...
- 2 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kapaa