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 (city = 'Kapaa' OR postalCode = 'Kapaa' OR region like '%|Kapaa|%') AND sleeps>=1 order by rating desc LIMIT 0, 15
KrellersGetaway has been renting units at the Islander on the Beach complex since 2005! Just listed each on VRBO, so for 300+ reviews collected over the years, please see HomeAway 960067.
Also, if not all of your dates are open for this unit ...
0 bedroom
1 bathroom
Sleeps 4
HI> Kapaa
GOOD NEWS! Hawaii is open for travelers! Make sure you get a negative covid test within 72 hours of arrival and check all of the details on the Hawaii.gov website so you can have a safe an successful trip to Kaua'i.
PROPERTY DESCRIPTION
You've...
2 bedroom
1 bathroom
Sleeps 6
HI> Kapaa
COVID-19 UPDATE: The state of Hawaii has very strict Arrival requirements. All travelers must register with Safe Travels Hawaii program. You are responsible for complying with the State of Hawaii and County of Kauai regulations. For more ...
3 bedroom
2 bathroom
Sleeps 7
HI> 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 ...
1 bedroom
1 bathroom
Sleeps 4
HI> Kapaa
AVAILABLE DATE: Stay 9 NIGHTS with TWO FULL WEEKENDS!
DECEMBER 23, 2021 - JANUARY 1, 2021
WHY STAY HERE:
This beautiful King Suite Condo has a lanais w) two sets of sliding glass doors and is just steps from the Beach.
...
1 bedroom
1 bathroom
Sleeps 4
HI> Kapaa
"Surf's Up!" at Islander on the Beach
New to Our Rental Program! Newly Decorated for Your enjoyment!
Gorgeous Ocean Front View!
"Surf's Up!" at Island on the Beach 327 has GOOD VIBES. From the moment you step into this prime, third floor ...
0 bedroom
1 bathroom
Sleeps 2
HI> Kapaa
"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
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
HI> 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 Kauai's ...
2 bedroom
2 bathroom
Sleeps 6
HI> Kapaa
Direct Oceanfront with Serene Feel. This establishment has 24 units on the beach. The unit has a full kitchen and is a studio unit on the 2nd floor overlooking the beach and ocean. Enjoy watching the waves roll in and surfing. The ocean in ...
0 bedroom
1 bathroom
Sleeps 2
HI> Kapaa
Aloha! Welcome to our freshly updated oceanfront condo located on the Garden Island of Kauai. The condo offers stunning views of the culturally significant Wailua Bay and the lush mountain range beyond. My grandparents’ home for 40 years, ...
2 bedroom
2 bathroom
Sleeps 4
HI> 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.
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
Islander on the Beach 155
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
You'll love staying at this beautiful condo where you're always steps away from ...
0 bedroom
1 bathroom
Sleeps 4
HI> Kapaa
Our recently remodeled 1 bed, 1 bath home is located on the second floor, so you’ll enjoy more privacy in your home-away-from-home. Being in the corner also gives us breath-taking views of the Pacific Ocean. During whale season, you’ll also ...
1 bedroom
1 bathroom
Sleeps 4
HI> Kapaa
Newly refurnished 2-Bedroom 2-Bath. Can sleep 6 with queen size Aerobed (included). Full size washer and dryer in unit. **Central Air Conditioning installed in December 2020 in Kitchen/Living/Dining Room and in Primary Bedroom**.
Lae Nani is...
2 bedroom
2 bathroom
Sleeps 6
HI> Kapaa