Let's get to know each other
Tell us about your project, we’ll take care of the rest.
WP_Query Object
(
[query] => Array
(
[post_type] => estates
[post_status] => publish
[post__in] => Array
(
[0] => 89257
[1] => 89251
[2] => 89235
[3] => 89107
[4] => 88988
[5] => 88672
[6] => 87806
[7] => 87535
)
[orderby] => post__in
[posts_per_page] => 17
)
[query_vars] => Array
(
[post_type] => estates
[post_status] => publish
[post__in] => Array
(
[0] => 89257
[1] => 89251
[2] => 89235
[3] => 89107
[4] => 88988
[5] => 88672
[6] => 87806
[7] => 87535
)
[orderby] => post__in
[posts_per_page] => 17
[error] =>
[m] =>
[p] => 0
[post_parent] =>
[subpost] =>
[subpost_id] =>
[attachment] =>
[attachment_id] => 0
[name] =>
[pagename] =>
[page_id] => 0
[second] =>
[minute] =>
[hour] =>
[day] => 0
[monthnum] => 0
[year] => 0
[w] => 0
[category_name] =>
[tag] =>
[cat] =>
[tag_id] =>
[author] =>
[author_name] =>
[feed] =>
[tb] =>
[paged] => 0
[meta_key] =>
[meta_value] =>
[preview] =>
[s] =>
[sentence] =>
[title] =>
[fields] => all
[menu_order] =>
[embed] =>
[category__in] => Array
(
)
[category__not_in] => Array
(
)
[category__and] => Array
(
)
[post__not_in] => Array
(
)
[post_name__in] => Array
(
)
[tag__in] => Array
(
)
[tag__not_in] => Array
(
)
[tag__and] => Array
(
)
[tag_slug__in] => Array
(
)
[tag_slug__and] => Array
(
)
[post_parent__in] => Array
(
)
[post_parent__not_in] => Array
(
)
[author__in] => Array
(
)
[author__not_in] => Array
(
)
[search_columns] => Array
(
)
[tax_query] => Array
(
[0] => Array
(
[taxonomy] => language
[field] => term_taxonomy_id
[terms] => Array
(
[0] => 2
)
[operator] => IN
)
)
[meta_query] => Array
(
[0] => Array
(
[key] => displaystatusid
[value] => 1
[compare] => !=
)
)
[update_post_term_cache] => 1
[ignore_sticky_posts] =>
[suppress_filters] =>
[cache_results] => 1
[update_menu_item_cache] =>
[lazy_load_term_meta] => 1
[update_post_meta_cache] => 1
[nopaging] =>
[comments_per_page] => 50
[no_found_rows] =>
[taxonomy] => language
[term_id] => 2
[order] =>
)
[tax_query] => WP_Tax_Query Object
(
[queries] => Array
(
[0] => Array
(
[taxonomy] => language
[terms] => Array
(
[0] => 2
)
[field] => term_taxonomy_id
[operator] => IN
[include_children] => 1
)
)
[relation] => AND
[table_aliases:protected] => Array
(
[0] => wpstbys_term_relationships
)
[queried_terms] => Array
(
[language] => Array
(
[terms] => Array
(
[0] => 2
)
[field] => term_taxonomy_id
)
)
[primary_table] => wpstbys_posts
[primary_id_column] => ID
)
[meta_query] => WP_Meta_Query Object
(
[queries] => Array
(
[0] => Array
(
[key] => displaystatusid
[value] => 1
[compare] => !=
)
[relation] => OR
)
[relation] => AND
[meta_table] => wpstbys_postmeta
[meta_id_column] => post_id
[primary_table] => wpstbys_posts
[primary_id_column] => ID
[table_aliases:protected] => Array
(
[0] => wpstbys_postmeta
)
[clauses:protected] => Array
(
[wpstbys_postmeta] => Array
(
[key] => displaystatusid
[value] => 1
[compare] => !=
[compare_key] => =
[alias] => wpstbys_postmeta
[cast] => CHAR
)
)
[has_or_relation:protected] =>
)
[date_query] =>
[request] => SELECT SQL_CALC_FOUND_ROWS wpstbys_posts.ID
FROM wpstbys_posts LEFT JOIN wpstbys_term_relationships ON (wpstbys_posts.ID = wpstbys_term_relationships.object_id) INNER JOIN wpstbys_postmeta ON ( wpstbys_posts.ID = wpstbys_postmeta.post_id ) INNER JOIN wpstbys_term_relationships AS pll_tr ON pll_tr.object_id = wpstbys_posts.ID
WHERE 1=1 AND wpstbys_posts.ID IN (87535,87806,88672,88988,89107,89235,89251,89257) AND (
wpstbys_term_relationships.term_taxonomy_id IN (2)
) AND (
( wpstbys_postmeta.meta_key = 'displaystatusid' AND wpstbys_postmeta.meta_value != '1' )
) AND wpstbys_posts.post_type = 'estates' AND ((wpstbys_posts.post_status = 'publish')) AND pll_tr.term_taxonomy_id IN ( 2 )
GROUP BY wpstbys_posts.ID
ORDER BY FIELD(wpstbys_posts.ID,89257,89251,89235,89107,88988,88672,87806,87535)
LIMIT 0, 17
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 89257
[post_author] => 0
[post_date] => 2026-03-30 11:10:18
[post_date_gmt] => 2026-03-30 09:04:42
[post_content] => Ideally located near Avenue Louise and the Jardins du Roi, at the rear of a recent building, this one-bedroom apartment offers a gross floor area (EPC) of 90 m² with a pleasant private interior courtyard.
The apartment, located at the rear of the building on the ground floor, opens onto a spacious living/dining room of 54 m², bathed in light thanks to large bay windows providing access to the private courtyard, ideally facing south/west. On the night side, a bedroom of approximately 14 m² also provides access to the outdoor space and is extended by a separate bathroom with a walk-in shower. A laundry area completes the property.
Other features: video intercom, dual-flow ventilation, bicycle storage, optional parking space (required), no cellar, common area charges, private heating and hot water: €200. EPC: C+
Le Jardin du Roi is ideally located near shops and restaurants in a peaceful and charming neighborhood. Easy access to public transportation.
For further information, please contact Laurence Ballaux at +32 (0) 2 640 08 01
[post_title] => Ixelles I Jardin du Roi
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 7635723-ixelles-i-jardin-du-roi
[to_ping] =>
[pinged] =>
[post_modified] => 2026-05-11 17:26:51
[post_modified_gmt] => 2026-05-11 15:26:51
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.be/estates/7635723-ixelles-i-jardin-du-roi/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 89251
[post_author] => 0
[post_date] => 2026-03-30 08:57:06
[post_date_gmt] => 2026-03-30 06:57:06
[post_content] => Ideally located in the heart of the Prince d'Orange and on the edge of the Sonian Forest, villa with a gross surface area according to PEB of ± 361 m² offering four bedrooms and a garden of ± 840 m² ideally oriented.
The house opens onto an entrance hall with cloakroom and guest toilet, and gives access to the office and living rooms of +/- 70 m² bathed in light thanks to the large bay windows facing the garden. A fully equipped semi-open kitchen completes the set. Night side on the 1st floor, two bedrooms of ± 22 m² each giving access to a terrace with a view of the garden and a third bedroom or office of ± 12 m². The three bedrooms share a shower room. On the top floor, the master bedroom of 30 m² with integrated dressing room and en-suite bathroom. On the lower floor, a large multipurpose space of ± 60 m² ideal for a liberal profession or family room giving access to the garden and the pétanque ground.
Others: alarm system, air conditioning in the master bedroom, laundry room, PEB: D-
On the edge of the Sonian forest and the Bois de la Cambre, the Prince d'Orange is an ideally located district in the direct vicinity of Fort Jaco. It offers a peaceful living environment while being close to the city center.
For any further information, please contact Laurence Ballaux on +32 (0) 2 640 08 01.
[post_title] => Uccle I Prince d'Orange
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 7635701-uccle-i-prince-dorange
[to_ping] =>
[pinged] =>
[post_modified] => 2026-05-11 17:29:55
[post_modified_gmt] => 2026-05-11 15:29:55
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.be/estates/7635701-uccle-i-prince-dorange/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 89235
[post_author] => 0
[post_date] => 2026-03-28 09:16:06
[post_date_gmt] => 2026-03-28 08:16:06
[post_content] => Ideally located near the Châtelain district, this charming duplex apartment comprises four bedrooms and an office in an Art Deco-style building offering a gross floor area of 265 m² (EPC).
This dual-aspect apartment, located on the 4th and 5th floors of a building on Square de la Victoire, opens onto an entrance hall leading to the living areas bathed in light thanks to large bay windows offering unobstructed views. They comprise a living room with a fireplace, a spacious, fully equipped Bulthaup kitchen with a dining area, a utility room/laundry room, and an office/TV lounge area opening onto a rear terrace. A separate office with built-in woodwork and the master bedroom with a separate dressing room, a bathroom, and a shower room complete the upper floor. Upstairs, three bedrooms, two of which are adjoining, share a bathroom.
Other: security door, alarm, air conditioning in the master bedroom, blinds/curtains and light fixtures, cellar, attic, common charges: €205, two parking spaces available as an option. EPC: C-
Le Châtelain is known for its location, close to the city center and the Bois de la Cambre. It is full of restaurants of all kinds, shops, and its popular market. Easy and quick access to public transportation.
For further information, please contact Laurence Ballaux at +32 (0)2 640 08 01.
[post_title] => Saint-Gilles I Châtelain
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 7634308-saint-gilles-i-chatelain
[to_ping] =>
[pinged] =>
[post_modified] => 2026-04-27 15:25:47
[post_modified_gmt] => 2026-04-27 13:25:47
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.be/estates/7634308-saint-gilles-i-chatelain/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[3] => WP_Post Object
(
[ID] => 89107
[post_author] => 0
[post_date] => 2026-03-20 09:58:16
[post_date_gmt] => 2026-03-20 08:58:16
[post_content] => Ideally located in the immediate vicinity of Avenue Louise and tucked away behind a private mansion, this rear house offers 298 m² of gross floor area (as per the Energy Performance Certificate - PEB) and features four bedrooms, an office, and a pleasant city garden.
The contemporary, loft-style house opens onto light-filled living spaces thanks to large bay windows overlooking the ideally oriented southwest-facing garden, which offers unobstructed views. These spaces comprise a spacious living room, a dining room, and a fully equipped Bulthaup kitchen with an adjoining utility/laundry room. A separate office completes this level. On the first floor, there is a master bedroom with a dressing room and en-suite bathroom, and two further bedrooms, each with a dressing room and en-suite bathroom. On the second floor, a fourth bedroom with a dressing room and bathroom provides access to a second terrace.
Other : Company lease possible, alarm system, blinds and curtains, individual boiler, alarm, garden shed, common charges: €115, no parking. (EPC): C-
The Louise district is known for its proximity to shops and its wide selection of restaurants. Easy and quick access to the city center and surrounding towns thanks to the numerous public transport options.
For further information, please contact Laurence Ballaux at +32 2 640 08 01.
[post_title] => Brussels I Louise area
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 7622678-brussels-i-louise-area
[to_ping] =>
[pinged] =>
[post_modified] => 2026-04-15 12:27:32
[post_modified_gmt] => 2026-04-15 10:27:32
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.be/estates/7622678-brussels-i-louise-area/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[4] => WP_Post Object
(
[ID] => 88988
[post_author] => 0
[post_date] => 2026-03-11 10:52:06
[post_date_gmt] => 2026-03-11 09:52:06
[post_content] => Ideally located opposite the Abbaye de la Cambre, in the new "The Metropolitan" residence, this newly built, high-end furnished apartment offers a gross floor area of 81 m² and a spacious terrace.
The apartment, located on the 4th floor, opens onto an entrance hall with a cloakroom and Japanese toilet and leads to the fully equipped living space, tastefully furnished and furnished to a high standard. It consists of a fully equipped open-plan kitchen with a back office/storage area, and a living/dining room opening onto an 11-meter terrace with a lush view of the Abbaye de la Cambre. On the sleeping area, a bedroom with a built-in dressing room and shower room also provides access to the terrace. A fully equipped laundry room completes the property. The building also offers a wellness area with a gym and sauna, accessible exclusively to residents.
Other: security door, home automation, Reverso hot/cold underfloor heating, electric blinds, lighting, cellar, VMC ventilation, one optional parking space (mandatory), bicycle storage, utilities €125. EPC: pending.
The Abbaye de la Cambre district is a beautiful, typically Brussels neighborhood, surrounded by shops. It offers easy access to public transportation. It is located close to the city center and Avenue Louise.
For further information, please contact Laurence Ballaux at +32 (0) 2 640 08 01.
[post_title] => Brussels I Abbaye de la Cambre
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 7604851-brussels-i-abbaye-de-la-cambre
[to_ping] =>
[pinged] =>
[post_modified] => 2026-04-28 01:02:43
[post_modified_gmt] => 2026-04-27 23:02:43
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.be/estates/7604851-brussels-i-abbaye-de-la-cambre/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[5] => WP_Post Object
(
[ID] => 88672
[post_author] => 0
[post_date] => 2026-03-02 15:17:10
[post_date_gmt] => 2026-03-02 14:17:10
[post_content] => Located in the Floride district, this property was fully renovated in 2025 by an architect. It offers six bedrooms, a staff apartment, and an optional swimming pool on a plot of approximately 22 ares.
With its original features, this residence, with a total floor area of approximately 740 m² according to the Energy Performance Certificate (EPC), comprises on the ground floor an entrance hall with cloakroom, reception rooms including a living room with fireplace, and a dining room opening onto the terrace and garden. A separate, fully equipped marble kitchen with a breakfast area opening onto the terrace, and a multi-purpose room that could serve as an office or TV room complete the ground floor. On the first floor, the master suite consists of a double bedroom with a dressing room and bathroom. Also on this floor are two bedrooms with dressing rooms and shower rooms. On the top floor, there are three bedrooms, each with a private bathroom and shower. A staff apartment with a kitchenette and shower room completes the property.
Other features: First occupancy after renovation, alarm system, garage, wine cellar, laundry room, fireplace. New Energy Performance Certificate (EPC) pending. Monthly charges of €1,850 cover garden maintenance and insurance.
The Floride neighborhood is ideally located in a green setting between Avenue Montjoie and Avenue Hamoir, near the Sonian Forest, public transportation, and shops.
For further information, please contact Mélody Bingoni at +32 (2) 640 08 01.
[post_title] => Uccle I Floride
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 7591891-uccle-i-floride
[to_ping] =>
[pinged] =>
[post_modified] => 2026-04-28 09:30:17
[post_modified_gmt] => 2026-04-28 07:30:17
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.be/estates/7591891-uccle-i-floride/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[6] => WP_Post Object
(
[ID] => 87806
[post_author] => 0
[post_date] => 2026-02-16 15:48:22
[post_date_gmt] => 2026-02-16 13:18:15
[post_content] => Ideally located between Cinquantenaire and Montgomery, in a Beaux-Arts style building dating from 1910 and fully renovated in 2013, this apartment, with a gross floor area (according to the Energy Performance Certificate) of 170 m², offers two bedrooms. The complete renovation of the building was carried out in a contemporary style while respecting and preserving its period features.
Located on the third floor, the apartment comprises an entrance hall, a spacious living and dining area with Haussmannian influences, and a separate, fully equipped kitchen with a breakfast nook. The hallway leads to the master suite with a dressing room, full bathroom, and access to the terrace, as well as a second bedroom with a built-in wardrobe and an en-suite shower room.
Other: daytime concierge service, individual gas boiler, alarm system, common charges: EUR 450 (maintenance of common areas and concierge service). EPC: F
Montgomery is a sought-after residential area, prized for its tranquility and quality of life, while being within easy reach of shops, schools, and public transport.
For more information, please contact Melody Bingoni at +32 (0) 2 640 08 01.
[post_title] => Etterbeek I Montgomery
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 7574534-etterbeek-i-montgomery
[to_ping] =>
[pinged] =>
[post_modified] => 2026-04-27 14:32:15
[post_modified_gmt] => 2026-04-27 12:32:15
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.be/estates/7574534-etterbeek-i-montgomery/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[7] => WP_Post Object
(
[ID] => 87535
[post_author] => 0
[post_date] => 2026-01-28 16:44:20
[post_date_gmt] => 2026-01-28 15:44:20
[post_content] => Located in the Prince d'Orange district, surrounded by greenery, this bright three-bedroom apartment offers approximately 145 m² of gross floor area (as per the Energy Performance Certificate - EPC) and a southwest-facing terrace of approximately 50 m².
The first-floor apartment comprises an entrance hall with a cloakroom and guest toilet, a large living room with a fireplace opening onto a spacious terrace, and a separate, fully equipped kitchen. The sleeping area includes three bedrooms: a master bedroom with an en-suite bathroom and shower, as well as a dressing room, and two further bedrooms each with a shower room. The apartment also includes an indoor garage and a cellar (included in the rent).
Other: Company lease possible, alarm system, fireplace, hardwood floors, waiver of recourse insurance, and garden maintenance included. A fixed monthly charge of €150 covers the upkeep of common areas. EPC: D.
The Prince d'Orange district is ideally located between Uccle and Rhode-Saint-Genèse. This is a pleasant neighborhood offering a green and peaceful environment while remaining close to amenities. Schools are nearby.
For further information, please contact Mélody Bingoni at +32 (0)2 640 08 01.
[post_title] => Uccle I Prince d'Orange
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 7549822-uccle-i-prince-dorange
[to_ping] =>
[pinged] =>
[post_modified] => 2026-04-03 10:54:35
[post_modified_gmt] => 2026-04-03 08:54:35
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.be/estates/7549822-uccle-i-prince-dorange/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
)
[post_count] => 8
[current_post] => -1
[before_loop] => 1
[in_the_loop] =>
[post] => WP_Post Object
(
[ID] => 89257
[post_author] => 0
[post_date] => 2026-03-30 11:10:18
[post_date_gmt] => 2026-03-30 09:04:42
[post_content] => Ideally located near Avenue Louise and the Jardins du Roi, at the rear of a recent building, this one-bedroom apartment offers a gross floor area (EPC) of 90 m² with a pleasant private interior courtyard.
The apartment, located at the rear of the building on the ground floor, opens onto a spacious living/dining room of 54 m², bathed in light thanks to large bay windows providing access to the private courtyard, ideally facing south/west. On the night side, a bedroom of approximately 14 m² also provides access to the outdoor space and is extended by a separate bathroom with a walk-in shower. A laundry area completes the property.
Other features: video intercom, dual-flow ventilation, bicycle storage, optional parking space (required), no cellar, common area charges, private heating and hot water: €200. EPC: C+
Le Jardin du Roi is ideally located near shops and restaurants in a peaceful and charming neighborhood. Easy access to public transportation.
For further information, please contact Laurence Ballaux at +32 (0) 2 640 08 01
[post_title] => Ixelles I Jardin du Roi
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 7635723-ixelles-i-jardin-du-roi
[to_ping] =>
[pinged] =>
[post_modified] => 2026-05-11 17:26:51
[post_modified_gmt] => 2026-05-11 15:26:51
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.be/estates/7635723-ixelles-i-jardin-du-roi/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 8
[max_num_pages] => 1
[max_num_comment_pages] => 0
[is_single] =>
[is_preview] =>
[is_page] =>
[is_archive] => 1
[is_date] =>
[is_year] =>
[is_month] =>
[is_day] =>
[is_time] =>
[is_author] =>
[is_category] =>
[is_tag] =>
[is_tax] =>
[is_search] =>
[is_feed] =>
[is_comment_feed] =>
[is_trackback] =>
[is_home] =>
[is_privacy_policy] =>
[is_404] =>
[is_embed] =>
[is_paged] =>
[is_admin] =>
[is_attachment] =>
[is_singular] =>
[is_robots] =>
[is_favicon] =>
[is_posts_page] =>
[is_post_type_archive] => 1
[query_vars_hash:WP_Query:private] => ed2efbb58c687fa846424715f8ed678b
[query_vars_changed:WP_Query:private] => 1
[thumbnails_cached] =>
[allow_query_attachment_by_filename:protected] =>
[stopwords:WP_Query:private] =>
[compat_fields:WP_Query:private] => Array
(
[0] => query_vars_hash
[1] => query_vars_changed
)
[compat_methods:WP_Query:private] => Array
(
[0] => init_query_flags
[1] => parse_tax_query
)
[query_cache_key:WP_Query:private] => wp_query:abf17d6317a024951195129cc52d666e
)
WHERE wpstbys_posts.post_type = 'estates' AND wpstbys_posts.post_status = 'publish' AND wpstbys_posts.post_parent = 0 AND EXISTS (
SELECT 1 FROM wpstbys_postmeta pm1
WHERE pm1.post_id = wpstbys_posts.ID
AND pm1.meta_key = 'displaystatusid'
AND pm1.meta_value = '2'
) AND (
NOT EXISTS (
SELECT 1 FROM wpstbys_postmeta pm2
WHERE pm2.post_id = wpstbys_posts.ID
AND pm2.meta_key = 'canhavechildren'
AND pm2.meta_value = '1'
)
OR NOT EXISTS (
SELECT 1 FROM wpstbys_postmeta pm3
WHERE pm3.post_id = wpstbys_posts.ID
AND pm3.meta_key = 'canhavechildren'
)
) AND (
EXISTS (
SELECT 1 FROM wpstbys_postmeta pm4
WHERE pm4.post_id = wpstbys_posts.ID
AND pm4.meta_key = 'price'
AND CAST(pm4.meta_value AS SIGNED) >= 1000
)
OR NOT EXISTS (
SELECT 1 FROM wpstbys_postmeta pm5
WHERE pm5.post_id = wpstbys_posts.ID
AND pm5.meta_key = 'price'
)
) AND NOT EXISTS (
SELECT 1 FROM wpstbys_term_relationships tr_exclude
INNER JOIN wpstbys_term_taxonomy tt_exclude ON tr_exclude.term_taxonomy_id = tt_exclude.term_taxonomy_id
INNER JOIN wpstbys_terms t_exclude ON tt_exclude.term_id = t_exclude.term_id
WHERE tr_exclude.object_id = wpstbys_posts.ID
AND tt_exclude.taxonomy = 'estate_subtypes'
AND t_exclude.slug IN ('building-ground_en','terrain-a-batir_fr','bouwgrond_nl')
) AND EXISTS (
SELECT 1 FROM wpstbys_term_relationships tr
INNER JOIN wpstbys_term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
INNER JOIN wpstbys_terms t ON tt.term_id = t.term_id
WHERE tr.object_id = wpstbys_posts.ID
AND tt.taxonomy = 'estate_status'
AND t.slug IN ('under-offer-rent_en')
)
Tell us about your project, we’ll take care of the rest.
By submitting this form, I agree that Sotheby's can contact me and I accept the Sotheby's privacy policy.