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] => 86756
)
[orderby] => post__in
[posts_per_page] => 17
)
[query_vars] => Array
(
[post_type] => estates
[post_status] => publish
[post__in] => Array
(
[0] => 86756
)
[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 (86756) 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,86756)
LIMIT 0, 17
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 86756
[post_author] => 1
[post_date] => 2024-01-15 15:39:44
[post_date_gmt] => 2024-01-15 14:39:44
[post_content] => In the heart of Brussels, near the Parc Royal, completely renovated triplex of around 550 m² gross surface area in a mansion mixing space, elegance and modernism.
The three different entrances will be ideal for the combination of a liberal profession, prestigious apartment and service. On the ground floor, the entrance hall leads to a large office, a technical data room, a bedroom with bathroom and access to the basements (± 130 m²) composed of a gym, shower room (possibility of hammam), boiler room, wine cellar and plenty of storage. On the mezzanine, large bedroom with dressing room, bathroom and separate entrance. On the first floor, majestic receptions (ceiling height of 4.50m) including living and dining room, open fire with ethanol, Bulthaup kitchen with central island offering a view of the Congress column, cloakroom and boudoir lounge. The second floor includes a mezzanine living room, master bedroom with large dressing room and bathroom, two other bedrooms with dressing room and adjoining shower rooms.
Other : Alarm, electricity compliant with data system at all levels, videophone, individual boiler, wine cellar, 4 optional parking spaces at 30,000 € per unit.
The Parc Royal district is surrounded by parks, museums and restaurants. It is the site of many cultural and traditional events.
For any further information, please contact Corinne Thumelaire + 32 (0) 498 23 79 35.
[post_title] => Brussels I Royal Neighbourhood
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 5727382-brussels-i-royal-neighbourhood
[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/5727382-brussels-i-royal-neighbourhood/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
)
[post_count] => 1
[current_post] => -1
[before_loop] => 1
[in_the_loop] =>
[post] => WP_Post Object
(
[ID] => 86756
[post_author] => 1
[post_date] => 2024-01-15 15:39:44
[post_date_gmt] => 2024-01-15 14:39:44
[post_content] => In the heart of Brussels, near the Parc Royal, completely renovated triplex of around 550 m² gross surface area in a mansion mixing space, elegance and modernism.
The three different entrances will be ideal for the combination of a liberal profession, prestigious apartment and service. On the ground floor, the entrance hall leads to a large office, a technical data room, a bedroom with bathroom and access to the basements (± 130 m²) composed of a gym, shower room (possibility of hammam), boiler room, wine cellar and plenty of storage. On the mezzanine, large bedroom with dressing room, bathroom and separate entrance. On the first floor, majestic receptions (ceiling height of 4.50m) including living and dining room, open fire with ethanol, Bulthaup kitchen with central island offering a view of the Congress column, cloakroom and boudoir lounge. The second floor includes a mezzanine living room, master bedroom with large dressing room and bathroom, two other bedrooms with dressing room and adjoining shower rooms.
Other : Alarm, electricity compliant with data system at all levels, videophone, individual boiler, wine cellar, 4 optional parking spaces at 30,000 € per unit.
The Parc Royal district is surrounded by parks, museums and restaurants. It is the site of many cultural and traditional events.
For any further information, please contact Corinne Thumelaire + 32 (0) 498 23 79 35.
[post_title] => Brussels I Royal Neighbourhood
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 5727382-brussels-i-royal-neighbourhood
[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/5727382-brussels-i-royal-neighbourhood/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 188
[max_num_pages] => 12
[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_sitemap] =>
[is_posts_page] =>
[is_post_type_archive] => 1
[query_vars_hash:WP_Query:private] => 63227115b37c58a889f8dedc5735de26
[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:8e446711c0044366b99f908c9277ffb1
)
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 ('for-sale_en')
)
1
113
17,768
93
85
By submitting this form, I agree that Sotheby's can contact me and I accept the Sotheby's privacy policy.