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 (`propertyName` like '%Manualoha%') AND sleeps>=1 order by rating desc LIMIT 0, 50
Important Notice: Ongoing Roofing Project in the Manualoha Community
We'd like to inform prospective guests that a roofing project will be
underway during your stay if you book a unit in Manualoha from 1/2025 to 5/2025.
In ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Koloa
Important Notice: Ongoing Roofing Project in the Manualoha Community
We'd like to inform prospective guests that a roofing project will be
underway during your stay if you book a unit in Manualoha from 1/2025 to 5/2025.
In ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Koloa
Important Notice: Ongoing Roofing Project in the Manualoha Community
We'd like to inform prospective guests that a roofing project will be
underway during your stay if you book a unit in Manualoha from 1/2025 to 5/2025.
In ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
Important Notice: Ongoing Roofing Project in the Manualoha Community
We'd like to inform prospective guests that a roofing project will be
underway during your stay if you book a unit in Manualoha from 1/2025 to 5/2025.
In ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
Important Notice: Ongoing Roofing Project in the Manualoha Community
We'd like to inform prospective guests that a roofing project will be
underway during your stay if you book a unit in Manualoha from 1/2025 to 5/2025.
In ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Koloa
Important Notice: Ongoing Roofing Project in the Manualoha Community
We'd like to inform prospective guests that a roofing project will be
underway during your stay if you book a unit in Manualoha from 1/2025 to 5/2025.
In ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
Important Notice: Ongoing Roofing Project in the Manualoha Community
We'd like to inform prospective guests that a roofing project will be
underway during your stay if you book a unit in Manualoha from 1/2025 to 5/2025.
In ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
Important Notice: Ongoing Roofing Project in the Manualoha Community
We'd like to inform prospective guests that a roofing project will be
underway during your stay if you book a unit in Manualoha from 1/2025 to 5/2025.
In ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
Important Notice: Ongoing Roofing Project in the Manualoha Community
We'd like to inform prospective guests that a roofing project will be
underway during your stay if you book a unit in Manualoha from 1/2025 to 5/2025.
In ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Koloa
Located in the premier Manualoha community of Poipu Kai resort, our 2 bedroom, 2 bath townhouse style condo is a short downhill stroll to the beach with a fabulous ocean-front pool, a tennis center with 8 courts and landscaped grounds with ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
Important Notice: Ongoing Roofing Project in the Manualoha Community
We'd like to inform prospective guests that a roofing project will be
underway during your stay if you book a unit in Manualoha from 1/2025 to 5/2025.
In ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
E komo mai, welcome to Manualoha 801!
This resort is replacing the roofing on all buildings beginning 2025. The building in which this unit is located is already finished. Estimated finish for the whole resort is end of March. On some ...
- 3 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Koloa
Important Notice: Ongoing Roofing Project in the Manualoha Community
We'd like to inform prospective guests that a roofing project will be
underway during your stay if you book a unit in Manualoha from 1/2025 to 5/2025.
In ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
Important Notice: Ongoing Roofing Project in the Manualoha Community
We'd like to inform prospective guests that a roofing project will be
underway during your stay if you book a unit in Manualoha from 1/2025 to 5/2025.
In ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
Important Notice: Ongoing Roofing Project in the Manualoha Community
We'd like to inform prospective guests that a roofing project will be
underway during your stay if you book a unit in Manualoha from 1/2025 to 5/2025.
In ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
Important Notice: Ongoing Roofing Project in the Manualoha Community
We'd like to inform prospective guests that a roofing project will be
underway during your stay if you book a unit in Manualoha from 1/2025 to 5/2025.
In ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Koloa
Important Notice: Ongoing Roofing Project in the Manualoha Community
We'd like to inform prospective guests that a roofing project will be
underway during your stay if you book a unit in Manualoha from 1/2025 to 5/2025.
In ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Koloa
This fabulous large rare 3 bedroom, 3 bath unit is in the popular Manualoha complex at Poipu Kai Resort. Ground floor corner unit is steps from the greenway and an easy walk to Poipu, Brenneke, and Shipwreck beaches. Featuring a large living ...
- 3 bedroom
- 3 bathroom
- Sleeps 10
Hawaii> Koloa
Across the street from Brennecke’s and Poipu Beach, perfect for swimming, snorkeling, surfing and beach parties, the Manualoha resort offers one of Kauai’s best locations.
PARRISH PROFESSIONAL CLEAN – Built Upon the Vacation Rental ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
Manualoha 101 is a ground floor, privately located end unit in the Poipu Kai Resort on the knoll just above world famous Poipu Beach Park and Brennecke's Beach.
The premiere location makes it a short walk to beach activities, tennis, ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Poipu
Important Notice: Ongoing Roofing Project in the Manualoha Community
We'd like to inform prospective guests that a roofing project will be
underway during your stay if you book a unit in Manualoha from 1/2025 to 5/2025.
In ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Koloa
Important Notice: Ongoing Roofing Project in the Manualoha Community
We'd like to inform prospective guests that a roofing project will be
underway during your stay if you book a unit in Manualoha from 1/2025 to 5/2025.
In ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Koloa
Manualoha 302
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Perfectly situated just up a garden path from the golden sand of Brennecke's ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Poipu
MANUALOHA 901 AT KOLOA KAI VACATION RENTALS
Spacious 3-Bedroom Condo in Sunny Poipu
Welcome to Manualoha 901, a rare and generously-sized 3-bedroom, 3-bath condo located on the ground floor in the heart of sunny Poipu. Perfect for ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Koloa
Important Notice: Ongoing Roofing Project in the Manualoha Community
We'd like to inform prospective guests that a roofing project will be
underway during your stay if you book a unit in Manualoha from 1/2025 to 5/2025.
In ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
Important Notice: Ongoing Roofing Project in the Manualoha Community
We'd like to inform prospective guests that a roofing project will be
underway during your stay if you book a unit in Manualoha from 1/2025 to 5/2025.
In ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
Important Notice: Ongoing Roofing Project in the Manualoha Community
We'd like to inform prospective guests that a roofing project will be
underway during your stay if you book a unit in Manualoha from 1/2025 to 5/2025.
In ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
Important Notice: Ongoing Roofing Project in the Manualoha Community
We'd like to inform prospective guests that a roofing project will be
underway during your stay if you book a unit in Manualoha from 1/2025 to 5/2025.
In ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
Important Notice: Ongoing Roofing Project in the Manualoha Community
We'd like to inform prospective guests that a roofing project will be
underway during your stay if you book a unit in Manualoha from 1/2025 to 5/2025.
In ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
Important Notice: Ongoing Roofing Project in the Manualoha Community
We'd like to inform prospective guests that a roofing project will be
underway during your stay if you book a unit in Manualoha from 1/2025 to 5/2025.
In ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Koloa
Important Notice: Ongoing Roofing Project in the Manualoha Community
We'd like to inform prospective guests that a roofing project will be
underway during your stay if you book a unit in Manualoha from 1/2025 to 5/2025.
In ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Koloa
Important Notice: Ongoing Roofing Project in the Manualoha Community
We'd like to inform prospective guests that a roofing project will be
underway during your stay if you book a unit in Manualoha from 1/2025 to 5/2025.
In ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Koloa
Important Notice: Ongoing Roofing Project in the Manualoha Community
We'd like to inform prospective guests that a roofing project will be
underway during your stay if you book a unit in Manualoha from 1/2025 to 5/2025.
In ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Koloa
Important Notice: Ongoing Roofing Project in the Manualoha Community
We'd like to inform prospective guests that a roofing project will be
underway during your stay if you book a unit in Manualoha from 1/2025 to 5/2025.
In ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
E Komo Mai to Condo 703 at Manualoha - one of the most coveted locations in all of Poipu Kai Resort! Our two-story island getaway offers ocean views from 2 of the 3 lanais and a quick walk to the ocean-view pool/beach that is the envy of the ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
Important Notice: Ongoing Roofing Project in the Manualoha Community
We'd like to inform prospective guests that a roofing project will be
underway during your stay if you book a unit in Manualoha from 1/2025 to 5/2025.
In ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
Important Notice: Ongoing Roofing Project in the Manualoha Community
We'd like to inform prospective guests that a roofing project will be
underway during your stay if you book a unit in Manualoha from 1/2025 to 5/2025.
In ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
Important Notice: Ongoing Roofing Project in the Manualoha Community
We'd like to inform prospective guests that a roofing project will be
underway during your stay if you book a unit in Manualoha from 1/2025 to 5/2025.
In ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
Important Notice: Ongoing Roofing Project in the Manualoha Community
We'd like to inform prospective guests that a roofing project will be
underway during your stay if you book a unit in Manualoha from 1/2025 to 5/2025.
In ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
MANUALOHA 303 AT KOLOA KAI VACATION RENTALS
Tropical Garden Retreat Near Poipu Beach
Escape to paradise at Manualoha 303, a beautifully upgraded 1-bedroom, 1-bathroom garden-view condo that combines comfort, convenience, and the ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Koloa
