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] => 5455 [post_author] => 0 [post_date] => 2025-05-19 11:13:15 [post_date_gmt] => 2025-05-19 09:13:14 [post_content] => In the San Siro area, within an elegant newly constructed building in Class A, we offer for sale an exclusive penthouse spread over two levels. This refined residence stands out for its high-quality finishes and excellent construction quality, providing a refined and comfortable environment. The apartment comprises a large and bright living room, a fully equipped kitchen, and a dining room. The sleeping area hosts three spacious bedrooms and three windowed bathrooms, designed with high-quality materials. The apartment is enriched by the presence of two balconies and a large covered terrace, perfect for enjoying pleasant moments outdoors. Thanks to the east-west double exposure, the house enjoys exceptional brightness throughout the day. In addition, it is equipped with radiant floor heating and air conditioning, ensuring excellent energy efficiency and superior living comfort. The interior finishes include rustic oak parquet flooring in the sleeping area, flush internal doors, external aluminum frames with thermal and acoustic insulating glass, and electric shutters, in addition to a robust armored entrance door, ensuring security and quality. Completing the property, there are two cellars. There is also the possibility of purchasing two adjacent garage spaces within the building, at a price of €50,000 each. For more information or to schedule a visit, please do not hesitate to contact us. All graphic and textual documentation is purely illustrative and does not constitute a contractual obligation. [post_title] => Quadrilocale in vendita a Milano Lotto, Novara, San Siro [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => quadrilocale-in-vendita-a-milano-lotto-novara-san-siro-2 [to_ping] => [pinged] => [post_modified] => 2025-06-06 01:13:52 [post_modified_gmt] => 2025-06-05 23:13:52 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/quadrilocale-in-vendita-a-milano-lotto-novara-san-siro-2/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [1] => WP_Post Object ( [ID] => 5141 [post_author] => 0 [post_date] => 2025-05-19 10:50:51 [post_date_gmt] => 2024-07-10 15:57:34 [post_content] => In the San Siro area, within an elegant newly constructed building in Class A, we offer for sale an exclusive penthouse spread over two levels. This refined residence stands out for its high-quality finishes and excellent construction quality, providing a refined and comfortable environment. The apartment comprises a large and bright living room, a fully equipped kitchen, and a dining room. The sleeping area hosts three spacious bedrooms and three windowed bathrooms, designed with high-quality materials. The apartment is enriched by the presence of two balconies and a large covered terrace, perfect for enjoying pleasant moments outdoors. Thanks to the east-west double exposure, the house enjoys exceptional brightness throughout the day. In addition, it is equipped with radiant floor heating and air conditioning, ensuring excellent energy efficiency and superior living comfort. The interior finishes include rustic oak parquet flooring in the sleeping area, flush internal doors, external aluminum frames with thermal and acoustic insulating glass, and electric shutters, in addition to a robust armored entrance door, ensuring security and quality. Completing the property, there are two cellars. There is also the possibility of purchasing two adjacent garage spaces within the building, at a price of €50,000 each. For more information or to schedule a visit, please do not hesitate to contact us. All graphic and textual documentation is purely illustrative and does not constitute a contractual obligation. [post_title] => Quadrilocale in vendita a Milano Lotto, Novara, San Siro [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => quadrilocale-in-vendita-a-milano-lotto-novara-san-siro [to_ping] => [pinged] => [post_modified] => 2025-06-06 01:13:43 [post_modified_gmt] => 2025-06-05 23:13:43 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/quadrilocale-in-vendita-a-milano-lotto-novara-san-siro/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [2] => WP_Post Object ( [ID] => 5434 [post_author] => 0 [post_date] => 2025-04-02 22:07:25 [post_date_gmt] => 2025-04-02 20:07:24 [post_content] => [post_title] => Trilocale in vendita a Milano Fiera, Firenze, Sempione [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => trilocale-in-vendita-a-milano-fiera-firenze-sempione [to_ping] => [pinged] => [post_modified] => 2025-06-06 01:13:49 [post_modified_gmt] => 2025-06-05 23:13:49 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/trilocale-in-vendita-a-milano-fiera-firenze-sempione/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [3] => WP_Post Object ( [ID] => 5448 [post_author] => 0 [post_date] => 2025-05-22 16:31:03 [post_date_gmt] => 2025-05-09 19:40:01 [post_content] => Discover this spacious three-room apartment in the heart of San Siro — a true gem, fully renovated. Located on the second floor of an elegant building with an elevator, the apartment welcomes you with a warm entrance that leads into a bright living room, which opens directly onto a large and private loggia-style veranda. Finished with parquet flooring, this outdoor space is perfect for year-round relaxation, thanks to its removable structure, both interior and exterior sunshades, and a split system for both heating and cooling. The dining area and partially open-plan kitchen overlook a large terrace facing the inner courtyard, creating a quiet and private atmosphere. The sleeping area is well-separated by a hallway and includes a master bedroom with a windowed en-suite bathroom, as well as a second spacious bedroom. A second windowed bathroom with a bathtub completes the sleeping quarters, while high-quality finishes, such as parquet flooring, add elegance and comfort throughout. The veranda, facing East, is a spacious and inviting area that can be used as a true extension of the interior, ideal as a home office or an additional living space. The terrace, facing West, looks out over the greenery of the inner courtyard — the perfect spot for lunches and dinners, with a view of the sunset every evening. Thanks to the East-West exposure of the two terraces, the apartment enjoys sunlight throughout the day, offering an ideal outdoor living experience for the whole family. With independent heating and air conditioning in every room, the apartment is comfortable in all seasons and has low running costs. Additionally, a dry, tiled cellar is available on the ground floor. Don't miss the opportunity to purchase a double garage in the building for €80,000. This elegant and functional property is perfect for the whole family. Contact us to schedule a viewing. All graphic and textual materials are for illustrative purposes [post_title] => Trilocale in vendita a Milano Lotto, Novara, 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-2 [to_ping] => [pinged] => [post_modified] => 2025-06-06 01:13:45 [post_modified_gmt] => 2025-06-05 23:13:45 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/trilocale-in-vendita-a-milano-lotto-novara-san-siro-2/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [4] => WP_Post Object ( [ID] => 5301 [post_author] => 0 [post_date] => 2025-05-22 16:31:28 [post_date_gmt] => 2024-11-19 15:42:48 [post_content] => Discover this spacious three-room apartment in the heart of San Siro — a true gem, fully renovated. Located on the second floor of an elegant building with an elevator, the apartment welcomes you with a warm entrance that leads into a bright living room, which opens directly onto a large and private loggia-style veranda. Finished with parquet flooring, this outdoor space is perfect for year-round relaxation, thanks to its removable structure, both interior and exterior sunshades, and a split system for both heating and cooling. The dining area and partially open-plan kitchen overlook a large terrace facing the inner courtyard, creating a quiet and private atmosphere. The sleeping area is well-separated by a hallway and includes a master bedroom with a windowed en-suite bathroom, as well as a second spacious bedroom. A second windowed bathroom with a bathtub completes the sleeping quarters, while high-quality finishes, such as parquet flooring, add elegance and comfort throughout. The veranda, facing East, is a spacious and inviting area that can be used as a true extension of the interior, ideal as a home office or an additional living space. The terrace, facing West, looks out over the greenery of the inner courtyard — the perfect spot for lunches and dinners, with a view of the sunset every evening. Thanks to the East-West exposure of the two terraces, the apartment enjoys sunlight throughout the day, offering an ideal outdoor living experience for the whole family. With independent heating and air conditioning in every room, the apartment is comfortable in all seasons and has low running costs. Additionally, a dry, tiled cellar is available on the ground floor. Don't miss the opportunity to purchase a double garage in the building for €80,000. This elegant and functional property is perfect for the whole family. Contact us to schedule a viewing. All graphic and textual materials are for illustrative purposes [post_title] => Trilocale in vendita a Milano Lotto, Novara, 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 [to_ping] => [pinged] => [post_modified] => 2025-06-06 01:13:45 [post_modified_gmt] => 2025-06-05 23:13:45 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/trilocale-in-vendita-a-milano-lotto-novara-san-siro-3/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [5] => WP_Post Object ( [ID] => 5198 [post_author] => 0 [post_date] => 2025-05-06 10:26:44 [post_date_gmt] => 2024-09-12 13:37:54 [post_content] => Bordighera, Piazza Eroi della libertà - bright and panoramic apartment on the second floor of a period building from the early 1900s with elevator. The apartment is to be renovated and divided internally. [post_title] => Appartamento in vendita a Bordighera [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => appartamento-in-vendita-a-bordighera [to_ping] => [pinged] => [post_modified] => 2025-06-06 01:13:36 [post_modified_gmt] => 2025-06-05 23:13:36 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/appartamento-in-vendita-a-bordighera/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [6] => WP_Post Object ( [ID] => 5445 [post_author] => 0 [post_date] => 2025-05-05 12:41:20 [post_date_gmt] => 2025-04-30 12:46:22 [post_content] => Charming apartment with terrace for sale in the heart of Porto Rotondo, just a few minutes’ drive from the area's most beautiful beaches, located within a residence with swimming pool. The apartment features a bright living room, kitchenette, two bathrooms, a double bedroom, and a spacious lofted mezzanine that can be used as a second bedroom. A beautiful terrace overlooking the gulf offers the perfect setting to enjoy outdoor moments. The property is situated within a quiet residence that includes a large swimming pool surrounded by lush greenery, accessible exclusively to residents. The apartment offers an excellent base to be customized according to personal taste, with great potential to become a cozy residence in one of Sardinia's most renowned destinations. It represents a great opportunity both as a family holiday home and as a rental investment. Annual condominium fees: approximately €1,477.11 Annual Porto Rotondo consortium fees: approximately €1,058 Private parking space available in the shared courtyard. Contact us to arrange a viewing. All graphic and textual documentation is for illustrative purposes only and does not constitute any contractual obligation. [post_title] => Trilocale in vendita a Olbia [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => trilocale-in-vendita-a-olbia [to_ping] => [pinged] => [post_modified] => 2025-06-06 01:13:51 [post_modified_gmt] => 2025-06-05 23:13:51 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/trilocale-in-vendita-a-olbia/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [7] => WP_Post Object ( [ID] => 4947 [post_author] => 0 [post_date] => 2024-07-01 11:30:08 [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] => 2025-06-06 01:13:42 [post_modified_gmt] => 2025-06-05 23:13:42 [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 ) [8] => 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] => 2025-06-06 01:13:40 [post_modified_gmt] => 2025-06-05 23:13:40 [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] => 9 [current_post] => -1 [before_loop] => 1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 5455 [post_author] => 0 [post_date] => 2025-05-19 11:13:15 [post_date_gmt] => 2025-05-19 09:13:14 [post_content] => In the San Siro area, within an elegant newly constructed building in Class A, we offer for sale an exclusive penthouse spread over two levels. This refined residence stands out for its high-quality finishes and excellent construction quality, providing a refined and comfortable environment. The apartment comprises a large and bright living room, a fully equipped kitchen, and a dining room. The sleeping area hosts three spacious bedrooms and three windowed bathrooms, designed with high-quality materials. The apartment is enriched by the presence of two balconies and a large covered terrace, perfect for enjoying pleasant moments outdoors. Thanks to the east-west double exposure, the house enjoys exceptional brightness throughout the day. In addition, it is equipped with radiant floor heating and air conditioning, ensuring excellent energy efficiency and superior living comfort. The interior finishes include rustic oak parquet flooring in the sleeping area, flush internal doors, external aluminum frames with thermal and acoustic insulating glass, and electric shutters, in addition to a robust armored entrance door, ensuring security and quality. Completing the property, there are two cellars. There is also the possibility of purchasing two adjacent garage spaces within the building, at a price of €50,000 each. For more information or to schedule a visit, please do not hesitate to contact us. All graphic and textual documentation is purely illustrative and does not constitute a contractual obligation. [post_title] => Quadrilocale in vendita a Milano Lotto, Novara, San Siro [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => quadrilocale-in-vendita-a-milano-lotto-novara-san-siro-2 [to_ping] => [pinged] => [post_modified] => 2025-06-06 01:13:52 [post_modified_gmt] => 2025-06-05 23:13:52 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/quadrilocale-in-vendita-a-milano-lotto-novara-san-siro-2/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 18 [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 ) [query_cache_key:WP_Query:private] => wp_query:708429f51078721df52c826d72030cbd:0.90607300 1749220520 )