172.31.37.173=39.04372=-77.48749
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 (836)
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(39.04372)) * cos(radians( city_latitude.meta_value)) * cos(radians(city_longitude.meta_value) - radians(-77.48749)) + sin( radians(39.04372)) * 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
Number 1 Liosban Tuam Road, Co. Galway, H91 T657
Cork Business & Technology Park , Model Farm Road, Cork City, T12 XHT4
Fastnet House, Cork Business & Technology Park , Model Farm Road, Cork City, T12 DD56
First Floor, Grattan Court, Washington Street West, Cork City
29 South Mall , South City Centre, Cork City, T12 EN88
Building 4600 Cork Airport Business Park
Unit 20, South Ring West Business Park, Tramore Road, Cork
First Floor, 6 Lapp’s Quay, Cork
Unit 3 The Elysian, Eglinton Street, South City Centre, Cork City, T12 KTD1
Unit 4 The Elysian, Eglinton Street, South City Centre, Cork City, T12 KTD1