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, 50
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.
Wailua, Kaua'i Vacation ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kapaa
Plantation Hale Suites D11, Royal Coconut Coast Kaua`i, Wailua, Kauai Vacation Rental.
*One-bedroom, one-bath condo, 2nd floor end-unit wit a King bed.
*633 square feet of living space
*Private lanai and balcony overlooking resort ...
- 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
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
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
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 more!
New Remodel! Beautiful and Tasteful Updates ...
- 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
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
Plantation Hale Suites Unit J-16, Royal Coconut Coast, Wailua, Kauai Vacation Rental.
*New luxury vinyl flooring and remodeled walk-in shower
*One bedroom, 1 bath condo, 2nd floor end unit with a King bed and a queen sofa sleeper
*Ocean...
- 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 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. ...
- 2 bedroom
- 1 bathroom
- Sleeps 3
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
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
Plantation Hale Suite A7, Ground Floor, Garden Unit. Kapa`a, Hawaii, Royal Coconut Coast. Walk to the beach, shops, restaurants, grocery stores, and more!
Wailua, Kauai Vacation Rental near to shops, restaurants, grocery stores and ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapa'a
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
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
Welcome to Nani Hale, a newly renovated ground-floor condo located in the heart of Kapaa, Hawaii. Experience the beauty and comfort of Kauai's Coconut Coast in this stylish and convenient retreat. With its prime location between Poipu and ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapaa
ALOHA! Welcome to our beautifully renovated ocean view hale! This is a one bedroom condo in Kapa’a on the beautiful island of Kauai.
You can enjoy listening to the ocean waves from the chairs on our oversized private lanai or with the ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapa?a
"Island Time", a freshly updated, ground-level condo at Plantation Hale, offering comfort, style, and space just steps from Kauai's Coconut Coastline. With two full size beds in the bedroom and a full size sofa sleeper, this unit is perfect for ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapaa
