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 (`propertyName` like '%Manualoha%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Located on seventy acres of lush tropical landscape, this two-bedroom ocean view condo is a vacationer's dream come true. Vaulted ceilings and an open split-level floor plan emit the carefree and relaxed island feeling. You’ll definitely feel ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
HI> Koloa
Manualoha 501
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Beautifully situated among rustling palms and verdant tropical greenery, this ...
- 1 bedroom
- 2 bathroom
- Sleeps 5
HI> Koloa
This beautiful garden condominium is located in Popui Kai's Manualoha, this community's signature is the gorgeous flowering gardens and bougainvillea all around you. The wonderful ground floor location gives this home a very private feel. The ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Koloa
Experience the blissful scenic beauty of your own living room. Located in one of the more popular and well-known areas of Poipu, this Manualoha condo is the perfect setting for an unforgettable vacation. Just steps from your lanai are Brennecke ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Koloa
Offering spectacular garden views, this two-bedroom Manualoha condo is an ideal place to spend your vacation amid peace and nature. For those who take pleasure in cooking, you will be delighted with the fully equipped upgraded kitchen that leads...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Koloa
Decorated in a relaxed tropical style, you will immediately feel at ease in this 1313 square foot Pacific Island getaway. The living room brings an open and welcoming feel, while the spacious master bedroom, with king bed, provides a sweet ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Koloa
The unique features of this stunning 1531 square foot condo are what keep this accommodation in high demand. From the upgraded kitchen with stainless steel appliances to the beautiful spiral staircase, you’ll truly appreciate the luxury and ...
- 3 bedroom
- 4 bathroom
- Sleeps 8
HI> Koloa
Brand new flooring, bathroom, and kitchen remodeled in 2018. The rattan furniture and tropical artwork in this luxurious condo showcase Kauai’s true laid-back island style. The private lanai just out of the living room is perfect for a ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Koloa
Manualoha Luxury Condo at Poipu Kai Resort is located within walking distance to Brennecke's and Poipu Beach, perfect for swimming, snorkeling, surfing, and beach parties. Manualoha 804 opens up to the gardens and spacious lawns, a spectacular ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Koloa
Our garden townhome is a two story, end unit with a very private spacious feel and a spectacular ocean view just steps away. Cooling is provided by ceiling fans located throughout the unit (no air conditioning). The upstairs master bedroom ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Koloa
Spend your day at the beach, out hiking or golfing then back to the condo for a beautiful sunset and BBQ ! Spacious, airy 2 bedroom, 2.5 bath condo with fantastic ocean and mountain views. A short walk down the greenbelt path to both ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
HI> Koloa
Spacious 1750sq ft,2 king beds,2+ baths,beautifully furnished.
Located among the lush acreage of the Poipu Kai Resort and within a 5 minute walk of Brenneke's Beach and another few minutes along the ocean to Poipu Beach Park our spacious 1750...
- 2 bedroom
- 3 bathroom
- Sleeps 5
HI> Poipu
Swimsuit…check. Sunglasses…check. Mai Tai…check. Don’t bring anything else, because this luxury condo in the Manualoha complex of the famed Poipu Kai Resort invites you to experience the real Kauai lifestyle in total relaxation. An open ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
HI> Koloa
Set in a splendid and convenient location, this condo can be yours to enjoy while exploring the exhilarating island of Kauai. This 1331 square foot condo has a fully equipped kitchen with full-size appliances, pots, pans, utensils, and ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
HI> 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 Beach, this ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Poipu
