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] => 86876
[1] => 86733
[2] => 86746
[3] => 86951
[4] => 86753
[5] => 86745
[6] => 86816
[7] => 86756
)
[orderby] => post__in
[posts_per_page] => 17
)
[query_vars] => Array
(
[post_type] => estates
[post_status] => publish
[post__in] => Array
(
[0] => 86876
[1] => 86733
[2] => 86746
[3] => 86951
[4] => 86753
[5] => 86745
[6] => 86816
[7] => 86756
)
[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 (86733,86745,86746,86753,86756,86816,86876,86951) 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,86876,86733,86746,86951,86753,86745,86816,86756)
LIMIT 0, 17
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 86876
[post_author] => 1
[post_date] => 2024-07-17 12:16:31
[post_date_gmt] => 2024-07-17 10:16:31
[post_content] => This property which only asks to be reborn (renovation and total or partial demolition) is implanted on a constructible plot of 28 ares 95 centiares which is to be added to 3 other plots of land of which two in agricultural zone and one in forest zone. The whole property benefits from a land of 4 hectares 68 ares 50 centiares ; this environment offers a privacity and an exceptional view on the country valleys.
The architect Nicolas Devuyst was invited to elaborate a new project of almost 1000 m² extra-muros which was accepted by the municipality of Lasne. The project can be consulted on request at the agency (construction under the VAT regime of 6%).
Both close to Brussels and at the quiet of the countryside, Lasne offers a quality of life without any comparison. With its valleys, forests, meadows and small shops, the town also offers many schools, which makes it ideal for a family life.
For further information and visits, please contact our office in Walloon Brabant on +32 (2) 898.09.40.
[post_title] => Walloon Brabant I Lasne Chapelle
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 4981241-walloon-brabant-i-lasne-chapelle
[to_ping] =>
[pinged] =>
[post_modified] => 2026-06-15 15:28:48
[post_modified_gmt] => 2026-06-15 13:28:48
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.be/estates/4981241-walloon-brabant-i-lasne-chapelle/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 86733
[post_author] => 1
[post_date] => 2024-05-13 11:59:08
[post_date_gmt] => 2024-05-13 09:59:08
[post_content] => Manor-style property with contemporary finishes located on the border of Uccle and Rhode-Saint-Genèse, built in 1907 and extensively renovated by Esther Gutmer.
It has a gross floor area of approx. 630 m² on 6700m² of ideally oriented wooded grounds designed by architect Wirtz. The reception rooms comprise a living room with an open fire, a dining room and a fitted kitchen in brushed aluminium, plus a vast study with a lounge/library area. On the 1st floor, a parental area featuring a bedroom, lounge, dressing room and bathroom designed by Andrée Putman, as well as another bedroom with en suite bathroom and terrace. On the 2nd floor, 2 bedrooms share a bathroom. In the 1st annex, a service flat (studio) and independent laundry room. In the 2nd annex, a fitness room and an office. Facing the street, a caretaker's lodge with lounge/dining room, kitchen and two bedrooms. A heated garage for collectors (7 cars).
Other features: outdoor infinity pool with solar shutter, wellness area, tennis court, garden lighting, alarm, wine cellar, boiler room, swimming pool technical cellar and storage cellar.
Between Uccle and Rhode Saint Genèse, La Petite Espinette is an excellent compromise between the peace and quiet of the forest and the proximity of many shops, transport and restaurants.
For further information, please contact Corinne Thumelaire on + 32 498 23 79 35.
[post_title] => Rhode-Saint-Genèse I Petite Espinette
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 5991861-rhode-saint-genese-i-petite-espinette
[to_ping] =>
[pinged] =>
[post_modified] => 2026-04-10 15:29:47
[post_modified_gmt] => 2026-04-10 13:29:47
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.be/estates/5991861-rhode-saint-genese-i-petite-espinette/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 86746
[post_author] => 1
[post_date] => 2024-05-10 18:28:20
[post_date_gmt] => 2024-05-10 16:28:20
[post_content] => Eclectic style castle dating from 1890 located in a magnificent private domain of ±19 ha with landscaped park including a large pond, woods and meadows. Privacy and tranquility are guaranteed here.
The castle has a living area of ± 680 m² and consists on the ground floor of a spacious entrance hall with a majestic staircase, several living rooms including a large dining room adjoining the living room with fireplace and direct access to the terrace, an office and a kitchen. On the first floor there is the master bedroom with bathroom, dressing room and four bedrooms with bathroom on the mezzanine. The second floor can be fully furnished as a multipurpose space or additional bedrooms.
The estate also includes four other houses which are also accessible via other entrances.
For more information, please contact our office on +32 3 647 30 72.
[post_title] => Province of Antwerp I Castle domain
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 5900257-province-of-antwerp-i-castle-domain
[to_ping] =>
[pinged] =>
[post_modified] => 2026-04-10 15:29:47
[post_modified_gmt] => 2026-04-10 13:29:47
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.be/estates/5900257-province-of-antwerp-i-castle-domain/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[3] => WP_Post Object
(
[ID] => 86951
[post_author] => 1
[post_date] => 2024-05-10 15:10:20
[post_date_gmt] => 2024-05-10 13:10:20
[post_content] => In one of the most sought-after areas of Brussels, magnificent villa with outbuildings built in 1955 by architect Jean Dumont and construction company Louis de Waele, offering a gross floor area of approx. 615 m² on a south-west-facing plot of approx. 45 ares with no overlooked neighbours and a swimming pool.
The villa has been technically refurbished (Reynaerts windows, electricity and heating) and the interiors have yet to be finished. It offers great potential. On the ground floor, the hall with cloakroom and guests' toilet leads to the receptions comprising a lounge with open fireplace, a bar, an study or TV room, a dining room with adjoining kitchen. A bedroom/studio with kitchenette completes the ensemble. The 1st floor offers a large master suite with lounge, dressing room and bathroom, another bedroom with en suite bathroom and a small bedroom. Possibility of a 4th bedroom with shower room. A heated swimming pool with poolhouse, an orchard and a rear house of approx. 140 m² (garage/summer cookery/studio) complete this property.
Other features: underfloor heating, cellars (including wine cellar), boiler room, 2-car garage + 3-car garage or possibility of a caretaker's office.
The Errera district is located in the heart of Uccle, with easy access to shops, public transport and not far from the Bois de la Cambre.
If you have any further questions, please contact Corinne Thumelaire on + 32 (0) 498 23 79 35.
[post_title] => Uccle I Errera
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 3753787-uccle-i-errera
[to_ping] =>
[pinged] =>
[post_modified] => 2026-04-10 15:29:47
[post_modified_gmt] => 2026-04-10 13:29:47
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.be/estates/3753787-uccle-i-errera/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[4] => WP_Post Object
(
[ID] => 86753
[post_author] => 1
[post_date] => 2024-04-30 15:11:24
[post_date_gmt] => 2024-04-30 13:11:24
[post_content] => This exceptional loft of approximately 310 m² is located on the Kanaal site by Axel Vervoordt, on the 8th floor of the iconic Silo building, and was designed by renowned architect Stéphane Beel. It perfectly combines contemporary design with refined urban elegance.
The apartment comprises an entrance hall, cloakroom, and guest toilet. A spacious and luminous living room with the potential to create an open-plan kitchen extends across the full width of the apartment. From this space, you have access to a sunny terrace with a covering. On the other side of the apartment are the bedrooms. The master suite includes a bedroom with a bathroom and dressing room. The second bedroom also has an en-suite bathroom. The apartment features a separate laundry room and ample storage space. Both the living area and bedrooms offer panoramic views.
Other: features include a separate storage room and 2 parking spaces within the building; the images combine real photographs and digital renderings for illustrative purposes.
Living in this unique loft not only promises an extraordinary living experience but also a lifestyle synonymous with refinement and comfort. The site houses galleries, offices, and a restaurant. Moreover, this location is easily accessible from various major roads.
For more information and a viewing, please contact Merva Marasligil on +32 (0) 484 96 35 94.
[post_title] => Antwerp I Wijnegem
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 5756359-antwerp-i-wijnegem
[to_ping] =>
[pinged] =>
[post_modified] => 2026-04-20 13:38:58
[post_modified_gmt] => 2026-04-20 11:38:58
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.be/estates/5756359-antwerp-i-wijnegem/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[5] => WP_Post Object
(
[ID] => 86745
[post_author] => 1
[post_date] => 2024-04-18 11:49:36
[post_date_gmt] => 2024-04-18 09:49:36
[post_content] => The "Kasteel van Velm", located in the middle of the Haspengouw landscape, dates from the 18th century. The castle with appurtenances, in classicist style, comprises ± 3,000 m² of living space and is located in a unique domain with ± 6.5 ha, partly park and partly forest.
The spacious entrance hall gives this castle a special cachet and is a perfect reception room where receptions can also be held. Then you have access to the office and the impressive staircase that leads you to the different floors with various lounges and private rooms. In addition, the part that today serves as a language center has several classrooms, a professional kitchen, dining room and many rooms for guests on the floors. At the rear of the main building is the chapel that can serve as a multi-purpose space. The large park garden with its century-old trees makes you dream away and here you can enjoy privacy and tranquility. Ideal as a wellness center, training center, coaching, seminars, hotel, etc.
Other: outdoor pool, parking, outbuildings.
Well situated near the highway E40 Liège (30 km) - Brussels (70 km) and Maastricht is 25 minutes away, all this in a unique place with authentic fauna and flora in the heart of Haspengouw.
For more information, please contact Kristof Goossens on +32 495 65 50 50.
[post_title] => Limburg I Kasteel van Velm
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 5900296-limburg-i-kasteel-van-velm
[to_ping] =>
[pinged] =>
[post_modified] => 2026-04-10 15:29:47
[post_modified_gmt] => 2026-04-10 13:29:47
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.be/estates/5900296-limburg-i-kasteel-van-velm/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[6] => WP_Post Object
(
[ID] => 86816
[post_author] => 1
[post_date] => 2024-03-08 09:13:34
[post_date_gmt] => 2024-03-08 08:13:34
[post_content] => Located close to the Abbaye de la Cambre on the Avenue Franklin Roosevelt, renovated house and rear house for lovers of character and beautiful materials of a gross surface area of around 700 m².
Atypical, it offers large through receptions, a beautiful fitted kitchen, four bedrooms with their private bathrooms and cupboards. On the ground floor there is an office, an ideal set for a liberal profession or separate apartment (bedroom, shower, small kitchen). The rear house, connected to the main house by a pleasant Italian courtyard and by a corridor, offers a double garage and a duplex service apartment.
Other: numerous cellars and two parking spaces in front of the house.
The Abbaye de la Cambre district is a magnificent typical Brussels district, surrounded by local shops. It offers easy access to public transport. It is located not far from the city center and Avenue Louise.
For further information, please contact Bertrand de Moffarts on + 32 (0) 475 944 508.
[post_title] => Ixelles I La Cambre Abbey
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 5496798-ixelles-i-la-cambre-abbey
[to_ping] =>
[pinged] =>
[post_modified] => 2026-04-13 13:25:20
[post_modified_gmt] => 2026-04-13 11:25:20
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.be/estates/5496798-ixelles-i-la-cambre-abbey/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[7] => WP_Post Object
(
[ID] => 86756
[post_author] => 1
[post_date] => 2024-01-15 15:39:44
[post_date_gmt] => 2024-01-15 14:39:44
[post_content] => In the heart of Brussels, near the Parc Royal, completely renovated triplex of around 550 m² gross surface area in a mansion mixing space, elegance and modernism.
The three different entrances will be ideal for the combination of a liberal profession, prestigious apartment and service. On the ground floor, the entrance hall leads to a large office, a technical data room, a bedroom with bathroom and access to the basements (± 130 m²) composed of a gym, shower room (possibility of hammam), boiler room, wine cellar and plenty of storage. On the mezzanine, large bedroom with dressing room, bathroom and separate entrance. On the first floor, majestic receptions (ceiling height of 4.50m) including living and dining room, open fire with ethanol, Bulthaup kitchen with central island offering a view of the Congress column, cloakroom and boudoir lounge. The second floor includes a mezzanine living room, master bedroom with large dressing room and bathroom, two other bedrooms with dressing room and adjoining shower rooms.
Other : Alarm, electricity compliant with data system at all levels, videophone, individual boiler, wine cellar, 4 optional parking spaces at 30,000 € per unit.
The Parc Royal district is surrounded by parks, museums and restaurants. It is the site of many cultural and traditional events.
For any further information, please contact Corinne Thumelaire + 32 (0) 498 23 79 35.
[post_title] => Brussels I Royal Neighbourhood
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 5727382-brussels-i-royal-neighbourhood
[to_ping] =>
[pinged] =>
[post_modified] => 2026-04-10 15:29:48
[post_modified_gmt] => 2026-04-10 13:29:48
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.be/estates/5727382-brussels-i-royal-neighbourhood/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
)
[post_count] => 8
[current_post] => -1
[before_loop] => 1
[in_the_loop] =>
[post] => WP_Post Object
(
[ID] => 86876
[post_author] => 1
[post_date] => 2024-07-17 12:16:31
[post_date_gmt] => 2024-07-17 10:16:31
[post_content] => This property which only asks to be reborn (renovation and total or partial demolition) is implanted on a constructible plot of 28 ares 95 centiares which is to be added to 3 other plots of land of which two in agricultural zone and one in forest zone. The whole property benefits from a land of 4 hectares 68 ares 50 centiares ; this environment offers a privacity and an exceptional view on the country valleys.
The architect Nicolas Devuyst was invited to elaborate a new project of almost 1000 m² extra-muros which was accepted by the municipality of Lasne. The project can be consulted on request at the agency (construction under the VAT regime of 6%).
Both close to Brussels and at the quiet of the countryside, Lasne offers a quality of life without any comparison. With its valleys, forests, meadows and small shops, the town also offers many schools, which makes it ideal for a family life.
For further information and visits, please contact our office in Walloon Brabant on +32 (2) 898.09.40.
[post_title] => Walloon Brabant I Lasne Chapelle
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 4981241-walloon-brabant-i-lasne-chapelle
[to_ping] =>
[pinged] =>
[post_modified] => 2026-06-15 15:28:48
[post_modified_gmt] => 2026-06-15 13:28:48
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.be/estates/4981241-walloon-brabant-i-lasne-chapelle/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 178
[max_num_pages] => 11
[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] => fe7eef718f95e78ebd142ee444ed4422
[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:21120ce85db2c723bf65e83495e061b3
)
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')
)
1
114
18,388
92
86
By submitting this form, I agree that Sotheby's can contact me and I accept the Sotheby's privacy policy.