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