Sales

Estates

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] => categoria_immobile [value] => Residenziale [compare] => = ) [3] => 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] => categoria_immobile [value] => Residenziale [compare] => = ) [3] => 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] => stato_costruzione [value] => Nuovo [compare] => != ) [1] => Array ( [key] => contratto [value] => vendita [compare] => = ) [2] => Array ( [key] => categoria_immobile [value] => Residenziale [compare] => = ) [3] => 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 [4] => mt4 ) [clauses:protected] => Array ( [wp_postmeta] => Array ( [key] => prezzo_immobile [compare] => = [alias] => wp_postmeta [cast] => CHAR ) [mt1] => Array ( [key] => stato_costruzione [value] => Nuovo [compare] => != [alias] => mt1 [cast] => CHAR ) [mt2] => Array ( [key] => contratto [value] => vendita [compare] => = [alias] => mt2 [cast] => CHAR ) [mt3] => Array ( [key] => categoria_immobile [value] => Residenziale [compare] => = [alias] => mt3 [cast] => CHAR ) [mt4] => Array ( [key] => riferimento_immobile [value] => VENDUTO [compare] => != [alias] => mt4 [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 ) INNER JOIN wp_postmeta AS mt4 ON ( wp_posts.ID = mt4.post_id ) JOIN wp_icl_translations t ON wp_posts.ID = t.element_id AND t.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 = 'categoria_immobile' AND mt3.meta_value = 'Residenziale' ) AND ( mt4.meta_key = 'riferimento_immobile' AND mt4.meta_value != 'VENDUTO' ) ) ) AND wp_posts.post_type = 'immobile' AND ((wp_posts.post_status = 'publish')) AND ( ( ( t.language_code = 'en' OR 0 ) AND wp_posts.post_type IN ('post','page','acf-field-group','immobile','careers' ) ) OR wp_posts.post_type NOT IN ('post','page','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] => 2018-07-06 17:02:41 [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] => 2018-07-08 01:01:53 [post_modified_gmt] => 2018-07-07 23:01:53 [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] => 1305 [post_author] => 0 [post_date] => 2018-07-06 17:07:50 [post_date_gmt] => 2017-03-28 14:16:37 [post_content] => [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] => 2018-07-07 01:02:56 [post_modified_gmt] => 2018-07-06 23:02:56 [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 ) [2] => WP_Post Object ( [ID] => 1311 [post_author] => 0 [post_date] => 2018-08-30 17:28:05 [post_date_gmt] => 2017-03-30 16:04:09 [post_content] => [post_title] => Appartamento in vendita a Milano Centro Storico Porta Vigentina [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => appartamento-in-vendita-a-milano-centro-storico-porta-vigentina [to_ping] => [pinged] => [post_modified] => 2018-08-31 01:05:29 [post_modified_gmt] => 2018-08-30 23:05:29 [post_content_filtered] => [post_parent] => 0 [guid] => http://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/appartamento-in-vendita-a-milano-centro-storico-porta-vigentina/ [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] => 2018-07-06 17:09:55 [post_date_gmt] => 2018-03-27 14:51:00 [post_content] => In the exclusive district of Crivelli-Quadronno, adjacent to Piazzetta Mondadori and via San Martino, a prestigious apartment with garden, in a new building with concierge, video surveillance, lift to the floor. The apartment is composed of a double living room with double-sided fireplace, dining room with fireplace, kitchen, master bedroom with en suite bathroom, second bedroom, guest bathroom, two gardens, gym, cellar, possibility of double garage in the building. The apartment has a double (east-west) and overlooks the two private gardens, both furnished with living rooms and dining area, and accessible throughout the year. Home automation system throughout the apartment, walnut-stained aluminum fixtures with shatterproof glass, Sicilian stone flooring, walnut boiserie, Jacuzzi with chromotherapy, Turkish bath, gym with Tecnogym equipment. [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] => 2018-07-07 01:03:03 [post_modified_gmt] => 2018-07-06 23:03:03 [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] => 2018-07-06 17:10:23 [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] => 2018-07-07 01:02:57 [post_modified_gmt] => 2018-07-06 23:02:57 [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] => 1615 [post_author] => 0 [post_date] => 2018-07-06 17:18:28 [post_date_gmt] => 2018-04-26 14:43:24 [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 [to_ping] => [pinged] => [post_modified] => 2018-07-07 01:03:05 [post_modified_gmt] => 2018-07-06 23:03:05 [post_content_filtered] => [post_parent] => 0 [guid] => http://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/attico-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] => 1459 [post_author] => 1 [post_date] => 2018-07-06 17:10:47 [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] => 2018-07-07 01:02:53 [post_modified_gmt] => 2018-07-06 23:02:53 [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 ) [7] => WP_Post Object ( [ID] => 1526 [post_author] => 0 [post_date] => 2018-07-25 18:29:32 [post_date_gmt] => 2018-02-19 16:51:24 [post_content] => Immersed in the green of San Siro, bright and panoramic apartment in an exclusive condominium with concierge and lift to the floor. The apartment has a double living room with terrace, dining room, kitchen, 3 master bedrooms, a service room, 3 bathrooms, walk-in closet, two terraces in the sleeping area. Central heating, air conditioning in all rooms, marble in the living area and parquet in the sleeping area, walk-in closet, Jacuzzi, double shower, double entrance, double east-west exposure. Possibility of quadruple box in the building, € 100,000 request. Common garden, swimming pool, tennis court. [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] => 2018-07-27 01:08:49 [post_modified_gmt] => 2018-07-26 23:08:49 [post_content_filtered] => [post_parent] => 0 [guid] => http://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 ) [8] => WP_Post Object ( [ID] => 1621 [post_author] => 0 [post_date] => 2018-09-03 15:59:31 [post_date_gmt] => 2018-05-31 15:55:12 [post_content] => [post_title] => Appartamento in vendita a Milano Bocconi, C.so Italia, Ticinese [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => appartamento-in-vendita-a-milano-bocconi-c-so-italia-ticinese [to_ping] => [pinged] => [post_modified] => 2018-09-04 01:19:23 [post_modified_gmt] => 2018-09-03 23:19:23 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/appartamento-in-vendita-a-milano-bocconi-c-so-italia-ticinese/ [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] => 2018-07-06 17:02:41 [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] => 2018-07-08 01:01:53 [post_modified_gmt] => 2018-07-07 23:01:53 [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] => 19 [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_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] => 3fff2544a5e4665c4f9ee2e8a4609e4e [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
1.820.000€

Quadrilocale in vendita a Milano Centro Storico

Piazza Sant'Erasmo , Milano 20121
  • Surface: 157m2
  • 3
  • 2
1.790.000€
  • Surface: 228m2
  • 4
  • 3
1.590.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: 300m2
  • 5
  • 3
1.390.000€
  • Surface: 155m2
  • 2
  • 2
1.090.000€
  • Surface: 265m2
  • 5
  • 3
1.090.000€
  • Surface: 220m2
  • 3
  • 3