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 '%Fairway Terrace%') AND sleeps>=1 order by rating desc LIMIT 0, 20
Come make memories at Waikoloa Fairway Terrace. This two-bedroom, two-bathroom has all you need for your Hawaii vacation. Enjoy the newly updated living area, dining area, and fully stocked kitchen. Enjoy the pool, hot tub, BBQ, and fitness ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Waikoloa
Gated Community in Waikoloa this 2 bedroom and 2 baths is situated on the 10th fairway of the Robert Trent Jones, Jr. golf course in Waikoloa Village.Hula your way to the Big Island for an incredible stay at this renovated 2-bed, 2-bath vacation...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa
Relax in paradise at Fairway Terrace unit A-204. This two-bedroom, two-bathroom, has all you need. Enjoy the fully stocked kitchen and relax and watch television in the living area. Fast WIFI, lanai with garden views and close to the pool. ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa
Fairway Terrace-In the town of Waikoloa Village
This vacation rental is professionally managed by ResorticaHawaii
Please scroll down for detailed information
Bedding Configuration:
Main Bedroom: King Bed
Guest Bedroom: ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa Village
Make the most of your stay between November 6th, 2024 and January 7th, 2025, with our exclusive offer! Book 6 nights and enjoy the 7th night free, plus complimentary late check-out to savor every moment of your getaway. Don't miss this ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa Village