New Homes Archives | Lisney Sotheby's International Realty

Meet our Experts

You may be excited at the prospect of being the first to move into a new home, and our New Homes team will share that excitement with you every step of the way. Our door is always open, and hopefully we can open new doors 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 (966) ) AND uqsbx_posts.post_type = 'team' AND ((uqsbx_posts.post_status = 'publish')) GROUP BY uqsbx_posts.ID ORDER BY CAST( (SELECT CASE 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 1 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 2 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 3 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