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 '%Waikoloa Colony Villas%') AND sleeps>=1 order by rating desc LIMIT 0, 15
The LoveRentals portfolio is comprised of curated, professionally managed vacation rental homes around the world. We only select professional property managers that meet our high standards. Book with peace of mind knowing that you will have the ...
2 bedroom
2 bathroom
Sleeps 4
HI> Waikoloa
Waikoloa Colony Villas 304
Please scroll down for detailed information
PLEASE NOTE: The Mauka Pool and Hot Tub will be closed for renovations from mid-April for approximately 6 weeks barring any unforseen issues/delays. The Makai Pool ...
2 bedroom
3 bathroom
Sleeps 4
HI> Waikoloa Village
Beautiful 2 bedroom private villa with tranquil golf course views is the perfect place for a relaxing vacation! Due to covid-19, the property is disinfected and cleaned in preparation for every stay.
The Waikoloa Colony Villas is a gated ...
2 bedroom
3 bathroom
Sleeps 5
HI> Waikoloa Village
**ATTENTION:** SEPTEMBER 2022
Work on Phase 2 of the irrigation system will begin in September 2022 and take approximately 3 months. There will be significant impact around the buildings noted above as they dig new trenching and replace ...
2 bedroom
3 bathroom
Sleeps 4
HI> Waikoloa Village
🏖️vrKCV - Waikoloa Colony Villas 1503, Professionally Managed by Kona Coast Vacations🏖️
Covid-19 Notice: Available amenities vary at each Complex, many have restricted use. Please inquire with KCV.
*Maintenance notice: Resurfacing ...
2 bedroom
3 bathroom
Sleeps 6
HI> Waikoloa
Waikoloa Colony Villas 2705
Please scroll down for detailed information
PLEASE NOTE: The Mauka Pool and Hot Tub will be closed for renovations from mid-April for approximately 6 weeks barring any unforseen issues/delays. The Makai Pool ...
3 bedroom
3 bathroom
Sleeps 6
HI> Waikoloa Village
*Renovation work on property: 1.) Beginning mid-April 2022 the Mauka pool and jacuzzi will be closed for approximately 6 weeks due to repair work. 2.) Beginning September 2022 irrigation work will be taking place around this building, which will...
2 bedroom
2 bathroom
Sleeps 5
HI> Waikoloa
Light and bright with 2 spacious bedrooms and 2 bathrooms, 2 lanais, a laundry room with washer/dryer, and fully stocked kitchen. Our townhome is perfectly situated on the Waikoloa Beach Golf Course with a large tropical green space that ...
2 bedroom
2 bathroom
Sleeps 4
HI> Waikoloa Village
You are sure to enjoy a fantastic memorable vacation at our Waikoloa Colony Villa
3 bedroom, 2 1/2 bath townhouse at the highly popular Waikoloa Beach Resort development on the sunny Kohala Coast. This 1699 sq. ft. villa is just steps to the ...
3 bedroom
3 bathroom
Sleeps 8
HI> Waikoloa Village
Waikoloa Colony Villas 1501
Please scroll down for detailed information
PLEASE NOTE: The Mauka Pool and Hot Tub will be closed for renovations from mid-April for approximately 6 weeks barring any unforseen issues/delays. The Makai Pool ...
2 bedroom
2 bathroom
Sleeps 6
HI> Waikoloa Village
Waikoloa Colony Villas 1705.
Please scroll down for detailed information
PLEASE NOTE: The Mauka Pool and Hot Tub will be closed for renovations from mid-April for approximately 6 weeks barring any unforseen issues/delays. The Makai ...
3 bedroom
3 bathroom
Sleeps 8
HI> Waikoloa Beach Resort
🏖️vrKCV - Waikoloa Colony Villas 2406, Professionally Managed by Kona Coast Vacations🏖️
Covid-19 Notice: Available amenities vary at each Complex, many have restricted use. Please inquire with KCV.
*Maintenance notice: Resurfacing of...
2 bedroom
2 bathroom
Sleeps 6
HI> Waikoloa Village
Waikoloa Colony Villas 1202.
Please scroll down for detailed information
PLEASE NOTE: The Mauka Pool and Hot Tub will be closed for renovations from mid-April for approximately 6 weeks barring any unforseen issues/delays. The Makai ...
3 bedroom
3 bathroom
Sleeps 8
HI> Waikoloa Beach Resort
Waikoloa Colony Villas 1102.
Please scroll down for detailed information
PLEASE NOTE: The Mauka Pool and Hot Tub will be closed for renovations from mid-April for approximately 6 weeks barring any unforseen issues/delays. The Makai ...
3 bedroom
3 bathroom
Sleeps 8
HI> Waikoloa Beach Resort
*Renovation work on property: Beginning mid-April 2022 the Mauka pool and jacuzzi will be closed for approximately 6 weeks due to repair work.
Located on the Hawaii Island’s west coast next to the 10th fairway of the Waikoloa Beach Golf ...
2 bedroom
3 bathroom
Sleeps 5
HI> Waikoloa
