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, 30
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
Amazing Ocean and Coastal views. Unit B102 has a ground level lanai, a well-designed primary bedroom and guest room with two twins. Snorkeling and water tour activities are a short distance away. Well-designed updated unit. Enjoy a sunset over ...
- 2 bedroom
- 3 bathroom
- Sleeps 4
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
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
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 to rent at a large discount.
* April promotion - stay 3 days or longer and get 30% off on your nightly rental.
* ...
- 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
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
Welcome to Keauhou Punahele, E305 where panoramic views of the golf course and ocean await. This two-bedroom, two-bathroom, plus loft, features an open living area and lanai with outdoor BBQ and pool area access.
The primary bedroom has a...
- 3 bedroom
- 2 bathroom
- Sleeps 5
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
