WP_Query Object
(
[query] => Array
(
[post_type] => estates
[post_status] => publish
[post__in] => Array
(
[0] => 75254
)
[orderby] => post__in
[posts_per_page] => 17
)
[query_vars] => Array
(
[post_type] => estates
[post_status] => publish
[post__in] => Array
(
[0] => 75254
)
[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] =>
[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 (75254) 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,75254)
LIMIT 0, 17
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 75254
[post_author] => 0
[post_date] => 2024-11-21 08:39:23
[post_date_gmt] => 2024-11-21 07:39:23
[post_content] => Gelegen temidden van het natuurgebied in de Dijlevallei, prachtige 18de eeuwse Brabantse vierkantshoeve met bewoonbare oppervlakte van ± 650 m² op een terrein van ± 13 hectare.
Rond de eeuwenoude eik op het binnenhof bevinden zich meerdere paardenboxen en het statige woonhuis. De Hoeve 'Lindenhof' bestaat uit meerdere gebouwen. Het hoofdgebouw biedt een ruime hall in blauwe steen, een woonkamer met open haard in Louis XIII-stijl, een eetkamer en een volledig ingerichte keuken met orangerie. Verder een bureau en verwarmde veranda. De eerste verdieping biedt 3 slaapkamers en 3 badkamers. Naast het hoofdgebouw bevindt zich een bijgebouw met living, keuken en een slaapkamer met badkamer. Daarbij biedt de imposante schuur tal van mogelijkheden en herbergt de mooi gerenoveerde oude priorij gewelfde stallingen voor paarden. De ± 13 hectare weiden zijn veilig afgespannen en opgedeeld in percelen met diverse afmetingen en dus ideaal voor paardenhouderij.
Andere : conciërge woning, kapel, opslagruimte, achterliggend natuurgebied van ± 250 hectare.
Het eigendom is gelegen in de Dijlevallei ten zuiden van Leuven en op 20 kilometer van Brussel.
Voor meer informatie kunt u contact opnemen met Bertrand de Moffarts op +32 (0) 475 94 45 08.
[post_title] => Vlaams-Brabant I Huldenberg
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 6337315-vlaams-brabant-i-huldenberg
[to_ping] =>
[pinged] =>
[post_modified] => 2025-09-10 09:30:28
[post_modified_gmt] => 2025-09-10 07:30:28
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.sothebysrealty.be/estates/6337315-flemish-brabant-i-huldenberg-3/
[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] => 75254
[post_author] => 0
[post_date] => 2024-11-21 08:39:23
[post_date_gmt] => 2024-11-21 07:39:23
[post_content] => Gelegen temidden van het natuurgebied in de Dijlevallei, prachtige 18de eeuwse Brabantse vierkantshoeve met bewoonbare oppervlakte van ± 650 m² op een terrein van ± 13 hectare.
Rond de eeuwenoude eik op het binnenhof bevinden zich meerdere paardenboxen en het statige woonhuis. De Hoeve 'Lindenhof' bestaat uit meerdere gebouwen. Het hoofdgebouw biedt een ruime hall in blauwe steen, een woonkamer met open haard in Louis XIII-stijl, een eetkamer en een volledig ingerichte keuken met orangerie. Verder een bureau en verwarmde veranda. De eerste verdieping biedt 3 slaapkamers en 3 badkamers. Naast het hoofdgebouw bevindt zich een bijgebouw met living, keuken en een slaapkamer met badkamer. Daarbij biedt de imposante schuur tal van mogelijkheden en herbergt de mooi gerenoveerde oude priorij gewelfde stallingen voor paarden. De ± 13 hectare weiden zijn veilig afgespannen en opgedeeld in percelen met diverse afmetingen en dus ideaal voor paardenhouderij.
Andere : conciërge woning, kapel, opslagruimte, achterliggend natuurgebied van ± 250 hectare.
Het eigendom is gelegen in de Dijlevallei ten zuiden van Leuven en op 20 kilometer van Brussel.
Voor meer informatie kunt u contact opnemen met Bertrand de Moffarts op +32 (0) 475 94 45 08.
[post_title] => Vlaams-Brabant I Huldenberg
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 6337315-vlaams-brabant-i-huldenberg
[to_ping] =>
[pinged] =>
[post_modified] => 2025-09-10 09:30:28
[post_modified_gmt] => 2025-09-10 07:30:28
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.sothebysrealty.be/estates/6337315-flemish-brabant-i-huldenberg-3/
[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_posts_page] =>
[is_post_type_archive] => 1
[query_vars_hash:WP_Query:private] => c63c322c47a2ae310bf9306f0def160d
[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:55d91e4bac4cd1f407914b46ed133779
)
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 ('te-koop_nl','compromis_nl','optie-te-koop_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_subtypes'
AND t.slug IN ('boerderij_nl')
)
1
118
18,724
92
87
By submitting this form, I agree that Sotheby's can contact me and I accept the Sotheby's privacy policy.