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] => [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] => 2358 [post_author] => 0 [post_date] => 2020-09-01 12:30:48 [post_date_gmt] => 2020-02-27 17:10:29 [post_content] => In an early 1900 building with concierge and lift, we offer an exclusive apartment with elegant vintage finishes. Inside it is made up of: entrance, double living room, dining room, 4 bedrooms, kitchen, two bathrooms (third bathroom possible), laundry and service room, balcony, cellar. Ceiling height h 4.05. Double entrance with lift on the floor, double exposure. Concierge, central heating, original parquet. All graphic and textual documentation is purely illustrative and does not constitute a contractual obligation. [post_title] => Appartamento in vendita a Milano Centro Storico [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => appartamento-in-vendita-a-milano-centro-storico [to_ping] => [pinged] => [post_modified] => 2020-09-03 01:05:44 [post_modified_gmt] => 2020-09-02 23:05:44 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/appartamento-in-vendita-a-milano-centro-storico/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [1] => WP_Post Object ( [ID] => 1674 [post_author] => 0 [post_date] => 2020-04-27 12:17:12 [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] => 2020-04-29 01:01:28 [post_modified_gmt] => 2020-04-28 23:01:28 [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 ) [2] => WP_Post Object ( [ID] => 2473 [post_author] => 0 [post_date] => 2020-10-20 15:01:40 [post_date_gmt] => 2020-07-10 10:25:30 [post_content] => San Siro, panoramic and bright prestigious penthouse developed on three levels connected with internal staircase and site in condominium with security H24 and swimming pool. The property comprises on the sixth floor an entrance with double living room, kitchen, study, terrace, laundry area with bathroom, hallway with walk-in closets, master bedroom with two walk-in closets and two en suite bathrooms, two bedrooms bed with relative bathrooms. On the seventh floor there is access to an open space with wardrobe, bathroom, balcony and staircase leading to the eighth floor, with a large terrace / solarium with a wonderful indoor swimming pool and service bathroom. The building is enriched with fine finishes. Heating and air conditioning are centralized. The property also offers the possibility of buying a double garage and a single in the building. [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] => 2020-10-22 01:06:11 [post_modified_gmt] => 2020-10-21 23:06:11 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/attico-in-vendita-a-milano-lotto-novara-san-siro-5/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [3] => WP_Post Object ( [ID] => 2467 [post_author] => 0 [post_date] => 2020-09-18 10:25:34 [post_date_gmt] => 2020-07-10 10:26:06 [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 [to_ping] => [pinged] => [post_modified] => 2020-09-21 01:07:39 [post_modified_gmt] => 2020-09-20 23:07:39 [post_content_filtered] => [post_parent] => 0 [guid] => https://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 ) [4] => WP_Post Object ( [ID] => 2476 [post_author] => 0 [post_date] => 2020-09-04 12:46:39 [post_date_gmt] => 2020-07-10 10:24:49 [post_content] => Brera-Montenapoleone, we offer prestigious penthouse with terrace in elegant building with concierge and lift to the floor. The apartment of about 70 square meters is currently developed in a main and divisible environment that includes the living room and the bedroom, a kitchen, a bathroom with a windowed bathtub, and a large walk-in window. The 65sq.m terrace develops on the front and the side of the apartment. Brightness and privacy are among the main features of this property. Fine finishes and custom-made furniture included in the price. [post_title] => Bilocale in vendita a Milano Centro Storico [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => bilocale-in-vendita-a-milano-centro-storico [to_ping] => [pinged] => [post_modified] => 2020-09-06 01:01:24 [post_modified_gmt] => 2020-09-05 23:01:24 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/bilocale-in-vendita-a-milano-centro-storico/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [5] => WP_Post Object ( [ID] => 2434 [post_author] => 0 [post_date] => 2020-09-16 17:33:09 [post_date_gmt] => 2020-05-22 13:41:07 [post_content] => In a building with elegant period finishes, we offer an apartment of 275 square meters located on the fourth and last floor and served with a lift and concierge. Inside there is a large entrance that precedes the double living room with corner exposure, dining room, study, three bedrooms (there is the possibility of obtaining two other bedrooms, for a total of five), three bathrooms, kitchen , closet, cellar, three balconies, six French balconies. The house has fine period finishes and enjoys excellent brightness on three sides of exposure (east-west-south), ceiling height 3.35 m. [post_title] => Appartamento in vendita a Milano Repubblica, Stazione Centrale [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => appartamento-in-vendita-a-milano-repubblica-stazione-centrale [to_ping] => [pinged] => [post_modified] => 2020-09-17 09:39:46 [post_modified_gmt] => 2020-09-17 07:39:46 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/appartamento-in-vendita-a-milano-repubblica-stazione-centrale/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [6] => WP_Post Object ( [ID] => 2361 [post_author] => 0 [post_date] => 2020-10-20 11:40:32 [post_date_gmt] => 2020-02-27 17:08:54 [post_content] => Inside the prestigious complex of San Siro Club, we offer for sale a large and bright apartment located on the fourth floor with quadruple exposure. Inside it consists of: triple living room overlooking a large balcony, kitchen, 4 bedrooms, 3 bathrooms, walk-in closet, large laundry room, closet, 3 balconies. Cellar and box included in the price. Excellent internal conditions, custom-made furniture included in the price, home automation, parquet. The San Siro Club has a concierge all day long, club house with swimming pool, restaurant, gym and recreation rooms for children and adults. There are also 2 tennis courts, a soccer field, a basketball court and a space for skating. 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-2 [to_ping] => [pinged] => [post_modified] => 2020-10-22 01:06:13 [post_modified_gmt] => 2020-10-21 23:06:13 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/appartamento-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] => 2568 [post_author] => 0 [post_date] => 2020-11-09 12:32:50 [post_date_gmt] => 2020-10-28 14:45:09 [post_content] => In the immediate vicinity of Buonarroti / Wagner, we offer a four-room apartment located on the fourth floor of an elegant building with two lifts on the floor. Inside it consists of a double living room, kitchen, three double bedrooms, a service room, two bathrooms (possibility of a third bathroom), a closet, three balconies, cellar. Double east / west exposure, double entrance (possibility of splitting), central heating with radiators. All the 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] => 2020-11-11 00:01:50 [post_modified_gmt] => 2020-11-10 23:01:50 [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 ) [8] => WP_Post Object ( [ID] => 2512 [post_author] => 0 [post_date] => 2020-08-07 12:10:30 [post_date_gmt] => 2020-07-30 16:40:04 [post_content] => Bordighera, in the central Piazza Eroi della Libertà, panoramic and bright apartment with sea view terrace. The apartment of 150sqm, consists of entrance hall, living room, dining room, kitchen, two bedrooms (possible third bedroom), bathroom (possible second bathroom), closet, terrace of about 140sqm. Historic building from the beginning of the 20th century with lift to the floor, double exposure, original flooring in cementine. [post_title] => Quadrilocale in vendita a Bordighera [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => quadrilocale-in-vendita-a-bordighera [to_ping] => [pinged] => [post_modified] => 2020-08-09 01:02:01 [post_modified_gmt] => 2020-08-08 23:02:01 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/quadrilocale-in-vendita-a-bordighera/ [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] => 2358 [post_author] => 0 [post_date] => 2020-09-01 12:30:48 [post_date_gmt] => 2020-02-27 17:10:29 [post_content] => In an early 1900 building with concierge and lift, we offer an exclusive apartment with elegant vintage finishes. Inside it is made up of: entrance, double living room, dining room, 4 bedrooms, kitchen, two bathrooms (third bathroom possible), laundry and service room, balcony, cellar. Ceiling height h 4.05. Double entrance with lift on the floor, double exposure. Concierge, central heating, original parquet. All graphic and textual documentation is purely illustrative and does not constitute a contractual obligation. [post_title] => Appartamento in vendita a Milano Centro Storico [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => appartamento-in-vendita-a-milano-centro-storico [to_ping] => [pinged] => [post_modified] => 2020-09-03 01:05:44 [post_modified_gmt] => 2020-09-02 23:05:44 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/appartamento-in-vendita-a-milano-centro-storico/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 20 [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_favicon] => [is_posts_page] => [is_post_type_archive] => 1 [query_vars_hash:WP_Query:private] => 4f3b88ac857b8c196470adccc6bee4f4 [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
  • Surface: 350m2
  • 4
  • 2
Private negotiation

Villa in vendita a Olbia

Via Punta Lada, Olbia 07026
  • Surface: 200m2
  • 4
  • 4
2.400.000€
  • Surface: 477m2
  • 5
  • 6
2.350.000€
  • Surface: 425m2
  • 5
  • 5
1.900.000€
  • Surface: 100m2
  • 1
  • 1
1.390.000€
  • Surface: 275m2
  • 5
  • 3
1.200.000€
  • Surface: 280m2
  • 4
  • 3
999.000€
  • Surface: 180m2
  • 4
  • 2
950.000€

Quadrilocale in vendita a Bordighera

Piazza Eroi Della Libertà, Bordighera 18012
  • Surface: 210m2
  • 3
  • 2