select * from (Select a.`postalCode`,a.`uniturl`, `bathrooms`, `bedrooms`,`registration_number`, `sleeps`,en_US_VRBO as href, `thumbnailUrl`, `headline`, description, `state`, `city`, `country`, `region`, `source`, `property_type`, `location_type`, `suitability`, `features`, `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) as vw where 1 and round(price)>0 and bedrooms>=0 AND (`headline` like '%Kona Shores%') AND sleeps>=1 order by rating desc LIMIT 0, 15
This upgraded “top floor” condo off of Alii Drive has everything you need to enjoy your time on the Big Island of Hawaii! This condo features a full kitchen and full bathroom with beautiful granite counter tops and stainless steel ...
- 0 bedroom
- 1 bathroom
- Sleeps 4
HI> Kailua Kona
This upgraded “top floor” condo off of Alii Drive has everything you need to enjoy your time on the Big Island of Hawaii! The property features a full kitchen and a full bathroom with stainless steel appliances and beautiful granite counter ...
- 0 bedroom
- 1 bathroom
- Sleeps 4
HI> Kailua Kona