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 (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(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
35 Merrion Square, South City Centre, Dublin 2, D02 KH30
10 Harmony Court, South City Centre, Dublin 2, D02 VY52
26 Pembroke Street Upper, Dublin 2
3 Kingram Place, Dublin 2
First and Second Floors, 103 Upper Leeson Street
72 Northumberland Road, Ballsbridge, Dublin 4
78 Sir John Rogerson’s Quay
15 Fitzwilliam Quay, Dublin 2
23 Shelbourne Road, Ballsbridge, Dublin 4, D04 PY68
140 Pembroke Road, Ballsbridge, Dublin 4, D04 NV34
2070 sqft 
