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, 20
Fabulous large 3 bedroom (A/C) and 3 bathroom unit in Building #7 of the popular Manualoha complex at Poipu Kai Resort.
Desirable ground floor corner unit, that's steps from greenway and an easy stroll to Poipu's amazing sandy beaches, the ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> 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
- 3 bathroom
- Sleeps 8
Hawaii> Koloa
Set atop a rising crest is a spectacularly remodeled holiday home that offers the most astonishingly breathtaking views of the shimmering blue Pacific Ocean. The large picture windows and high vaulted ceilings invite the natural sunlight to ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Koloa
Beautifully adorned with the most exquisite and tasteful furnishings, artwork, and pieces, this humble home exemplifies true elegance. The mixture of varying shades of browns, greens, blues and yellow exuberates the aesthetics in each room. As...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
This spacious two-bedroom suite is the ideal relaxation spot for the whole family. The carpeted living room, white-walled interior, spacious layout, and natural sunlight create a welcoming atmosphere perfect for your Garden Isle vacation. ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
Set in the lush tropical landscape of the Manualoha complex in the majestic Poipu Kai Resort, Manualoha 1005 is the perfect home away from home. Verdant lawns, immaculate palm trees, and a variety of fragrant blossoms surround the spacious 2 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
If you’re looking for an island retreat filled with the comforts of home, this quiet condo welcomes you with the perfect aloha spirit. The large one-bedroom and two full bathrooms are spacious for four adults, a family with two+ kids, or a ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Koloa
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
- 2 bathroom
- Sleeps 6
Hawaii> 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
Hawaii> 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
Hawaii> Koloa
Experience the blissful scenic beauty all around in the privacy of your 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 ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> 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
- 2 bathroom
- Sleeps 6
Hawaii> 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
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
E komo mai, welcome to Manualoha 801!
This recently remodeled (2024) multi-level 2bd-2ba condo is just steps from Poipu Beach. The ground level has a fully equipped kitchen, dining area, full bathroom, indoor laundry W/D, and guest bedroom ...
- 3 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Koloa
If you want to maximize your tropical enjoyment, this comfortable condo with its spectacular views offers just that. This 1331 square foot unit features 2 bedrooms, and 2 and a half baths, as well as a fully stocked kitchen with cookware for up ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
The perfect place to spend your island vacation no matter what type of traveler you are: active - snorkeling, golfing, scuba diving, or hiking; or laid back - tanning on a beach, reading beside a pool, whale watching or just unwinding in ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
Manualoha 804 Condo at Poipu Kai Resort is located within walking distance of 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
Hawaii> Koloa
My Kauai Vacation Rental℠ is one of the largest 1 bedroom Condos on all of Kauai - Discounts up to 15% on Stays 7 Nights & Longer for 2024 (discount is automatically applied) — with a full kitchen, washer-dryer and all the comforts of home ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
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