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 '%pono kai%') AND sleeps>=1 order by rating desc LIMIT 0, 15
The Pono Kai Resort in Kauai 2 Bedroom Ocean View Unit Sleeps 6
**PLEASE READ ENTIRE DESCRIPTION BEFORE REQUESTING RESERVATION**
Book our Amazing Condo & let The Timeshare Brokers, LLC make the booking process easy!
Key Points:
-You’re ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kapa'a
J305 is a 3rd floor condo in Pono Kai Resort. It has been newly remodeled with a fully-equipped kitchen. There is A/C in the living room with sliding glass doors leading onto the lanai, perfect for relaxing and enjoying the view of the grounds ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Kapaa
I know his has been a very trying time for everyone and I hope that Covid-19 has not touched your life personally. I have worked with all of my guests that have had to cancel due to their concerns and/or the state of Hawaii instituting ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
HI> Kapaa
Beautifully remodeled, 1 bedroom condo with a stunning ocean view. The only thing between you and the beach is the Kauai Coastal Path!
• King size bed in the bedroom
• Queen size wallbed in the living room (that's a real mattress, not a ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kapaa
The resort is located in the historic town of Kapaa, Kauai. You can catch the sunrise in the morning over the Pacific Ocean or even see whales during migrating season. The resort is within walking distance of restaurants, boutiques, shopping ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kapaa
GARDEN VIEW CONDO JUST STEPS FROM THE OCEAN!!!
This beautiful Pono Kai Condo (Building H) is steps from the ocean and the beach!! With a full kitchen, dining area, living room, private patio, pool, hot tub, tennis, exercise room, volleyball, ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kapaa
Without a doubt, the Pono Kai Zen Retreat is the finest unit on this 15 acre property. This 2 bedroom 2 bath condo is literally only steps to the warm Pacific Ocean! Golden sunrises, warm trade winds, and shimmering waters next to a mile-long ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kapa'a
Pono Kai Resort is located on oceanfront/beachfront property. Our condo has a fully equipped kitchen, 1 bedroom and 1 full bathroom. The bedroom has a Queen size bed. There is also a pull out sleeper sofa in the living room, fully stocked ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kapaa
Pono Kai Resort B101, Oceanfront, 2 bedroom, 2 bath end unit in the heart of Old Kapa'a Town.
Air conditioning in both bedrooms and living/dining area!
We have implemented enhanced cleaning and disinfecting guidelines as well as infection ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kapaa
Pono Kai Resort is located on oceanfront/beachfront property. Our condo has a fully equipped kitchen, 1 bedroom and 1 full bathroom. The bedroom has a Queen size bed. There is also a pull out queen sleeper sofa in the living room, fully ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kapaʻa
Our condo has a fully equipped kitchen, 1 bedroom and 1 full bathroom. The bedroom has a Queen size bed. There is also a pull out sleeper sofa in the living room. They are very spacious units. The units are fully stocked with linens, towels,...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kapaa
WAKE UP TO BREATH TAKING KAUAI SUNRISES AND OCEAN FRONT VIEWS from the MASTER BEDROOM, LIVING/DINING ROOMS and KITCHEN!!
This Beautiful 1200 sq/ft. Pono Kai Condo directly in front of the ocean and the beach!! Full kitchen, dining room, ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kapaa
Pono Kai Resort B109, Kapa'a Oceanfront two bedroom, Kauai Vacation Rental.
We have implemented enhanced cleaning and disinfecting guidelines as well as infection prevention advice provided by the CDC. This is a Contactless Check-In Property.
...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kapaa
THE VIEW IS UNBELIEVABLE!!
Picture yourself on the lanai at sunrise. Directly, unobstructed, 50 FEET from the ocean, and experiencing the most breathtaking sunrise of your life. This Beautiful Pono Kai Condo is the place!! Complete ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kapaa
Minimum Stay 3 Nights - THIS UNIT IS NOT ELIGIBLE FOR QUARANTINE.
Please note "Hawai'i Safe Travels" restrictions and rules to visit Hawai'i. Visit www.travel.hawaii.gov for details.
We furnish 2 boogie boards, 2 beach chairs, and a cooler ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Kapaa
