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, 50
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
Aloha and welcome to your slice of paradise in Fairway Terrace, Waikoloa Village! This enchanting 2-bedroom, 2-bathroom, plus a sleeper sofa in the living room, is the perfect blend of island charm and modern comfort, offering you a true ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa Village
