WP_Query Object
(
[query] => Array
(
[post_type] => estates
[post_status] => publish
[post__in] => Array
(
[0] => 88969
[1] => 85687
[2] => 85642
[3] => 75688
)
[orderby] => post__in
[posts_per_page] => 17
)
[query_vars] => Array
(
[post_type] => estates
[post_status] => publish
[post__in] => Array
(
[0] => 88969
[1] => 85687
[2] => 85642
[3] => 75688
)
[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 (75688,85642,85687,88969) 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,88969,85687,85642,75688)
LIMIT 0, 17
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 88969
[post_author] => 0
[post_date] => 2026-05-11 10:17:14
[post_date_gmt] => 2026-03-10 12:52:06
[post_content] => Located in an elegant neo-eclectic townhouse dating back to 1875, “DE BARON” is a charming bed & breakfast where historic elegance and contemporary comfort blend harmoniously. Over the years, the property has developed a strong identity and presents a unique opportunity in the heart of Antwerp.
The ground floor comprises an entrance hall featuring original 19th-century details, a living room, a bedroom with en-suite bathroom, and an office. The first floor features the breakfast room and a fully equipped kitchen with an adjoining covered terrace/utility room. The second floor offers two bedrooms, each with its own en-suite bathroom. The attic floor includes two additional bedrooms, each with an en-suite bathroom, providing a spacious and functional layout for guest accommodation.
Additional features include: recently renewed roof, air conditioning, alarm system, authentic entrance hall, B&B furnishings included, townhouse, character property.
Situated in a highly accessible urban setting, this property combines a central location with immediate proximity to the train station, public transport, shops, and all city amenities, making it an excellent base for both leisure and business guests.
For more information, please contact Merva Marasligil at +32 (0)484 96 35 94.
[post_title] => Antwerp I City Center
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 7603109-antwerp-i-city-center
[to_ping] =>
[pinged] =>
[post_modified] => 2026-05-11 10:28:55
[post_modified_gmt] => 2026-05-11 08:28:55
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.be/estates/7603109-estate-7603109/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 85687
[post_author] => 0
[post_date] => 2025-12-11 16:00:04
[post_date_gmt] => 2025-11-07 08:56:14
[post_content] => Set on a magnificent, 2-hectare landscaped estate, this exceptional property in Meise is an oasis where contemporary architecture and unspoilt nature blend together masterfully. The villa has been completely renovated with an unparalleled eye for detail. With a living area of ±560 m², the property offers exceptional comfort and versatility.
The main building welcomes you with a living room around an atmospheric fireplace, an office and a cinema room. The spacious dining room and generous kitchen, equipped with high-quality Gaggenau appliances, form the heart of the house and exude warmth and refinement. Five bedrooms, each with its own bathroom, offer serene intimacy, while a separate wellness area with outdoor swimming pool, hammam and jacuzzi invites complete relaxation. The estate also features a guest house with two bedrooms, a bathroom and a fully equipped modern kitchen. A covered outdoor terrace opens onto the surrounding greenery and offers breathtaking panoramic views.
Located in charming and green Meise, the estate offers a serene and residential environment, close to excellent schools and local shops. The landscape combines tranquillity, nature and privacy with exceptional accessibility, just a stone's throw from Brussels.
For more information and to arrange a viewing, please contact Merva Marasligil on +32 (0) 484 96 35 94.
[post_title] => Flemish Brabant I Meise
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 7244162-flemish-brabant-i-meise
[to_ping] =>
[pinged] =>
[post_modified] => 2026-05-06 14:14:03
[post_modified_gmt] => 2026-05-06 12:14:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.be/estates/7244162-estate-7244162/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 85642
[post_author] => 1
[post_date] => 2025-10-30 22:25:51
[post_date_gmt] => 2025-10-30 21:25:51
[post_content] => Located between Prince d’Orange and Fort Jaco, set on a magnificent rear plot of approximately 25 ares, this project consists of a villa with two spacious apartments under construction. The resolutely contemporary architecture is nestled in a quiet, leafy setting.
Duplex Apartment A1 offers a generous surface area of ± 444 m². On the ground floor, it features an entrance hall with cloakroom and private elevator, a guest toilet, a spacious and bright open living area with dual aspect, opening onto a ± 80 m² terrace and a ± 1,300 m² garden, a fully fitted American-style kitchen, a second living room facing a double-sided gas fireplace, a TV room, an office, and a beautiful master suite with dressing room and full bathroom.
On the lower level, accessible via the staircase or private elevator, there are three bedrooms, each with its own bathroom and toilet, a laundry room, a technical room, a garage for three cars, an additional cloakroom, and a cellar.
The access road to the rear plot is shared with a second villa composed of two apartments.
Additional information: Sale subject to 21% VAT. Delivery scheduled for March 2026. Energy rating A. Heat pump. Private elevator. Some images have been modified by AI.
Fort Jaco is well known for its boutiques and shops. A quiet and family-friendly neighborhood, it is located close to the Soignes Forest. It is a pleasant area offering a peaceful and green environment while remaining close to all amenities.
For more information, please contact Bertrand de Moffarts on +32 (0) 475 944 508
[post_title] => Penthouse Fort Jaco
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 6881179-penthouse-fort-jaco
[to_ping] =>
[pinged] =>
[post_modified] => 2026-03-29 10:48:48
[post_modified_gmt] => 2026-03-29 08:48:48
[post_content_filtered] =>
[post_parent] => 78292
[guid] => https://sothebysrealty.be/estates/6881179-penthouse-fort-jaco/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[3] => WP_Post Object
(
[ID] => 75688
[post_author] => 0
[post_date] => 2025-06-25 08:23:49
[post_date_gmt] => 2025-06-25 06:23:49
[post_content] => Located in one of the most coveted areas of Knokke, adjacent to the prestigious Royal Zoute Golf Club, lies this exceptional property.
Originally part of the historic Vieux Moulin estate, this residence offers a rare combination of space, privacy, and exclusivity. The expansive 5,728 m² plot, with an impressive width of 60 meters, presents a unique opportunity in this prime location. A long driveway leads to the villa, perfectly integrated into its lush and tranquil surroundings.
The spacious home features an entrance hall, living room, kitchen, 5 bedrooms, 3 bathrooms, and an integrated garage, offering endless possibilities to adapt the property to your personal style and vision. While the villa is in good condition, a renovation offers the ideal opportunity to blend its existing charm and character with modern luxury and comfort.
This is a rare chance to create a fully customized property that honors its historical value and exceptional location. A place where authenticity and exclusivity come together, set in the unique ambiance of Knokke.
For more information, please contact Kristof Goossens at +32 (0) 495 65 50 50.
[post_title] => Knokke-Heist I West-Flanders
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 6318665-knokke-heist-i-west-flanders
[to_ping] =>
[pinged] =>
[post_modified] => 2026-04-10 15:29:44
[post_modified_gmt] => 2026-04-10 13:29:44
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.be/estates/6318665-west-vlaanderen-i-knokke/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
)
[post_count] => 4
[current_post] => -1
[before_loop] => 1
[in_the_loop] =>
[post] => WP_Post Object
(
[ID] => 88969
[post_author] => 0
[post_date] => 2026-05-11 10:17:14
[post_date_gmt] => 2026-03-10 12:52:06
[post_content] => Located in an elegant neo-eclectic townhouse dating back to 1875, “DE BARON” is a charming bed & breakfast where historic elegance and contemporary comfort blend harmoniously. Over the years, the property has developed a strong identity and presents a unique opportunity in the heart of Antwerp.
The ground floor comprises an entrance hall featuring original 19th-century details, a living room, a bedroom with en-suite bathroom, and an office. The first floor features the breakfast room and a fully equipped kitchen with an adjoining covered terrace/utility room. The second floor offers two bedrooms, each with its own en-suite bathroom. The attic floor includes two additional bedrooms, each with an en-suite bathroom, providing a spacious and functional layout for guest accommodation.
Additional features include: recently renewed roof, air conditioning, alarm system, authentic entrance hall, B&B furnishings included, townhouse, character property.
Situated in a highly accessible urban setting, this property combines a central location with immediate proximity to the train station, public transport, shops, and all city amenities, making it an excellent base for both leisure and business guests.
For more information, please contact Merva Marasligil at +32 (0)484 96 35 94.
[post_title] => Antwerp I City Center
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 7603109-antwerp-i-city-center
[to_ping] =>
[pinged] =>
[post_modified] => 2026-05-11 10:28:55
[post_modified_gmt] => 2026-05-11 08:28:55
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.be/estates/7603109-estate-7603109/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 4
[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] => a56a7bfedda360bf44f9f2b5057c6c18
[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:da4cc7b09b304bac262d9781368cb97c
)
WHERE wpstbys_posts.post_type = 'estates' AND wpstbys_posts.post_status = 'publish' AND EXISTS (
SELECT 1 FROM wpstbys_postmeta pm1
WHERE pm1.post_id = wpstbys_posts.ID
AND pm1.meta_key = 'displaystatusid'
AND pm1.meta_value = '3'
) 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')
)
house
Antwerp
Reference:7603109
house
Flemish Brabant
Reference:7244162
duplex
Penthouse Fort Jaco
Reference:6881179
house
Knokke-Heist
Reference:6318665
Whether you wish to sell, rent or acquire a unique property, entrust us with your vision. Our unparalleled expertise and bespoke service will make all the difference.
Contact usContact
Hello, you can contact our agent Merva Marasligil for free advice at +32 484 96 35 94 or via the form below
Get called
By submitting this form, I agree that Sotheby's can contact me and I accept the Sotheby's privacy policy.
