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 '%Country Club Villas%') AND sleeps>=1 order by rating desc LIMIT 0, 30
Immersed in a haven of lush, tropical vegetation, this two-bedroom, two-bath condo at Country Club Villas invites you to unwind during your Big Island vacation. Conveniently located on the 2nd floor, you’ll find plenty of space to unpack your...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kailua-Kona
Country Club Villas, Unit#115 is a remarkable addition to the Vacation Rental Market that Knutson & Associates Property Management is proud to represent. Newly remodeled in July 2023, with all new flooring, furnishings, paint, and guest bathroom...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua Kona
Maximum occupancy strictly enforced in accordance with local ordinances.
Country Club Villas #208 has been renovated from top to bottom with lavish details and furnishings. Country Club Villas are located in an exquisite setting with ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kailua Kona
Country Club Villas #226 is perfect for 1 - 4 guests.
Your view is over the fairway of the Kona Country Club's Ocean Course right out to the ocean beyond. Beautiful ocean views and sunsets from your lanai.
• King bed in the primary ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kailua Kona
Country Club Villas #320 is great for 1-6 individuals. Your view of the Kona Country Club's Ocean Course is right out to the ocean beyond. Enjoy the views of the ocean and the breathtaking sunsets of your lanai.
King's Bed in primary ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua Kona
Enjoy panoramic coastline views and year-round sunsets from our wonderful, upgraded two bedroom, two bath, bright, airy and tropically furnished corner condo overlooking the 17th fairway of Kona Country Club's Ocean Golf Course. An impeccably ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> KAILUA KONA
This vacation rental is professionally managed by ResorticaHawaii
Kona Country Club Villas #229
Please scroll down for detailed information
Bedroom Configuration:
Master Bedroom: King Bed
Guest Bedroom: Queen ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua Kona
Country Club Villas, Unit#326 is a phenomenal new addition to the Vacation Rental Market that Knutson & Associates Property Management is proud to represent.
This top floor corner unit is completely remodeled, with soaring ceilings & lots ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua Kona
