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
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
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
If you are an avid golfer, then staying at this Ground Floor Manualoha condo will give you easy access to first-class golfing facilities and opportunities at the world-renowned Poipu Bay Golf Course. The luxurious master suite has a California ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Koloa
This lovely New 2020 Remodel 852 square foot garden view condo is just a short walk from Brennecke and Poipu Beach, and is close to a variety of great ocean and inland activities; all without feeling like you are in a crowd. Enjoy your meals on ...
- 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
Welcome to Manualoha 901, a rare and spacious 3-bedroom, 3-bath condo located on the ground level in sunny Poipu. This is the perfect spot for a family vacation, as it offers easy access to ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Koloa
The open floor plan, vaulted ceilings, tropical furnishing, upgraded kitchen, and other modern amenities in this beautiful condo will leave you in awe. Tropical trade winds and ceiling fans add to the relaxed atmosphere of this 1700 square foot ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
Located near Brennecke Beach, this charming 1313-square-foot condo is an excellent getaway for you to spend a few days away from the monotony of routine life. The tropically furnished interior immediately whisks your mind away into a vacation ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
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 a carefree and relaxed island feeling. You’ll feel right at home...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
Guests who have stayed in this unit will attest to the charm and beauty of this 2 bedroom/2.5 bath townhouse condo overlooking the azure ocean of the Poipu's South Shore. From honeymooners, first-time visitors, anniversary and birthday ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
Whether you choose to enjoy the outdoors by lounging at the private swimming pool or relaxing in the easily accessible community hot tub, or whether you choose to stay inside watching your favorite movies, listening to your favorite songs, or ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
The beautifully updated two-bedroom and two-bathroom condominium, Manualoha 505 will exceed your expectations for an unforgettable stay in paradise. With 1700 sq. ft., there is room to gather and entertain or stretch out for peace and ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Koloa
Welcome to your bit of paradise in Poipu! The ideal location of the new 2020 remodeled Manualoha 1002 brings you easy and beautiful access to all of Poipu Kai and what it has to offer. This island condo in Poipu will feel like your home away ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Koloa
This enviable vacation rental is located at the Manualoha complex at Poipu Kai Resort in sunny Poipu Beach. Although less than a mile from the beach, the complex pool is practically attached to the Pacific Ocean and provides a private getaway ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Koloa
This beautifully renovated, ground floor, one-bedroom end unit with no unit above, provides quiet and privacy for your dream Hawaiian getaway. Windows on three walls and ceiling fans throughout let you enjoy the cooling trade winds. Cook at home...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Koloa
Splendidly remodeled and upgraded with new furnishings in 2021, Manualoha 404 in renowned Poipu Kai Resort offers all the thrills of the perfect tropical retreat. This gorgeous 2 bedroom, 2.5 bath home is surrounded by a flourishing landscape ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
2nd bedroom is a Loft Surrounded by swaying palms, you will find this 1184-square-foot beautiful condo to be your own Hawaiian Paradise. The unique setup of this one-bedroom condo permits for an additional separate loft area allowing it to ...
- 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
This 1300 square feet condo 2 bedrooms, 2 bath ocean view condo offers spectacular ocean and mountain views in addition to all the comforts of home. Enjoy lounging in the fully furnished living room; dine in or out on the lanai while watching ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
Spacious enough to accommodate up to six vacationers, this centrally located condo is minutes away from Brennecke Beach, Poipu Beach, and Shipwreck Beach, and is fully furnished with a king-size bed, two twin-size beds, and a pull-out sofa bed. ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
Nestled within the lush landscape of the Poipu Kai Resort, you will find a true island gem, Manualoha 402. This spacious 2 bedroom, 2.5 bath townhouse style condo offers amazing views of the ocean and is only a short stroll to popular ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
MANUALOHA 303 AT KOLOA KAI VACATION RENTALS
Take full advantage of this amazing upgraded one-bedroom garden view condo, where the cooling trade winds sweep through, bringing in the sweet scent of the surrounding flowers. The tropical ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Koloa
