WP_Query Object ( [query] => Array ( [paged] => 1 [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] => 1 [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] => [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 0, 9 [posts] => Array ( [0] => WP_Post Object ( [ID] => 3998 [post_author] => 0 [post_date] => 2023-11-15 09:26:35 [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-12-02 00:13:51 [post_modified_gmt] => 2023-12-01 23:13:51 [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] => 4856 [post_author] => 0 [post_date] => 2023-11-23 15:07:24 [post_date_gmt] => 2023-11-23 14:07:24 [post_content] => In an elegant building with a communal garden, concierge and lift, we offer a bright apartment with a terrace. Inside it is made up of: entrance, living room, dining room, eat-in kitchen, four bedrooms, three bathrooms, laundry room, terrace, two balconies, large cellar. Double entrance, triple exposure on the internal garden, 3.20m ceilings. Concierge, central heating, ducted air conditioning. Parking space in the courtyard and possibility to purchase a garage in the building. All graphic and textual documentation is purely illustrative and does not constitute a contractual obligation. [post_title] => Appartamento in vendita a Milano De Angeli, Vercelli, Washington [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => appartamento-in-vendita-a-milano-de-angeli-vercelli-washington [to_ping] => [pinged] => [post_modified] => 2023-12-02 00:14:02 [post_modified_gmt] => 2023-12-01 23:14:02 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/appartamento-in-vendita-a-milano-de-angeli-vercelli-washington-2/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [2] => WP_Post Object ( [ID] => 4046 [post_author] => 0 [post_date] => 2023-11-14 11:53:05 [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 garage in the buiding. 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-12-02 00:13:54 [post_modified_gmt] => 2023-12-01 23:13:54 [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 ) [3] => WP_Post Object ( [ID] => 4782 [post_author] => 0 [post_date] => 2023-11-14 11:52:46 [post_date_gmt] => 2023-09-29 12:14:00 [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 garage. 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-2 [to_ping] => [pinged] => [post_modified] => 2023-12-02 00:13:54 [post_modified_gmt] => 2023-12-01 23:13:54 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/attico-in-vendita-a-milano-bocconi-c-so-italia-ticinese-navigli-2/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [4] => WP_Post Object ( [ID] => 4804 [post_author] => 0 [post_date] => 2023-10-20 10:17:42 [post_date_gmt] => 2023-10-18 13:13:00 [post_content] => [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] => 2023-12-02 00:14:00 [post_modified_gmt] => 2023-12-01 23:14:00 [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 ) [5] => WP_Post Object ( [ID] => 4815 [post_author] => 0 [post_date] => 2023-11-14 11:51:49 [post_date_gmt] => 2023-10-19 15:36:27 [post_content] => In the immediate vicinity of the Pasteur subway and a short distance from Corso Buenos Aires we propose a large apartment located on the second floor of an elegant building, with concierge service and elevator to the floor. The property is composed as follows: entrance hall, double living room, dining room, kitchen, 4 bedrooms, 3 bathrooms, storage room, hallway, 3 balconies. The property is completed by 2 cellars. Heating is central, enjoys triple exposure and double entrance, so the apartment is fractionable. 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 Bicocca, Greco, Monza, Palmanova Pasteur [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => appartamento-in-vendita-a-milano-bicocca-greco-monza-palmanova-pasteur [to_ping] => [pinged] => [post_modified] => 2023-12-02 00:13:59 [post_modified_gmt] => 2023-12-01 23:13:59 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/appartamento-in-vendita-a-milano-bicocca-greco-monza-palmanova-pasteur/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [6] => WP_Post Object ( [ID] => 4823 [post_author] => 0 [post_date] => 2023-11-14 11:52:11 [post_date_gmt] => 2023-10-30 12:53:46 [post_content] => In the immediate vicinity of the Pasteur subway and a short distance from Corso Buenos Aires we propose a large apartment located on the second floor of an elegant building, with concierge service and elevator to the floor. The property is composed as follows: entrance hall, double living room, dining room, kitchen, 4 bedrooms, 3 bathrooms, storage room, hallway, 3 balconies. The property is completed by 2 cellars. Heating is central, enjoys triple exposure and double entrance, so the apartment is fractionable. 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 Bicocca, Greco, Monza, Palmanova Pasteur [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => appartamento-in-vendita-a-milano-bicocca-greco-monza-palmanova-pasteur-2 [to_ping] => [pinged] => [post_modified] => 2023-12-02 00:14:00 [post_modified_gmt] => 2023-12-01 23:14:00 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/appartamento-in-vendita-a-milano-bicocca-greco-monza-palmanova-pasteur-2/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [7] => WP_Post Object ( [ID] => 4313 [post_author] => 0 [post_date] => 2023-11-16 09:38:53 [post_date_gmt] => 2023-06-16 14:03:39 [post_content] => We offer in an elegant building with concierge, a bright three-room apartment of about 100 square meters, on a high and panoramic floor. Composed of entrance, living room with balcony, kitchen with balcony, two double bedrooms, master bathroom with shower and window, second bathroom [post_title] => Trilocale in vendita a Milano Repubblica, Stazione Centrale [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => trilocale-in-vendita-a-milano-repubblica-stazione-centrale [to_ping] => [pinged] => [post_modified] => 2023-12-02 00:13:55 [post_modified_gmt] => 2023-12-01 23:13:55 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/trilocale-in-vendita-a-milano-repubblica-stazione-centrale/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [8] => WP_Post Object ( [ID] => 4735 [post_author] => 0 [post_date] => 2023-11-16 09:38:31 [post_date_gmt] => 2023-09-13 12:44:56 [post_content] => We offer in an elegant building with concierge, a bright three-room apartment of approximately 100 m2, high and panoramic floor. Consisting of entrance hall, living room with balcony, kitchen with balcony, two double bedrooms, master bathroom with shower and window, second bathroom/laundry room with window, hallway, closet, a cellar completes the property. The property has been recently renovated, in the bedrooms and living room there is polished and smooth parquet, 2.95 h ceilings. The heating is centralized and there is provision for air conditioning. 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 Repubblica, Stazione Centrale [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => trilocale-in-vendita-a-milano-repubblica-stazione-centrale-2 [to_ping] => [pinged] => [post_modified] => 2023-12-02 00:13:57 [post_modified_gmt] => 2023-12-01 23:13:57 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/trilocale-in-vendita-a-milano-repubblica-stazione-centrale-2/ [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] => 3998 [post_author] => 0 [post_date] => 2023-11-15 09:26:35 [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-12-02 00:13:51 [post_modified_gmt] => 2023-12-01 23:13:51 [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] => 10 [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] => 6ed05064e01ee5f4b957dc0b99920229 [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 ) )