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 '%Waikoloa Fairways%') AND sleeps>=1 order by rating desc LIMIT 0, 50
New Listing! Relax at this two-bedroom, two-and-a-half-bath Waikoloa Fairways unit in the heart of Waikoloa Village. The primary offers a soaking tub. Enjoy the open living layout, outdoor wet bar, and large lanai. Pool, hot tub, and BBQ at the ...
- 2 bedroom
- 3 bathroom
- Sleeps 4
Hawaii> Waikoloa
VIEWS, VIEWS, VIEWS!! This gorgeous condominium has the WOW Factor when you go to the Lanai. Absolutely Breathtaking views over the Golf Course that sweep to the Ocean over the Kohala Coast and to Maui, make this condominium a truly special ...
- 2 bedroom
- 3 bathroom
- Sleeps 4
Hawaii> KAILUA KONA
Turn moments into memories at this two-bedroom, two-and-a-half-bath Waikoloa Fairways property. A golfer's paradise as the property sits right on holes 3 and 4 at Waikoloa Village Golf Course, designed by Robert Trent Jones Jr. This property ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Waikoloa
