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] => 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] => [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] => 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] => = [compare_key] => = [alias] => wp_postmeta [cast] => CHAR ) [mt1] => Array ( [key] => stato_costruzione [value] => Nuovo [compare] => != [compare_key] => = [alias] => mt1 [cast] => CHAR ) [mt2] => Array ( [key] => contratto [value] => vendita [compare] => = [compare_key] => = [alias] => mt2 [cast] => CHAR ) [mt3] => Array ( [key] => categoria_immobile [value] => Commerciale [compare] => = [compare_key] => = [alias] => mt3 [cast] => CHAR ) [mt4] => Array ( [key] => riferimento_immobile [value] => VENDUTO [compare] => != [compare_key] => = [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 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 = '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 ( ( ( 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] => 3986 [post_author] => 0 [post_date] => 2023-10-19 17:17:16 [post_date_gmt] => 2022-09-11 21:21:20 [post_content] => Bordighera, in the central Piazza Eroi della Libertà, large and bright commercial space of about 350sqm in a period building of the early '900. The property is spread over two levels: ground floor of about 320sqm and basement of about 70 square meters connected by an internal staircase. The real estate unit lends itself to various commercial solutions, has a high visibility, excellent position of passage, triple exposure with shop windows on the street and private entrance. Free immediately. [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] => 2024-11-09 00:09:02 [post_modified_gmt] => 2024-11-08 23:09:02 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/locale-commerciale-in-vendita-a-bordighera-2/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) ) [post_count] => 1 [current_post] => -1 [before_loop] => 1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 3986 [post_author] => 0 [post_date] => 2023-10-19 17:17:16 [post_date_gmt] => 2022-09-11 21:21:20 [post_content] => Bordighera, in the central Piazza Eroi della Libertà, large and bright commercial space of about 350sqm in a period building of the early '900. The property is spread over two levels: ground floor of about 320sqm and basement of about 70 square meters connected by an internal staircase. The real estate unit lends itself to various commercial solutions, has a high visibility, excellent position of passage, triple exposure with shop windows on the street and private entrance. Free immediately. [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] => 2024-11-09 00:09:02 [post_modified_gmt] => 2024-11-08 23:09:02 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/locale-commerciale-in-vendita-a-bordighera-2/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 1 [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_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] => f58b5b82a5ffad04b17bf74865032c9f [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 ) )
Private negotiation

Locale Commerciale in vendita a Bordighera

Piazza Eroi Della Libertà, Bordighera 18012
  • Surface: 350m2