WP_Query Object
(
    [query] => Array
        (
            [post_type] => estates
            [post_status] => publish
            [posts_per_page] => 17
            [paged] => 8
            [meta_query] => Array
                (
                    [relation] => AND
                    [0] => Array
                        (
                            [key] => offsale
                            [value] => yes
                            [compare] => !=
                        )

                    [1] => Array
                        (
                            [key] => canhavechildren
                            [value] => 1
                            [compare] => !=
                        )

                    [2] => Array
                        (
                            [relation] => OR
                            [0] => Array
                                (
                                    [key] => price
                                    [value] => 300000
                                    [type] => NUMERIC
                                    [compare] => >=
                                )

                            [1] => Array
                                (
                                    [key] => price
                                    [compare] => NOT EXISTS
                                )

                        )

                )

            [orderby] => date
            [order] => DESC
            [post_parent] => 0
            [tax_query] => Array
                (
                    [0] => Array
                        (
                            [taxonomy] => estate_status
                            [field] => slug
                            [terms] => Array
                                (
                                    [0] => for-sale_en
                                    [1] => draft-contract_en
                                )

                        )

                )

        )

    [query_vars] => Array
        (
            [post_type] => estates
            [post_status] => publish
            [posts_per_page] => 17
            [paged] => 8
            [meta_query] => Array
                (
                    [relation] => AND
                    [0] => Array
                        (
                            [key] => offsale
                            [value] => yes
                            [compare] => !=
                        )

                    [1] => Array
                        (
                            [key] => canhavechildren
                            [value] => 1
                            [compare] => !=
                        )

                    [2] => Array
                        (
                            [relation] => OR
                            [0] => Array
                                (
                                    [key] => price
                                    [value] => 300000
                                    [type] => NUMERIC
                                    [compare] => >=
                                )

                            [1] => Array
                                (
                                    [key] => price
                                    [compare] => NOT EXISTS
                                )

                        )

                    [3] => Array
                        (
                            [key] => offsale
                            [value] => yes
                            [compare] => !=
                        )

                )

            [orderby] => date
            [order] => DESC
            [post_parent] => 0
            [tax_query] => Array
                (
                    [0] => Array
                        (
                            [taxonomy] => estate_status
                            [field] => slug
                            [terms] => Array
                                (
                                    [0] => for-sale_en
                                    [1] => draft-contract_en
                                )

                        )

                )

            [error] => 
            [m] => 
            [p] => 0
            [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] => 
            [meta_key] => 
            [meta_value] => 
            [preview] => 
            [s] => 
            [sentence] => 
            [title] => 
            [fields] => all
            [menu_order] => 
            [embed] => 
            [category__in] => Array
                (
                )

            [category__not_in] => Array
                (
                )

            [category__and] => Array
                (
                )

            [post__in] => 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
                (
                )

            [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] => estate_status
            [term] => for-sale_en
        )

    [tax_query] => WP_Tax_Query Object
        (
            [queries] => Array
                (
                    [0] => Array
                        (
                            [taxonomy] => estate_status
                            [terms] => Array
                                (
                                    [0] => for-sale_en
                                    [1] => draft-contract_en
                                )

                            [field] => slug
                            [operator] => IN
                            [include_children] => 1
                        )

                )

            [relation] => AND
            [table_aliases:protected] => Array
                (
                    [0] => wpstbys_term_relationships
                )

            [queried_terms] => Array
                (
                    [estate_status] => Array
                        (
                            [terms] => Array
                                (
                                    [0] => for-sale_en
                                    [1] => draft-contract_en
                                )

                            [field] => slug
                        )

                )

            [primary_table] => wpstbys_posts
            [primary_id_column] => ID
        )

    [meta_query] => WP_Meta_Query Object
        (
            [queries] => Array
                (
                    [0] => Array
                        (
                            [key] => offsale
                            [value] => yes
                            [compare] => !=
                        )

                    [1] => Array
                        (
                            [key] => canhavechildren
                            [value] => 1
                            [compare] => !=
                        )

                    [2] => Array
                        (
                            [0] => Array
                                (
                                    [key] => price
                                    [value] => 300000
                                    [type] => NUMERIC
                                    [compare] => >=
                                )

                            [1] => Array
                                (
                                    [key] => price
                                    [compare] => NOT EXISTS
                                )

                            [relation] => OR
                        )

                    [3] => Array
                        (
                            [key] => offsale
                            [value] => yes
                            [compare] => !=
                        )

                    [relation] => AND
                )

            [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
                    [1] => mt1
                    [2] => mt2
                    [3] => mt3
                )

            [clauses:protected] => Array
                (
                    [wpstbys_postmeta] => Array
                        (
                            [key] => offsale
                            [value] => yes
                            [compare] => !=
                            [compare_key] => =
                            [alias] => wpstbys_postmeta
                            [cast] => CHAR
                        )

                    [mt1] => Array
                        (
                            [key] => canhavechildren
                            [value] => 1
                            [compare] => !=
                            [compare_key] => =
                            [alias] => mt1
                            [cast] => CHAR
                        )

                    [mt2] => Array
                        (
                            [key] => price
                            [value] => 300000
                            [type] => NUMERIC
                            [compare] => >=
                            [compare_key] => =
                            [alias] => mt2
                            [cast] => SIGNED
                        )

                    [mt3] => Array
                        (
                            [key] => price
                            [compare] => NOT EXISTS
                            [compare_key] => =
                            [alias] => mt3
                            [cast] => CHAR
                        )

                    [wpstbys_postmeta-1] => Array
                        (
                            [key] => offsale
                            [value] => yes
                            [compare] => !=
                            [compare_key] => =
                            [alias] => wpstbys_postmeta
                            [cast] => CHAR
                        )

                )

            [has_or_relation:protected] => 1
        )

    [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) LEFT JOIN wpstbys_postmeta ON ( wpstbys_posts.ID = wpstbys_postmeta.post_id )  LEFT JOIN wpstbys_postmeta AS mt1 ON ( wpstbys_posts.ID = mt1.post_id )  LEFT JOIN wpstbys_postmeta AS mt2 ON ( wpstbys_posts.ID = mt2.post_id )  LEFT JOIN wpstbys_postmeta AS mt3 ON ( wpstbys_posts.ID = mt3.post_id AND mt3.meta_key = 'price' ) INNER JOIN wpstbys_term_relationships AS pll_tr ON pll_tr.object_id = wpstbys_posts.ID
					 WHERE 1=1  AND wpstbys_posts.post_parent = 0  AND ( 
  wpstbys_term_relationships.term_taxonomy_id IN (1796780,359428)
) AND ( 
  ( wpstbys_postmeta.meta_key = 'offsale' AND wpstbys_postmeta.meta_value != 'yes' ) 
  AND 
  ( mt1.meta_key = 'canhavechildren' AND mt1.meta_value != '1' ) 
  AND 
  ( 
    ( mt2.meta_key = 'price' AND CAST(mt2.meta_value AS SIGNED) >= '300000' ) 
    OR 
    mt3.post_id IS NULL
  ) 
  AND 
  ( wpstbys_postmeta.meta_key = 'offsale' AND wpstbys_postmeta.meta_value != 'yes' )
) 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 wpstbys_posts.menu_order, wpstbys_posts.post_date DESC
					 LIMIT 119, 17
    [posts] => Array
        (
            [0] => WP_Post Object
                (
                    [ID] => 21871
                    [post_author] => 0
                    [post_date] => 2021-11-26 09:25:05
                    [post_date_gmt] => 2021-11-26 08:25:05
                    [post_content] => Road to Amizmiz, about fifteen minutes from the city center, this villa of ± 500 m², is located on a plot of more than ± 2.000 m², on the front line of the Samanah golf course.

This villa is composed on the ground floor of an entrance hall, a kitchen, a bedroom, and a spacious living room with a fireplace offering stunning views of the lakes, the golf course, and the Atlas Mountains. The atmosphere is pleasant thanks to the large windows that provide a beautiful brightness inside and allows you to take full advantage of the garden and pool. The first floor of this house has four bedrooms, including a master suite, all equipped with dressing rooms and bathrooms. This house was constructed only with the highest quality materials.

Other: two-car garage, air conditioning, aluminum joinery with double glazing.

The Samanah Golf Course has a Club House with a restaurant and an international class course built on nearly 100 hectares with 18 holes, of 72, 6,700 meters long, and this is the only golf course designed by Jack Nicklaus in Morocco. This residential golf course is located just fifteen minutes from Marrakech Airport.

For more information, please contact David Montérin at +212 6 71 43 72 27. [post_title] => Marrakech I Route d'Amizmiz [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => 4574061-marrakech-i-route-damizmiz [to_ping] => [pinged] => [post_modified] => 2025-04-29 09:04:12 [post_modified_gmt] => 2025-04-29 07:04:12 [post_content_filtered] => [post_parent] => 0 [guid] => https://sothebysrealty.ma/estates/4574061-marrakech-i-route-damizmiz-2/ [menu_order] => 0 [post_type] => estates [post_mime_type] => [comment_count] => 0 [filter] => raw ) [1] => WP_Post Object ( [ID] => 21953 [post_author] => 0 [post_date] => 2021-11-19 13:27:53 [post_date_gmt] => 2021-11-19 12:27:53 [post_content] => Located in the Bab Atlas district of the Palmeraie, this contemporary villa of ± 950 m² is built on a park of half a hectare and enjoys a breathtaking view of the Atlas mountains.

A cathedral entrance hall located in the main part of the house leads to the reception rooms. The two living rooms and the dining room extend onto two covered terraces and enjoy unobstructed garden views thanks to large windows. The other part consists of five suites on the ground floor; they are all equipped with ensuite bathrooms, a large dressing room, and a private terrace. The villa is fully equipped with underfloor heating, air conditioning, a sound system, and a SPA with hammam, sauna, fitness area. The swimming pool allows for relaxing moments without any onlookers. Only the finest quality materials (marble, solid parquet, etc.) were used in the construction of this outstanding property.

Others: Office, cinema, library, staff accommodation, laundry, reversible air conditioning, fireplace, parking.

La Palmeraie is one of the most popular areas of Marrakech. It covers more than 13,000 hectares and offers more than 150,000 palm trees, and it is peaceful and luxuriant.

For more information, please contact David Montérin at +212 6 71 43 72 27. [post_title] => Marrakech I Palmeraie [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => 4574059-marrakech-i-palmeraie [to_ping] => [pinged] => [post_modified] => 2025-04-29 09:04:26 [post_modified_gmt] => 2025-04-29 07:04:26 [post_content_filtered] => [post_parent] => 0 [guid] => https://sothebysrealty.ma/estates/4574059-marrakech-i-palmeraie-2/ [menu_order] => 0 [post_type] => estates [post_mime_type] => [comment_count] => 0 [filter] => raw ) [2] => WP_Post Object ( [ID] => 21927 [post_author] => 0 [post_date] => 2021-09-17 15:38:28 [post_date_gmt] => 2021-09-17 13:38:28 [post_content] => Located in one of the historic districts of the Medina, this set of ± 1.300 m² on the ground consists of seven riads with 25 bedrooms.

It occupies a living area of ± 2.000 m², with alley access to the large entrance door. The first patio has retained its old woodwork and original decoration, several other patios with different styles generate different ambiances. Beautiful lounges, a dining room, a bar, 25 rooms, and suites with private terraces are all decorated in different styles. In the heart of a large patio, there is a beautiful swimming pool. From the roof terrasse, you will enjoy an impressive view of the Koutoubia and Atlas Mountains in the background. Operated for more than fifteen years, this guest house has forged a reputation for quality and authenticity.

Others: Sought after area, SPA, Hammam, close to the medina.

Authentic and welcoming, El Ksour offers many well-known guest houses. It is ideally located close to Jema al Fna Square, the beating heart of the Medina of Marrakech, and listed as a UNESCO World Heritage Site.

For further information, please contact Abdelhadi Laaouina at +212 6 61 07 49 33. [post_title] => Marrakech I Medina [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => 4444868-marrakech-i-medina [to_ping] => [pinged] => [post_modified] => 2025-04-29 09:02:27 [post_modified_gmt] => 2025-04-29 07:02:27 [post_content_filtered] => [post_parent] => 0 [guid] => https://sothebysrealty.ma/estates/4444868-marrakech-i-medina-2/ [menu_order] => 0 [post_type] => estates [post_mime_type] => [comment_count] => 0 [filter] => raw ) [3] => WP_Post Object ( [ID] => 21925 [post_author] => 0 [post_date] => 2021-09-13 09:25:19 [post_date_gmt] => 2021-09-13 07:25:19 [post_content] => On the outskirts of the palm grove, in the district of Bab Atlas and 15 minutes from the city center, this very contemporary architect's villa of ± 1.000 m² is built on a park of ± one hectare with a breathtaking view of the Atlas Mountains.

As soon as you enter, the magic happens with a view of a Mexican garden made of red gravel and dotted with a few agaves. Behind a huge backlit stone wall is the entrance to the villa with a view of a water basin and the garden. A transverse corridor with geometric shapes serves the entire house, which is mainly organized on one level. The night part comprises six suites all equipped with bathrooms, a dressing room, and a terrace. On the poolside, there is a lounge and a shaded dining area.

Other: Office, Cinema room, Library, Staff quarters, Laundry, Laundry room, Reversible air conditioning, Through fireplace, Parking.

The district of Bab Atlas is the extension of the palm grove which shelters hotels and palaces like the "Namaskar" as well as beautiful residences. Easily accessible from the road to Fez and the road to Casablanca.

For more information, please contact David Montérin at +212 6 71 43 72 27. [post_title] => Marrakech I Palmeraie [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => 4457843-marrakech-i-bab-atlas [to_ping] => [pinged] => [post_modified] => 2025-04-29 09:05:43 [post_modified_gmt] => 2025-04-29 07:05:43 [post_content_filtered] => [post_parent] => 0 [guid] => https://sothebysrealty.ma/estates/4457843-marrakech-i-palmeraie-2/ [menu_order] => 0 [post_type] => estates [post_mime_type] => [comment_count] => 0 [filter] => raw ) [4] => WP_Post Object ( [ID] => 21917 [post_author] => 0 [post_date] => 2021-09-07 11:36:04 [post_date_gmt] => 2021-09-07 09:36:04 [post_content] => South of Marrakech, a palace of ± 2.500 m² and its two guest pavilions nestled on a plot of ± 4 hectares. Embellished by a south-facing park, the property enjoys a breathtaking view of the Atlas mountains.

The main palace is built around a large Andalusian patio surrounded, on the ground floor, by several lounges, a dining room, a kitchen, and a laundry room. Upstairs, five bedrooms and their bathroom, which are accessible by the passageway that encircles the Andalusian patio or by stairs at the four corners of the palace, enjoy a view of the green park. The space is extended in a masterful way by a swimming pool of more than 40 meters. In addition, two charming guest pavilions, located on either side of the ornamental central stream, each offer two bedrooms, a living room, and a bathroom, allowing the occupants to benefit from certain privacy.

Others: accommodation for staff, fitness and wellness area, hammam, spa.

For more information, please contact Franck Le Péculier on +212 6 63 15 92 44. [post_title] => Marrakech I Road of Ourika [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => 4498628-marrakech-i-route-de-lourika [to_ping] => [pinged] => [post_modified] => 2025-04-29 09:01:50 [post_modified_gmt] => 2025-04-29 07:01:50 [post_content_filtered] => [post_parent] => 0 [guid] => https://sothebysrealty.ma/estates/4498628-marrakech-i-route-de-lourika-2/ [menu_order] => 0 [post_type] => estates [post_mime_type] => [comment_count] => 0 [filter] => raw ) [5] => WP_Post Object ( [ID] => 21923 [post_author] => 0 [post_date] => 2021-09-03 18:27:09 [post_date_gmt] => 2021-09-03 16:27:09 [post_content] => Located in the green area of the "Palmeraie", an Andalusian-style palace enjoying a total habitable surface of ± 4.450 m² in a wooded park garden of ± 40.000 m².

The access to the property is via a large door that opens onto an alley from which we gradually discover the impressive dimensions of the palace. At the entrance of the villa, a large reception hall comprises a large living room, an office, and a kitchen. The first floor, accommodates the spa, the hammam, large living areas, and a spacious room that opens onto a large terrace. In the continuity, a patio occupied by a large basin serves six private villas which vary in size between ± 350 and ± 450 m², each villa offers a suite and its bathroom, two living rooms, a dining room, a kitchen, and service rooms. The upper floor offers, a suite and two bedrooms with a bathroom, an office, and a living room overlooking a large terrace. Each villa has its private garden and a swimming pool of 5m x 11m.

Others: three wells, underfloor heating installation in the villas, caretaker housing, ± 12 hectares not built are linked to a second title.

The Palmeraie, which is very popular, covers 13.000 hectares and has 150.000 palm trees. It is an oasis of calm on the outskirts of the city.

For further information, please contact David Montérin at +212 6 71 43 72 27. [post_title] => Marrakech I Palmeraie [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => 4490056-marrakech-i-palmeraie [to_ping] => [pinged] => [post_modified] => 2025-04-29 09:03:55 [post_modified_gmt] => 2025-04-29 07:03:55 [post_content_filtered] => [post_parent] => 0 [guid] => https://sothebysrealty.ma/estates/4490056-marrakech-i-palmeraie-2/ [menu_order] => 0 [post_type] => estates [post_mime_type] => [comment_count] => 0 [filter] => raw ) ) [post_count] => 6 [current_post] => -1 [before_loop] => 1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 21871 [post_author] => 0 [post_date] => 2021-11-26 09:25:05 [post_date_gmt] => 2021-11-26 08:25:05 [post_content] => Road to Amizmiz, about fifteen minutes from the city center, this villa of ± 500 m², is located on a plot of more than ± 2.000 m², on the front line of the Samanah golf course.

This villa is composed on the ground floor of an entrance hall, a kitchen, a bedroom, and a spacious living room with a fireplace offering stunning views of the lakes, the golf course, and the Atlas Mountains. The atmosphere is pleasant thanks to the large windows that provide a beautiful brightness inside and allows you to take full advantage of the garden and pool. The first floor of this house has four bedrooms, including a master suite, all equipped with dressing rooms and bathrooms. This house was constructed only with the highest quality materials.

Other: two-car garage, air conditioning, aluminum joinery with double glazing.

The Samanah Golf Course has a Club House with a restaurant and an international class course built on nearly 100 hectares with 18 holes, of 72, 6,700 meters long, and this is the only golf course designed by Jack Nicklaus in Morocco. This residential golf course is located just fifteen minutes from Marrakech Airport.

For more information, please contact David Montérin at +212 6 71 43 72 27. [post_title] => Marrakech I Route d'Amizmiz [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => 4574061-marrakech-i-route-damizmiz [to_ping] => [pinged] => [post_modified] => 2025-04-29 09:04:12 [post_modified_gmt] => 2025-04-29 07:04:12 [post_content_filtered] => [post_parent] => 0 [guid] => https://sothebysrealty.ma/estates/4574061-marrakech-i-route-damizmiz-2/ [menu_order] => 0 [post_type] => estates [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 125 [max_num_pages] => 8 [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] => 1 [is_search] => [is_feed] => [is_comment_feed] => [is_trackback] => [is_home] => [is_privacy_policy] => [is_404] => [is_embed] => [is_paged] => 1 [is_admin] => [is_attachment] => [is_singular] => [is_robots] => [is_favicon] => [is_posts_page] => [is_post_type_archive] => 1 [query_vars_hash:WP_Query:private] => de877ce8caf060997226542617b370ad [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:a204b26a2913186f9d24310b9a9b7b83:0.74506300 17459173790.76140400 1745917379 )

Let's get to know each other

Tell us about your project, we’ll take care of the rest.