Ventes

Biens immobiliers

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] => Commerciale [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] => Commerciale [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] => Commerciale [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] => Commerciale [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 = 'Commerciale' ) 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 = 'fr' 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] => 1533 [post_author] => 0 [post_date] => 2018-06-08 12:56:09 [post_date_gmt] => 2018-02-20 15:52:13 [post_content] => Bordighera, dans la place centrale Eroi della Libertà, grand et lumineux espace commercial d'environ 350m² dans un bâtiment d'époque du début du '900. La propriété est répartie sur deux niveaux: rez de chaussée d'environ 320m² et sous-sol d'environ 70 mètres carrés reliés par un escalier intérieur. L'unité immobilière se prête à diverses solutions commerciales, a une grande visibilité, une excellente position de passage, une triple exposition avec des vitrines sur la rue et une entrée privée. Gratuit immédiatement. [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 [to_ping] => [pinged] => [post_modified] => 2018-06-10 01:01:34 [post_modified_gmt] => 2018-06-09 23:01:34 [post_content_filtered] => [post_parent] => 0 [guid] => http://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/locale-commerciale-in-vendita-a-bordighera/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [1] => WP_Post Object ( [ID] => 1560 [post_author] => 0 [post_date] => 2018-07-20 11:16:39 [post_date_gmt] => 2018-03-19 15:05:52 [post_content] => Dans la rue centrale Via San Nicolao, à quelques pas de Corso Magenta et Piazza Cadorna, des locaux commerciaux à usage de bureaux au rez-de-chaussée dans un bâtiment d'époque du début du '900, avec un service de conciergerie toute la journée. La propriété se développe sur deux étages et se compose d'une entrée, grand espace ouvert de 90 mètres carrés au rez-de-chaussée avec trois fenêtres sur la cour calme, service. Connecté par un escalier intérieur, nous trouvons un grand espace ouvert de 70 mètres carrés qui peut être utilisé comme un entrepôt / entrepôt. Rénové, chauffage central, climatisation, parquet. Idéal comme studio ou showroom professionnel. Disponibilité immédiate [post_title] => Trilocale in vendita a Milano Centro Storico [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => trilocale-in-vendita-a-milano-centro-storico [to_ping] => [pinged] => [post_modified] => 2018-07-21 01:02:54 [post_modified_gmt] => 2018-07-20 23:02:54 [post_content_filtered] => [post_parent] => 0 [guid] => http://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/trilocale-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] => 1548 [post_author] => 0 [post_date] => 2018-07-06 17:21:45 [post_date_gmt] => 2018-02-22 16:43:33 [post_content] => Via Vincenzo Monti à l'angle de Via Tonoli, espace commercial lumineux et spacieux situé au sous-sol dans un immeuble élégant avec concierge et ascenseur. Composé d'entrée, réception, neuf chambres, deux salles de bains, double exposition, double entrée. Possible changement d'usage en résidentiel (par le client), avec la possible construction de trois appartements et d'un studio. Excellent comme un investissement. Possibilité de box unique dans le bâtiment. [post_title] => Ufficio in vendita a Milano Fiera, Firenze, Sempione [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => ufficio-in-vendita-a-milano-fiera-firenze-sempione [to_ping] => [pinged] => [post_modified] => 2018-07-07 01:03:01 [post_modified_gmt] => 2018-07-06 23:03:01 [post_content_filtered] => [post_parent] => 0 [guid] => http://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/ufficio-in-vendita-a-milano-fiera-firenze-sempione/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) ) [post_count] => 3 [current_post] => -1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 1533 [post_author] => 0 [post_date] => 2018-06-08 12:56:09 [post_date_gmt] => 2018-02-20 15:52:13 [post_content] => Bordighera, dans la place centrale Eroi della Libertà, grand et lumineux espace commercial d'environ 350m² dans un bâtiment d'époque du début du '900. La propriété est répartie sur deux niveaux: rez de chaussée d'environ 320m² et sous-sol d'environ 70 mètres carrés reliés par un escalier intérieur. L'unité immobilière se prête à diverses solutions commerciales, a une grande visibilité, une excellente position de passage, une triple exposition avec des vitrines sur la rue et une entrée privée. Gratuit immédiatement. [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 [to_ping] => [pinged] => [post_modified] => 2018-06-10 01:01:34 [post_modified_gmt] => 2018-06-09 23:01:34 [post_content_filtered] => [post_parent] => 0 [guid] => http://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/locale-commerciale-in-vendita-a-bordighera/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 3 [max_num_pages] => 1 [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] => 6bf385e8efd3d2e2bdea9daf5607de0f [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 ) )
1.800.000€

Locale Commerciale in vendita a Bordighera

Piazza Eroi Della Libertà, Bordighera 18012
  • Superficie: 350m2
599.000€

Trilocale in vendita a Milano Centro Storico

Via San Nicolao, Milano 20123
  • Superficie: 135m2
389.000€
  • Superficie: 230m2