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 '%Fairway Villas%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Waikoloa Fairway Villa F6 is the ultimate getaway with merged indoor/outdoor living spaces and our 3 bedroom and 3 bath townhome is perfect for up to six guests. Our well-maintained end unit has lots of light and breezes. We have high-end ...
3 bedroom
3 bathroom
Sleeps 6
HI> Waikoloa
Enjoy our 2 bedroom / 2 bath home for you and your family quietly tucked away along the Big Island's sunny Kohala Coast, Fairway Villas Waikoloa offers the crisp style, gracious elegance, and modern sophistication. The master bedroom has a king ...
2 bedroom
2 bathroom
Sleeps 4
HI> Waikoloa
Fairway Villas N2 is an elegantly decorated ground floor, 2-bedroom condo in a fantastic location at the Waikoloa Beach Resort. Only a short walk away from shops, restaurants, golf and beaches, N2 is located across the fairways from the Kings ...
2 bedroom
2 bathroom
Sleeps 4
HI> Waikoloa
Aloha and welcome to the Big Island of Hawaii. Our recently remodeled home is steps away from Shopping, Dining, Entertainment, and World Famous A’ Bay Beach- great for swimming and snorkeling. Covered parking is included. Great for all types ...
2 bedroom
2 bathroom
Sleeps 6
HI> Waikoloa Village
Fairway Villas Waikoloa F31 Description
Covid-19 Notice: Available amenities vary at each Complex, many have restricted use. Please inquire with KCV.
The Fairway Villas at Waikoloa Beach Resort is an excellent location to work remotely and ...
2 bedroom
2 bathroom
Sleeps 6
HI> Waikoloa
* 2 Bedroom, 2 Bath, third floor unit with loft.
* Beautifully furnished with tropical decor. TV in living room.
* Great views of the Kings' Lake & golf course.
* Master bedroom has a king bed and TV.
* Master bathroom fully renovated in 2019.
*...
2 bedroom
2 bathroom
Sleeps 6
HI> Waikoloa
Enjoy Waikoloa Resort from a newly renovated (2021) penthouse villa at the Fairway Villas. N34 is a top floor condo with beautiful mountain views that features two bedrooms and a bonus upstairs loft bedroom. This popular resort condo has newly ...
2 bedroom
2 bathroom
Sleeps 6
HI> Waikoloa
This nicely furnished (Tommy Bahama) two bedroom, two bathroom unit is located on the ground floor and can accommodate up to four guests comfortably. Guests will be able to walk out from the lanai onto a grassy area. It has a king bed in the ...
2 bedroom
2 bathroom
Sleeps 4
HI> Waikoloa
Welcome to our spacious 2 bedroom/2 bathroom premium ground floor villa overlooking the fourth hole of the Robert Trent Jones II-designed Waikoloa Lakes Golf Course. The Fairway Villas complex is a part of the Waikoloa Beach Resort area, ...
2 bedroom
2 bathroom
Sleeps 4
HI> Waikoloa
Enjoy Waikoloa Resort from Fairway Villas B34, a newly renovated penthouse condo with fantastic views. Completely renovated and re-furnished in 2021, this new-to-market villa is one of the freshest and most desirable rentals at the Fairway ...
2 bedroom
2 bathroom
Sleeps 6
HI> Waikoloa
Welcome to our family’s piece of paradise. We’ve been travelling to Hawaii for twenty years, and our condo is the fulfillment of a dream to call the Big Island our second home. Our goal is to provide you with that same sense of aloha.
Our...
2 bedroom
2 bathroom
Sleeps 6
HI> Waikoloa Village
Enjoy your Hawaiian vacation at this gorgeous Hawaiian - plantation style golf villa situated spectacularly on the 'Lake' Side of the Fairway Villas condominium complex. This fabulously furnished second floor unit has a spacious lanai ...
2 bedroom
2 bathroom
Sleeps 4
HI> Waikoloa
Tucked away in the quiet enclave of Fairway Villas within Wāikoloa Beach Resort, unit #C2 offers privacy, comfort and serenity. Enjoy your morning coffee from your private lanai (covered porch) watching the sun rise over Mauna Kea. In the ...
2 bedroom
2 bathroom
Sleeps 4
HI> Waikoloa
Covid-19 Notice: Available amenities vary at each Complex, many have restricted use. Please inquire with KCV.
Welcome to Fairway Waikoloa G33! With a Hawaiiana theme throughout, this one of a kind residence is nestled in a garden-like ...
2 bedroom
2 bathroom
Sleeps 6
HI> Waikoloa
Designer furnishings, tropical artwork, luxurious linens and toiletries! Outstanding accommodations await you. Conveniently located parking to condo and elevator. Well-appointed, spacious master bedroom features a comfy Cal-king size bed, with...
2 bedroom
2 bathroom
Sleeps 5
HI> Waikoloa
