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] => 78548
[1] => 75252
)
[orderby] => post__in
[posts_per_page] => 17
)
[query_vars] => Array
(
[post_type] => estates
[post_status] => publish
[post__in] => Array
(
[0] => 78548
[1] => 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,78548) 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,78548,75252)
LIMIT 0, 17
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 78548
[post_author] => 0
[post_date] => 2025-07-15 16:10:10
[post_date_gmt] => 2025-07-15 12:10:10
[post_content] => Located in the heart of a private estate of over 6 hectares, the Ferme de Penteville is a truly exceptional property, rare in both its variety of uses and the quality of its facilities. It perfectly combines private life, professional activity, and leisure in a green and peaceful setting.
The main house, completely renovated in 2014, offers approximately 870 m² of living space. It features generous volumes: several lounges, dining room, office, fully equipped kitchen, 7 bedrooms, multiple bathrooms, and a wellness area with indoor pool, gym, and elevator serving all floors. Three independent apartments comfortably accommodate guests, family, staff, or tenants — each with living room, kitchen, and one or two bedrooms. The professional area includes an office building of ±610 m² with separate entrance, a reception hall of ±190 m², and a ±600 m² hangar divided into garages, one of which is equipped with a car lift. Equestrian facilities include stables, paddocks, lunging ring, track, tack room, and storage spaces.
Others: alarm system, video surveillance, rainwater tanks, compliant electrical installation.
Gembloux offers a green and tranquil living environment, ideally located between Brussels and Namur. The town combines heritage, accessibility, and all the conveniences of a dynamic center.
For further information and visits, please contact our office in Walloon Brabant on +32 (2) 898.09.40.
[post_title] => Namur I Gembloux
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 6957222-namur-i-gembloux
[to_ping] =>
[pinged] =>
[post_modified] => 2026-01-05 09:32:12
[post_modified_gmt] => 2026-01-05 08:32:12
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.be/estates/6957222-2/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => 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] => 2
[current_post] => -1
[before_loop] => 1
[in_the_loop] =>
[post] => WP_Post Object
(
[ID] => 78548
[post_author] => 0
[post_date] => 2025-07-15 16:10:10
[post_date_gmt] => 2025-07-15 12:10:10
[post_content] => Located in the heart of a private estate of over 6 hectares, the Ferme de Penteville is a truly exceptional property, rare in both its variety of uses and the quality of its facilities. It perfectly combines private life, professional activity, and leisure in a green and peaceful setting.
The main house, completely renovated in 2014, offers approximately 870 m² of living space. It features generous volumes: several lounges, dining room, office, fully equipped kitchen, 7 bedrooms, multiple bathrooms, and a wellness area with indoor pool, gym, and elevator serving all floors. Three independent apartments comfortably accommodate guests, family, staff, or tenants — each with living room, kitchen, and one or two bedrooms. The professional area includes an office building of ±610 m² with separate entrance, a reception hall of ±190 m², and a ±600 m² hangar divided into garages, one of which is equipped with a car lift. Equestrian facilities include stables, paddocks, lunging ring, track, tack room, and storage spaces.
Others: alarm system, video surveillance, rainwater tanks, compliant electrical installation.
Gembloux offers a green and tranquil living environment, ideally located between Brussels and Namur. The town combines heritage, accessibility, and all the conveniences of a dynamic center.
For further information and visits, please contact our office in Walloon Brabant on +32 (2) 898.09.40.
[post_title] => Namur I Gembloux
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 6957222-namur-i-gembloux
[to_ping] =>
[pinged] =>
[post_modified] => 2026-01-05 09:32:12
[post_modified_gmt] => 2026-01-05 08:32:12
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.be/estates/6957222-2/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 2
[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_posts_page] =>
[is_post_type_archive] => 1
[query_vars_hash:WP_Query:private] => f2369820a3489cc32ef0980a25c4e34f
[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:25b094ceeaedfa7f9528af4e7fc2f225
)
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
115
18,348
90
86
By submitting this form, I agree that Sotheby's can contact me and I accept the Sotheby's privacy policy.