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] => retire-v-_fr
)
)
)
)
[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] => retire-v-_fr
)
)
)
[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] => retire-v-_fr
)
[tax_query] => WP_Tax_Query Object
(
[queries] => Array
(
[0] => Array
(
[taxonomy] => estate_status
[terms] => Array
(
[0] => retire-v-_fr
)
[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] => retire-v-_fr
)
[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 (5134569)
) 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 ( 5 )
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] => 21838
[post_author] => 0
[post_date] => 2023-07-10 15:39:13
[post_date_gmt] => 2023-07-10 13:39:13
[post_content] => Situé en plein cœur de Gueliz proche du centre commercial Carre Eden et à proximité de l'école française Victor Hugo , cet appartement s'étale sur ± 270 m² habitable et bénéficie d'une terrasse de ± 80 m².
Élégance et raffinement sont les maîtres-mots caractérisant la décoration minutieusement étudiée de cet appartement. Il a été entièrement refait à neuf dans les normes. Les matériaux et les finitions sont de très haute qualité. Le mobilier a été importé et il est de bonne facture. L'appartement dispose de trois chambre, d'une cuisine entièrement équipée avec de nombreux rangements avec chambre de personnel, une chambre principale avec salle de bain et un vaste dressing donnant sur la terrasse, et deux autres chambres avec dressing et une salle de bain invité, salle a manger et deux grands salons.
Autres: Quartier très calme, et 2 place de parking en sous-sol, emplacement centrale.
Le quartier Gueliz est un quartier centrale, il héberge plusieurs marques et centre commerciaux . C'est un quartier touristique, commercial et résidentiel qui bénéficie de toutes les commodités à deux pas du centre ville.
Pour plus d’informations, veuillez contacter Abdelhadi Laaouina au + 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-3/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 21922
[post_author] => 0
[post_date] => 2021-11-09 10:28:59
[post_date_gmt] => 2021-11-09 09:28:59
[post_content] => Caché en plein coeur historique de l'hivernage à deux pas du Sofitel, ce duplex familial développe une surface totale de ± 560 m² dont ± 220 m² habitables donnant sur un exceptionnel jardin d'angle arboré.
Entièrement à réaménager, son plan offre de multiples possibilités d’aménagement grâce notamment à son grand jardin où l'on peut créer une piscine, ses deux entrées indépendantes et son volume habitable facilement modifiable. Aujourd’hui, le niveau du rez-de-jardin se compose d'un hall d'entrée, de trois salons et d'une cuisine. Le niveau supérieur dessert la chambre parentale avec sa salle de bain et son dressing ainsi que deux chambres avec une salle de bain commune. Son côté « campagne à Marrakech », avec le calme absolu et l’absence de vis à vis confère à ce lieu une atmosphère unique à l'hivernage.
Autres: Place de parking au sous-sol.
L'hivernage est un quartier résidentiel chic et calme abritant les plus beaux palaces, les meilleurs restaurants, les casinos et discothèques.
Pour plus d'informations, veuillez contacter David Montérin au +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-3/
[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] => 21838
[post_author] => 0
[post_date] => 2023-07-10 15:39:13
[post_date_gmt] => 2023-07-10 13:39:13
[post_content] => Situé en plein cœur de Gueliz proche du centre commercial Carre Eden et à proximité de l'école française Victor Hugo , cet appartement s'étale sur ± 270 m² habitable et bénéficie d'une terrasse de ± 80 m².
Élégance et raffinement sont les maîtres-mots caractérisant la décoration minutieusement étudiée de cet appartement. Il a été entièrement refait à neuf dans les normes. Les matériaux et les finitions sont de très haute qualité. Le mobilier a été importé et il est de bonne facture. L'appartement dispose de trois chambre, d'une cuisine entièrement équipée avec de nombreux rangements avec chambre de personnel, une chambre principale avec salle de bain et un vaste dressing donnant sur la terrasse, et deux autres chambres avec dressing et une salle de bain invité, salle a manger et deux grands salons.
Autres: Quartier très calme, et 2 place de parking en sous-sol, emplacement centrale.
Le quartier Gueliz est un quartier centrale, il héberge plusieurs marques et centre commerciaux . C'est un quartier touristique, commercial et résidentiel qui bénéficie de toutes les commodités à deux pas du centre ville.
Pour plus d’informations, veuillez contacter Abdelhadi Laaouina au + 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-3/
[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] => 026471ba6f798516b7297c91cf2d79c0
[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:51eb48db127126ec76dc6faf50db403c:0.11852700 17523026540.15666700 1752302654
)
