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 Resort%') AND sleeps>=1 order by rating desc LIMIT 0, 50
1B/1b Short distance to beautiful Keauhou Bay (5 min walk)
Please read completely, so that there are no surprises upon your arrival! ❤
■ We love the open air lifestyle and find it comfortable with the doors and windows open and the...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kailua-Kona
Experience perfection at Keauhou Resort Condo 108! This immaculate, renovated condo offers stunning ocean views, breathtaking sunsets, and stellar stargazing from your private lanai. Enjoy top-notch amenities, a fully equipped kitchen, updated ...
- 1 bedroom
- 2 bathroom
- Sleeps 2
Hawaii> Kailua Kona
Kona Keauhou Resort #124
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
The best unit in Kona Keauhou Resort, this top-level, end-unit condo ...
- 2 bedroom
- 1 bathroom
- Sleeps 6
Hawaii> Kailua-Kona
Aloha! Panoramic ocean
and sunset views await!
Gorgeous 1-bedroom,
1-full-bath, split-level townhome with vaulted ceilings offers ocean and golf
course views with beautiful tropical landscapes. Enjoy a Mai Tai or a bottle ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kailua Kona
This smoke-free condo boasts ocean and golf course views from both lanais. Beautiful furnishings and completely remodeled with upper end appliances and reverse osmosis water filtration. This split level unit offers vaulted ceilings, a spacious ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kailua Kona
Maximum occupancy strictly enforced in accordance with local ordinances.
This private 2 bedroom unit is close to the fairways of the Keauhou Golf Course. Enjoy the blue water views and endless golf on your tropical vacation.
The ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua Kona
Come enjoy this nicely appointed, private condo with ocean views of the coastline, in quiet Keauhou.
The bright property #125 at Keauhou Resort includes open living room with inviting seating options and a flat-screen television. Wireless ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kailua Kona
Welcome to our stunning condo at the sought-after Hale Kehau in the heart of Keauhou! This spacious three-bedroom, 2.5-bathroom home offers the perfect blend of comfort and luxury, located on the upper level of a two-story building—no stairs ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Honolulu
