Residential Listing
Residential Listing
Count: 4 -- Request: 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) LEFT JOIN uqsbx_term_relationships AS tt1 ON (uqsbx_posts.ID = tt1.object_id) WHERE 1=1 AND (
uqsbx_term_relationships.term_taxonomy_id IN (862)
AND
tt1.term_taxonomy_id IN (37)
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
Lower Baggot Street
Dublin 2
41 Wellington Road,
Ballsbridge,
Dublin 4
38 The Bramblings
Killester
Dublin 5
Willow Brook
Saval Park Road
Dalkey
County Dublin