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] => out-of-sales_en
)
)
)
)
[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] => out-of-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] => out-of-sales_en
)
[tax_query] => WP_Tax_Query Object
(
[queries] => Array
(
[0] => Array
(
[taxonomy] => estate_status
[terms] => Array
(
[0] => out-of-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] => out-of-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 (5134567)
) 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] => 21837
[post_author] => 0
[post_date] => 2023-07-10 15:39:13
[post_date_gmt] => 2023-07-10 13:39:13
[post_content] => Located in the heart of Gueliz near the Carre Eden shopping center and the Victor Hugo French school, this apartment is spread over ± 270 m² of living space and has a terrace of ± 80 m².
Elegance and refinement are the keywords characterizing the meticulously studied decoration of this apartment. It has been completely redone to standards. The materials and finishes are of very high quality. The furniture has been imported and well made. The apartment has three bedrooms, a fully equipped kitchen with plenty of storage space with a staff room, a master bedroom with a bathroom and a large dressing room overlooking the terrace, and two other bedrooms with a dressing room and a guest bathroom, dining room, and two large living rooms.
Others: Tranquil area, two parking spaces in the basement, central location.
The Gueliz district is central; it houses several brands and shopping centers. It is a tourist, commercial, and residential area that benefits from all amenities close to the city center.
For more information, don't hesitate to contact Abdelhadi Laaouina at + 212 6 61 07 49 33.
[post_title] => Marrakech I Gueliz
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 5391512-marrakech-i-gueliz
[to_ping] =>
[pinged] =>
[post_modified] => 2025-07-12 06:04:29
[post_modified_gmt] => 2025-07-12 04:04:29
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.ma/estates/5391512-marrakech-i-gueliz-2/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 21921
[post_author] => 0
[post_date] => 2021-11-09 10:28:59
[post_date_gmt] => 2021-11-09 09:28:59
[post_content] => Hidden in the heart of Hivernage just a few minutes away from the Sofitel, this family duplex has a total surface area of ± 560 m² including ± 220 m² of living area overlooking an exceptional garden.
The two independent entrances, the large living area, and the wide garden offer several redevelopment opportunities. The garden level consists of an entrance hall, three living rooms, and a kitchen. The upper level serves the master bedroom with its bathroom and dressing room as well as two bedrooms with a shared bathroom. The «countryside of Marrakech», with the absolute calm and no vis-à-vis gives this place a unique and lovely atmosphere.
Others: Parking space in the basement.
Hivernage is a chic and quiet residential area housing the most beautiful palaces, the best restaurants, casinos, and nightclubs.
For more information, please contact David Montérin on +212 6 71 43 72 27.
[post_title] => Marrakech I Hivernage
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 4498625-marrakech-i-hivernage
[to_ping] =>
[pinged] =>
[post_modified] => 2025-07-12 06:04:09
[post_modified_gmt] => 2025-07-12 04:04:09
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.ma/estates/4498625-marrakech-i-hivernage-2/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
)
[post_count] => 2
[current_post] => -1
[before_loop] => 1
[in_the_loop] =>
[post] => WP_Post Object
(
[ID] => 21837
[post_author] => 0
[post_date] => 2023-07-10 15:39:13
[post_date_gmt] => 2023-07-10 13:39:13
[post_content] => Located in the heart of Gueliz near the Carre Eden shopping center and the Victor Hugo French school, this apartment is spread over ± 270 m² of living space and has a terrace of ± 80 m².
Elegance and refinement are the keywords characterizing the meticulously studied decoration of this apartment. It has been completely redone to standards. The materials and finishes are of very high quality. The furniture has been imported and well made. The apartment has three bedrooms, a fully equipped kitchen with plenty of storage space with a staff room, a master bedroom with a bathroom and a large dressing room overlooking the terrace, and two other bedrooms with a dressing room and a guest bathroom, dining room, and two large living rooms.
Others: Tranquil area, two parking spaces in the basement, central location.
The Gueliz district is central; it houses several brands and shopping centers. It is a tourist, commercial, and residential area that benefits from all amenities close to the city center.
For more information, don't hesitate to contact Abdelhadi Laaouina at + 212 6 61 07 49 33.
[post_title] => Marrakech I Gueliz
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 5391512-marrakech-i-gueliz
[to_ping] =>
[pinged] =>
[post_modified] => 2025-07-12 06:04:29
[post_modified_gmt] => 2025-07-12 04:04:29
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.ma/estates/5391512-marrakech-i-gueliz-2/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 2
[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] => 4459dfc15ae8a53b7b5eb90655c7d31c
[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:5a56fab2634b8f8ddb02733af7710cf2:0.17495100 17523014960.19390600 1752301496
)
Let's get to know each other
Tell us about your project, we’ll take care of the rest.