Close Close filters 0
SIZE:
PRICE:
LOCATION
PROPERTY TYPE
BEDS:
SIZE:
Residential Listing
Residential Listing
Count: 0 -- 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 (3,862,867,869,870,873,995)
AND
tt1.term_taxonomy_id IN (981)
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
No Properties Found
Property Wishlist
Close
Contact
St. Stephen's Green House,
Earlsfort Terrace,
Dublin 2,
D02 PH42
Earlsfort Terrace,
Dublin 2,
D02 PH42
Close
Book a valuation
If you'd like to set up a valuation or we can help you with more information, call (01) 638 2700 or submit this form and we'll get in touch.
Close
Book a viewing
Arrange to view this property
If you'd like to set up a viewing or we can help you with more information, call (01) 662 4511 or submit this form and we'll get in touch.
Close
To access please enter your name and email
Thanks for showing an interest in our research reports. For access to our archive, just add your details and we’ll get back right away with your account confirmation and the publications you’d like to read.
Close
To access please enter your name and email
Thanks for showing an interest in our research reports. For access to our archive, just add your details and we’ll get back right away with your account confirmation and the publications you’d like to read.