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 '%waipouli%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Oceanfront! Priceless and Tranquil Waipouli Beach Resort an Oceanfront 2 bedroom, 3 bath condo at the beautiful #1 Ranked Waipouli Beach Resort & Spa on the island of Kauai.
There is Central AC in this condo as well as a full size washer and ...
- 2 bedroom
- 3 bathroom
- Sleeps 8
HI> Waipouli
Aloha! Welcome to the luxury Waipouli Beach Resort unit D 308, the biggest 1500
square foot unit with the most central location and breathtaking ocean view from every room!
Let Waipouli Beach Resort D 308 become your Kauai home away from home!...
- 2 bedroom
- 3 bathroom
- Sleeps 9
HI> Kapaʻa
Special* Book Now & We Pay Your Daily Resort Fee's!
No hidden fees, what you see after selecting your dates is the total price.
Building/Unit # C203 decent ocean and Mountain View unit.
The Waipouli Beach Resort is a new concept in luxury ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
HI> Kapaa
Luxurious Hawaiian Modern Timeless Theme Top Floor PENTHOUSE Waipouli Beach RESORT D407, Beachfront Resort.
"CRAZY" Mountain Range VIEWS and Evening SUNSETS, a "ROMANTIC" Master 2bd/3ba w/a King bd in one rm & 2 Full bds in another & Queen ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
HI> Kapaa
Our Most Popular Garden View! This well decorated, Luxury condo is ideal for Families! A two Bedroom/three Bath condo located on the ground floor with easy pool, beach and garden access and a view of the beautiful mountains. Enjoy your evening ...
- 2 bedroom
- 3 bathroom
- Sleeps 8
HI> Kapaa
This luxury garden view 2bd 3ba condo is located at beautiful Waipouli Beach Resort & Spa on Kauai.
We are Unit #A303
Beautifully furnished and with central air for your comfort. The kitchen is fully stocked, top of the line appliances, granite...
- 2 bedroom
- 3 bathroom
- Sleeps 6
HI> Kapaʻa
Oceanfront! Exquisite and Tranquil #1 Rated Oceanfront 2 bedroom, 3 bath condo at the beautiful #1 Ranked Waipouli Beach Resort & Spa on the island of Kauai.
There is Central AC in this condo as well as a full size washer and dryer for ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
HI> Kapaa
If you’re seeking a 5 Star premier vacation condo experience, look no further. This deluxe oceanfront condominium property offers luxurious units with rich hardwood furnishings, gourmet kitchens, and spacious baths. A beautiful, heated river ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Kapaa
PLEASE CHECK HAWAII and KAUAI TOURISM AUTHORITY - COVID POLICY websites to confirm if regulations can be met before booking.
Welcome to paradise on Kauai at Waipouli Beach Resort F-204. This 2 suite bedroom, 3 full bath unit is loaded with ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
HI> Kapaa
Our luxury one bedroom condo is a penthouse (top floor) mountain and pool facing condo with vaulted ceilings, new appliances and Keurig.
The large main bedroom features a King size bed with all new luxury bedding, mahogany wood décor and ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Kapa'a
If a sanctuary on one the worlds most beautiful islands is what you are looking for, Waipouli Beach Resort & Spa is where you want to be. A beautiful beach front setting with Lush Tropical landscaping and Spectacular Views awaits you. The resort...
- 2 bedroom
- 3 bathroom
- Sleeps 6
HI> Kapaa
Special* Book Now & We Pay Your Daily Resort Fee's!
Click the contact owner button and I will respond with a complete quote for you within a few minutes.
Covid-19 UPDATE: IF there is a mandatory quarantine in effect on the day of your ...
- 2 bedroom
- 3 bathroom
- Sleeps 7
HI> Kapaa
Oceanfront! Live the Dream! Ultra Luxury "Beachfront" Ground Floor Unit A104 at Waipouli Beach Resort & Spa offering stunning full oceanfront views from every room, with watercolor sunrises, whale watching and romantic dinners on the lanai with...
- 2 bedroom
- 3 bathroom
- Sleeps 6
HI> Kapaa
Royal Oceanfront G101, an Exquisite Ground Floor Oceanfront Villa! Privacy, "Expansive Lawn".
NEW LANAI FURNITURE by Kingsley Bate!
Paradise Found! Royal Waipouli Beach Resort Oceanfront Ground Floor Villa G101 your vacation destination on ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
HI> Kapaa
This unit is MOUNTAIN VIEW VIEW VIEW!
Special* Book Now & We Pay Your Daily Resort Fee's!
Covid-19 UPDATE: IF there is a mandatory quarantine in effect on the day of your arrival, I will refund you 100% if you request to cancel, and if the ...
- 2 bedroom
- 3 bathroom
- Sleeps 7
HI> Kapaa
