Ventes

Biens immobiliers

WP_Query Object ( [query] => Array ( [paged] => 2 [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] => riferimento_immobile [value] => VENDUTO [compare] => != ) ) [meta_key] => prezzo_immobile [orderby] => meta_value_num [order] => DESC ) [query_vars] => Array ( [paged] => 2 [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] => 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] => 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] => 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] => 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 = 'stato_costruzione' AND mt1.meta_value != 'Nuovo' ) AND ( mt2.meta_key = 'contratto' AND mt2.meta_value = 'vendita' ) 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 = 'fr' 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 9, 9 [posts] => Array ( [0] => WP_Post Object ( [ID] => 4948 [post_author] => 0 [post_date] => 2024-03-06 09:48:53 [post_date_gmt] => 2024-02-13 15:48:34 [post_content] => C'est un manoir, sur deux niveaux, avec un grand jardin privatif. Depuis l'entrée située à l'entresol vous entrez dans le logement situé au premier étage, composé d'une entrée importante avec une fenêtre qui communique avec la terrasse, un couloir d'où il est possible d'accéder à toutes les pièces de la maison : un spacieux le salon, la salle à manger, la cuisine, un couloir qui mène à la salle de bain, un débarras et la terrasse arrière, trois chambres et un balcon donnant sur le jardin. Au rez-de-chaussée se trouvent un grand garage et la chaufferie de la maison. Toute documentation graphique et textuelle est purement illustrative et ne constitue pas une obligation contractuelle. [post_title] => Casa indipendente in vendita a Candia Lomellina [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => casa-indipendente-in-vendita-a-candia-lomellina [to_ping] => [pinged] => [post_modified] => 2024-04-18 13:00:35 [post_modified_gmt] => 2024-04-18 11:00:35 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/casa-indipendente-in-vendita-a-candia-lomellina/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [1] => WP_Post Object ( [ID] => 4990 [post_author] => 0 [post_date] => 2024-02-27 13:30:06 [post_date_gmt] => 2024-02-26 17:50:43 [post_content] => Dans le quartier de San Siro, nous proposons à la vente un garage simple au premier sous-sol. Ouverture basculante manuelle. Le prix est soumis à une TVA de 4% s'il s'agit de la première maison ou de 10% de TVA si la maison n'est pas une première maison. Dimensions intérieures : 5 x 2,77 m (h. 2,60 m) A côté, nous avons un deuxième garage disponible à la vente. Mesures internes : 5 x 262 (h. 2,63) Contactez-nous pour voir la propriété. Toute documentation graphique et textuelle est purement illustrative et ne constitue pas une obligation contractuelle [post_title] => Monolocale in vendita a Milano Lotto, Novara, San Siro San Siro [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => monolocale-in-vendita-a-milano-lotto-novara-san-siro-san-siro [to_ping] => [pinged] => [post_modified] => 2024-04-18 13:00:27 [post_modified_gmt] => 2024-04-18 11:00:27 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/monolocale-in-vendita-a-milano-lotto-novara-san-siro-san-siro/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) ) [post_count] => 2 [current_post] => -1 [before_loop] => 1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 4948 [post_author] => 0 [post_date] => 2024-03-06 09:48:53 [post_date_gmt] => 2024-02-13 15:48:34 [post_content] => C'est un manoir, sur deux niveaux, avec un grand jardin privatif. Depuis l'entrée située à l'entresol vous entrez dans le logement situé au premier étage, composé d'une entrée importante avec une fenêtre qui communique avec la terrasse, un couloir d'où il est possible d'accéder à toutes les pièces de la maison : un spacieux le salon, la salle à manger, la cuisine, un couloir qui mène à la salle de bain, un débarras et la terrasse arrière, trois chambres et un balcon donnant sur le jardin. Au rez-de-chaussée se trouvent un grand garage et la chaufferie de la maison. Toute documentation graphique et textuelle est purement illustrative et ne constitue pas une obligation contractuelle. [post_title] => Casa indipendente in vendita a Candia Lomellina [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => casa-indipendente-in-vendita-a-candia-lomellina [to_ping] => [pinged] => [post_modified] => 2024-04-18 13:00:35 [post_modified_gmt] => 2024-04-18 11:00:35 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/casa-indipendente-in-vendita-a-candia-lomellina/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 11 [max_num_pages] => 2 [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] => 1 [is_admin] => [is_attachment] => [is_singular] => [is_robots] => [is_favicon] => [is_posts_page] => [is_post_type_archive] => 1 [query_vars_hash:WP_Query:private] => 69bc40f3baf0484cd226faab99f2ff9b [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 ) )
150.000€

Casa indipendente in vendita a Candia Lomellina

Viale Giuseppe Garibaldi , Candia Lomellina
  • Superficie: 400m2
  • 3
  • 2
41.000€
  • Superficie: 13m2