WP_Query Object
(
[query] => Array
(
[post_type] => estates
[post_status] => publish
[post__in] => Array
(
[0] => 85732
)
[orderby] => post__in
[posts_per_page] => 17
)
[query_vars] => Array
(
[post_type] => estates
[post_status] => publish
[post__in] => Array
(
[0] => 85732
)
[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] => 9
)
[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] => 9
[order] =>
)
[tax_query] => WP_Tax_Query Object
(
[queries] => Array
(
[0] => Array
(
[taxonomy] => language
[terms] => Array
(
[0] => 9
)
[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] => 9
)
[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] =>
[queried_object] =>
[queried_object_id] =>
[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 (85732) AND (
wpstbys_term_relationships.term_taxonomy_id IN (9)
) 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 ( 9 )
GROUP BY wpstbys_posts.ID
ORDER BY FIELD(wpstbys_posts.ID,85732)
LIMIT 0, 17
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 85732
[post_author] => 0
[post_date] => 2024-01-15 15:39:44
[post_date_gmt] => 2024-01-15 14:39:44
[post_content] => In het hartje van Brussel, vlakbij het Koninklijk Park, volledig gerenoveerde triplex van ± 550 m² bruto oppervlakte in een herenhuis dat ruimte, elegantie en modernisme allieert.
De drie verschillende ingangen zijn ideaal voor de combinatie van een vrij beroep, prestigieus appartement en service. Op het gelijkvloers leidt de inkomhal naar een groot kantoor, een technische gegevensruimte, een slaapkamer met badkamer en toegang tot de kelders (± 130 m²) bestaande uit een gymzaal, doucheruimte (mogelijkheid tot hammam), stookruimte, wijn kelder en veel opslagruimte. Op de tussenverdieping, grote slaapkamer met kleedkamer, badkamer en aparte ingang. Op de eerste verdieping majestueuze recepties (plafondhoogte 4,50m) inclusief woon- en eetkamer, open haard met ethanol, Bulthaup keuken met centraal eiland met zicht op de Congreszuil, vestiaire en boudoirsalon. De tweede verdieping omvat een mezzanine woonkamer, hoofdslaapkamer met grote kleedkamer en badkamer, twee andere slaapkamers met kleedkamer en aangrenzende doucheruimtes.
Andere : alarm, elektriciteit conform datasysteem op alle niveaus, videofoon, individuele boiler, wijnkelder, 4 optionele parkeerplaatsen à 30.000 € per eenheid.
De wijk rond het warandepark is uitstekend gelegen in het centrum van Brussel, op wandelafstand van vele restaurants, musea en winkels.
Voor meer informatie kunt u contact opnemen met Corinne Thumelaire + 32498 23 79 35.
[post_title] => Brussel I Koninklijke wijk
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 5727382-brussel-i-koninklijke-wijk
[to_ping] =>
[pinged] =>
[post_modified] => 2026-02-05 14:52:13
[post_modified_gmt] => 2026-02-05 13:52:13
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.be/estates/5727382-brussel-i-koninklijke-wijk/
[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] => 85732
[post_author] => 0
[post_date] => 2024-01-15 15:39:44
[post_date_gmt] => 2024-01-15 14:39:44
[post_content] => In het hartje van Brussel, vlakbij het Koninklijk Park, volledig gerenoveerde triplex van ± 550 m² bruto oppervlakte in een herenhuis dat ruimte, elegantie en modernisme allieert.
De drie verschillende ingangen zijn ideaal voor de combinatie van een vrij beroep, prestigieus appartement en service. Op het gelijkvloers leidt de inkomhal naar een groot kantoor, een technische gegevensruimte, een slaapkamer met badkamer en toegang tot de kelders (± 130 m²) bestaande uit een gymzaal, doucheruimte (mogelijkheid tot hammam), stookruimte, wijn kelder en veel opslagruimte. Op de tussenverdieping, grote slaapkamer met kleedkamer, badkamer en aparte ingang. Op de eerste verdieping majestueuze recepties (plafondhoogte 4,50m) inclusief woon- en eetkamer, open haard met ethanol, Bulthaup keuken met centraal eiland met zicht op de Congreszuil, vestiaire en boudoirsalon. De tweede verdieping omvat een mezzanine woonkamer, hoofdslaapkamer met grote kleedkamer en badkamer, twee andere slaapkamers met kleedkamer en aangrenzende doucheruimtes.
Andere : alarm, elektriciteit conform datasysteem op alle niveaus, videofoon, individuele boiler, wijnkelder, 4 optionele parkeerplaatsen à 30.000 € per eenheid.
De wijk rond het warandepark is uitstekend gelegen in het centrum van Brussel, op wandelafstand van vele restaurants, musea en winkels.
Voor meer informatie kunt u contact opnemen met Corinne Thumelaire + 32498 23 79 35.
[post_title] => Brussel I Koninklijke wijk
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 5727382-brussel-i-koninklijke-wijk
[to_ping] =>
[pinged] =>
[post_modified] => 2026-02-05 14:52:13
[post_modified_gmt] => 2026-02-05 13:52:13
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.be/estates/5727382-brussel-i-koninklijke-wijk/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comments] =>
[comment_count] => 0
[current_comment] => -1
[comment] =>
[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] => 6ee3e78d0a38675b6d07f88e9dbf9cdf
[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:145b44174fb3c0a40f9281ce9ccc3152
)
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.