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 (city = 'Kurtistown' OR postalCode = 'Kurtistown' OR region like '%|Kurtistown|%') AND sleeps>=1 order by rating desc LIMIT 0, 20
Experience life on a mini lychee orchard in a plantation home very close to The Volcano National Park. Just 15 minutes to Volcano National Park and 8 minutes to the airport & shopping! Enjoy the views of our beautiful Mauna ...
3 bedroom
1 bathroom
Sleeps 6
Hawaii> Kurtistown
Sophisticated & luxurious meets rugged farm & charm!
2 bedroom
1 bathroom
Sleeps 6
Hawaii> Kurtistown
We kindly ask that guests interested PLEASE read our entire profile before booking, as we're not for everyone. We're affordable because we think everyone should be able to enjoy what we call home, and while we welcome everyone as ohana, we find ...
1 bedroom
2 bathroom
Sleeps 2
Hawaii> Kurtistown
