Ocampo Realtors


1

Renta: $4,500/mes


Departamento tipo estudio cerca de Altabrisa, Mérida, Yuc.

  • Departamento
  • 1 baños completo
  • Aire acondicionado
  • Sistema de entrada de seguridad
object(WP_Query)#6175 (55) {
  ["query"]=>
  array(3) {
    ["post_type"]=>
    string(9) "propiedad"
    ["posts_per_page"]=>
    string(2) "-1"
    ["tax_query"]=>
    array(2) {
      [0]=>
      array(3) {
        ["taxonomy"]=>
        string(8) "category"
        ["field"]=>
        string(4) "slug"
        ["terms"]=>
        string(5) "renta"
      }
      [1]=>
      array(3) {
        ["taxonomy"]=>
        string(17) "tipo_de_propiedad"
        ["field"]=>
        string(4) "slug"
        ["terms"]=>
        string(12) "departamento"
      }
    }
  }
  ["query_vars"]=>
  array(68) {
    ["post_type"]=>
    array(16) {
      ["post"]=>
      string(4) "post"
      ["page"]=>
      string(4) "page"
      ["attachment"]=>
      string(10) "attachment"
      ["revision"]=>
      string(8) "revision"
      ["nav_menu_item"]=>
      string(13) "nav_menu_item"
      ["custom_css"]=>
      string(10) "custom_css"
      ["customize_changeset"]=>
      string(19) "customize_changeset"
      ["oembed_cache"]=>
      string(12) "oembed_cache"
      ["user_request"]=>
      string(12) "user_request"
      ["wp_block"]=>
      string(8) "wp_block"
      ["wp_template"]=>
      string(11) "wp_template"
      ["wp_template_part"]=>
      string(16) "wp_template_part"
      ["wp_global_styles"]=>
      string(16) "wp_global_styles"
      ["wp_navigation"]=>
      string(13) "wp_navigation"
      ["coblocks_pattern"]=>
      string(16) "coblocks_pattern"
      ["propiedad"]=>
      string(9) "propiedad"
    }
    ["posts_per_page"]=>
    int(-1)
    ["tax_query"]=>
    array(2) {
      [0]=>
      array(3) {
        ["taxonomy"]=>
        string(8) "category"
        ["field"]=>
        string(4) "slug"
        ["terms"]=>
        string(5) "renta"
      }
      [1]=>
      array(3) {
        ["taxonomy"]=>
        string(17) "tipo_de_propiedad"
        ["field"]=>
        string(4) "slug"
        ["terms"]=>
        string(12) "departamento"
      }
    }
    ["error"]=>
    string(0) ""
    ["m"]=>
    string(0) ""
    ["p"]=>
    int(0)
    ["post_parent"]=>
    string(0) ""
    ["subpost"]=>
    string(0) ""
    ["subpost_id"]=>
    string(0) ""
    ["attachment"]=>
    string(0) ""
    ["attachment_id"]=>
    int(0)
    ["name"]=>
    string(0) ""
    ["pagename"]=>
    string(0) ""
    ["page_id"]=>
    int(0)
    ["second"]=>
    string(0) ""
    ["minute"]=>
    string(0) ""
    ["hour"]=>
    string(0) ""
    ["day"]=>
    int(0)
    ["monthnum"]=>
    int(0)
    ["year"]=>
    int(0)
    ["w"]=>
    int(0)
    ["category_name"]=>
    string(5) "renta"
    ["tag"]=>
    string(0) ""
    ["cat"]=>
    int(16)
    ["tag_id"]=>
    string(0) ""
    ["author"]=>
    string(0) ""
    ["author_name"]=>
    string(0) ""
    ["feed"]=>
    string(0) ""
    ["tb"]=>
    string(0) ""
    ["paged"]=>
    int(0)
    ["meta_key"]=>
    string(0) ""
    ["meta_value"]=>
    string(0) ""
    ["preview"]=>
    string(0) ""
    ["s"]=>
    string(0) ""
    ["sentence"]=>
    string(0) ""
    ["title"]=>
    string(0) ""
    ["fields"]=>
    string(0) ""
    ["menu_order"]=>
    string(0) ""
    ["embed"]=>
    string(0) ""
    ["category__in"]=>
    array(0) {
    }
    ["category__not_in"]=>
    array(0) {
    }
    ["category__and"]=>
    array(0) {
    }
    ["post__in"]=>
    array(0) {
    }
    ["post__not_in"]=>
    array(0) {
    }
    ["post_name__in"]=>
    array(0) {
    }
    ["tag__in"]=>
    array(0) {
    }
    ["tag__not_in"]=>
    array(0) {
    }
    ["tag__and"]=>
    array(0) {
    }
    ["tag_slug__in"]=>
    array(0) {
    }
    ["tag_slug__and"]=>
    array(0) {
    }
    ["post_parent__in"]=>
    array(0) {
    }
    ["post_parent__not_in"]=>
    array(0) {
    }
    ["author__in"]=>
    array(0) {
    }
    ["author__not_in"]=>
    array(0) {
    }
    ["search_columns"]=>
    array(0) {
    }
    ["ignore_sticky_posts"]=>
    bool(false)
    ["suppress_filters"]=>
    bool(false)
    ["cache_results"]=>
    bool(true)
    ["update_post_term_cache"]=>
    bool(true)
    ["update_menu_item_cache"]=>
    bool(false)
    ["lazy_load_term_meta"]=>
    bool(true)
    ["update_post_meta_cache"]=>
    bool(true)
    ["nopaging"]=>
    bool(true)
    ["comments_per_page"]=>
    string(2) "50"
    ["no_found_rows"]=>
    bool(false)
    ["taxonomy"]=>
    string(17) "tipo_de_propiedad"
    ["term"]=>
    string(12) "departamento"
    ["order"]=>
    string(4) "DESC"
  }
  ["tax_query"]=>
  object(WP_Tax_Query)#6176 (6) {
    ["queries"]=>
    array(2) {
      [0]=>
      array(5) {
        ["taxonomy"]=>
        string(8) "category"
        ["terms"]=>
        array(1) {
          [0]=>
          string(5) "renta"
        }
        ["field"]=>
        string(4) "slug"
        ["operator"]=>
        string(2) "IN"
        ["include_children"]=>
        bool(true)
      }
      [1]=>
      array(5) {
        ["taxonomy"]=>
        string(17) "tipo_de_propiedad"
        ["terms"]=>
        array(1) {
          [0]=>
          string(12) "departamento"
        }
        ["field"]=>
        string(4) "slug"
        ["operator"]=>
        string(2) "IN"
        ["include_children"]=>
        bool(true)
      }
    }
    ["relation"]=>
    string(3) "AND"
    ["table_aliases":protected]=>
    array(2) {
      [0]=>
      string(26) "JHVVlOKHterm_relationships"
      [1]=>
      string(3) "tt1"
    }
    ["queried_terms"]=>
    array(2) {
      ["category"]=>
      array(2) {
        ["terms"]=>
        array(1) {
          [0]=>
          string(5) "renta"
        }
        ["field"]=>
        string(4) "slug"
      }
      ["tipo_de_propiedad"]=>
      array(2) {
        ["terms"]=>
        array(1) {
          [0]=>
          string(12) "departamento"
        }
        ["field"]=>
        string(4) "slug"
      }
    }
    ["primary_table"]=>
    string(13) "JHVVlOKHposts"
    ["primary_id_column"]=>
    string(2) "ID"
  }
  ["meta_query"]=>
  object(WP_Meta_Query)#6178 (9) {
    ["queries"]=>
    array(0) {
    }
    ["relation"]=>
    NULL
    ["meta_table"]=>
    NULL
    ["meta_id_column"]=>
    NULL
    ["primary_table"]=>
    NULL
    ["primary_id_column"]=>
    NULL
    ["table_aliases":protected]=>
    array(0) {
    }
    ["clauses":protected]=>
    array(0) {
    }
    ["has_or_relation":protected]=>
    bool(false)
  }
  ["date_query"]=>
  bool(false)
  ["queried_object"]=>
  object(WP_Term)#6216 (16) {
    ["term_id"]=>
    int(16)
    ["name"]=>
    string(5) "Renta"
    ["slug"]=>
    string(5) "renta"
    ["term_group"]=>
    int(0)
    ["term_taxonomy_id"]=>
    int(16)
    ["taxonomy"]=>
    string(8) "category"
    ["description"]=>
    string(0) ""
    ["parent"]=>
    int(0)
    ["count"]=>
    int(15)
    ["filter"]=>
    string(3) "raw"
    ["cat_ID"]=>
    int(16)
    ["category_count"]=>
    int(15)
    ["category_description"]=>
    string(0) ""
    ["cat_name"]=>
    string(5) "Renta"
    ["category_nicename"]=>
    string(5) "renta"
    ["category_parent"]=>
    int(0)
  }
  ["queried_object_id"]=>
  int(16)
  ["request"]=>
  string(1857) "
			SELECT   JHVVlOKHposts.*
			FROM JHVVlOKHposts  LEFT JOIN JHVVlOKHterm_relationships ON (JHVVlOKHposts.ID = JHVVlOKHterm_relationships.object_id)  LEFT JOIN JHVVlOKHterm_relationships AS tt1 ON (JHVVlOKHposts.ID = tt1.object_id)
			WHERE 1=1  AND ( 
  JHVVlOKHterm_relationships.term_taxonomy_id IN (16) 
  AND 
  tt1.term_taxonomy_id IN (18)
) AND ((JHVVlOKHposts.post_type = 'post' AND (JHVVlOKHposts.post_status = 'publish')) OR (JHVVlOKHposts.post_type = 'page' AND (JHVVlOKHposts.post_status = 'publish')) OR (JHVVlOKHposts.post_type = 'attachment' AND (JHVVlOKHposts.post_status = 'publish')) OR (JHVVlOKHposts.post_type = 'revision' AND (JHVVlOKHposts.post_status = 'publish')) OR (JHVVlOKHposts.post_type = 'nav_menu_item' AND (JHVVlOKHposts.post_status = 'publish')) OR (JHVVlOKHposts.post_type = 'custom_css' AND (JHVVlOKHposts.post_status = 'publish')) OR (JHVVlOKHposts.post_type = 'customize_changeset' AND (JHVVlOKHposts.post_status = 'publish')) OR (JHVVlOKHposts.post_type = 'oembed_cache' AND (JHVVlOKHposts.post_status = 'publish')) OR (JHVVlOKHposts.post_type = 'user_request' AND (JHVVlOKHposts.post_status = 'publish')) OR (JHVVlOKHposts.post_type = 'wp_block' AND (JHVVlOKHposts.post_status = 'publish')) OR (JHVVlOKHposts.post_type = 'wp_template' AND (JHVVlOKHposts.post_status = 'publish')) OR (JHVVlOKHposts.post_type = 'wp_template_part' AND (JHVVlOKHposts.post_status = 'publish')) OR (JHVVlOKHposts.post_type = 'wp_global_styles' AND (JHVVlOKHposts.post_status = 'publish')) OR (JHVVlOKHposts.post_type = 'wp_navigation' AND (JHVVlOKHposts.post_status = 'publish')) OR (JHVVlOKHposts.post_type = 'coblocks_pattern' AND (JHVVlOKHposts.post_status = 'publish')) OR (JHVVlOKHposts.post_type = 'propiedad' AND (JHVVlOKHposts.post_status = 'publish')))
			GROUP BY JHVVlOKHposts.ID
			ORDER BY JHVVlOKHposts.post_date DESC
			
		"
  ["posts"]=>
  array(1) {
    [0]=>
    object(WP_Post)#6179 (24) {
      ["ID"]=>
      int(1412)
      ["post_author"]=>
      string(1) "1"
      ["post_date"]=>
      string(19) "2021-05-31 12:54:23"
      ["post_date_gmt"]=>
      string(19) "2021-05-31 17:54:23"
      ["post_content"]=>
      string(7239) "








Se renta departamento con excelente ubicación al norte de la ciudad de Mérida.
Renta $4,000 más $500 de mantenimiento mensual.

Información del Inmueble

Ubicado en el segundo piso.
Cuenta con estufa, cocineta, barra desayunadora, iluminación, cama matrimonial, blancos y un baño completo.
Cuenta con sistema de entrada de seguridad.
Servicio de lavandería y restaurante en planta baja.
Muy cerca de Altabrisa y periférico.

" ["post_title"]=> string(59) "Departamento tipo estudio cerca de Altabrisa, Mérida, Yuc." ["post_excerpt"]=> string(0) "" ["post_status"]=> string(7) "publish" ["comment_status"]=> string(6) "closed" ["ping_status"]=> string(6) "closed" ["post_password"]=> string(0) "" ["post_name"]=> string(55) "departamento-tipo-estudio-cerca-de-altabrisa-merida-yuc" ["to_ping"]=> string(0) "" ["pinged"]=> string(0) "" ["post_modified"]=> string(19) "2022-01-31 20:58:54" ["post_modified_gmt"]=> string(19) "2022-02-01 02:58:54" ["post_content_filtered"]=> string(0) "" ["post_parent"]=> int(0) ["guid"]=> string(59) "https://ocamporealtors.com/?post_type=propiedad&p=1412" ["menu_order"]=> int(0) ["post_type"]=> string(9) "propiedad" ["post_mime_type"]=> string(0) "" ["comment_count"]=> string(1) "0" ["filter"]=> string(3) "raw" } } ["post_count"]=> int(1) ["current_post"]=> int(-1) ["before_loop"]=> bool(false) ["in_the_loop"]=> bool(false) ["post"]=> object(WP_Post)#6179 (24) { ["ID"]=> int(1412) ["post_author"]=> string(1) "1" ["post_date"]=> string(19) "2021-05-31 12:54:23" ["post_date_gmt"]=> string(19) "2021-05-31 17:54:23" ["post_content"]=> string(7239) "

Se renta departamento con excelente ubicación al norte de la ciudad de Mérida.
Renta $4,000 más $500 de mantenimiento mensual.

Información del Inmueble

Ubicado en el segundo piso.
Cuenta con estufa, cocineta, barra desayunadora, iluminación, cama matrimonial, blancos y un baño completo.
Cuenta con sistema de entrada de seguridad.
Servicio de lavandería y restaurante en planta baja.
Muy cerca de Altabrisa y periférico.

" ["post_title"]=> string(59) "Departamento tipo estudio cerca de Altabrisa, Mérida, Yuc." ["post_excerpt"]=> string(0) "" ["post_status"]=> string(7) "publish" ["comment_status"]=> string(6) "closed" ["ping_status"]=> string(6) "closed" ["post_password"]=> string(0) "" ["post_name"]=> string(55) "departamento-tipo-estudio-cerca-de-altabrisa-merida-yuc" ["to_ping"]=> string(0) "" ["pinged"]=> string(0) "" ["post_modified"]=> string(19) "2022-01-31 20:58:54" ["post_modified_gmt"]=> string(19) "2022-02-01 02:58:54" ["post_content_filtered"]=> string(0) "" ["post_parent"]=> int(0) ["guid"]=> string(59) "https://ocamporealtors.com/?post_type=propiedad&p=1412" ["menu_order"]=> int(0) ["post_type"]=> string(9) "propiedad" ["post_mime_type"]=> string(0) "" ["comment_count"]=> string(1) "0" ["filter"]=> string(3) "raw" } ["comment_count"]=> int(0) ["current_comment"]=> int(-1) ["found_posts"]=> int(1) ["max_num_pages"]=> int(0) ["max_num_comment_pages"]=> int(0) ["is_single"]=> bool(false) ["is_preview"]=> bool(false) ["is_page"]=> bool(false) ["is_archive"]=> bool(true) ["is_date"]=> bool(false) ["is_year"]=> bool(false) ["is_month"]=> bool(false) ["is_day"]=> bool(false) ["is_time"]=> bool(false) ["is_author"]=> bool(false) ["is_category"]=> bool(true) ["is_tag"]=> bool(false) ["is_tax"]=> bool(true) ["is_search"]=> bool(false) ["is_feed"]=> bool(false) ["is_comment_feed"]=> bool(false) ["is_trackback"]=> bool(false) ["is_home"]=> bool(false) ["is_privacy_policy"]=> bool(false) ["is_404"]=> bool(false) ["is_embed"]=> bool(false) ["is_paged"]=> bool(false) ["is_admin"]=> bool(false) ["is_attachment"]=> bool(false) ["is_singular"]=> bool(false) ["is_robots"]=> bool(false) ["is_favicon"]=> bool(false) ["is_posts_page"]=> bool(false) ["is_post_type_archive"]=> bool(true) ["query_vars_hash":"WP_Query":private]=> string(32) "eae66151f72598eb3d5e9936e9429a2d" ["query_vars_changed":"WP_Query":private]=> bool(true) ["thumbnails_cached"]=> bool(true) ["allow_query_attachment_by_filename":protected]=> bool(false) ["stopwords":"WP_Query":private]=> NULL ["compat_fields":"WP_Query":private]=> array(2) { [0]=> string(15) "query_vars_hash" [1]=> string(18) "query_vars_changed" } ["compat_methods":"WP_Query":private]=> array(2) { [0]=> string(16) "init_query_flags" [1]=> string(15) "parse_tax_query" } }