WP_Query Object ( [query] => Array ( [paged] => 2 [post_type] => immobile [post_status] => publish [meta_query] => Array ( [relation] => AND [0] => Array ( [key] => contratto [value] => vendita [compare] => = ) [1] => Array ( [key] => categoria_immobile [value] => Residenziale [compare] => = ) [2] => Array ( [key] => riferimento_immobile [value] => VENDUTO [compare] => != ) ) [meta_key] => prezzo_immobile [orderby] => meta_value_num [order] => DESC ) [query_vars] => Array ( [paged] => 2 [post_type] => immobile [post_status] => publish [meta_query] => Array ( [relation] => AND [0] => Array ( [key] => contratto [value] => vendita [compare] => = ) [1] => Array ( [key] => categoria_immobile [value] => Residenziale [compare] => = ) [2] => Array ( [key] => riferimento_immobile [value] => VENDUTO [compare] => != ) ) [meta_key] => prezzo_immobile [orderby] => meta_value_num [order] => DESC [error] => [m] => [p] => 0 [post_parent] => [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_value] => [preview] => [s] => [sentence] => [title] => [fields] => [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 ( ) [ignore_sticky_posts] => [suppress_filters] => [cache_results] => 1 [update_post_term_cache] => 1 [update_menu_item_cache] => [lazy_load_term_meta] => 1 [update_post_meta_cache] => 1 [posts_per_page] => 9 [nopaging] => [comments_per_page] => 50 [no_found_rows] => ) [tax_query] => WP_Tax_Query Object ( [queries] => Array ( ) [relation] => AND [table_aliases:protected] => Array ( ) [queried_terms] => Array ( ) [primary_table] => wp_posts [primary_id_column] => ID ) [meta_query] => WP_Meta_Query Object ( [queries] => Array ( [0] => Array ( [key] => prezzo_immobile ) [1] => Array ( [0] => Array ( [key] => contratto [value] => vendita [compare] => = ) [1] => Array ( [key] => categoria_immobile [value] => Residenziale [compare] => = ) [2] => Array ( [key] => riferimento_immobile [value] => VENDUTO [compare] => != ) [relation] => AND ) [relation] => AND ) [relation] => AND [meta_table] => wp_postmeta [meta_id_column] => post_id [primary_table] => wp_posts [primary_id_column] => ID [table_aliases:protected] => Array ( [0] => wp_postmeta [1] => mt1 [2] => mt2 [3] => mt3 ) [clauses:protected] => Array ( [wp_postmeta] => Array ( [key] => prezzo_immobile [compare] => = [compare_key] => = [alias] => wp_postmeta [cast] => CHAR ) [mt1] => Array ( [key] => contratto [value] => vendita [compare] => = [compare_key] => = [alias] => mt1 [cast] => CHAR ) [mt2] => Array ( [key] => categoria_immobile [value] => Residenziale [compare] => = [compare_key] => = [alias] => mt2 [cast] => CHAR ) [mt3] => Array ( [key] => riferimento_immobile [value] => VENDUTO [compare] => != [compare_key] => = [alias] => mt3 [cast] => CHAR ) ) [has_or_relation:protected] => ) [date_query] => [request] => SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) INNER JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) INNER JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.post_id ) JOIN wp_icl_translations wpml_translations ON wp_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type) WHERE 1=1 AND ( wp_postmeta.meta_key = 'prezzo_immobile' AND ( ( mt1.meta_key = 'contratto' AND mt1.meta_value = 'vendita' ) AND ( mt2.meta_key = 'categoria_immobile' AND mt2.meta_value = 'Residenziale' ) AND ( mt3.meta_key = 'riferimento_immobile' AND mt3.meta_value != 'VENDUTO' ) ) ) AND wp_posts.post_type = 'immobile' AND ((wp_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR 0 ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','acf-field-group','immobile','careers' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','acf-field-group','immobile','careers' ) ) GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value+0 DESC LIMIT 9, 9 [posts] => Array ( [0] => WP_Post Object ( [ID] => 5073 [post_author] => 0 [post_date] => 2024-04-29 16:35:13 [post_date_gmt] => 2024-04-23 14:03:12 [post_content] => In the immediate vicinity of MM Pasteur and a short distance from Corso Buenos Aires we offer for sale a bright, newly renovated two-room apartment, located in an elegant building with lift to the floor and concierge service. The real estate unit is composed of: entrance, living room with open kitchen, bedroom with balcony, laundry room, bathroom. The apartment is sold completely renovated, with certified systems, perimeter walls with acoustic insulation, pre-finished parquet in natural oak essence, bathroom walls in washable enamel, shower tray and shower covering in porcelain stoneware, certified thermal break PVC windows and shutters motorized. The property is equipped with a centralized underfloor heating system, a ducted air conditioning system and the provision of a volumetric alarm system. Contact us to view the property. All graphic and textual documentation is purely illustrative and does not constitute a contractual obligation. [post_title] => Bilocale in vendita a Milano Bicocca, Greco, Monza, Palmanova Pasteur [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => bilocale-in-vendita-a-milano-bicocca-greco-monza-palmanova-pasteur-4 [to_ping] => [pinged] => [post_modified] => 2024-05-15 01:05:37 [post_modified_gmt] => 2024-05-14 23:05:37 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/bilocale-in-vendita-a-milano-bicocca-greco-monza-palmanova-pasteur-4/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [1] => WP_Post Object ( [ID] => 5076 [post_author] => 0 [post_date] => 2024-04-29 16:39:10 [post_date_gmt] => 2024-04-23 14:05:59 [post_content] => In the immediate vicinity of MM Pasteur and a short distance from Corso Buenos Aires we offer for sale a bright, newly renovated two-room apartment, located in an elegant building with lift to the floor and concierge service. The real estate unit is composed of: entrance, living room with open kitchen, bedroom, dressing room and bathroom, balcony. The apartment is sold completely renovated, with certified systems, perimeter walls with acoustic insulation, pre-finished parquet in natural oak essence, bathroom walls in washable enamel, shower tray and shower covering in porcelain stoneware, certified thermal break PVC windows and shutters motorized. The property is equipped with a centralized underfloor heating system, a ducted air conditioning system and the provision of a volumetric alarm system. Contact us to view the property. All graphic and textual documentation is purely illustrative and does not constitute a contractual obligation. [post_title] => Bilocale in vendita a Milano Bicocca, Greco, Monza, Palmanova Pasteur [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => bilocale-in-vendita-a-milano-bicocca-greco-monza-palmanova-pasteur-5 [to_ping] => [pinged] => [post_modified] => 2024-05-15 01:05:37 [post_modified_gmt] => 2024-05-14 23:05:37 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/bilocale-in-vendita-a-milano-bicocca-greco-monza-palmanova-pasteur-5/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [2] => WP_Post Object ( [ID] => 5067 [post_author] => 0 [post_date] => 2024-04-29 16:39:55 [post_date_gmt] => 2024-04-23 14:08:32 [post_content] => Pasteur district, we offer for sale a bright two-room apartment recently renovated with double exposure, located in an elegant building with elevator upstairs and concierge service. The real estate unit is composed of: entrance, living room with open kitchen, bedroom, bathroom with shower and a comfortable laundry area, balcony. The apartment is sold completely renovated, with certified systems, surrounding walls with acoustic insulation, prefinished parquet in natural oak essence, bathroom walls in washable enamel, shower tray and shower cladding in porcelain stoneware, windows in PVC with certified thermal break and motorized shutters. The property is equipped with a centralized underfloor heating system, a ducted air conditioning system and the provision of a volumetric alarm system. Contact us to view the property. Any graphic and textual documentation is purely illustrative and does not constitute a contractual obligation. [post_title] => Bilocale in vendita a Milano Bicocca, Greco, Monza, Palmanova Pasteur [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => bilocale-in-vendita-a-milano-bicocca-greco-monza-palmanova-pasteur-2 [to_ping] => [pinged] => [post_modified] => 2024-05-15 01:05:36 [post_modified_gmt] => 2024-05-14 23:05:36 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/bilocale-in-vendita-a-milano-bicocca-greco-monza-palmanova-pasteur-2/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [3] => WP_Post Object ( [ID] => 5064 [post_author] => 0 [post_date] => 2024-04-29 16:40:25 [post_date_gmt] => 2024-04-23 13:56:59 [post_content] => In the immediate vicinity of MM Pasteur and a short distance from Corso Buenos Aires, we offer for sale a recently renovated bright two-room apartment, located in an elegant building with elevator to the upper floor and concierge service. The real estate unit is composed of: entrance, living room with open kitchen, bedroom, dressing room and bathroom with window, balcony. The apartment is sold completely renovated, with certified systems, surrounding walls with acoustic insulation, prefinished parquet in natural oak essence, bathroom walls in washable enamel, shower tray and shower cladding in porcelain stoneware, windows in PVC with certified thermal break and motorized shutters. The property is equipped with a centralized underfloor heating system, a ducted air conditioning system and the provision of a volumetric alarm system. Contact us to view the property. Any graphic and textual documentation is purely illustrative and does not constitute a contractual obligation. [post_title] => Bilocale in vendita a Milano Bicocca, Greco, Monza, Palmanova Pasteur [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => bilocale-in-vendita-a-milano-bicocca-greco-monza-palmanova-pasteur [to_ping] => [pinged] => [post_modified] => 2024-05-15 01:05:36 [post_modified_gmt] => 2024-05-14 23:05:36 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/bilocale-in-vendita-a-milano-bicocca-greco-monza-palmanova-pasteur/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [4] => WP_Post Object ( [ID] => 5070 [post_author] => 0 [post_date] => 2024-04-30 10:59:45 [post_date_gmt] => 2024-04-23 13:59:54 [post_content] => In the immediate vicinity of MM Pasteur and a short distance from Corso Buenos Aires we offer for sale a bright, newly renovated two-room apartment, located in an elegant building with lift to the floor and concierge service. The real estate unit is composed of: entrance, large living room with open kitchen, bedroom, storage room used as a laundry area, bathroom. The apartment is sold completely renovated, with certified systems, perimeter walls with acoustic insulation, pre-finished parquet in natural oak essence, bathroom walls in washable enamel, shower tray and shower covering in porcelain stoneware, certified thermal break PVC windows and shutters motorized. The property is equipped with a centralized underfloor heating system, a ducted air conditioning system and the provision of a volumetric alarm system. Contact us to view the property. All graphic and textual documentation is purely illustrative and does not constitute a contractual obligation. [post_title] => Bilocale in vendita a Milano Bicocca, Greco, Monza, Palmanova Pasteur [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => bilocale-in-vendita-a-milano-bicocca-greco-monza-palmanova-pasteur-3 [to_ping] => [pinged] => [post_modified] => 2024-05-15 01:05:37 [post_modified_gmt] => 2024-05-14 23:05:37 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/bilocale-in-vendita-a-milano-bicocca-greco-monza-palmanova-pasteur-3/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [5] => WP_Post Object ( [ID] => 4947 [post_author] => 0 [post_date] => 2024-03-06 09:48:53 [post_date_gmt] => 2024-02-13 15:48:34 [post_content] => It is a manor house, on two levels, with a large private garden. From the entrance located on the mezzanine floor you enter the accommodation located on the first floor, consisting of an important entrance with a window that communicates with the terrace, a corridor from which it is possible to reach all the rooms of the house: a spacious living room, the dining room, the kitchen, a hallway which leads to the bathroom, a storage room and the rear terrace, three bedrooms and a balcony overlooking the garden. On the ground floor there is a large garage and the house's heating plant. All graphic and textual documentation is purely illustrative and does not constitute a contractual obligation. [post_title] => Casa indipendente in vendita a Candia Lomellina [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => casa-indipendente-in-vendita-a-candia-lomellina [to_ping] => [pinged] => [post_modified] => 2024-05-15 01:05:32 [post_modified_gmt] => 2024-05-14 23:05:32 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/casa-indipendente-in-vendita-a-candia-lomellina/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [6] => WP_Post Object ( [ID] => 4989 [post_author] => 0 [post_date] => 2024-02-27 13:30:06 [post_date_gmt] => 2024-02-26 17:50:43 [post_content] => In the San Siro area we offer for sale a single garage on the first basement floor. Manual tilting opening. The price is subject to 4% VAT if pertaining to the first home or 10% VAT if the home is not a first home. Internal measurements: 5 x 2.77 m (h. 2.60 m) Next door we have a second garage available for sale. Internal measurements: 5 x 262 (h. 2.63) Contact us to view the property. All graphic and textual documentation is purely illustrative and does not constitute a contractual obligation [post_title] => Monolocale in vendita a Milano Lotto, Novara, San Siro San Siro [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => monolocale-in-vendita-a-milano-lotto-novara-san-siro-san-siro [to_ping] => [pinged] => [post_modified] => 2024-05-15 01:05:25 [post_modified_gmt] => 2024-05-14 23:05:25 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/monolocale-in-vendita-a-milano-lotto-novara-san-siro-san-siro/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) ) [post_count] => 7 [current_post] => -1 [before_loop] => 1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 5073 [post_author] => 0 [post_date] => 2024-04-29 16:35:13 [post_date_gmt] => 2024-04-23 14:03:12 [post_content] => In the immediate vicinity of MM Pasteur and a short distance from Corso Buenos Aires we offer for sale a bright, newly renovated two-room apartment, located in an elegant building with lift to the floor and concierge service. The real estate unit is composed of: entrance, living room with open kitchen, bedroom with balcony, laundry room, bathroom. The apartment is sold completely renovated, with certified systems, perimeter walls with acoustic insulation, pre-finished parquet in natural oak essence, bathroom walls in washable enamel, shower tray and shower covering in porcelain stoneware, certified thermal break PVC windows and shutters motorized. The property is equipped with a centralized underfloor heating system, a ducted air conditioning system and the provision of a volumetric alarm system. Contact us to view the property. All graphic and textual documentation is purely illustrative and does not constitute a contractual obligation. [post_title] => Bilocale in vendita a Milano Bicocca, Greco, Monza, Palmanova Pasteur [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => bilocale-in-vendita-a-milano-bicocca-greco-monza-palmanova-pasteur-4 [to_ping] => [pinged] => [post_modified] => 2024-05-15 01:05:37 [post_modified_gmt] => 2024-05-14 23:05:37 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/bilocale-in-vendita-a-milano-bicocca-greco-monza-palmanova-pasteur-4/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 16 [max_num_pages] => 2 [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] => [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] => f2f24f5de22a443fadda416cf4e48c7a [query_vars_changed:WP_Query:private] => [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 ) )