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 (`headline` like '%Marriott\'s Waiohai Beach%') AND sleeps>=1 order by rating desc LIMIT 0, 15
This condo is located within the Marriott Vacation Club’s Waiohai Beach Club resort, on the lovely south shore of Hawaii’s Garden Isle, Kaua’i. This is a spectacular beachfront resort with lush grounds and lovely outdoor pools. All ...
2 bedroom
2 bathroom
Sleeps 8
HI> Koloa
Enjoy a luxurious stay for a fraction of the cost. Typical savings range from 30-70% when comparing our rates to direct resort bookings. All of our units are managed and maintained by the resort. Upon arrival, guests will check-in at the ...
2 bedroom
2 bathroom
Sleeps 8
HI> Koloa
Enjoy a luxurious stay for a fraction of the cost. Typical savings range from 30-70% when comparing our rates to direct resort bookings. All of our units are managed and maintained by the resort. Upon arrival, guests will check-in at the ...
2 bedroom
2 bathroom
Sleeps 8
HI> Koloa
Enjoy a luxurious stay for a fraction of the cost. Typical savings range from 30-70% when comparing our rates to direct resort bookings. All of our units are managed and maintained by the resort. Upon arrival, guests will check-in at the ...
2 bedroom
2 bathroom
Sleeps 8
HI> Koloa
Concierge Realty is proud to present luxury villas at Marriott's Waiohai Beach Club.
Reservations available in 7 night increments with arrivals and departures on Fridays, Saturdays and Sundays only.
Kaua'i is Hawaii's most remote and private ...
2 bedroom
2 bathroom
Sleeps 8
HI> Koloa
Rentals at Marriott's Waiohai are available in 7 night increments, with check in on Friday, Saturday, or Sunday. We cannot accommodate mid-week check ins. Please "CONTACT HOST" to ask about availability and an accurate price quote, as the Vrbo ...
2 bedroom
2 bathroom
Sleeps 8
HI> Koloa
Concierge Realty is proud to present luxury villas at Marriott's Waiohai Beach Club.
Reservations available in 7 night increments with arrivals and departures on Fridays, Saturdays and Sundays only.
Kaua'i is Hawaii's most remote and private ...
2 bedroom
2 bathroom
Sleeps 8
HI> Koloa
The Waiohai Beach Club is beautifully landscaped with waterfalls and lagoons, lush tropical plants, and the sandy shores of Poipu Beach just steps away. Spend a lazy day in the sun snorkeling or swimming in the ocean or either of the two outdoor...
2 bedroom
2 bathroom
Sleeps 8
HI> Koloa
Don't be modest; you are not the average traveler. Where others go on vacation, you have life experience. While others enjoy their surroundings, you immerse yourself in them. Luckily for you, Marriott's Waihoi Beach Club caters to your need for ...
2 bedroom
2 bathroom
Sleeps 8
HI> Koloa
Experience the unparalleled magic of Hawaii at Marriott's Waiohai Beach Club, a premium vacation ownership resort on Kauai. Located by the ocean on Poipu Beach, we offer spacious villa rentals and an array of resort amenities for your visit to ...
2 bedroom
2 bathroom
Sleeps 8
HI> Koloa
Marriott's Waiohai Beach Club welcomes you to Poipu, Kauai with elegant accommodations and a wide range of wonderful amenities. You'll feel at home the moment you step into your chic guest room or modern villa rental, which is equipped with ...
2 bedroom
2 bathroom
Sleeps 8
HI> Koloa
Concierge Realty is proud to present luxury villas at Marriott's Waiohai Beach Club.
Reservations available in seven night increments with arrivals and departures on Fridays, Saturdays and Sundays only.
Kaua'i is Hawaii's most remote and ...
2 bedroom
2 bathroom
Sleeps 6
HI> Koloa