Rent Archives - Lisney Sotheby's International Realty

Meet our experts

Whether you’re a landlord looking for reliable tenants or someone searching for a perfect rental home, we always meet in the middle. Our Rental team will be your greatest asset in the process. 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 (964) ) 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 0, 12