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
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
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