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 (`headline` like '%Keauhou Punahele%') AND sleeps>=1 order by rating desc LIMIT 0, 50
Keauhou Punahele #B108 is an excellent location for relaxation, close to Keauhou Bay and the shopping center. Enjoy this two-bedroom, two-bathroom, ground-floor unit. Relax on the large lanai with a barbecue grill, outdoor seating, and garden
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kailua-Kona
Keauhou Punahele
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
This dreamy island condo is waiting to welcome you to a true slice of
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Kailua-Kona
Keauhou Punahele#E-202 is a fantastic option for your Hawaii Vacation. You'll appreciate no stairs to access the unit! Bridge unit allows easy access.
Paradise awaits you in the Keauhou area of Kailua-Kona, Hawaii. This beautiful vacation
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua Kona
Hawaii, Big Island, Kona, Keauhou Punahele, golf course with the ocean in the background. The condo is located close to Keauhou Bay, Keauhou shopping center (with cinema) and snorkel/surfing beaches.
We have owned this top floor 3
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kailua-Kona
Keauhou Punahele #B-107 is a beautiful ground floor 2 bedroom, 2 bathroom condo with approximately 1200 interior sq feet. It sits right on Keauhou Country Club golf course. Enjoy an expansive lanai that reaches from living room to the master
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kailua Kona
Say “Aloha” to your own slice of the Hawaiian Islands in this lovely island-themed 2 bedroom 2 bath unit in the beautiful Keauhou Punahele Condominium Complex. With all the convenience of home, have it all on your island retreat. With
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kailua-Kona
Keauhou Punahele#D-103 is a beautiful ground floor 2 bedroom, 2 bathroom condo with approximately 1200 interior sq feet. It sits right on Keauhou Country Club golf course. Enjoy an expansive lanai that reaches from living room to the master
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kailua Kona
Summary:
This family friendly condo in Keauhou Punahele offers privacy and comfort. The Kona country club is less than a mile away so don't forget to reserve your tee-time. The Keauhou Bay Beach Park is half a mile away, great for snorkeling!
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kailua Kona
NEW Listing! Take advantage of our discounted rates starting at $180/night plus fees and taxes.
Pool will be closed for approx 2 weeks starting May 5th, 2025.
*Fully* Remodeled 2 Bedroom 2 Bathroom Condo with Ocean and Golf Course
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kailua Kona
