Residential Archives | Page 3 of 3

Meet Our Experts

At Lisney we know our people are our greatest asset, and they will deliver for you with their in-depth industry knowledge. With offices in Dublin and Cork, our team collaborate across Ireland and in every sector of real estate.

Meet our experts and find out how they can work for you.

Filter By:

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 (1086) ) AND uqsbx_posts.post_type = 'team' AND ((uqsbx_posts.post_status = 'publish')) GROUP BY uqsbx_posts.ID ORDER BY CAST( (SELECT CASE WHEN uqsbx_posts.ID = 681 THEN 1 WHEN uqsbx_posts.ID = 1493 THEN 2 WHEN (SELECT team_office.post_id FROM uqsbx_postmeta as team_office WHERE team_office.meta_value NOT LIKE '%"600"%' AND team_office.meta_value NOT LIKE '%"601"%' AND team_office.meta_key='select_office' AND team_office.post_id=team_location.post_id LIMIT 1) THEN 3 WHEN (SELECT team_office.post_id FROM uqsbx_postmeta as team_office WHERE team_office.meta_value LIKE '%"601"%' AND team_office.meta_key='select_office' AND team_office.post_id=team_location.post_id LIMIT 1) THEN 4 WHEN (SELECT team_office.post_id FROM uqsbx_postmeta as team_office WHERE team_office.meta_value LIKE '%"600"%' AND team_office.meta_key='select_office' AND team_office.post_id=team_location.post_id LIMIT 1) THEN 5 END AS order_by_location FROM uqsbx_postmeta as team_location WHERE team_location.meta_key='select_office' AND team_location.post_id=uqsbx_posts.ID) AS SIGNED) ASC , CAST( IF((SELECT COUNT(team_ordering.post_id) FROM uqsbx_postmeta as team_ordering WHERE (team_ordering.meta_key='team_ordering_location_dublin') AND team_ordering.post_id=uqsbx_posts.ID LIMIT 1)>0, (SELECT team_ordering.meta_value FROM uqsbx_postmeta as team_ordering WHERE (team_ordering.meta_key='team_ordering_location_dublin') AND team_ordering.post_id=uqsbx_posts.ID LIMIT 1), 999999) AS SIGNED) ASC , CAST( IF((SELECT COUNT(team_ordering.post_id) FROM uqsbx_postmeta as team_ordering WHERE (team_ordering.meta_key='team_ordering_location_cork') AND team_ordering.post_id=uqsbx_posts.ID LIMIT 1)>0, (SELECT team_ordering.meta_value FROM uqsbx_postmeta as team_ordering WHERE (team_ordering.meta_key='team_ordering_location_cork') AND team_ordering.post_id=uqsbx_posts.ID LIMIT 1), 999999) AS SIGNED) ASC , CAST( IF((SELECT COUNT(team_ordering.post_id) FROM uqsbx_postmeta as team_ordering WHERE (team_ordering.meta_key='team_ordering_location_belfast') AND team_ordering.post_id=uqsbx_posts.ID LIMIT 1)>0, (SELECT team_ordering.meta_value FROM uqsbx_postmeta as team_ordering WHERE (team_ordering.meta_key='team_ordering_location_belfast') AND team_ordering.post_id=uqsbx_posts.ID LIMIT 1), 999999) AS SIGNED) ASC, uqsbx_posts.post_title ASC LIMIT 24, 12