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, 30
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...
- 2 bedroom
- 2 bathroom
- Sleeps 4
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