PRS Let Archives | Lisney Sotheby's International Realty

Meet Our Experts

The private rental sector (PRS) is Ireland’s fastest growing property market, and we’ve been the leading experts for nearly a decade. Meet our PRS experts, and find out how they can work for you.

People are our greatest asset. They add value and deliver results and you’ll see that from the moment you meet them.

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 (965) ) 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