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] => 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] => 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] => 5986 [post_author] => 0 [post_date] => 2026-11-05 17:21:49 [post_date_gmt] => 2026-10-29 15:59:39 [post_content] => In the San Siro district, within an elegant, recently constructed residential complex, we offer for sale five three-room apartments, each featuring a terrace. Prices start at €560,000, varying according to the floor level. These apartments are distinguished by their functional layout, welcoming atmosphere, and seamless transition between indoor and outdoor spaces. Each unit consists of a bright living area, featuring a comfortable lounge and an open-plan, furnished kitchen. The sleeping area includes a spacious double bedroom, a single bedroom, and a fully furnished bathroom. The terrace and balcony provide a pleasant outdoor space, perfect for relaxation or social gatherings. The properties are offered partially furnished—with kitchens and bathrooms already equipped—and include underfloor heating and cooling systems, reinforced entrance doors, video intercoms, and fiber-optic connectivity. The residential complex also features extensive communal green spaces, a children’s playground, bicycle racks, and a gym exclusively for residents. Each apartment comes with a cellar. There is also an option to purchase a garage within the building, with prices starting at €40,000. The Via Newton area in the San Siro district is well-served by public transport, with close proximity to the M5 metro line (San Siro Ippodromo and Segesta stations), tram line 16, and bus lines 49 and 98. Numerous educational institutions are located nearby, including middle and high schools, the Vittorio Veneto scientific high school (Liceo Scientifico), and the Galileo Galilei Institute. The area also offers various sports facilities—such as tennis courts, swimming pools, and multi-purpose centers—and is situated near the San Siro Hippodrome and the San Siro Stadium. An ideal living solution for those who wish to reside in a contemporary setting, complete with outdoor spaces and exclusive amenities, in the San Siro district. Contact us for further information or to arrange a viewing. [post_title] => Trilocale 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] => trilocale-in-vendita-a-milano-lotto-novara-san-siro-san-siro [to_ping] => [pinged] => [post_modified] => 2026-11-08 00:05:10 [post_modified_gmt] => 2026-11-07 23:05:10 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/trilocale-in-vendita-a-milano-lotto-novara-san-siro-san-siro/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [1] => WP_Post Object ( [ID] => 5989 [post_author] => 0 [post_date] => 2026-11-05 16:25:18 [post_date_gmt] => 2026-10-29 15:14:57 [post_content] => In the San Siro district, within an elegant, recently constructed residential complex, we offer for sale three spacious one-bedroom apartments, each featuring a terrace. Prices start at €459,000, varying according to the floor level. These apartments are distinguished by their functional layout, welcoming atmosphere, and seamless transition between indoor and outdoor living spaces. Each unit consists of a bright living area, including a comfortable lounge and a dining space with an open-plan kitchen. The sleeping area comprises a spacious double bedroom, a fully furnished bathroom, and a convenient storage room that can also serve as a walk-in closet. The terrace—approximately 25 square meters—provides a delightful outdoor space, perfect for relaxation or social gatherings. The properties are offered partially furnished, with the kitchen and bathroom already equipped. Features include a radiant heating and cooling system, a reinforced entrance door, a video intercom, and fiber-optic connectivity. The residential complex also offers extensive communal green spaces, a children’s playground, bicycle racks, and a gym exclusively for residents. Each apartment includes a cellar. There is also an option to purchase a garage within the building, with prices starting at €40,000. An ideal living solution for those seeking a contemporary environment with private outdoor space and exclusive amenities in the San Siro district. Availability: 3 one-bedroom apartments Prices: From €459,000 (depending on the floor) Garage: From €40,000 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] => Bilocale 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] => bilocale-in-vendita-a-milano-lotto-novara-san-siro-san-siro [to_ping] => [pinged] => [post_modified] => 2026-11-08 00:05:11 [post_modified_gmt] => 2026-11-07 23:05:11 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/bilocale-in-vendita-a-milano-lotto-novara-san-siro-san-siro/ [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-08 00:05:13 [post_modified_gmt] => 2026-11-07 23:05:13 [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] => 5986 [post_author] => 0 [post_date] => 2026-11-05 17:21:49 [post_date_gmt] => 2026-10-29 15:59:39 [post_content] => In the San Siro district, within an elegant, recently constructed residential complex, we offer for sale five three-room apartments, each featuring a terrace. Prices start at €560,000, varying according to the floor level. These apartments are distinguished by their functional layout, welcoming atmosphere, and seamless transition between indoor and outdoor spaces. Each unit consists of a bright living area, featuring a comfortable lounge and an open-plan, furnished kitchen. The sleeping area includes a spacious double bedroom, a single bedroom, and a fully furnished bathroom. The terrace and balcony provide a pleasant outdoor space, perfect for relaxation or social gatherings. The properties are offered partially furnished—with kitchens and bathrooms already equipped—and include underfloor heating and cooling systems, reinforced entrance doors, video intercoms, and fiber-optic connectivity. The residential complex also features extensive communal green spaces, a children’s playground, bicycle racks, and a gym exclusively for residents. Each apartment comes with a cellar. There is also an option to purchase a garage within the building, with prices starting at €40,000. The Via Newton area in the San Siro district is well-served by public transport, with close proximity to the M5 metro line (San Siro Ippodromo and Segesta stations), tram line 16, and bus lines 49 and 98. Numerous educational institutions are located nearby, including middle and high schools, the Vittorio Veneto scientific high school (Liceo Scientifico), and the Galileo Galilei Institute. The area also offers various sports facilities—such as tennis courts, swimming pools, and multi-purpose centers—and is situated near the San Siro Hippodrome and the San Siro Stadium. An ideal living solution for those who wish to reside in a contemporary setting, complete with outdoor spaces and exclusive amenities, in the San Siro district. Contact us for further information or to arrange a viewing. [post_title] => Trilocale 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] => trilocale-in-vendita-a-milano-lotto-novara-san-siro-san-siro [to_ping] => [pinged] => [post_modified] => 2026-11-08 00:05:10 [post_modified_gmt] => 2026-11-07 23:05:10 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/trilocale-in-vendita-a-milano-lotto-novara-san-siro-san-siro/ [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] => 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 ) [query_cache_key:WP_Query:private] => wp_query:9af257eee4537818f30f1c59375035c3 )