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] => 91848
)
[orderby] => post__in
[posts_per_page] => 17
)
[query_vars] => Array
(
[post_type] => estates
[post_status] => publish
[post__in] => Array
(
[0] => 91848
)
[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 (91848) 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,91848)
LIMIT 0, 17
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 91848
[post_author] => 0
[post_date] => 2026-09-08 17:27:58
[post_date_gmt] => 2026-09-08 14:21:47
[post_content] => Propriété de caractère entièrement rénovée en 2024, implantée sur un terrain de plus de 50 ares. Développant une superficie construite totale de ± 1.147 m² hors terrasses couvertes, cet ensemble immobilier conjugue volumes généreux, caractère architectural et prestations contemporaines.
Le corps de logis accueille, au rez-de-chaussée, un vaste hall d’entrée, un salon de réception de ± 57 m² avec feu ouvert traversant, une salle à manger, une cuisine familiale avec îlot central et arrière-cuisine, un bureau ainsi qu’un espace home cinéma. L’étage propose une suite parentale avec dressing et salle de bains privative, 3 chambres supplémentaires, 3 salles d’eau et une buanderie. L’aile gauche abrite également 2 logements indépendants, tandis que de vastes terrasses, dont une couverte orientée plein sud, prolongent harmonieusement les espaces de vie vers le jardin. Pour compléter l’ensemble, les anciennes écuries ont été entièrement réhabilitées en une villa contemporaine indépendante de ± 225 m² bruts, offrant de généreux espaces de vie et 3 chambres supplémentaires.
Autre : Cave à vin, nombreux espaces de rangement, système d'alarme, climatisation, chauffage PAC, ... PEB : B.
Avec ses villas prestigieuses, Ohain est connu pour ses paysages attrayants et sa place de village classée.
Pour toute information complémentaire, veuillez contacter Sotheby’s Brabant au 02/898.09.40.
[post_title] => Brabant Wallon I Lasne
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 7860469-brabant-wallon-i-lasne
[to_ping] =>
[pinged] =>
[post_modified] => 2026-11-19 12:28:17
[post_modified_gmt] => 2026-11-19 11:28:17
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.be/estates/7860469-brabant-wallon-i-lasne/
[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] => 91848
[post_author] => 0
[post_date] => 2026-09-08 17:27:58
[post_date_gmt] => 2026-09-08 14:21:47
[post_content] => Propriété de caractère entièrement rénovée en 2024, implantée sur un terrain de plus de 50 ares. Développant une superficie construite totale de ± 1.147 m² hors terrasses couvertes, cet ensemble immobilier conjugue volumes généreux, caractère architectural et prestations contemporaines.
Le corps de logis accueille, au rez-de-chaussée, un vaste hall d’entrée, un salon de réception de ± 57 m² avec feu ouvert traversant, une salle à manger, une cuisine familiale avec îlot central et arrière-cuisine, un bureau ainsi qu’un espace home cinéma. L’étage propose une suite parentale avec dressing et salle de bains privative, 3 chambres supplémentaires, 3 salles d’eau et une buanderie. L’aile gauche abrite également 2 logements indépendants, tandis que de vastes terrasses, dont une couverte orientée plein sud, prolongent harmonieusement les espaces de vie vers le jardin. Pour compléter l’ensemble, les anciennes écuries ont été entièrement réhabilitées en une villa contemporaine indépendante de ± 225 m² bruts, offrant de généreux espaces de vie et 3 chambres supplémentaires.
Autre : Cave à vin, nombreux espaces de rangement, système d'alarme, climatisation, chauffage PAC, ... PEB : B.
Avec ses villas prestigieuses, Ohain est connu pour ses paysages attrayants et sa place de village classée.
Pour toute information complémentaire, veuillez contacter Sotheby’s Brabant au 02/898.09.40.
[post_title] => Brabant Wallon I Lasne
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 7860469-brabant-wallon-i-lasne
[to_ping] =>
[pinged] =>
[post_modified] => 2026-11-19 12:28:17
[post_modified_gmt] => 2026-11-19 11:28:17
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.be/estates/7860469-brabant-wallon-i-lasne/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 1
[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_sitemap] =>
[is_posts_page] =>
[is_post_type_archive] => 1
[query_vars_hash:WP_Query:private] => a7a9dc856c526ac1ef1fb309048c63d3
[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:166dab428f83507ba0b08c2e981323fb
)
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 ('preparation_fr')
)
Parlez-nous de votre projet, nous nous occuperons du reste.
By submitting this form, I agree that Sotheby's can contact me and I accept the Sotheby's privacy policy.