select * from (Select a.`postalCode`,a.`uniturl`, `bathrooms`, `bedrooms`,`registration_number`, `sleeps`,en_US_VRBO as href, `thumbnailUrl`, `headline`, description, `state`, `city`, `country`, `region`, `source`, `property_type`, `location_type`, `suitability`, `features`, `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) 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, 15
Covid-19 Notice: Available amenities vary at each Complex, many have restricted use. Please inquire with KCV.
Enjoy the expansive ocean view from Country Club Villas #311. This is a beautifully remodeled and nicely furnished 3rd floor unit that...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kailua Kona
Country Club Villas, Unit#115 is a remarkable NEW addition to the Vacation Rental Market that Knutson & Associates Property Management is proud to represent.
Picture yourself living on the "Kona Country Club" golf course, be mesmerized by the ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> 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
HI> KAILUA KONA
Covid-19 Notice: Available amenities vary at each Complex, many have restricted use. Please inquire with KCV.
Country Club Villas #334 enjoys panoramic views of the Pacific Ocean and coastline. Enjoy morning coffee and tropical breezes on the ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kailua Kona
Country Club Villas #226 is great for 1-4 guests and has a fantastic remodeling experience.
Your view is from the fairway of the Kona Country Club Ocean Course to the ocean beyond. Enjoy the views of the ocean and the breathtaking sunsets of ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> 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 Master
Guest ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
HI> Kailua Kona
Covid-19 Notice: Available amenities vary at each Complex, many have restricted use. Please inquire with KCV.
You will be calling this two-bedroom two-bathroom deluxe condo home in no time! The amazing Pacific Ocean views and the spacious floor...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kailua- Kona