Sales

Estates

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] => [static] => [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 ( ) [ignore_sticky_posts] => [suppress_filters] => [cache_results] => 1 [update_post_term_cache] => 1 [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','acf-field-group','immobile','careers' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','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] => 1674 [post_author] => 0 [post_date] => 2019-06-24 11:42:17 [post_date_gmt] => 2018-07-03 16:06:00 [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] => 2019-06-25 01:11:27 [post_modified_gmt] => 2019-06-24 23:11:27 [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 ) [1] => WP_Post Object ( [ID] => 1776 [post_author] => 0 [post_date] => 2019-06-05 13:56:25 [post_date_gmt] => 2019-02-13 17:08:21 [post_content] => San Siro, panoramic and bright penthouse of absolute value, developed on 3 levels and located in a condominium with security service 24/7 and swimming pool. The property comprises on the fifth floor of a large double living room with dining room overlooking the first terrace facing west, a kitchen that overlooks a second terrace facing east, 3 bedrooms and 3 bathrooms. On the sixth floor there is a large hobby / multimedia room with terrace, 2 bedrooms, two bathrooms, laundry and ironing room. On the seventh floor, connected by an internal staircase, there is a majestic panoramic terrace that is free on three sides. The dwelling presents in all its environments a timeless design and valuable and sustainable materials that combine well-being and essential style. Ancient and modern blend together in a harmony created by the chromatic contrast and the refined choice of materials. Worthy of note is the internal staircase that internally connects the three floors covered in wood, light and minimal but extremely solid. The property includes a large garage of about 68 square meters, ideal for parking up to 4 cars, € 150,000 request. [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-4 [to_ping] => [pinged] => [post_modified] => 2019-06-06 01:02:57 [post_modified_gmt] => 2019-06-05 23:02:57 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/attico-in-vendita-a-milano-lotto-novara-san-siro-4/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [2] => WP_Post Object ( [ID] => 1305 [post_author] => 0 [post_date] => 2019-05-21 09:40:54 [post_date_gmt] => 2017-03-28 14:16:37 [post_content] => Brera- Montenapoleone. Bright apartment located on the third floor of an elegant building with concierge all day and double lift on the floor. Inside it is composed of entrance, double living room, kitchen, three bedrooms, two windowed bathrooms, two balconies. Double exposure, central heating, air conditioning, parquet. Car garage in the building € 180,000. [post_title] => Quadrilocale in vendita a Milano Centro Storico [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => quadrilocale-in-vendita-a-milano-centro-storico [to_ping] => [pinged] => [post_modified] => 2019-05-22 01:06:39 [post_modified_gmt] => 2019-05-21 23:06:39 [post_content_filtered] => [post_parent] => 0 [guid] => http://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/quadrilocale-in-vendita-a-milano-centro-storico/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [3] => WP_Post Object ( [ID] => 1568 [post_author] => 0 [post_date] => 2019-07-02 11:16:41 [post_date_gmt] => 2018-03-27 14:51:00 [post_content] => Close to piazzetta Mondadori, very precious 125sqm apartment with two private gardens of 98sqm and 47sqm respectively. The apartment is internally composed of a double living room, dining room, kitchen, master bedroom with en suite bathroom, second bedroom, guest bathroom, gym on the basement floor. Home automation system throughout the apartment, walnut-colored aluminum frames with shatter-proof athermal glass, Sicilian stone flooring, walnut paneling, hydromassage bath with chromotherapy, Turkish bath, gym with Tecnogym equipment. Newly built condominium with concierge, video surveillance, lift to the floor. Possibility of double garage in the building. [post_title] => Quadrilocale in vendita a Milano Centro Storico [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => quadrilocale-in-vendita-a-milano-centro-storico-3 [to_ping] => [pinged] => [post_modified] => 2019-07-03 01:01:40 [post_modified_gmt] => 2019-07-02 23:01:40 [post_content_filtered] => [post_parent] => 0 [guid] => http://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/quadrilocale-in-vendita-a-milano-centro-storico-3/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [4] => WP_Post Object ( [ID] => 1501 [post_author] => 0 [post_date] => 2019-02-13 14:42:04 [post_date_gmt] => 2018-01-18 16:40:36 [post_content] => The main feature of this house is to be independent, with an independent entrance and therefore not within a condominium. Located on the second floor of three, it has an independent pedestrian entrance as well as an elevator connected to the underlying available space of approx. 35 and at the garage. Composed of living room / kitchen (50 sqm) with fireplace, small study, laundry room, 3 large and bright bedrooms and 2 bathrooms, terrace. The property includes a parking space in a covered garage connected to the house and an outdoor parking space. Lovely panorama. CHF 1,690,000 for residents in Switzerland. CHF 1,990,000 for non-residents. [post_title] => Appartamento in vendita a St. Moritz [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => appartamento-in-vendita-a-st-moritz [to_ping] => [pinged] => [post_modified] => 2019-02-14 00:04:22 [post_modified_gmt] => 2019-02-13 23:04:22 [post_content_filtered] => [post_parent] => 0 [guid] => http://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/appartamento-in-vendita-a-madulain/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [5] => WP_Post Object ( [ID] => 1459 [post_author] => 1 [post_date] => 2019-05-20 17:37:51 [post_date_gmt] => 2017-10-16 13:30:20 [post_content] => Conca del Naviglio - Penthouse with terrace entirely renovated. Composed of livingroom with fireplace, terrace, kitchen, two bedrooms, two bathrooms, laundry room, storage room, two balconies, cellar. Very bright and very peaceful apartment. Central heating, air conditioning, parquet, customized furnitures. [post_title] => Trilocale in vendita a Milano Centro Storico Conca del Naviglio [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => trilocale-in-vendita-a-milano-centro-storico-conca-del-naviglio [to_ping] => [pinged] => [post_modified] => 2019-05-21 01:05:58 [post_modified_gmt] => 2019-05-20 23:05:58 [post_content_filtered] => [post_parent] => 0 [guid] => http://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/trilocale-in-vendita-a-milano-centro-storico-conca-del-naviglio/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [6] => WP_Post Object ( [ID] => 1717 [post_author] => 0 [post_date] => 2019-05-21 09:39:05 [post_date_gmt] => 2018-10-29 13:58:04 [post_content] => San Siro, panoramic and bright high representative apartment on the eighth floor in the prestigious building of Pinerolo with concierge 24 hours a day. The apartment has a double living room overlooking the terrace, dining room, 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 in all rooms. Swimming pool and tennis courts for the exclusive use of condominiums. Quadruple box in the codomain, 100,000 euros request. The apartment is currently rented for a fee of 48,000 / year plus expenses with a 4 + 4 contract expiring on 31 December 2018 (first expiry) and 31 December 2022 (second expiry). Excellent as an investment. [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] => 2019-05-22 01:06:42 [post_modified_gmt] => 2019-05-21 23:06:42 [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 ) [7] => WP_Post Object ( [ID] => 1677 [post_author] => 0 [post_date] => 2018-07-06 17:17:33 [post_date_gmt] => 2018-07-06 15:17:33 [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] => 2018-07-07 01:03:00 [post_modified_gmt] => 2018-07-06 23:03:00 [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 ) [8] => WP_Post Object ( [ID] => 1801 [post_author] => 0 [post_date] => 2019-05-20 16:35:53 [post_date_gmt] => 2019-02-27 16:27:02 [post_content] => Camogli center, elegant and bright apartment of absolute value with sea view. The apartment consists of entrance hall, kitchen, living room, four bedrooms, two bathrooms, utility room, two balconies. Independent heating, air conditioning, fine finishes. Possibility box and cellar. Free to deed. [post_title] => Appartamento in vendita a Camogli [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => appartamento-in-vendita-a-camogli [to_ping] => [pinged] => [post_modified] => 2019-05-22 01:07:03 [post_modified_gmt] => 2019-05-21 23:07:03 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/appartamento-in-vendita-a-camogli/ [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] => 1674 [post_author] => 0 [post_date] => 2019-06-24 11:42:17 [post_date_gmt] => 2018-07-03 16:06:00 [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] => 2019-06-25 01:11:27 [post_modified_gmt] => 2019-06-24 23:11:27 [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 ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 22 [max_num_pages] => 3 [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_posts_page] => [is_post_type_archive] => 1 [query_vars_hash:WP_Query:private] => e80586a5ee78935a712b207a648de938 [query_vars_changed:WP_Query:private] => [thumbnails_cached] => [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 ) )
Private negotiation

Villa in vendita a Olbia

Via Punta Lada, Olbia 07026
  • Surface: 200m2
  • 4
  • 4
2.350.000€
  • Surface: 425m2
  • 5
  • 5
1.980.000€

Quadrilocale in vendita a Milano Centro Storico

Piazza Sant'Erasmo , Milano 20121
  • Surface: 170m2
  • 3
  • 2
1.575.000€

Quadrilocale in vendita a Milano Centro Storico

Via Santa Lucia, Milano 20122
  • Surface: 200m2
  • 2
  • 2
1.440.000€
  • Surface: 160m2
  • 3
  • 2
1.390.000€
  • Surface: 155m2
  • 2
  • 2
1.390.000€
  • Surface: 300m2
  • 5
  • 3
880.000€

Appartamento in vendita a Bordighera

Piazza Eroi Della Libertà, Bordighera 18012
  • Surface: 215m2
  • 9
  • 2
790.000€

Appartamento in vendita a Camogli

Via Bozzo, Camogli 16032
  • Surface: 160m2
  • 4
  • 2