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] => [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] => 3998 [post_author] => 0 [post_date] => 2023-03-03 17:30:50 [post_date_gmt] => 2022-03-03 16:18:55 [post_content] => Porto Rotondo, one of the most important realities of national and international tourism, spearhead of the north-eastern coast of Sardinia. The territory is divided into three "points": Punta Nuraghe, Punta Volpe, Punta Lada and welcomes the prestigious villas of important figures of culture, fashion, business and politics, half hidden by lush Mediterranean vegetation. The suggestive beaches are the crown of the District and its marina that offers 800 berths. Among the most famous beaches: Marinella Beach is defined by the locals as one of the most beautiful and spacious. The sand is extremely fine and almost dazzling whiteness, the seabed is low and sandy, perfect for allowing children to play freely. There is a fully equipped bathhouse to make the holiday a moment of relaxation; Punta degli Asfodeli is a collection of small beaches and rocky coves where you can choose once you arrive. Porto Rotondo is a magical and wonderful place, ideal for holidays for families or couples. Villa Tartaruga is located in the locality of Punta Lada, an exclusive and private place, within the residential complex of MARINA PICCOLA and the Centro Vela Marina Piccola, whose access is allowed only to the owners of the residences and their guests. The villa is surrounded on three sides by a large private garden that overlooks the suggestive view of Punta Lada. The large outdoor areas are equipped to accommodate families and guests for moments of conviviality, leisure and relaxation. Inside we are greeted by a large living room, overlooking the panoramic terrace, equipped kitchen, four bedrooms and four bathrooms. Internal parking spaces for up to three cars. The villa can accommodate up to 8 people. Weekly rent (minimum stay 2 weeks): - June € 4,200 - July € 5.500 - August € 7,000 - September € 4,200 Cleaning fee at the end of stay: € 300 Extra sheets change € 50 Check in Monday 10-12 Check out on Sunday 10-12am Entrance to Marina Piccola Sailing Center on request: € 1.500 tot (max 6 people) Services included in the fee of the Sailing Center: swimming pool, basketball court, beach access, 1 beach umbrella 2 deck chairs, kiosk with barbecue and fridge, possibility to rent a canoa. Possibility to rent a boat. [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] => 2023-03-06 10:02:43 [post_modified_gmt] => 2023-03-06 09:02:43 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/villa-in-vendita-a-olbia-2/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [1] => WP_Post Object ( [ID] => 4004 [post_author] => 0 [post_date] => 2023-05-17 14:30:14 [post_date_gmt] => 2023-02-07 16:01:42 [post_content] => San Siro, panoramic and bright prestigious penthouse developed on three levels connected by an internal staircase and located in a condominium with garden and 24-hour security. The property comprises on the sixth floor entrance hall, double living room with terrace, kitchen with terrace, study, 4 bedrooms, 4 bathrooms, walk-in closet. On the seventh floor there is a large bedroom/living room with wardrobe, bathroom, balcony. On the eighth floor we find the large panoramic terrace with partially covered swimming pool and bathroom. The property has fine finishes, central heating, split air conditioning. In the basement there is the opportunity to purchase a large single garage of 18 m2 or a quadruple garage of 58 m2 c. to. 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 Lotto, Novara, San Siro [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => attico-in-vendita-a-milano-lotto-novara-san-siro-3 [to_ping] => [pinged] => [post_modified] => 2023-05-18 09:38:01 [post_modified_gmt] => 2023-05-18 07:38:01 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/attico-in-vendita-a-milano-lotto-novara-san-siro-8/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [2] => WP_Post Object ( [ID] => 3986 [post_author] => 0 [post_date] => 2022-09-11 23:21:21 [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-2 [to_ping] => [pinged] => [post_modified] => 2023-02-13 12:09:05 [post_modified_gmt] => 2023-02-13 11:09:05 [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 ) [3] => WP_Post Object ( [ID] => 4046 [post_author] => 0 [post_date] => 2023-05-23 16:33:35 [post_date_gmt] => 2023-02-10 14:25:51 [post_content] => In the immediate vicinity of Bocconi and a few steps from the Prada Foundation, we offer a prestigious penthouse developed on two levels, with a panoramic terrace. The property is composed as follows: on the eighth floor there is an entrance hall, double living room, dinette, kitchen, four bedrooms, three bathrooms and three balconies. An internal staircase leads from the apartment to the ninth floor where we find a greenhouse, a veranda and a large panoramic terrace. The interiors and the original custom-made furniture are the result of a project carried out by the prestigious Muzio studio by architects Lorenzo Muzio and Mirella Zevi in ​​the 1970s. Triple exposure, central heating, ceiling height h 2.90, concierge service and night watchman, video surveillance, Club House with swimming pool reserved for condominiums, tennis court, soccer field, children's play area. Residential area well served by means of transport: Tram 3 and 15 stop in the direction of the Duomo and the brand new Circle Line with Tibaldi Bocconi station, one stop away from Romolo M2 and Lodi / Villaggio Olimpico M3 and two stops from Forlanini station, interconnected to the new M4 line for Linate. Possibility of single garage € 75,000; possibility of double garage € 100,000. All graphic and textual documentation is purely illustrative and does not constitute a contractual obligation. [post_title] => Attico in vendita a Milano Bocconi, C.so Italia, Ticinese Navigli [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => attico-in-vendita-a-milano-bocconi-c-so-italia-ticinese-navigli [to_ping] => [pinged] => [post_modified] => 2023-05-24 09:22:31 [post_modified_gmt] => 2023-05-24 07:22:31 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/appartamento-in-vendita-a-milano-fiera-firenze-sempione-city-life/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [4] => WP_Post Object ( [ID] => 4055 [post_author] => 0 [post_date] => 2023-03-22 16:04:36 [post_date_gmt] => 2023-02-10 14:25:51 [post_content] => In an elegant 60s context with concierge, we offer for sale a splendid apartment on the sixth floor. The property, with large spaces and double exposure, comprises entrance hall, double living room, five bedrooms, three bathrooms, three balconies, cellar. The position in which the property is located is particularly convenient for accessing the Leone XIII schools and the San Carlo college, the proximity to the Pallavicino park is a favorite with families with children and in a few minutes it is possible to reach the City Life shopping center . All graphic and textual documentation is purely illustrative and does not constitute a contractual obligation. [post_title] => Appartamento in vendita a Milano Fiera, Firenze, Sempione City Life [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => appartamento-in-vendita-a-milano-fiera-firenze-sempione-city-life [to_ping] => [pinged] => [post_modified] => 2023-03-23 09:12:52 [post_modified_gmt] => 2023-03-23 08:12:52 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/appartamento-in-vendita-a-milano-fiera-firenze-sempione-city-life/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [5] => WP_Post Object ( [ID] => 3828 [post_author] => 1 [post_date] => 2023-04-20 14:32:00 [post_date_gmt] => 2022-12-05 17:04:12 [post_content] => Splendid farmhouse immersed in the greenery and quiet of the Piacenza hills. The property is spread over several levels: basement, ground floor, first floor, second floor. Inside it consists of 5 bedrooms, 5 bathrooms, 2 kitchens, a double living room, a dining room with dining area, hobby room, service area with laundry, woodshed. On the second floor we find an attic with double living room, study, bedroom, bathroom. Large courtyard of approximately 100m2 and garden of approximately 76m2 including 2 parking spaces. Ideal as a second home for those looking for a place to relax, a short distance from Milan and Piacenza. All graphic and textual documentation is purely illustrative and does not constitute a contractual obligation. [post_title] => Rustico in vendita a Ziano Piacentino [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => rustico-in-vendita-a-ziano-piacentino-2 [to_ping] => [pinged] => [post_modified] => 2023-04-21 09:28:01 [post_modified_gmt] => 2023-04-21 07:28:01 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/appartamento-in-vendita-a-milano-fiera-firenze-sempione-city-life/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [6] => WP_Post Object ( [ID] => 4028 [post_author] => 0 [post_date] => 2023-03-20 14:28:20 [post_date_gmt] => 2022-10-01 19:54:31 [post_content] => San Siro, panoramic and bright apartment on the eighth floor in the prestigious context of Pinerolo with shared swimming pool and 24-hour concierge The apartment has a triple living room overlooking the terrace, kitchen with terrace, 5 bedrooms, 3 bathrooms with windows, closet. Marble flooring in the living area and ceramic in the sleeping area, central heating, air conditioning, ceilings h 2.80, triple exposure. Quadruple box in the codominio, request € 150,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 Lotto, Novara, San Siro [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => attico-in-vendita-a-milano-lotto-novara-san-siro [to_ping] => [pinged] => [post_modified] => 2023-03-21 11:23:04 [post_modified_gmt] => 2023-03-21 10:23:04 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/attico-in-vendita-a-milano-lotto-novara-san-siro-10/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [7] => WP_Post Object ( [ID] => 4191 [post_author] => 0 [post_date] => 2023-04-03 17:35:10 [post_date_gmt] => 2023-04-03 15:35:10 [post_content] => San Siro, panoramic and bright apartment on the eighth floor in the prestigious context of Pinerolo with shared swimming pool and 24-hour concierge The apartment has a triple living room overlooking the terrace, kitchen with terrace, 5 bedrooms, 3 bathrooms with windows, closet. Marble flooring in the living area and ceramic in the sleeping area, central heating, air conditioning, ceilings h 2.80, triple exposure. Quadruple box in the codominio, request € 150,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 Lotto, Novara, San Siro [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => attico-in-vendita-a-milano-lotto-novara-san-siro-2 [to_ping] => [pinged] => [post_modified] => 2023-04-04 09:27:50 [post_modified_gmt] => 2023-04-04 07:27:50 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/attico-in-vendita-a-milano-lotto-novara-san-siro-2/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [8] => WP_Post Object ( [ID] => 4188 [post_author] => 0 [post_date] => 2023-04-03 17:35:32 [post_date_gmt] => 2023-04-03 15:35:31 [post_content] => San Siro, panoramic and bright apartment on the eighth floor in the prestigious context of Pinerolo with shared swimming pool and 24-hour concierge The apartment has a triple living room overlooking the terrace, kitchen with terrace, 5 bedrooms, 3 bathrooms with windows, closet. Marble flooring in the living area and ceramic in the sleeping area, central heating, air conditioning, ceilings h 2.80, triple exposure. Quadruple box in the codominio, request € 150,000. Contact us to view the property. 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] => 2023-04-04 09:27:48 [post_modified_gmt] => 2023-04-04 07:27:48 [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 ) ) [post_count] => 9 [current_post] => -1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 3998 [post_author] => 0 [post_date] => 2023-03-03 17:30:50 [post_date_gmt] => 2022-03-03 16:18:55 [post_content] => Porto Rotondo, one of the most important realities of national and international tourism, spearhead of the north-eastern coast of Sardinia. The territory is divided into three "points": Punta Nuraghe, Punta Volpe, Punta Lada and welcomes the prestigious villas of important figures of culture, fashion, business and politics, half hidden by lush Mediterranean vegetation. The suggestive beaches are the crown of the District and its marina that offers 800 berths. Among the most famous beaches: Marinella Beach is defined by the locals as one of the most beautiful and spacious. The sand is extremely fine and almost dazzling whiteness, the seabed is low and sandy, perfect for allowing children to play freely. There is a fully equipped bathhouse to make the holiday a moment of relaxation; Punta degli Asfodeli is a collection of small beaches and rocky coves where you can choose once you arrive. Porto Rotondo is a magical and wonderful place, ideal for holidays for families or couples. Villa Tartaruga is located in the locality of Punta Lada, an exclusive and private place, within the residential complex of MARINA PICCOLA and the Centro Vela Marina Piccola, whose access is allowed only to the owners of the residences and their guests. The villa is surrounded on three sides by a large private garden that overlooks the suggestive view of Punta Lada. The large outdoor areas are equipped to accommodate families and guests for moments of conviviality, leisure and relaxation. Inside we are greeted by a large living room, overlooking the panoramic terrace, equipped kitchen, four bedrooms and four bathrooms. Internal parking spaces for up to three cars. The villa can accommodate up to 8 people. Weekly rent (minimum stay 2 weeks): - June € 4,200 - July € 5.500 - August € 7,000 - September € 4,200 Cleaning fee at the end of stay: € 300 Extra sheets change € 50 Check in Monday 10-12 Check out on Sunday 10-12am Entrance to Marina Piccola Sailing Center on request: € 1.500 tot (max 6 people) Services included in the fee of the Sailing Center: swimming pool, basketball court, beach access, 1 beach umbrella 2 deck chairs, kiosk with barbecue and fridge, possibility to rent a canoa. Possibility to rent a boat. [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] => 2023-03-06 10:02:43 [post_modified_gmt] => 2023-03-06 09:02:43 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/villa-in-vendita-a-olbia-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 ) )