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] => all [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] => 5199 [post_author] => 0 [post_date] => 2025-05-06 10:26:44 [post_date_gmt] => 2024-09-12 13:37:54 [post_content] => Bordighera, Piazza Eroi della libertà - appartement lumineux et panoramique au deuxième étage d'un immeuble d'époque du début des années 1900 avec ascenseur. L'appartement doit être rénové et divisé en interne. [post_title] => Appartamento in vendita a Bordighera [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => appartamento-in-vendita-a-bordighera [to_ping] => [pinged] => [post_modified] => 2025-09-03 09:47:46 [post_modified_gmt] => 2025-09-03 07:47:46 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/appartamento-in-vendita-a-bordighera/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [1] => WP_Post Object ( [ID] => 5446 [post_author] => 0 [post_date] => 2025-07-10 11:34:23 [post_date_gmt] => 2025-04-30 12:46:22 [post_content] => Charmant appartement avec terrasse à vendre au cœur de Porto Rotondo, à quelques minutes en voiture des plus belles plages de la région, situé dans une résidence avec piscine. L'appartement se compose d'un séjour lumineux, d’un coin cuisine, de deux salles de bains, d’une chambre double, ainsi que d’une grande mezzanine mansardée pouvant être utilisée comme seconde chambre. Une splendide terrasse avec vue sur le golfe est idéale pour profiter de moments en plein air. La maison se trouve dans une résidence calme offrant une spacieuse piscine entourée de vastes espaces verts, accessible uniquement aux résidents. Le bien constitue une excellente base à personnaliser selon ses goûts, avec un fort potentiel pour devenir une résidence accueillante dans l’une des localités les plus renommées de la Sardaigne. Il représente une belle opportunité, tant comme maison de vacances familiale que comme investissement locatif. Charges de copropriété annuelles : environ 1 477,11 € Frais annuels de consortium Porto Rotondo : environ 1 058 € Place de parking dans la cour de la résidence. Contactez-nous pour organiser une visite. Toute la documentation graphique et textuelle est purement illustrative et ne constitue aucun engagement contractuel. [post_title] => Trilocale in vendita a Olbia [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => trilocale-in-vendita-a-olbia [to_ping] => [pinged] => [post_modified] => 2025-09-03 09:47:58 [post_modified_gmt] => 2025-09-03 07:47:58 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/trilocale-in-vendita-a-olbia/ [menu_order] => 0 [post_type] => immobile [post_mime_type] => [comment_count] => 0 [filter] => raw ) [2] => WP_Post Object ( [ID] => 4948 [post_author] => 0 [post_date] => 2024-07-01 11:30:08 [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] => 2025-09-03 09:47:51 [post_modified_gmt] => 2025-09-03 07:47:51 [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 ) [3] => 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] => 2025-09-03 09:47:50 [post_modified_gmt] => 2025-09-03 07:47:50 [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] => 4 [current_post] => -1 [before_loop] => 1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 5199 [post_author] => 0 [post_date] => 2025-05-06 10:26:44 [post_date_gmt] => 2024-09-12 13:37:54 [post_content] => Bordighera, Piazza Eroi della libertà - appartement lumineux et panoramique au deuxième étage d'un immeuble d'époque du début des années 1900 avec ascenseur. L'appartement doit être rénové et divisé en interne. [post_title] => Appartamento in vendita a Bordighera [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => appartamento-in-vendita-a-bordighera [to_ping] => [pinged] => [post_modified] => 2025-09-03 09:47:46 [post_modified_gmt] => 2025-09-03 07:47:46 [post_content_filtered] => [post_parent] => 0 [guid] => https://manuelalinguardo.com/immobile/%tipologia_contratto%/%tipologia_immobile%/appartamento-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] => 13 [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 ) [query_cache_key:WP_Query:private] => wp_query:6503fdf8779761aa19643b47c9896fcb:0.32631600 1756907700 )