WP_Query Object
(
[query] => Array
(
[post_type] => estates
[post_status] => publish
[posts_per_page] => 17
[paged] => 1
[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] =>
)
)
)
)
[query_vars] => Array
(
[post_type] => estates
[post_status] => publish
[posts_per_page] => 17
[paged] => 1
[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] => suspended-sales_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] => suspended-sales_en
)
[tax_query] => WP_Tax_Query Object
(
[queries] => Array
(
[0] => Array
(
[taxonomy] => estate_status
[terms] => Array
(
[0] => suspended-sales_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] => suspended-sales_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 (2776475)
) 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 0, 17
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 23484
[post_author] => 0
[post_date] => 2025-05-28 08:48:11
[post_date_gmt] => 2025-05-28 06:48:11
[post_content] => This 132 m² riad captivates with its understated elegance, functionality, and prime location in Marrakech's medina.
Centered around a bright patio featuring a decorative pool—perfect for cooling off and enjoying a tranquil setting—the riad offers four beautiful bedrooms, each with a private bathroom. Every space is thoughtfully decorated, blending traditional materials—such as tadelakt, zellige, and carved wood—with contemporary touches to create an authentic yet refined ambiance. The ground floor houses a cozy living room, a dining area, and a fully equipped kitchen. At the same time, the furnished terrace provides a pleasant relaxation space with views over the medina's rooftops. Additionally, the riad boasts close car access—a rare advantage in the medina—facilitating arrivals and departures while ensuring a calm and serene atmosphere.
Additional Features: Titled property, reversible air conditioning, sold furnished, high rental potential, or turnkey secondary residence.
Located in the vibrant and highly sought-after Riad Laarous district, it is appreciated for its proximity to the souks, Dar El Bacha, shops, traditional cafés, and authentic hammams. This area combines local authenticity with easy access, offering the true art of living in the heart of Marrakech.
For more information or to arrange a private viewing, 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] => 6793990-marrakech-i-medina
[to_ping] =>
[pinged] =>
[post_modified] => 2025-07-12 09:00:07
[post_modified_gmt] => 2025-07-12 07:00:07
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.ma/estates/6793990-marrakech-i-medina/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 22037
[post_author] => 0
[post_date] => 2022-04-15 12:20:40
[post_date_gmt] => 2022-04-15 10:20:40
[post_content] => In the front line of the famous Amelkis golf course, this contemporary property of ± 480 m² enjoys a prime location with southern exposure without any onlookers and a breathtaking view of the Atlas Mountains and the lake. The total area of the property is around ± 2.000 m².
Built according to European standards with high-quality materials, this villa is built on 3 levels. The ground floor consists of a large reception area, dining room, double living room, one with a fireplace, an American kitchen, and a master suite of ± 50 m² equipped with an office, a fireplace, a bathroom, and a double dressing room. The first floor has three suites, each with its dressing room and bathroom and a large terrace facing the golf course. The garden is decorated with an infinity pool and a varied landscaped area.
Other: personal accommodation, laundry, service yard, air conditioning and heating, automatic watering, video surveillance, fiber optic, heated swimming pool 12m x 4m.
Amelkis Golf Course is a secure residential area close to the city center and home to a famous 27-hole course.
For more information, please contact David Montérin at +212 6 71 43 72 27.
[post_title] => Marrakech I Amelkis
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 4728050-marrakech-i-amelkis
[to_ping] =>
[pinged] =>
[post_modified] => 2024-12-06 00:06:00
[post_modified_gmt] => 2024-12-05 23:06:00
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.ma/estates/4728050-marrakech-i-amelkis-2/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 21881
[post_author] => 0
[post_date] => 2021-10-01 12:39:40
[post_date_gmt] => 2021-10-01 10:39:40
[post_content] => On a plot of ± 1.5 hectares, this family house with rural charm represents a hotel complex classified as a "guest house," with a surface of ± 650 m².
This property is composed of two buildings with suites and rooms, combining a family house's comfort with various decoration styles and an independent pavilion with a total of ten rooms to accommodate family and friends. The villa consists of a reception room, a restaurant with a fireplace and bar, and a swimming pool of 20 meters long and 6 meters wide collection. This place is a haven of peace, relaxation, and serenity in the quiet of the south countryside of Marrakech. An outdoor reception area with a bar can accommodate more than a hundred people away from the main house.
Others: classification guest house, well-wooded ground.
The Ourika Road leaves Marrakech to the south towards the lush Ourika Valley and the Oukameiden Winter Sports Resort.
For more information, please contact Axel de Sambucy at +212 6 23 36 53 10.
[post_title] => Marrakech I Tamesloht
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 4515668-marrakech-i-tamesloht
[to_ping] =>
[pinged] =>
[post_modified] => 2025-05-24 00:05:53
[post_modified_gmt] => 2025-05-23 22:05:53
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.ma/estates/4515668-marrakech-i-tamesloht-2/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
)
[post_count] => 3
[current_post] => -1
[before_loop] => 1
[in_the_loop] =>
[post] => WP_Post Object
(
[ID] => 23484
[post_author] => 0
[post_date] => 2025-05-28 08:48:11
[post_date_gmt] => 2025-05-28 06:48:11
[post_content] => This 132 m² riad captivates with its understated elegance, functionality, and prime location in Marrakech's medina.
Centered around a bright patio featuring a decorative pool—perfect for cooling off and enjoying a tranquil setting—the riad offers four beautiful bedrooms, each with a private bathroom. Every space is thoughtfully decorated, blending traditional materials—such as tadelakt, zellige, and carved wood—with contemporary touches to create an authentic yet refined ambiance. The ground floor houses a cozy living room, a dining area, and a fully equipped kitchen. At the same time, the furnished terrace provides a pleasant relaxation space with views over the medina's rooftops. Additionally, the riad boasts close car access—a rare advantage in the medina—facilitating arrivals and departures while ensuring a calm and serene atmosphere.
Additional Features: Titled property, reversible air conditioning, sold furnished, high rental potential, or turnkey secondary residence.
Located in the vibrant and highly sought-after Riad Laarous district, it is appreciated for its proximity to the souks, Dar El Bacha, shops, traditional cafés, and authentic hammams. This area combines local authenticity with easy access, offering the true art of living in the heart of Marrakech.
For more information or to arrange a private viewing, 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] => 6793990-marrakech-i-medina
[to_ping] =>
[pinged] =>
[post_modified] => 2025-07-12 09:00:07
[post_modified_gmt] => 2025-07-12 07:00:07
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.ma/estates/6793990-marrakech-i-medina/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 3
[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] => 1
[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] => a3e16b46c55fa97512b7370cffb90095
[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:bc0aa040ba16afea9f04f0050cf80d7a:0.68135200 17523055800.73386100 1752305580
)
Let's get to know each other
Tell us about your project, we’ll take care of the rest.