Faisons connaissance
Parlez-nous de votre projet, nous nous occuperons du reste.
WP_Query Object
(
[query] => Array
(
[post_type] => estates
[post_status] => publish
[post__in] => Array
(
[0] => 85240
)
[orderby] => post__in
[posts_per_page] => 17
)
[query_vars] => Array
(
[post_type] => estates
[post_status] => publish
[post__in] => Array
(
[0] => 85240
)
[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] => 5
)
[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] => 5
[order] =>
)
[tax_query] => WP_Tax_Query Object
(
[queries] => Array
(
[0] => Array
(
[taxonomy] => language
[terms] => Array
(
[0] => 5
)
[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] => 5
)
[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 (85240) AND (
wpstbys_term_relationships.term_taxonomy_id IN (5)
) 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 ( 5 )
GROUP BY wpstbys_posts.ID
ORDER BY FIELD(wpstbys_posts.ID,85240)
LIMIT 0, 17
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 85240
[post_author] => 0
[post_date] => 2025-10-17 12:05:01
[post_date_gmt] => 2025-10-17 10:04:22
[post_content] => Idéalement situé à coté du parc Duden, à deux pas de l’avenue Winston Churchill, offrant un accès aisé vers le centre ville et le Thalys, demeure d'architecte classique datant de 1968 avec une très belle façade en pierres de France sise sur un terrain de 48 a 95 ca.
Entièrement rénovée par 3ème Bureau et Esther Gutmer, elle offre une superficie brute selon Peb de ± 1.2910 m². La maison s'ouvre sur un hall d'entrée d'apparat avec mezzanine. Le rez-de-chaussée propose un vaste salon lambrissé, une salle à manger d'honneur et une plus petite salle à manger privée ainsi q'un petit salon, une cuisine professionnelle "La Cornue" neuve et un bureau. À l'étage, une suite parentale avec salon, chambre, salle de bains et dressing, cinq chambres avec dressings et salles de bains. Une conciergerie independanre avec un salon, deux chambres et une salle de bains vient compléter l'ensemble.
Autres : Bail société possible, garages 4 voitures, ascenseur, piscine extérieure de 8 x 15 m avec douche et sauna, caves de rangement et cave à vins, grande salle de jeux,
Le parc Duden est un quartier très agréable idéalement situé entre les transports en commun, les petits commerces. Accès facile au centre-ville comme à Uccle ou à Ixelles.
Pour toute information complémentaire, veuillez contacter Mélody Bingoni au +32 2 640 08 01.
[post_title] => Forest I Altitude Cent
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 7215482-forest-i-altitude-cent
[to_ping] =>
[pinged] =>
[post_modified] => 2026-08-21 12:20:47
[post_modified_gmt] => 2026-08-21 10:20:47
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.be/estates/7215482-forest-i-altitude-cent/
[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] => 85240
[post_author] => 0
[post_date] => 2025-10-17 12:05:01
[post_date_gmt] => 2025-10-17 10:04:22
[post_content] => Idéalement situé à coté du parc Duden, à deux pas de l’avenue Winston Churchill, offrant un accès aisé vers le centre ville et le Thalys, demeure d'architecte classique datant de 1968 avec une très belle façade en pierres de France sise sur un terrain de 48 a 95 ca.
Entièrement rénovée par 3ème Bureau et Esther Gutmer, elle offre une superficie brute selon Peb de ± 1.2910 m². La maison s'ouvre sur un hall d'entrée d'apparat avec mezzanine. Le rez-de-chaussée propose un vaste salon lambrissé, une salle à manger d'honneur et une plus petite salle à manger privée ainsi q'un petit salon, une cuisine professionnelle "La Cornue" neuve et un bureau. À l'étage, une suite parentale avec salon, chambre, salle de bains et dressing, cinq chambres avec dressings et salles de bains. Une conciergerie independanre avec un salon, deux chambres et une salle de bains vient compléter l'ensemble.
Autres : Bail société possible, garages 4 voitures, ascenseur, piscine extérieure de 8 x 15 m avec douche et sauna, caves de rangement et cave à vins, grande salle de jeux,
Le parc Duden est un quartier très agréable idéalement situé entre les transports en commun, les petits commerces. Accès facile au centre-ville comme à Uccle ou à Ixelles.
Pour toute information complémentaire, veuillez contacter Mélody Bingoni au +32 2 640 08 01.
[post_title] => Forest I Altitude Cent
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 7215482-forest-i-altitude-cent
[to_ping] =>
[pinged] =>
[post_modified] => 2026-08-21 12:20:47
[post_modified_gmt] => 2026-08-21 10:20:47
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.be/estates/7215482-forest-i-altitude-cent/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 69
[max_num_pages] => 5
[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] => c4543044c075210af3b82f4f5acefef8
[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:982bc02e733a92b1da5c84cf836eb260
)
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 ('a-louer_fr','option-l-_fr')
)
1
112
17,733
93
84
By submitting this form, I agree that Sotheby's can contact me and I accept the Sotheby's privacy policy.