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 (`headline` like '%waipouli%') AND sleeps>=1 order by rating desc LIMIT 0, 20
Welcome to the oceanfront paradise on Kauai at Waipouli Beach Resort Unit F-204!
This unit is a 2 Master Suite bedroom with 3 full bathroom floorplan. Each Master Suite comes with a smart flat screen television, balcony, dresser and ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kapaa
Gorgeious Oceanview 2 Bedroom, 3 Bathroom Condo at First Class Waipouli Beachfront Resort & Spa on Beautiful Kauai.
There is Central AC in this condo as well as a full size washer and dryer for laundry!
This exceptionally, well ...
- 2 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> 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
Hawaii> Kapaa
Gorgeous Oceanfront Waipouli Beach Resort G302, one of Waipouli Beach Resort's most desirable Ocean Front suites, offers spectacular 180 degree unobstructed ocean and sandy beach views. You can see the ocean from every room! Fall asleep to the ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kapaa
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 8
Hawaii> Kapaa
Royal Oceanfront G101, an Exquisite Ground Floor Oceanfront Villa! Privacy, "Expansive Lawn".
OPEN DATES FALL 2024 SPECIAL
Lanai ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kapaa
Oceanfront! Resort Living at its Best in this Ultimate Luxury Condo Waipouli Beach Resort Oceanfront. Extraordinary Oceanfront 2 bedroom 3 bath condo at the beautiful Waipouli Beach Resort & Spa on the island of Kauai named Hawaii’s #1 ...
- 2 bedroom
- 3 bathroom
- Sleeps 7
Hawaii> Kapaa
Kauai Calls! Premier Luxury Gorgeous Oceanview! One of the most gorgeous views of the resorts tropical grounds, the beach and the ocean during the day; and, at night the fire glow of the tiki torches reflecting in the pool and the moon ...
- 2 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Kapaa
Oceanview! Beautiful! Luxury Gorgeous Oceanview from Living Room, Dining Area and Lanai. Located in Coveted Oceanfront H Building, a one bedroom, two bath condominium at the "New" Waipouli Beach Resort on Kauai. This 2nd floor, oceanview with ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> 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
Hawaii> Kapaa
Experience a Vacation of your Dreams in Exquisite Luxury Oceanview Waipouli Beach Resort & Spa H204 offering one of the most spectacular views of the sparkling blue azure Pacific Ocean as it washes over the white sand beachfront just beyond the ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kapaa
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...
- 2 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> 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
Hawaii> Kapaa
Extra Large Unit! Beautiful Luxury Decor!
Exquisite Luxury Condo of Distinction located at the World Renown Waipouli Beach Resort on the Coconut Coast of Beautiful Kauai!
Guest Reviews:
"Aloha! Thank you for an incredible ...
- 2 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Kapaa
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
Hawaii> 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 ...
- 2 bedroom
- 3 bathroom
- Sleeps 7
Hawaii> 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, ...
- 2 bedroom
- 3 bathroom
- Sleeps 7
Hawaii> Kapaa
Special* Book Now & We Pay Your Daily Resort Fee's!
No hidden fees, what you see after selecting your dates is the total price.
The Waipouli Beach Resort is a new concept in luxury accommodations on the lush island of Kauai, Hawaii ...
- 2 bedroom
- 3 bathroom
- Sleeps 7
Hawaii> 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 & ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kapaa
Penthouse - Ocean & Pool View 1 bedroom "Jewel" - AC
Experience your vacation in this Beautiful Ocean and Pool View, a 1 bedroom, 2 bath condo "Jewel" in this Oceanfront Resort & Spa. From the moment you walk into the living room and ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kapaa
