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 (city = '96746' OR postalCode = '96746' OR region like '%|96746|%') AND sleeps>=1 order by rating desc LIMIT 0, 50
Paradise awaits you in this beautiful ground floor, one-bedroom, two-full-bath Lae Nani Condo, Unit #317 on the beautiful Garden Isle of Kauai!
Located on Kauai’s beautiful Coconut Coast (East side), this Condo has all the amenities you...
- 1 bedroom
- 4 bathroom
- Sleeps 4
Hawaii> Kapaa
Aloha and welcome to our tropical paradise in beautiful Kauai, Hawaii!
Indulge in an extraordinary couples' getaway at our top floor ocean and beachfront studio condo in Kapa'a. Just 150 steps from our condo's front door, the beach ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kapaa
Aloha and welcome to our tropical paradise in beautiful Kauai, Hawaii!
Indulge in an extraordinary couples' getaway at our top-floor ocean view studio condo in Kapa'a. Just 160 steps from our condo's front door, the beach awaits! ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kapaa
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
Newly renovated condo with 2 TV's, WIFI, Washer & Dryer, Dishwasher, Stove, Fridge, Keurig Coffee Machine, Nespresso Machine and Microwave. One bedroom has a king size bed and the other has a queen size bed. 55" Flat screen smart TV in Living ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapaa
Enjoy stunning ocean views from all the bedrooms and living area of the condo. Greet every morning on your bed enjoying the views and sounds from the ocean!
*** OCEANFRONT overlooking greenbelt, quiet and private, no noise from pool or ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kapaa
Stylish Oceanfront 2nd Floor 2 Bedroom | 2 Bathroom
Lanikai is centrally located on the Island yet 'tucked away'. This elegant second floor unit has sweeping Ocean views. This luxurious condo comes with a fully-equipped kitchen area ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kapaa
***OPEN NIGHTS CHECK IN 11/19/24 TO 1/15/25 WEEKLY SPECIAL - TOTAL ALREADY ADJUSTED FOR THE 7th NIGHT FREE!
Gorgeious Oceanview 2 Bedroom, 3 Bathroom Condo at First Class Waipouli Beachfront Resort & Spa on Beautiful Kauai.
There ...
- 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 $395 per night plus taxes, outclean, resort fee, admin, damage protection
...
- 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
Waipouli Beach Resort Gorgeous Luxury Ocean View Condo! Sleeps 8!
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 ...
- 2 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Kapaa
*** OPEN NIGHTS CHECK IN 11/23/24 TO 1/15/25 WEEKLY SPECIAL - TOTAL ALREADY ADJUSTED FOR THE 7th NIGHT FREE! ***
Oceanview! Beautiful! Luxury Gorgeous Oceanview from Living Room, Dining Area and Lanai. Located in Coveted Oceanfront H ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kapaa
Unit #324 is third floor (Top Floor) DIRECT oceanfront and is in a perfect location in the complex. It has panoramic ocean views of the stunning Pacific Ocean. Being that it is on the top floor, you have the great views and optimal privacy. ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
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
WHY STAY HERE
Kauai Coast Resort at the Beachboy is the perfect beachfront location in Kapaa next to the Coconut Marketplace. The spacious suites are decorated to let the Hawaiian culture be seen throughout the resort. Filled with ...
- 2 bedroom
- 1 bathroom
- Sleeps 6
Hawaii> Kappa
$275 per night up to 4 guests. $35 per night for each additional guest. Due to oceanfront location, this unit is located within the Tsunami Evacuation Zone.
Honu Hale Kai is a warm and casual home base for your family vacation ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kapaa
Tropical Garden Cottages—One Block from Beach
Why stay at Fern Grotto Inn? The reasons are as numerous as our glowing guest reviews. In fact, Fern Grotto Inn recently became the best-rated vacation rental on TripAdvisor and was featured...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kapaa
Renovation Dates: 1/4/25 - 3/7/25
We have applied a 25% discount due to refurbishments to the interiors of various condos in the F building. The standard nightly rate is $255 + tax & $180 cleaning fee. The discounted rate will be $191 + tax ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Kapaa
The Kauai Coast is a beautiful Shell Vacations/ Wyndham Resort located near the Coconut Marketplace in the centrally located town of Kapaa, Kauai. This beautiful resort offers beach access and features a full kitchen, with living room/dining ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapaa
Welcome to "Paradise Found" at Hale Awapuhi, a luxurious 2-bedroom, 2-bath oceanfront condo on Kauai's stunning east shore. Nestled within a private, gated community, this exclusive retreat offers breathtaking ocean views and the ultimate island...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kapaa
Penthouse Luxury Oceanfront, Third Floor, 2 Bedroom | 2 Bathroom with Central Air
Fall asleep to the sounds of enchanting surf and awake to tropical sunrises in this spectacular and fully remodeled 2 bedroom condo overlooking Wailua Bay ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kapaa
At Lae Nani #511, you will feel truly relaxed, surrounded by lush tropical landscaping and listening to the soothing sound of the ocean’s waves breaking on the shore. The location of this three-bedroom suite is ideal, providing views of the ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kapaa
Newly refurnished 2-Bedroom 2-Bath. Can sleep 6 with queen size Aerobed (included). Full size washer and dryer in unit. **Air Conditioning installed in all rooms**.
Lae Nani is by far the nicest condominium community on Papaloa Road, ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kapaa
Please know we are awaiting your arrival at Lae Nani and have taken extra precautions in our cleaning methods with Covid infection in mind. Are you ready to relax?! Come to Kauai and stay at Lae Nani 513! Whether you want to lay on the beach ...
- 2 bedroom
- 2 bathroom
- Sleeps 3
Hawaii> Kapaa
Another unit we'd love to share with you! Ground floor unit just steps from the beautiful Wailua Bay. Ask anyone, Lae nani is the premier resort of the Coconut Coast; your vacation is sure to exceed your expectations.
Enjoy a cup of ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kapaa
Welcome to the Waipouli Beach Resort and Spa! The premier resort on Kauai!
Waipouli Beach Resort and Spa is located beach front on the Coconut Coast between the historic towns of Kapaa and Wailua. Located convenient to both Princeville...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kapaa
NOTE: For Kauai travel requirements due to Covid-10, please visit:
https://Kauai.Gov/Covid-19
The Wailua Hideaway vacation home borders the Opaekaa Stream just behind Sleeping Giant mountain on Kauai's East side, in the Wailua ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kapaa
Welcome to 'Wailua Hale Lani'; our beautiful, Kauai, one bedroom, one bath condominium at Wailua Bayview. The condominium is on the second floor (#201) of a three-story, 45 unit complex. Continually updated and meticulously maintained, the unit...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapa'a
Centrally located on east coast of Kauai, commonly known as the Royal Coconut Coast. If you have found this property you have found a jewel. No other coastline provides you with central access to both north and south shores; no other coastline ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kapaa
Book with Confidence! If there is any government restriction in the United States which prevents you from travelling to Kauai, or which imposes an isolation period for travellers upon arrival in Kauai, I will refund 100% of your payment (I ...
- 2 bedroom
- 1 bathroom
- Sleeps 2
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
*CoronaVirus Update:* There are no domestic travel restrictions to Hawaii. No documentation or quarantine is required for domestic travel to Hawaii and interisland travel within Hawaii, effective March 26, 2022. Kauai specific information can be...
- 4 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Kapaa
Private master bedroom, semi private twin beds, pantry, regular coffee maker, toaster, electric stove, dishwasher, refrigerator/freezer, microwave and many accessory cooking utensils. Walk in shower, washer and dryer. Lot's of storage, deck ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
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
Air Conditioned! Swimmable Beach. Lae Nani unit #411 is a corner, ocean view unit located in building 4 of the complex with Three large bedrooms and Two full bathrooms . The unit has been fully renovated and professionally decorated with ...
- 3 bedroom
- 2 bathroom
- Sleeps 7
Hawaii> Kapaa
Lae Nani is a premier property on the Coconut Coast centrally located near grocery stores, galleries, restaurants, small boutique shops, etc.
Our condo is on the ground floor in Building Five and here are some of the features:
-Location ...
- 1 bedroom
- 2 bathroom
- Sleeps 2
Hawaii> Wailua
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 ...
- 3 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
1 BR w/Den, Full Kitchen, Garden, Pool, Mountain And Ocean Views. Have whole Condo air conditioning.
We LOVE Kauai and hope you will too! You are invited to come and enjoy our beautifully renovated condo in paradise. A ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapaa
If you are looking for the absolute best location at Waipouli Beach Resort in Kauai...look no further. This one-of-a-kind ground level beachfront/oceanfront vacation condo is the most sought after property at Waipouli Beach resort! Step off ...
- 3 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
Welcome to our beach front home on the Island of Kauai!
Lae Nani is a beautiful resort located on the east side of Kauai, just south of Kapaa. Our location gives you easy access to the North Shore (Napali Coast) and South Shore ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kapaa
