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 '%lae nani%') AND sleeps>=1 order by rating desc LIMIT 0, 15
"Simply Paradise" at this Oceanfront Condo Suite at Lae Nani 123!
E komo mai i kēia Lae Nani! Welcome to this beautiful point, a peaceful and lovely haven on the shores of Wailua, Kauaʻi
Lae Nani 123 is a 1 bedroom, 1.5 bath condo suite is...
1 bedroom
2 bathroom
Sleeps 4
HI> Kapaa
Centrally located on the Royal Coconut Coast, our property gives access to the most desirable destinations the beautiful Garden Island of Kauai has to offer and puts you in close proximity to the top family-friendly beaches, scenic trails, and ...
1 bedroom
1 bathroom
Sleeps 6
HI> Kapaʻa
Oceanfront Second Floor Lae Nani Condo | 1 Bedroom | 1.5 Bathroom
The newly remodeled Lae Nani 523 is a peaceful aesthetic haven of comfort and relaxation. This beautiful condominium is located on the Kaua'i Coconut Coast, only a 7 mile drive ...
1 bedroom
2 bathroom
Sleeps 2
HI> Kapaa
Please know we are awaiting your arrival at Lae Nani and have taken extra precautions in our cleaning methods to prevent Covid infection. There will be hand sanitizers and other supplies for your safety!! Are you ready to relax?! Come to Kauai...
1 bedroom
2 bathroom
Sleeps 3
HI> Kapaa
Paradise awaits you in this beautiful one bedroom, two full baths Lae Nani Condo, Unit #317 on the Coconut coast of the Garden Isle of Kauai!
The recently remodeled ground floor unit, with new owners...new on the market!
Located on Kauai’s ...
1 bedroom
2 bathroom
Sleeps 4
HI> 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 8
HI> 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 (Poipu, ...
2 bedroom
2 bathroom
Sleeps 4
HI> Kapaʻa
Completely remodeled ~ finished in 6/2018
Located on Kauai's beautiful central coconut coast. Lae Nani 338 overlooks the ocean, majestic mountains and beautifully landscaped gardens that roll into the sea
...
1 bedroom
2 bathroom
Sleeps 3
HI> Kapaa
Lae Nani Condo unit 435 is a 2-bedroom, 2-bathroom Penthouse unit with two ocean view lanais from the main living area and the master bedroom suite.
Lae Nani Grounds:
There are only 83 units at this gated, oceanfront condo complex, nestled ...
2 bedroom
2 bathroom
Sleeps 4
HI> Kapaʻa
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.
...
1 bedroom
2 bathroom
Sleeps 4
HI> 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 Location...
1 bedroom
2 bathroom
Sleeps 2
HI> Wailua
Lae Nani 231 is located on Kauai's beautiful coconut coast. The Penthouse overlooks the pool, lawn, beach, ocean and majestic mountains. We are located on the top floor in a corner end unit, which provides the ultimate privacy. Panoramic ocean ...
1 bedroom
2 bathroom
Sleeps 2
HI> Kapaʻa
***Ground Floor Oceanview Condo Unit 211***
Steps from the beach, Lae Nani 211 is a lovely, newly renovated and furnished condo on the beach in Wailua on Kauai's east side. We are only a short walk to a variety of shops, restaurants and ...
1 bedroom
2 bathroom
Sleeps 4
HI> Kapaa
Our ocean front condo has been recently remodeled with all new furniture, kitchen appliances & countertops, Smart TV, window coverings and a new comfy king size bed. From inside our unit and from our lanai, we have a wonderful view of the ...
1 bedroom
2 bathroom
Sleeps 2
HI> Kapaa
10% DISSCOUNT to February 1, 2021
Our Lae Nani unit opens to a captivating view of the beach, ocean, the stunning tropical landscaping and the Wailua Bay. It is a second floor unit. We have completed major remodeling with a new kitchen, ...
1 bedroom
2 bathroom
Sleeps 4
HI> kapaa