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 '%Kohala Ranch%') AND sleeps>=1 order by rating desc LIMIT 0, 30
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
Located in the exclusive Kohala Ranch community on the beautiful and sunny North Kohala coast on the big island of Hawaii, Hale Maka Kohola is truly a breathtaking and magical place. Hawaiian for "Home to Eye Whales", the home features rich ...
4 bedroom
5 bathroom
Sleeps 6
Hawaii> Waimea
