172.31.46.57=53.339964=-6.2466117
Commercial Listing
Commercial Listing
SELECT SQL_CALC_FOUND_ROWS uqsbx_posts.ID FROM uqsbx_posts LEFT JOIN uqsbx_term_relationships ON (uqsbx_posts.ID = uqsbx_term_relationships.object_id) WHERE 1=1 AND (
uqsbx_term_relationships.term_taxonomy_id IN (837)
AND
uqsbx_posts.ID NOT IN (
SELECT object_id
FROM uqsbx_term_relationships
WHERE term_taxonomy_id IN (35)
)
) AND uqsbx_posts.post_type = 'property' AND ((uqsbx_posts.post_status = 'publish')) GROUP BY uqsbx_posts.ID ORDER BY (SELECT (6371 * acos(cos(radians(53.339964)) * cos(radians( city_latitude.meta_value)) * cos(radians(city_longitude.meta_value) - radians(-6.2466117)) + sin( radians(53.339964)) * sin(radians(city_latitude.meta_value)))) AS distance FROM
uqsbx_postmeta AS city_latitude
LEFT JOIN uqsbx_postmeta as city_longitude ON city_latitude.post_id = city_longitude.post_id
WHERE city_latitude.post_id=uqsbx_posts.ID AND city_latitude.meta_key = 'property_latitude' AND city_longitude.meta_key = 'property_longitude') LIMIT 0, 12
Warehouse/Light Industrial Unit, Unit 6 Watergrasshill Business Park, Watergrasshill, Cork
12 Brunswick Place, Dublin 2 D02 PA09
Botanic Road, Glasnevin, Dublin 9, D09 AF59
Creation House, Botanic Road, Glasnevin, Dublin 9, D09 AF59
Unit D7 Ballymount Industrial Estate, Walkinstown, Dublin 12
Bluebell Business Centre, Old Naas Road, Dublin 12
Unit 13 Bluebell Business Park, Old Naas Road, Dublin 12
51C Robinhood Industrial Estate, Robinhood Road, D22 TX34
Unit 3 JFK Drive, JFK Industrial Estate
5 & 6 Port Tunnel Business Park, Clonshaugh, Dublin 17, D17 CK64
Unit S4, Henry Road, Dublin 12, D12 VKP4.