Residential Archives | Page 4 of 6 | Lisney Sotheby's International Realty

Meet our experts

Our doors are always open and we’re only a phone call or an email away. People are our greatest asset, and they’ll deliver for you with their in-depth industry and local knowledge. 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 (911,1027,1094,975,966,1028,912,913,914,915,916,962,963,964,965,978) ) 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 36, 12