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 (city = 'Koloa' OR postalCode = 'Koloa' OR region like '%|Koloa|%') AND sleeps>=1 order by rating desc LIMIT 0, 15
This is a 3 story building with our 2 story unit located on second and third floors with entry to condo up a flight of stairs. We have four bedrooms, 2 on the second story (the condo's main floor) which are Master suites. While upstairs on the ...
4 bedroom
4 bathroom
Sleeps 8
HI> Koloa
This 3rd-floor, 880sf tropical retreat for four offers a spacious living area and WiFi Internet. Its large, furnished lanai overlooks beautiful gardens, ponds, and the glittering beaches of Poipu.
Fringing Poipu Beach, this plantation-style...
1 bedroom
1 bathroom
Sleeps 4
HI> KOLOA
Lawai Beach Resort 1 Bedroom Sleeps 4
**PLEASE READ ENTIRE DESCRIPTION BEFORE REQUESTING RESERVATION**
Book our Amazing Timeshare & let The Timeshare Brokers, LLC make the booking process easy!
Key Points:
-You’re inquiring on a ...
1 bedroom
1 bathroom
Sleeps 4
HI> Koloa
Our professional cleaning staff have received formal training on the CDC Guidelines, and we are making your health our number one priority. All surfaces are sterilized and cleaning supplies are being made available to our guests for interim use...
4 bedroom
6 bathroom
Sleeps 10
HI> Koloa
Embrace the open, airy feel of this 690sf ground floor island home with views flowing from lush lawns to furnished lanai and into the living area and open kitchen. Easy island living rolls out with cool tile floors, ceiling fan, WiFi, flat ...
1 bedroom
1 bathroom
Sleeps 4
HI> KOLOA
Embrace casual living in this 690sf suite with a furnished lanai flowing onto the landscaped lawn. Touches include a full kitchen and dining table that make at home meals a breeze, ceiling fans, WiFi, wall-mounted flat screen with DVD and ...
1 bedroom
1 bathroom
Sleeps 4
HI> KOLOA
You’ll love the glass block walk-in shower of this 690sf villa where the ocean peaks above a canopy of trees off the lanai. Upgraded with wood cabinets and granite countertops, the kitchen flows into a living area with dining table, ceiling ...
1 bedroom
1 bathroom
Sleeps 4
HI> KOLOA
Savor “at home” dining on the furnished lanai of this 690sf suite that defines casual island comfort. Conveniences include an open kitchen for prepping meals, roomy living area, private bedroom, ceiling fans, flat screen, Wi-Fi, DVD and ...
1 bedroom
1 bathroom
Sleeps 4
HI> KOLOA
Welcome to this amazing 3rd floor condominium with two bedrooms and two bathrooms. You’ll love the modern look of this unit, featuring granite kitchen and bathroom countertops, large ceramic floors, large wicker furniture, and stone showers. ...
2 bedroom
2 bathroom
Sleeps 6
HI> Koloa
You’ve arrived! This comfy 640sf island-style retreat sleeping four welcomes you to laid back Poipu living. Laze the day away overlooking the grassy green lawns and tropical flowers. Dine at home with meals cooked in your full kitchen. Then ...
1 bedroom
1 bathroom
Sleeps 4
HI> KOLOA
GOOD NEWS! Hawaii is open for travelers! Make sure you get a negative covid test within 72 hours of arrival and check all of the details on the Hawaii.gov website so you can have a safe an successful trip to Kaua'i.
PROPERTY DESCRIPTION
...
2 bedroom
2 bathroom
Sleeps 6
HI> Koloa
Tropical Delight, this 690sf ground floor suite lets you vacation your way! Sleep in, hit the tennis courts and then prep dinner in the modern kitchen to savor on the lanai. Touches include WiFi, flat screens, ceiling fans, washer/dryer and ...
1 bedroom
1 bathroom
Sleeps 4
HI> KOLOA
★The Fab Four is a roomy and centrally air conditioned home with plenty of space for your whole crew. Walk to the beach and take the provided beach towels in the little wagon.
》4 bedrooms (KKQ - 2 twins), 3 full bathrooms
》Spacious ...
4 bedroom
3 bathroom
Sleeps 9
HI> Koloa
Enjoy our breathtaking oceanfront resort style home, in Poipu Beach Kauai. Featuring 1837sqft of spacious condo living, with spectacular ocean, pool, and sunset views. With its classic Hawaii plantation style architecture and design, ...
2 bedroom
3 bathroom
Sleeps 6
HI> Koloa
Bright and airy, this tropical “home away from home” makes you want to stay in Poipu forever! The 880 sq ft suite pampers with epic ocean views, full kitchen for dining ease, furnished lanai for soaking in scenery, ceiling fans, WiFi, and ...
1 bedroom
1 bathroom
Sleeps 4
HI> KOLOA