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 (`headline` like '%pono kai%') AND sleeps>=1 order by rating desc LIMIT 0, 50
This 1 bedroom, 1 bathroom condo comes with a fully equipped kitchen and spacious living area with a sleeper sofa. The bedroom has a King size bed, the second bed is the sleeper sofa in the living room. The condo is fully stocked with linens, ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapa`a
Our 1 Bedroom Garden View 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. Very spacious units fully stocked with linens, ...
- 0 bedroom
- 0 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!
Paradise as you imagined Penthouse in the heart of wonderful Kapa'a Town! Pono Kai Condominiums are perfectly located RIGHT ON ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapaa
Welcome to Pono Kai J201 in Kapaa, Kauai! Escape to your own tropical retreat at Pono Kai J201, nestled on the second floor of the sought-after Pono Kai Resort. This cozy 1-bedroom oasis is perfect for your Hawaiian getaway, offering all the ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> 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, ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> 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
Hawaii> Kapa'a
J305 is a 3rd floor condo in Pono Kai Resort. It has a fully-equipped kitchen. Just installed as of May 2024, Fujitsu Multi-Zone 24,000 BTU total with 9,000 BTU master bedroom and 18,000 BTU in living room. New bamboo shades leading to the ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kapaa
"Lush Garden Island Condo" is a 1 bedroom, 1 bathroom condo with a fully equipped kitchen and spacious living area with a sleeper sofa. There is a Queen size bed in the bedroom. The condo is fully stocked with linens, towels, soap, shampoo, ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> 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!
SEP-NOV 2025 tentative pool closure scheduled (subject to change).
Swim, bike ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kapaa
Welcome to East Kaua'i!
Located within Pono Kai Resort in Kapa'a on the Coconut Coast and 20 mins. from Lihu'e Airport.
This beautiful OCEANFRONT (Newly refurbished in 2019), 1-Bedroom Condo (Queen Bed) with sleeper sofa at east ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kapaa
Beautifully remodeled, 1 bedroom condo with a stunning ocean view. The only thing between you and the beach is the Kauai Coastal Path!
• Cal King bed in the bedroom (new mattress, Dec 2023)
• Queen size wallbed in the living room ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> 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 ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kapaa
This is a 1 bedroom, 1 bathroom condo was just renovated in December 2022. The condo comes with a fully equipped kitchen and spacious living area with a pull out sofa bed. There is AC in BOTH the main living space and the master bedroom!! The ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapaa
Oceanfront one bedroom plus a loft, one bath, top/3rd floor Pono Kai Resort Unit B304 with elevator and beautiful ocean views is centrally located in historic Kapa'a Town with easy access to the North and South shores of Kaua'i. Situated on 13 ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapaa
NOTE: Starting April 5th Kauai is open again for travel with only one covid pre-test! Hurry dates are booking fast!
Imagine sitting on your lanai watching the sunrise, ocean, and waves hitting the beach 75 FEET away! This is what a ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kapa?a
Pono Kai Resort is located on oceanfront/beachfront property. Our garden view condo has a fully equipped kitchen, 1 bedroom and 1 full bathroom. The bedroom has a either a queen or king size bed. There is also a pull out queen sleeper sofa in...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapa?a
This is a 1 bedroom, 1 bathroom condo with a fully equipped kitchen and spacious living area with a murphy bed. The bedroom has a Queen size bed. The condo is fully stocked with linens, towels, soap, shampoo, conditioner and all kitchen ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapaa
This 2 bedroom, 2 bathroom condo comes with a fully equipped kitchen and spacious living area with a sleeper sofa. The first bedroom has a King size bed and the second bedroom has a Queen size bed. The condo is fully stocked with linens, towels,...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kapaa
This 2 bedroom, 2 bathroom condo comes with a fully equipped kitchen and spacious living area with a sleeper sofa. The master bedroom has a king size bed the second bedroom has a queen size bed.. The condo is fully stocked with linens, towels, ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kapaa
Pono Kai Resort B109, Kapa'a Oceanfront two bedroom, Kauai Vacation Rental.
SEP-NOV 2025 tentative pool closure scheduled (subject to change).
Bike or stroll along the Ke Ala Hele Makalae Bike Path directly in front of the condo....
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kapaa
Pono Kai Resort C101, Oceanfront, Kapaa, Kauai Vacation Rental. Just steps to the beach and Coconut Coast bike path. Walk to shops and restaurants.
SEP-NOV 2025 tentative pool closure scheduled (subject to change).
*Two Bedroom, ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kapaa
WAKE UP TO BREATH TAKING KAUAI SUNRISES AND OCEANFRONT 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...and furnished in traditional ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kapaa
Enjoy beautiful sunrises and all the luxuries that accompany beach side living. This two-bedroom ground floor condominium in Pono Kai is steps from a mile-long, sandy beach. This beautiful condominium has been privately owned, cared for, and ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kapaa
The Pono Kai Resort sits on 12 acres in the quiet town of Kapa`a on the east side of the island of Kaua`i. The Resort is right on the beach, which is perfect for wind surfing, kite surfing or wading and frolicking in the waves. This condo is ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapaa
Pono Kai Resort D101
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Pono Kai Resort is the perfect choice for rest and rejuvenation. ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kapaa
LOCATION, LOCATION – the best way to enjoy your stay is in a 3rd (top) floor beachfront condo like Building B at the Pono Kai Resort. Leave the lanai curtains open and enjoy the sound of waves on the beach, feel the trade wind breeze, and ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kapaa
Our 1 Bedroom Ocean Front condo has a fully equipped kitchen, 1 bedroom and 1 private bathroom. The first bedroom has a Queen or King size bed depending on the condo available and the living room has a pull out queen sofa sleeper. Very ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapaa
"Welcoming Condo with Ocean View" This 1 bedroom, 1 bathroom condo comes with a fully equipped kitchen and spacious living area with a sleeper sofa. The bedroom has a King size bed, the second bed is the sleeper sofa in the living room. The ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapa?a
This is 1 bedroom, 1 bathroom condo comes with a fully equipped kitchen and spacious living area with a queen size sleeper sofa. The bedroom has a huge "California" king size bed. This condo is stocked with linens, towels (including pool ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapa'a
Pono Kai Resort J101
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Pono Kai Resort is the perfect choice for rest and rejuvenation. ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kapaa
This is 1 bedroom, 1 bathroom condo comes with a fully equipped kitchen and spacious living area with a sleeper sofa. The bedroom has a King size bed. The condo is fully stocked with linens, towels, soap, shampoo, conditioner and all kitchen ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapa?a
"Garden View Suite" is currently the only 1 bedroom suite in Pohaku Vacation Rentals inventory! At just about 600 sq ft, "Garden View Suite is an affordable options that sleeps 4 guests and includes a kitchenette along with a sleeper sofa. The...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapa?a
Pono Kai Resort, 2 bedroom Ocean Front Condo. King bed in first bedroom, Queen bed in second bedroom, 2 bathrooms, full kitchen, living area, sleeper sofa in living area.
Stroll the 12 lushly landscaped acres and you’ll discover ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kapaa
Kauai Serenity Condo is your perfect island escape! Nestled in the Kapaa which is really the the heart of Kauai, this charming one-bedroom condo with a loft offers a serene and cozy retreat, ideal for couples, small families, or solo travelers ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapa`a
Garden Breeze Retreat is your perfect island escape! Nestled in the Kapaa which is really the the heart of Kauai, this charming one-bedroom condo with a loft offers a serene and cozy retreat, ideal for couples, small families, or solo travelers ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapa`a
"Lush Garden View Condo" is a 1 bedroom, 1 bathroom condo with a fully equipped kitchen and spacious living area with a sleeper sofa. There is a Queen size bed in the bedroom. The condo is fully stocked with linens, towels, soap, shampoo, ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapa`a
***OPEN NIGHTS CHECK IN 11/23/24 TO 1/15/25 WEEKLY SPECIAL - TOTAL ALREADY ADJUSTED FOR THE 7th NIGHT FREE!
Paradise as you imagined it! Oceanview! Steps from the Swimming Pool and Sandy Beach surrounded by lush tropical gardens, in the...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapaa
***OPEN NIGHTS CHECK IN 11/23/24 TO 1/15/25 WEEKLY SPECIAL - TOTAL ALREADY ADJUSTED FOR THE 7th NIGHT FREE!
Kapaa Shore - Beachfront Resort on Kauai!
Paradise as you imagined it! Oceanview! Steps from the Swimming Pool and Sandy ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapaa
