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, rewritten_description,
(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
Gorgeous 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".
Lanai Furniture by Kingsley Bate!
Paradise Found! Royal Waipouli Beach Resort Oceanfront Ground Floor Villa
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kapaa
Experience resort. style oceanfront living in this stunning 2. bedroom, 3. bath condo at Waipouli Beach Resort & Spa, a premier destination on Kauai. With breathtaking direct ocean views from every room, this luxurious retreat is just steps from
- 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
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
$325 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
2025 UPDATE: Pool and hot tub area will be closed for remodeling for approximately 3 months during Sep, Oct, and Nov 2025. Standard nightly rate is $280 plus tax & fees. With the 25% discount the nightly rate is $210.00 plus tax &
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Kapaa
Welcome to Paradise Found, a luxurious oceanfront escape at Hale Awapuhi along Kauai's breathtaking Coconut Coast. Located in an exclusive, gated community with only nine private units, this stunning two-bedroom, two-bath condo offers sweeping
- 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
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
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
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
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> Kapa?a
Wailua Bay View Unit 306 is a premium ocean front condo with stunning views from the lanai. WBV 306 has been renovated with luxurious amenities.
This unit is limited to a maximum of 2 adults. No children or pets are
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kapa?a
This ground-floor studio condo is the perfect tropical getaway for your most memorable vacation. Grab a cold drink, head out to the private lanai to the lush Hawaiian gardens, the sound of birds, and sparkling waves. The private lanai is
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kauai Kapaa
Enjoy an amazing 180-degree view of the ocean overlooking Wailua Bay, a wonderful sandy beach and beautiful green mountains in the background. Your stay here puts you just steps away from the water and on one of the few swimmable beaches on the
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapaa
Lae Nani Resort Kaua'i #312, Beautiful Oceanfront Unit on a Tropical Beachfront Oasis. This Kauai Vacation Rental is conveniently located in Kapaa Town within walking distance to shops, restaurants, and just steps to beautiful sandy beaches.
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kapaa
NEW OWNER- Newly Renovated with Central AIR
Oceanview, Second Floor, 2 Bedroom | 2 Bathroom
A beautiful newly remodeled two bedroom, two bathroom unit on the second floor of building four at Lae Nani, the premier condo property on
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kapaa
Aloha! Welcome to our freshly updated oceanfront condo located on the "Garden Island" Kauai.
- The condo offers stunning views of the culturally significant Wailua Bay and the lush mountain range beyond. My grandparents’ home, the
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> 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,
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kapa?a
ALOHA! This 1st floor, updated unit has a private lanai to enjoy spectacular ocean views, stunning sunrises or perhaps an evening moonrise, if the time is right! This place has it all! The pool is just 20-feet from the lanai, and world-famous
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapa?a
