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 '%Keauhou Punahele%') AND sleeps>=1 order by rating desc LIMIT 0, 20
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
Fun Ocean and Coastal views.Fans only. No A/C. Perfect for Non-A/C users. Nice Shared Heated Pool and Hot TubUnit B102 has a ground level lanai, a well-designed primary bedroom and guest room with two twins. Snorkeling and water tour activities ...
- 2 bedroom
- 3 bathroom
- Sleeps 4
Hawaii> Kailua Kona
A True Beauty at Keauhou Punahele: New Rental in 2024!
Keauhou Punahele#B-308 is a gorgeous top floor rarely available 3 bedroom, 3 bathroom condo with approximately 1594 interior sq. feet with an additional 234 square foot lanai! It sits ...
- 3 bedroom
- 3 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
Make memories at Keauhou Punahele Unit C104: two-bedroom, two-bathroom home, and newly remodeled kitchen. There is a Murphy bed in the living room, a television in both bedrooms, and a fully stocked kitchen. Relax on your lanai and enjoy the ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua Kona
WOW! The owners put a lot of love into this unit with beautiful upgrades.
Keauhou Punahele#E-102 is a beautiful ground floor 2 bedroom, 2 bathroom condo with approximately 1200 interior sq. feet. It sits right on Keauhou Country Club golf ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
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
Keauhou Punahele E103 at a glance:
*Recently updated bathrooms
* 2019 black Jeep available to guests at a special rate!
* Once vacation rental is booked, inquire about jeep rental. A Turo link will be sent to you ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
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
Welcome to Keauhou Punahele, A310! Located in Keauhou with great views of the golf course and the ocean. This three-bedroom, three-bathroom condo has an open layout of the living area and lanai. Amenities include televisions, high-speed ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
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
Come enjoy your vacation at Keauhou Punahele #E301! This three-bedroom, the three-bathroom condo has high ceilings, an open layout, and a large lanai. Relax and take in the ocean and golf course views, fully stocked kitchen, smart television, ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kailua-Kona
The Keauhou area of Kailua-Kona Hawaii is a tropical paradise that boasts beautiful coastlines, stunning ocean views, and a rich cultural history. And what better way to experience it all than by staying at this beautiful vacation rental!As soon...
- 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 ...
- 2 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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua Kona