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')
            )

Private sales

Reset Filters

house

Flemish Brabant

Reference:7677811

Interested in the property ?

Merva Marasligil

house

Watermael-Boitsfort

Reference:7634563

Interested in the property ?

Natalie Van Lerbeirghe

house

Bruges

Reference:7564652

Interested in the property ?

Heidi Stevens

exceptional house

Walloon Brabant

Reference:7211110

Interested in the property ?

Maximilien Indekeu

house

Flemish Brabant

Reference:7244162

Interested in the property ?

Merva Marasligil

duplex

Penthouse Fort Jaco

Reference:6881179

Interested in the property ?

Bertrand de Moffarts

house

Knokke-Heist

Reference:6318665

Interested in the property ?

Kristof Goossens

Your project deserves bespoke attention.

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.