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] => 5384 [post_author] => 0 [post_date] => 2025-05-06 10:16:11 [post_date_gmt] => 2025-03-17 17:07:15 [post_content] => In one of the most prestigious streets of the city, San Martino, we offer a splendid three-room apartment in the exclusive context of a villa with a large and private communal garden. The apartment consists of an entrance hall, living room, kitchen, bedroom, two bathrooms with windows and a practical laundry room. Possibility of creating a second bedroom. Thanks to the two balconies and its triple exposure on the communal garden you will be able to enjoy moments of relaxation in the open air without giving up privacy. The double entrance and double lift on the floor add a touch of exclusivity and comfort. The property is equipped with piped music systems to accompany evenings in company with friends. Central heating, independent air conditioning, preparation of the alarm system, concierge. There is a cellar included in the price and the possibility of purchasing a single garage in the building for €100,000. This apartment is perfect for those seeking elegance and tranquility without giving up the convenience of the city center. Contact us to view the property. All graphic and textual documentation is purely illustrative 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] => 2025-05-09 01:06:27 [post_modified_gmt] => 2025-05-08 23:06:27 [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] => 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-05-09 01:06:21 [post_modified_gmt] => 2025-05-08 23:06:21 [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 ) [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-05-09 01:06:29 [post_modified_gmt] => 2025-05-08 23:06:29 [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] => 5301 [post_author] => 0 [post_date] => 2025-04-29 12:44:44 [post_date_gmt] => 2024-11-19 15:42:48 [post_content] => San Siro area, we offer for sale a large three-room apartment with terrace in an elegant building with lift to the floor. Inside it is composed of: entrance, living room with terrace, partially open kitchen with large balcony, hallway sleeping area, master bedroom with en-suite bathroom with window, second bedroom and second bathroom with tub with window, cellar. Autonomous heating, air conditioning, parquet, triple exposure. Possibility of purchasing a double garage in the building €80,000. Contact us to view the property. All graphic and textual documentation is purely illustrative and does not constitute a contractual obligation. [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-05-09 01:06:25 [post_modified_gmt] => 2025-05-08 23:06:25 [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 ) [4] => 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-05-09 01:06:17 [post_modified_gmt] => 2025-05-08 23:06:17 [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 ) [5] => 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-05-09 01:06:32 [post_modified_gmt] => 2025-05-08 23:06:32 [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 ) [6] => 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-05-09 01:06:22 [post_modified_gmt] => 2025-05-08 23:06:22 [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 ) [7] => 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-05-09 01:06:20 [post_modified_gmt] => 2025-05-08 23:06:20 [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] => 8 [current_post] => -1 [before_loop] => 1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 5384 [post_author] => 0 [post_date] => 2025-05-06 10:16:11 [post_date_gmt] => 2025-03-17 17:07:15 [post_content] => In one of the most prestigious streets of the city, San Martino, we offer a splendid three-room apartment in the exclusive context of a villa with a large and private communal garden. The apartment consists of an entrance hall, living room, kitchen, bedroom, two bathrooms with windows and a practical laundry room. Possibility of creating a second bedroom. Thanks to the two balconies and its triple exposure on the communal garden you will be able to enjoy moments of relaxation in the open air without giving up privacy. The double entrance and double lift on the floor add a touch of exclusivity and comfort. The property is equipped with piped music systems to accompany evenings in company with friends. Central heating, independent air conditioning, preparation of the alarm system, concierge. There is a cellar included in the price and the possibility of purchasing a single garage in the building for €100,000. This apartment is perfect for those seeking elegance and tranquility without giving up the convenience of the city center. Contact us to view the property. All graphic and textual documentation is purely illustrative 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] => 2025-05-09 01:06:27 [post_modified_gmt] => 2025-05-08 23:06:27 [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] => 17 [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] => 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:944cf47daa63c507ff8053eb60af90a5:0.09933300 1746818846 )