WP_Query Object ( [query] => Array ( [paged] => 2 [post_type] => immobile [post_status] => publish [meta_query] => Array ( [relation] => AND [0] => Array ( [key] => stato_costruzione [value] => Nuovo [compare] => != ) [1] => Array ( [key] => contratto [value] => vendita [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] => stato_costruzione [value] => Nuovo [compare] => != ) [1] => Array ( [key] => contratto [value] => vendita [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] => 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 ( ) [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] => stato_costruzione [value] => Nuovo [compare] => != ) [1] => Array ( [key] => contratto [value] => vendita [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] => stato_costruzione [value] => Nuovo [compare] => != [compare_key] => = [alias] => mt1 [cast] => CHAR ) [mt2] => Array ( [key] => contratto [value] => vendita [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 = 'stato_costruzione' AND mt1.meta_value != 'Nuovo' ) AND ( mt2.meta_key = 'contratto' AND mt2.meta_value = 'vendita' ) 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] => 5983 [post_author] => 0 [post_date] => 2026-10-30 15:26:35 [post_date_gmt] => 2026-10-28 14:27:59 [post_content] => In the heart of Porta Romana—one of Milan’s most vibrant and sought-after neighborhoods—we offer for sale an elegant, two-level apartment. It is situated on the second and third floors of a charming early 20th-century building, which features a half-day concierge service. The property, characterized by welcoming and well-laid-out spaces, spans two levels connected by an internal staircase. The current layout includes a bright living area with an open-plan kitchen, two bedrooms, a full bathroom (equipped with both a bathtub and a shower), and a second, smaller bathroom with a sink and toilet. The kitchen—fully equipped with high-end appliances—and the custom-made cabinetry are included in the sale, representing a significant added value. A particularly attractive feature is the communal terrace, which is directly accessible from the apartment. The property is also equipped with a modern "Innova" climate control system featuring a heat pump, providing both heating and cooling. The stylish, recessed fan-coil units are seamlessly integrated into the interior, ensuring comfort without the need for visible split units. Smart thermostats allow for independent temperature control in every room, with the option to program and manage settings remotely via an app. Domestic hot water is provided by a gas boiler. The building includes a well-maintained courtyard—available for short-term stops—as well as common areas for parking bicycles and motorcycles (the latter in a covered space). This charming residence is an ideal choice for a young couple or as an investment, thanks to its central location and proximity to the area’s key amenities, shops, and transport links. Please contact us for further information or to arrange a viewing. All graphic and textual documentation is provided for illustrative purposes only and does not constitute a contractual obligation. [post_title] => Trilocale in vendita a Milano Bocconi, C.so Italia, Ticinese [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => trilocale-in-vendita-a-milano-bocconi-c-so-italia-ticinese [to_ping] => [pinged] => [post_modified] => 2026-11-01 00:05:47 [post_modified_gmt] => 2026-10-31 23:05:47 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/trilocale-in-vendita-a-milano-bocconi-c-so-italia-ticinese/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [1] => WP_Post Object ( [ID] => 5951 [post_author] => 0 [post_date] => 2026-10-15 17:19:18 [post_date_gmt] => 2026-10-09 14:12:24 [post_content] => In the heart of Brera—one of Milan’s most exclusive, charming, and sought-after districts—we offer for sale an elegant office located within a distinguished, character-filled building in a highly prestigious setting. The property has been fully renovated using high-quality finishes and materials. It stands out for its refined interior design and contemporary furnishings, creating a sophisticated professional environment where aesthetics, functionality, and comfort coexist harmoniously. The expertly laid-out and enhanced spaces include a welcoming open-plan entrance featuring a living area and kitchenette, a bright mezzanine level, a separate room, a hallway, and a bathroom. Its dual aspect ensures excellent natural light and pleasant airflow, making the interiors particularly inviting and comfortable. The property also features independent heating and a full-day concierge service. This is an ideal solution for professional firms, consultants, and freelancers seeking a prestigious headquarters that combines status and comfort with a strategic location in the heart of Milan. Contact us for further information or to arrange a viewing. All graphic and textual documentation is for illustrative purposes only and does not constitute a contractual element or obligation. [post_title] => Trilocale in vendita a Milano Centro Storico Centro Storico [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => trilocale-in-vendita-a-milano-centro-storico-centro-storico [to_ping] => [pinged] => [post_modified] => 2026-11-01 00:05:38 [post_modified_gmt] => 2026-10-31 23:05:38 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/trilocale-in-vendita-a-milano-centro-storico-centro-storico/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [2] => WP_Post Object ( [ID] => 4947 [post_author] => 0 [post_date] => 2026-10-29 12:29:30 [post_date_gmt] => 2024-02-13 15:48:34 [post_content] => In Candia Lomellina, we offer for sale an independent manor house, characterized by generously sized rooms, intriguing original architectural details, and a large private garden. The property is spread over two levels and features traditional architecture, with facades embellished by exposed brickwork, wooden shutters, and pleasant outdoor spaces. An entrance on the raised ground floor leads up to the first floor, which is entirely dedicated to the living quarters. A spacious foyer—featuring a large glass panel and access to a terrace—serves as the gateway to the various rooms, which are arranged along a central hallway. The living area includes a large living room, a separate dining room, and an eat-in kitchen. The sleeping area comprises three bedrooms, a bathroom, and a convenient storage room. The interiors retain original elements of particular charm, including distinctive mosaic floors with multicolored geometric patterns; these add character to the spaces and offer an excellent opportunity for restoration. The floor is completed by a large terrace at the rear and a balcony overlooking the garden. On the ground floor, there is a spacious garage, notable for its high, partially vaulted ceilings and expansive floor area. The property is surrounded by a generous private garden, enriched by mature trees and ample green space—an ideal setting for creating outdoor relaxation or social areas, ensuring both privacy and tranquility. The property requires renovation and offers significant potential for customization, allowing for the enhancement of its original character while adapting the spaces to meet contemporary needs. An ideal solution for those seeking independence, ample space, and the allure of a residence waiting to be restored to its former splendor. Contact us to arrange a viewing. All graphic and textual documentation is provided for illustrative purposes only 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] => 2026-11-01 00:05:37 [post_modified_gmt] => 2026-10-31 23:05:37 [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 ) ) [post_count] => 3 [current_post] => -1 [before_loop] => 1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 5983 [post_author] => 0 [post_date] => 2026-10-30 15:26:35 [post_date_gmt] => 2026-10-28 14:27:59 [post_content] => In the heart of Porta Romana—one of Milan’s most vibrant and sought-after neighborhoods—we offer for sale an elegant, two-level apartment. It is situated on the second and third floors of a charming early 20th-century building, which features a half-day concierge service. The property, characterized by welcoming and well-laid-out spaces, spans two levels connected by an internal staircase. The current layout includes a bright living area with an open-plan kitchen, two bedrooms, a full bathroom (equipped with both a bathtub and a shower), and a second, smaller bathroom with a sink and toilet. The kitchen—fully equipped with high-end appliances—and the custom-made cabinetry are included in the sale, representing a significant added value. A particularly attractive feature is the communal terrace, which is directly accessible from the apartment. The property is also equipped with a modern "Innova" climate control system featuring a heat pump, providing both heating and cooling. The stylish, recessed fan-coil units are seamlessly integrated into the interior, ensuring comfort without the need for visible split units. Smart thermostats allow for independent temperature control in every room, with the option to program and manage settings remotely via an app. Domestic hot water is provided by a gas boiler. The building includes a well-maintained courtyard—available for short-term stops—as well as common areas for parking bicycles and motorcycles (the latter in a covered space). This charming residence is an ideal choice for a young couple or as an investment, thanks to its central location and proximity to the area’s key amenities, shops, and transport links. Please contact us for further information or to arrange a viewing. All graphic and textual documentation is provided for illustrative purposes only and does not constitute a contractual obligation. [post_title] => Trilocale in vendita a Milano Bocconi, C.so Italia, Ticinese [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => trilocale-in-vendita-a-milano-bocconi-c-so-italia-ticinese [to_ping] => [pinged] => [post_modified] => 2026-11-01 00:05:47 [post_modified_gmt] => 2026-10-31 23:05:47 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/trilocale-in-vendita-a-milano-bocconi-c-so-italia-ticinese/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 12 [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_sitemap] => [is_posts_page] => [is_post_type_archive] => 1 [query_vars_hash:WP_Query:private] => 69bc40f3baf0484cd226faab99f2ff9b [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 ) [query_cache_key:WP_Query:private] => wp_query:13fcb94437d476d75d053a7233af7e67 )