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] => 86819
[1] => 86830
[2] => 86881
[3] => 88532
)
[orderby] => post__in
[posts_per_page] => 17
)
[query_vars] => Array
(
[post_type] => estates
[post_status] => publish
[post__in] => Array
(
[0] => 86819
[1] => 86830
[2] => 86881
[3] => 88532
)
[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 (86819,86830,86881,88532) 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,86819,86830,86881,88532)
LIMIT 0, 17
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 86819
[post_author] => 1
[post_date] => 2024-01-17 16:25:48
[post_date_gmt] => 2024-01-17 15:25:48
[post_content] => Located in a green setting, close to all amenities, this penthouse has been tastefully renovated to a gross floor area of ± 365 m², with a perfectly oriented terrace of ±55 m².
Perched on the 7th floor, this contemporary-style penthouse boasts unique views over Brussels and the Bois de la Cambre. The vast walk-through receptions and skylights provide unparalleled luminosity. These include a double lounge with open fireplace opening onto the terrace, a dining room, a fully equipped Bulthaup kitchen with pantry/laundry room, air-conditioned wine cellar and a TV lounge. A master suite with access to the terrace, dressing room and bathroom, 2 bedrooms with en suite bathroom/shower, relaxation area with hammam and infrared sauna. An additional professional area with sitting room or study, bedroom and shower room. A maid's room with shower room, a double garage and a parking space complete this beautiful property.
Other features: PEB C, integrated air conditioning, RJ 45, audio cabling, numerous cupboards, armoured door, private lift, 2 large cellars.
L'Observatoire is a green, quiet neighbourhood within easy reach of shops, public transport and several schools. It's a friendly, family-friendly neighbourhood.
For further information, please contact Corinne Thumelaire + 32 (0) 498 23 79 35
[post_title] => Uccle I Observatoire
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 5472701-uccle-i-observatoire
[to_ping] =>
[pinged] =>
[post_modified] => 2026-04-10 15:29:48
[post_modified_gmt] => 2026-04-10 13:29:48
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.be/estates/5472701-uccle-i-observatoire/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 86830
[post_author] => 1
[post_date] => 2023-06-12 15:39:26
[post_date_gmt] => 2023-06-12 13:39:26
[post_content] => In the heart of a sought-after area of Woluwe Saint-Lambert, in a quiet street close to all facilities, elegant mansion built in 1931 and renovated in 2003, situated on a plot of 2 ares 85.
Behind a 9 m wide façade, this office building offers a total surface area of ± 699 m² and consists of office space on 3 levels, respectively ± 157 m², ± 145 m² and ± 135 m², and a flat under the roof of ± 127 m² as well as cellars under the whole house. The ground floor office has a kitchen and an east-facing garden. Each other office level has a kitchenette. On the top floor, the flat is composed of a large living room, an office, a kitchen and 2 bedrooms sharing a bathroom.
Other: 1 car garage, cellars, laundry room, boiler 2019, good rental yield.
Located near the Cinquantenaire and Square Montgomery, this lively family neighbourhood around the Saint-Henri Church, has all the amenities such as schools, shops, access to major roads and numerous public transport links.
For further information, please contact Corinne Thumelaire on + 32 (0) 498 23 79 35.
[post_title] => Woluwe Saint-Lambert I Parvis Saint Henri
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 5394974-woluwe-saint-lambert-i-parvis-saint-henri
[to_ping] =>
[pinged] =>
[post_modified] => 2026-04-10 15:30:33
[post_modified_gmt] => 2026-04-10 13:30:33
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.be/estates/5394974-woluwe-saint-lambert-i-parvis-saint-henri/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 86881
[post_author] => 1
[post_date] => 2022-06-30 11:11:39
[post_date_gmt] => 2022-06-30 09:11:39
[post_content] => Located in the heart of the historic "Tour & Taxis" site, at the top of the Brooklyn building, penthouse of ± 220 m² gross with pleasant terraces and panoramic views over Brussels. He benefits from all the facilities of this inspiring and dynamic urban hub in full development. This is a unique living environment in the city, located in a quiet, soft mobility site, bordering a vast green park.
This penthouse is located on the 12th and top floor of this New York-inspired building. He consists of an entrance hall with cloakroom and guest toilet, a living room open onto three glass façades, a fully equipped kitchen and an independent office (or guest room), all opening onto two beautiful terraces totalling ± 36 m² overlooking the Tour & Taxis site and the lights of the city. The night area offers two bedrooms en suite, each with its own shower room and toilet, a laundry room and a storage room.
Other: optional cellars, rental parking in the basement with direct access to the flats.
The Canal is an original and atypical district just a stone's throw from the city centre, close to public transport and all other facilities. It is also known for its many restaurants and its extraordinary views.
For further information, please contact Philippe Dijkmans on +32 (0) 475 45 77 20.
[post_title] => Brussels I Canal
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 4812439-brussels-i-canal
[to_ping] =>
[pinged] =>
[post_modified] => 2026-04-10 15:30:34
[post_modified_gmt] => 2026-04-10 13:30:34
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.be/estates/4812439-brussels-i-canal/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[3] => WP_Post Object
(
[ID] => 88532
[post_author] => 1
[post_date] => 2022-02-04 12:39:32
[post_date_gmt] => 2022-02-04 11:39:32
[post_content] => Residence on a plot of ± 54 ares with double access, located in a quiet and residential area a few minutes from Fort Jaco.
This villa enjoys a bird's eye view of a beautifully landscaped garden. This opens onto an entrance hall leading to receptions consisting of a living room with fireplace and an office, the dining room, the kitchen and its direct access to the outside. Upstairs, the master suite with dressing room, bathroom and its terrace on the garden side, another bedroom. On the second floor, two bedrooms share a bathroom. This one-of-a-kind property is to be completely renovated or knocked down (there is already a magnificent project by a renowned architect).
Others: Two outdoor garages, a beautiful swimming pool with its atypical pool house, a duplex caretaker's lodge, numerous cellars, a technical room with gas boiler, laundry room.
The Espinette Centrale is a green and calm district close to the Forêt de Soignes. It is located close to small shops and offers easy access to restaurants and shops in Waterloo.
For any further information, please contact Sylvie Koch +32 (0) 472 86 96 68.
[post_title] => Rhode-Saint-Genèse I Espinette Centrale
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 4491410-rhode-saint-genese-i-espinette-centrale
[to_ping] =>
[pinged] =>
[post_modified] => 2026-04-10 15:30:35
[post_modified_gmt] => 2026-04-10 13:30:35
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.be/estates/4491410-rhode-saint-genese-i-espinette-centrale/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
)
[post_count] => 4
[current_post] => -1
[before_loop] => 1
[in_the_loop] =>
[post] => WP_Post Object
(
[ID] => 86819
[post_author] => 1
[post_date] => 2024-01-17 16:25:48
[post_date_gmt] => 2024-01-17 15:25:48
[post_content] => Located in a green setting, close to all amenities, this penthouse has been tastefully renovated to a gross floor area of ± 365 m², with a perfectly oriented terrace of ±55 m².
Perched on the 7th floor, this contemporary-style penthouse boasts unique views over Brussels and the Bois de la Cambre. The vast walk-through receptions and skylights provide unparalleled luminosity. These include a double lounge with open fireplace opening onto the terrace, a dining room, a fully equipped Bulthaup kitchen with pantry/laundry room, air-conditioned wine cellar and a TV lounge. A master suite with access to the terrace, dressing room and bathroom, 2 bedrooms with en suite bathroom/shower, relaxation area with hammam and infrared sauna. An additional professional area with sitting room or study, bedroom and shower room. A maid's room with shower room, a double garage and a parking space complete this beautiful property.
Other features: PEB C, integrated air conditioning, RJ 45, audio cabling, numerous cupboards, armoured door, private lift, 2 large cellars.
L'Observatoire is a green, quiet neighbourhood within easy reach of shops, public transport and several schools. It's a friendly, family-friendly neighbourhood.
For further information, please contact Corinne Thumelaire + 32 (0) 498 23 79 35
[post_title] => Uccle I Observatoire
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 5472701-uccle-i-observatoire
[to_ping] =>
[pinged] =>
[post_modified] => 2026-04-10 15:29:48
[post_modified_gmt] => 2026-04-10 13:29:48
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.be/estates/5472701-uccle-i-observatoire/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 4
[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] => 6ea9c02b67138143bef1920cb9723e3c
[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:c5382579314ca8ce393d84a3caa89788
)
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) >= 300000
)
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 ('out-of-sales_en')
)
1
117
18,724
92
87
By submitting this form, I agree that Sotheby's can contact me and I accept the Sotheby's privacy policy.