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, rewritten_description,
(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 '%Kohala Ranch%') AND sleeps>=1 order by rating desc LIMIT 0, 50
From our covered lanai you have expansive views of the ocean, the sprawling Kohala ranchland and Haleakala on neighboring Maui. There really is no better way to start your day!
4 bedroom
2 bathroom
Sleeps 8
Hawaii> Kamuela
Gorgeous home with spectacular views and extra privacy on 6 acres in the Kohala Ranch community. This newly upgraded dream home is perfect for couples and families looking for a spacious three bedroom home where they can relax and enjoy
3 bedroom
4 bathroom
Sleeps 6
Hawaii> Kamuela
