WP_Query Object ( [query] => Array ( [paged] => 1 [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] => 1 [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 0, 9 [posts] => Array ( [0] => WP_Post Object ( [ID] => 5359 [post_author] => 0 [post_date] => 2025-02-19 15:22:59 [post_date_gmt] => 2025-02-06 15:42:00 [post_content] => Porta Romana, in the immediate vicinity of the Franco Parenti Theater and Bagni Misteriosi swimming pools, bright penthouse on two levels with terraces, triple exposure and panoramic view of the Duomo, Velasca Tower, Porta Nuova skyscrapers. THE PENTHOUSE is located on the eighth and ninth floors of an elegant building with concierge, communal garden and lift to the floor. On the eighth floor there is an entrance hall, large living room with dining room and terrace, kitchen with terrace, three bedrooms, three bathrooms, laundry room. The ninth floor attic, connected by an internal staircase, is composed of two bedrooms, a large bathroom, living room with open kitchen, utility room, large panoramic terrace on three sides. The attic also has external access from the condominium stairs. Central heating, air conditioning, parquet, cellar. Ceiling height h 2.75. Double garage in the 30m2 building €100,000. Contact us to view the property. All graphic and textual documentation is purely illustrative and does not constitute a contractual obligation. [post_title] => Attico in vendita a Milano V Giornate, XXII Marzo, Porta Romana, Viale Corsica [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => attico-in-vendita-a-milano-v-giornate-xxii-marzo-porta-romana-viale-corsica-2 [to_ping] => [pinged] => [post_modified] => 2025-07-01 01:18:41 [post_modified_gmt] => 2025-06-30 23:18:41 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/attico-in-vendita-a-milano-v-giornate-xxii-marzo-porta-romana-viale-corsica-2/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [1] => WP_Post Object ( [ID] => 5344 [post_author] => 0 [post_date] => 2025-02-19 15:15:03 [post_date_gmt] => 2025-01-29 16:44:00 [post_content] => Porta Romana, in the immediate vicinity of the Franco Parenti Theater and Bagni Misteriosi swimming pools, bright penthouse on two levels with terraces, triple exposure and panoramic view of the Duomo, Velasca Tower, Porta Nuova skyscrapers. THE PENTHOUSE is located on the eighth and ninth floors of an elegant building with concierge, communal garden and lift to the floor. On the eighth floor there is an entrance hall, large living room with dining room and terrace, kitchen with terrace, three bedrooms, three bathrooms, laundry room. The ninth floor attic, connected by an internal staircase, is composed of two bedrooms, a large bathroom, living room with open kitchen, utility room, large panoramic terrace on three sides. The attic also has external access from the condominium stairs. Central heating, air conditioning, parquet, cellar. Ceiling height h 2.75. Double garage in the 30m2 building €100,000. Contact us to view the property. All graphic and textual documentation is purely illustrative and does not constitute a contractual obligation. [post_title] => Attico in vendita a Milano V Giornate, XXII Marzo, Porta Romana, Viale Corsica [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => attico-in-vendita-a-milano-v-giornate-xxii-marzo-porta-romana-viale-corsica [to_ping] => [pinged] => [post_modified] => 2025-07-01 01:18:32 [post_modified_gmt] => 2025-06-30 23:18:32 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/attico-in-vendita-a-milano-v-giornate-xxii-marzo-porta-romana-viale-corsica/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [2] => WP_Post Object ( [ID] => 5370 [post_author] => 0 [post_date] => 2025-05-14 16:43:49 [post_date_gmt] => 2025-02-20 10:23:55 [post_content] => Discover the beauty of Villa Tartaruga, located in the prestigious resort of Punta Lada, Porto Rotondo. This splendid villa, completely renovated, offers a breathtaking view of the Porto Rotondo beach, guaranteeing an exclusive living experience. Surrounded on three sides by a large private garden, the villa is perfect for those seeking tranquility and contact with nature. Inside, you will find a large living room that opens onto a panoramic terrace, ideal for al fresco dining or moments of relaxation overlooking the sea. The equipped kitchen will satisfy even the most demanding cooks. With four bedrooms and as many bathrooms, Villa Tartaruga can comfortably accommodate up to eight people, offering space and privacy to all guests. The large outdoor spaces are perfect for welcoming families and friends, while the internal parking spaces can accommodate up to three cars. Furthermore, you will have exclusive access to the Marina Piccola Sailing Center, a beach reserved for residents. Porto Rotondo is one of the most renowned tourist destinations in Sardinia, famous for its enchanting beaches such as Spiaggia Marinella and Punta degli Asfodeli. The tourist port with 800 berths is a point of reference for boating lovers. With a commercial area of ​​300 m², five rooms, four bathrooms, terrace and balcony, Villa Tartaruga represents an unmissable opportunity for those who want to live in a dream place. Don't miss the opportunity to own a piece of paradise in one of the most fascinating places in Sardinia! All graphic and textual documentation is purely illustrative and does not constitute a contractual obligation. [post_title] => Villa in vendita a Olbia [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => villa-in-vendita-a-olbia [to_ping] => [pinged] => [post_modified] => 2025-07-01 01:18:33 [post_modified_gmt] => 2025-06-30 23:18:33 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/villa-in-vendita-a-olbia/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [3] => WP_Post Object ( [ID] => 5478 [post_author] => 0 [post_date] => 2025-06-27 10:39:13 [post_date_gmt] => 2025-06-18 14:49:28 [post_content] => Au cœur du prestigieux quartier de Brera, nous proposons à la vente un spacieux deux-pièces avec terrasse entièrement rénovée. Situé dans un immeuble de standing, l’appartement se distingue par sa luminosité et la répartition élégante de ses espaces. L’entrée mène à un vaste séjour accueillant, jouxté par une cuisine séparée. L’espace nuit comprend une grande chambre double avec dressing, tandis que la salle de bains avec fenêtre offre confort et fonctionnalité. Un pratique débarras complète le bien. Atout supplémentaire : une grande terrasse, idéale pour se détendre ou recevoir à l’extérieur. Doté d’un système de chauffage et de climatisation autonomes, il garantit un confort optimal en toute saison. Une opportunité unique pour ceux qui souhaitent vivre dans l’un des quartiers les plus prisés et recherchés de la ville. Contactez-nous pour organiser une visite. Toute la documentation graphique et textuelle est à but purement illustratif et ne constitue pas un engagement contractuel. [post_title] => Bilocale in vendita a Milano Centro Storico [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => bilocale-in-vendita-a-milano-centro-storico [to_ping] => [pinged] => [post_modified] => 2025-07-01 01:18:47 [post_modified_gmt] => 2025-06-30 23:18:47 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/bilocale-in-vendita-a-milano-centro-storico-2/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [4] => WP_Post Object ( [ID] => 3986 [post_author] => 0 [post_date] => 2023-10-19 17:17:16 [post_date_gmt] => 2022-09-11 21:21:20 [post_content] => Bordighera, in the central Piazza Eroi della Libertà, large and bright commercial space of about 350sqm in a period building of the early '900. The property is spread over two levels: ground floor of about 320sqm and basement of about 70 square meters connected by an internal staircase. The real estate unit lends itself to various commercial solutions, has a high visibility, excellent position of passage, triple exposure with shop windows on the street and private entrance. Free immediately. [post_title] => Locale Commerciale in vendita a Bordighera [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => locale-commerciale-in-vendita-a-bordighera [to_ping] => [pinged] => [post_modified] => 2025-07-01 01:18:31 [post_modified_gmt] => 2025-06-30 23:18:31 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/locale-commerciale-in-vendita-a-bordighera-2/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [5] => WP_Post Object ( [ID] => 5388 [post_author] => 0 [post_date] => 2025-05-26 11:37:37 [post_date_gmt] => 2025-03-25 17:14:43 [post_content] => Splendid apartment for sale in the prestigious condominium in via Pinerolo in San Siro, perfect for those looking for an exclusive and refined environment. Located on the eleventh floor of an elegant building, the property boasts two large terraces, ideal for moments of relaxation with a breathtaking view of the city center. The apartment has a double living room with a large and bright dining room, eat-in kitchen, five bedrooms, three bathrooms and two closets. A perfect solution to accommodate a large family or for those who love generous spaces. The condominium has a large communal garden and a supervised swimming pool. Concierge active 24H every day of the week. The orientation on three sides ensures perfect natural light at any time of the day. In addition, central heating and air conditioning offer comfort in every season. Large 48m2 garage in the building €100,000. Contact us for more information and to organize a viewing. All graphic and textual documentation is purely illustrative and does not constitute a contractual obligation. [post_title] => Appartamento in vendita a Milano Lotto, Novara, San Siro [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => appartamento-in-vendita-a-milano-lotto-novara-san-siro [to_ping] => [pinged] => [post_modified] => 2025-07-01 01:18:42 [post_modified_gmt] => 2025-06-30 23:18:42 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/appartamento-in-vendita-a-milano-lotto-novara-san-siro/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [6] => WP_Post Object ( [ID] => 5439 [post_author] => 0 [post_date] => 2025-06-06 10:39:12 [post_date_gmt] => 2025-04-29 13:46:23 [post_content] => Splendid apartment for sale in the prestigious condominium in via Pinerolo in San Siro, perfect for those looking for an exclusive and refined environment. Located on the eleventh floor of an elegant building, the property boasts two large terraces, ideal for moments of relaxation with a breathtaking view of the city center. The apartment has a double living room with a large and bright dining room, eat-in kitchen, five bedrooms, three bathrooms and two closets. A perfect solution to accommodate a large family or for those who love generous spaces. The condominium has a large communal garden and a supervised swimming pool. Concierge active 24H every day of the week. The orientation on three sides ensures perfect natural light at any time of the day. In addition, central heating and air conditioning offer comfort in every season. Large 48m2 garage in the building €100,000. Contact us for more information and to organize a viewing. All graphic and textual documentation is purely illustrative and does not constitute a contractual obligation. [post_title] => Appartamento in vendita a Milano Lotto, Novara, San Siro [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => appartamento-in-vendita-a-milano-lotto-novara-san-siro-2 [to_ping] => [pinged] => [post_modified] => 2025-07-01 01:18:46 [post_modified_gmt] => 2025-06-30 23:18:46 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/appartamento-in-vendita-a-milano-lotto-novara-san-siro-2/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [7] => WP_Post Object ( [ID] => 4804 [post_author] => 0 [post_date] => 2024-08-27 12:33:39 [post_date_gmt] => 2023-10-18 13:13:00 [post_content] => A short distance from Florence and the new Viola Park sports center, a center owned by the Italian football club ACF Fiorentina, we offer a splendid panoramic villa on three levels with a large garden and terraces. On the ground floor we find a double living room with fireplace, study, kitchen, dining room, bathroom with window, large patio and outdoor garden. On the first floor we have two bedrooms with two bathrooms with windows, a large panoramic terrace. On the second floor an attic room with bathroom, panoramic terrace. The villa has two main entrances, pedestrian from the main road and secondary with driveway to access the property directly by car. The property includes a double garage directly connected to the villa and a cellar. This residence is ideal for those seeking the tranquility of the Florentine countryside a short distance from the city. Contact us to view the property. All graphic and textual documentation is purely illustrative and does not constitute a contractual obligation. Bagno a Ripoli covers an area of ​​approximately 74 km² and extends east of Florence on flat land for approximately a third of its surface and for the remaining part on hilly terrain. It occupies the Valdarno Superiore area on one side and a part of Chianti on the other. As the capital grew in size, the town of Bagno a Ripoli is now located on the border of the city of Florence, with the two inhabited centers which today join together without an obvious border. [post_title] => Villa in vendita a Bagno a Ripoli [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => villa-in-vendita-a-bagno-a-ripoli [to_ping] => [pinged] => [post_modified] => 2025-07-01 01:18:37 [post_modified_gmt] => 2025-06-30 23:18:37 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/villa-in-vendita-a-bagno-a-ripoli/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [8] => 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-07-01 01:18:43 [post_modified_gmt] => 2025-06-30 23:18:43 [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 ) ) [post_count] => 9 [current_post] => -1 [before_loop] => 1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 5359 [post_author] => 0 [post_date] => 2025-02-19 15:22:59 [post_date_gmt] => 2025-02-06 15:42:00 [post_content] => Porta Romana, in the immediate vicinity of the Franco Parenti Theater and Bagni Misteriosi swimming pools, bright penthouse on two levels with terraces, triple exposure and panoramic view of the Duomo, Velasca Tower, Porta Nuova skyscrapers. THE PENTHOUSE is located on the eighth and ninth floors of an elegant building with concierge, communal garden and lift to the floor. On the eighth floor there is an entrance hall, large living room with dining room and terrace, kitchen with terrace, three bedrooms, three bathrooms, laundry room. The ninth floor attic, connected by an internal staircase, is composed of two bedrooms, a large bathroom, living room with open kitchen, utility room, large panoramic terrace on three sides. The attic also has external access from the condominium stairs. Central heating, air conditioning, parquet, cellar. Ceiling height h 2.75. Double garage in the 30m2 building €100,000. Contact us to view the property. All graphic and textual documentation is purely illustrative and does not constitute a contractual obligation. [post_title] => Attico in vendita a Milano V Giornate, XXII Marzo, Porta Romana, Viale Corsica [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => attico-in-vendita-a-milano-v-giornate-xxii-marzo-porta-romana-viale-corsica-2 [to_ping] => [pinged] => [post_modified] => 2025-07-01 01:18:41 [post_modified_gmt] => 2025-06-30 23:18:41 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/attico-in-vendita-a-milano-v-giornate-xxii-marzo-porta-romana-viale-corsica-2/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 15 [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] => [is_admin] => [is_attachment] => [is_singular] => [is_robots] => [is_favicon] => [is_posts_page] => [is_post_type_archive] => 1 [query_vars_hash:WP_Query:private] => 9ac7e3a08822a47f35ba1af9a3252ea6 [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:73a169462b70904ab2b66b560b6af2fc:0.42381300 1751336300 )