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] => 91542
[1] => 91231
[2] => 75252
)
[orderby] => post__in
[posts_per_page] => 17
)
[query_vars] => Array
(
[post_type] => estates
[post_status] => publish
[post__in] => Array
(
[0] => 91542
[1] => 91231
[2] => 75252
)
[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 (75252,91231,91542) 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,91542,91231,75252)
LIMIT 0, 17
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 91542
[post_author] => 0
[post_date] => 2026-09-02 10:39:34
[post_date_gmt] => 2026-08-21 13:28:50
[post_content] => Situated in the charming municipality of Malèves-Sainte-Marie, just a short distance from the village square, this remarkable 18th-century quadrangular farmhouse offers an exceptional character property comprising a versatile space, a garage, an impressive barn and a main residence with six bedrooms.
The courtyard is accessed through an elegant entrance gate. It provides access to the professional areas, currently arranged as a workshop, the barn, whose roof has been completely renovated, as well as the impressive garage, which was formerly converted into an indoor tennis court. The main residence, carefully and tastefully restored, features several reception rooms, a large kitchen with a breakfast area, as well as a separate guest wing comprising two bedrooms. Upstairs are the principal suite with dressing room and bathroom, together with three additional bedrooms.
Additional features include a swimming pool, a reception/party room, a wine cellar and several cellars, as well as a fitness room, EPC pending.
Malèves-Sainte-Marie, a charming village in Walloon Brabant, appeals with its bucolic surroundings, well-preserved rural heritage and peaceful atmosphere. Close to the main roads and amenities, it offers a privileged lifestyle in a lush and verdant setting.
For further information or to arrange a viewing, please contact Sotheby’s Brabant on +32 (2) 898.09.40.
[post_title] => Walloon Brabant I Malèves-Sainte-Marie
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 7832754-walloon-brabant-i-maleves-sainte-marie
[to_ping] =>
[pinged] =>
[post_modified] => 2026-09-03 13:06:15
[post_modified_gmt] => 2026-09-03 11:06:15
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.be/estates/7832754-estate-7832754/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 91231
[post_author] => 0
[post_date] => 2026-08-08 08:36:27
[post_date_gmt] => 2026-07-30 11:27:01
[post_content] => This exclusive equestrian estate is situated in the Heuvelland region of West Flanders, on a plot of approximately 7.7 ha, offering panoramic views.
The estate comprises a house with a living area and fireplace, a fully equipped kitchen, 3 bedrooms, 2 bathrooms, a utility room, a study and 2 indoor garages. Adjacent to this is a building housing a wellness centre, reception facilities and an outdoor swimming pool. The estate also features a caretaker’s house with a living area and fireplace, a fully equipped kitchen, an office, a utility room, four bedrooms, four bathrooms and an indoor garage. Adjacent to this is a guest house with three bedrooms, three bathrooms and a living area with a kitchen. Furthermore, the estate comprises stables, an indoor arena with stands, a judges’ room and a bar, an outdoor arena, spacious (covered) parking facilities and storage space. Set in beautiful countryside, with charming terraces and ponds, the estate offers exceptional tranquillity and privacy, with scope for residential and professional activities in accordance with current regulations.
Other details: EPC A, Class 2 environmental permit (105 horses) valid until 16/06/2029, heat pumps, electrical substation, water reservoir, on-site wastewater treatment system (IBA), solar water heater, solar panels and ground-source heat pump (GSC), home automation and CCTV.
A rare combination of exclusive living and commercial activities in the idyllic hilly landscape of Poperinge.
For further information, please contact Heidi Stevens on +32 477 63 69 65.
[post_title] => West Flanders I Poperinge
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 7798927-west-flanders-i-poperinge
[to_ping] =>
[pinged] =>
[post_modified] => 2026-08-27 14:03:53
[post_modified_gmt] => 2026-08-27 12:03:53
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.be/estates/7798927-west-vlaanderen-i-reningelst/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 75252
[post_author] => 0
[post_date] => 2024-11-21 08:39:23
[post_date_gmt] => 2024-11-21 07:39:23
[post_content] => Square-shaped farm of the eighteenth century with a living area of ± 650 m² located on a plot of ± 13 hectares in the Flemish Brabant.
In the middle of the courtyard is an ancient oak tree surrounded by the main house and several stalls. The ‘Lindenhof’ farm is composed of several buildings. The main building consists in a spacious entrance hall, a living room with a Louis XIII style open fireplace, a dining room and a fully equipped kitchen with orangery, an office and a heated veranda.The first floor leads up to three bedrooms and three bathrooms. Adjoining the farm there are a second home with a living room, a kitchen and a bedroom with bathroom, an impressive multi-functional barn and an ancient priory, which has been renovated and converted into a stable with a beautiful vaulted ceiling. The surrounding meadow of circa 13 acres is entirely fenced and divided into several plots which would be ideal for horse breeding.
Other: dependence, chapel, nature reserve of ± 250 ha.
The domain is located in a nature reserve of the Dyle Valley, in the south of Leuven and only 20 minutes from Brussels.
For more information, please contact Bertrand de Moffarts au +32 (0) 475 94 45 08.
[post_title] => Flemish Brabant I Huldenberg
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 6337315-flemish-brabant-i-huldenberg
[to_ping] =>
[pinged] =>
[post_modified] => 2025-09-10 09:30:30
[post_modified_gmt] => 2025-09-10 07:30:30
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.sothebysrealty.be/estates/6337315-flemish-brabant-i-huldenberg/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
)
[post_count] => 3
[current_post] => -1
[before_loop] => 1
[in_the_loop] =>
[post] => WP_Post Object
(
[ID] => 91542
[post_author] => 0
[post_date] => 2026-09-02 10:39:34
[post_date_gmt] => 2026-08-21 13:28:50
[post_content] => Situated in the charming municipality of Malèves-Sainte-Marie, just a short distance from the village square, this remarkable 18th-century quadrangular farmhouse offers an exceptional character property comprising a versatile space, a garage, an impressive barn and a main residence with six bedrooms.
The courtyard is accessed through an elegant entrance gate. It provides access to the professional areas, currently arranged as a workshop, the barn, whose roof has been completely renovated, as well as the impressive garage, which was formerly converted into an indoor tennis court. The main residence, carefully and tastefully restored, features several reception rooms, a large kitchen with a breakfast area, as well as a separate guest wing comprising two bedrooms. Upstairs are the principal suite with dressing room and bathroom, together with three additional bedrooms.
Additional features include a swimming pool, a reception/party room, a wine cellar and several cellars, as well as a fitness room, EPC pending.
Malèves-Sainte-Marie, a charming village in Walloon Brabant, appeals with its bucolic surroundings, well-preserved rural heritage and peaceful atmosphere. Close to the main roads and amenities, it offers a privileged lifestyle in a lush and verdant setting.
For further information or to arrange a viewing, please contact Sotheby’s Brabant on +32 (2) 898.09.40.
[post_title] => Walloon Brabant I Malèves-Sainte-Marie
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 7832754-walloon-brabant-i-maleves-sainte-marie
[to_ping] =>
[pinged] =>
[post_modified] => 2026-09-03 13:06:15
[post_modified_gmt] => 2026-09-03 11:06:15
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.be/estates/7832754-estate-7832754/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 3
[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] => b3631ff89981ff5e94de261e68fc524f
[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:08b12f5ff91d03b8cb6c303c757f279a
)
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','draft-contract_en','under-offer-sale_en')
) 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_subtypes'
AND t.slug IN ('farm_en')
)
1
116
17,944
94
86
By submitting this form, I agree that Sotheby's can contact me and I accept the Sotheby's privacy policy.