WP_Query Object( [query] => Array ( [paged] => 2 [post_type] => realforce_prop-sale [lang] => fr ) [query_vars] => Array ( [paged] => 2 [post_type] => realforce_prop-sale [lang] => fr [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_key] => rfcrm_creation_date [meta_value] => [preview] => [s] => [sentence] => [title] => [fields] => all [menu_order] => => [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 ( ) [update_post_term_cache] => 1 [posts_per_page] => 20 [orderby] => Array ( [sold] => ASC [meta_value_num] => DESC [external_id] => ASC ) [meta_query] => Array ( [external_id] => Array ( [key] => rfcrm_external_id ) [sold] => Array ( [key] => rfcrm_is_sold [compare] => EXISTS ) [is_sold] => Array ( [relation] => OR [0] => Array ( [key] => rfcrm_is_sold [compare] => NOT EXISTS ) [1] => Array ( [key] => rfcrm_is_sold [value] => 0 ) [2] => Array ( [relation] => AND [0] => Array ( [key] => rfcrm_is_sold [value] => 1 ) ) ) ) [ignore_sticky_posts] => [suppress_filters] => [cache_results] => 1 [update_menu_item_cache] => [lazy_load_term_meta] => 1 [update_post_meta_cache] => 1 [nopaging] => [comments_per_page] => 50 [no_found_rows] => [taxonomy] => language [term] => fr [order] => DESC ) [tax_query] => WP_Tax_Query Object ( [queries] => Array ( [0] => Array ( [taxonomy] => language [terms] => Array ( [0] => fr ) [field] => slug [operator] => IN [include_children] => 1 ) ) [relation] => AND [table_aliases:protected] => Array ( [0] => wp_term_relationships ) [queried_terms] => Array ( [language] => Array ( [terms] => Array ( [0] => fr ) [field] => slug ) ) [primary_table] => wp_posts [primary_id_column] => ID ) [meta_query] => WP_Meta_Query Object ( [queries] => Array ( [0] => Array ( [key] => rfcrm_creation_date ) [1] => Array ( [external_id] => Array ( [key] => rfcrm_external_id ) [sold] => Array ( [key] => rfcrm_is_sold [compare] => EXISTS ) [is_sold] => Array ( [0] => Array ( [key] => rfcrm_is_sold [compare] => NOT EXISTS ) [1] => Array ( [key] => rfcrm_is_sold [value] => 0 ) [2] => Array ( [0] => Array ( [key] => rfcrm_is_sold [value] => 1 ) [relation] => OR ) [relation] => OR ) [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 [5] => mt5 ) [clauses:protected] => Array ( [wp_postmeta] => Array ( [key] => rfcrm_creation_date [compare] => = [compare_key] => = [alias] => wp_postmeta [cast] => CHAR ) [external_id] => Array ( [key] => rfcrm_external_id [compare] => = [compare_key] => = [alias] => mt1 [cast] => CHAR ) [sold] => Array ( [key] => rfcrm_is_sold [compare] => EXISTS [compare_key] => = [alias] => mt2 [cast] => CHAR ) [mt3] => Array ( [key] => rfcrm_is_sold [compare] => NOT EXISTS [compare_key] => = [alias] => mt3 [cast] => CHAR ) [mt4] => Array ( [key] => rfcrm_is_sold [value] => 0 [compare] => = [compare_key] => = [alias] => mt4 [cast] => CHAR ) [mt5] => Array ( [key] => rfcrm_is_sold [value] => 1 [compare] => = [compare_key] => = [alias] => mt5 [cast] => CHAR ) ) [has_or_relation:protected] => 1 ) [date_query] => [queried_object] => WP_Post_Type Object ( [name] => realforce_prop-sale [label] => Biens à vendre [labels] => stdClass Object ( [name] => Biens à vendre [singular_name] => Bien à vendre [add_new] => Ajouter une nouvelle entrée [add_new_item] => Ajouter un bien à vendre [edit_item] => Éditer un bien à vendre [new_item] => Nouvel article [view_item] => Voir les biens à la vente [view_items] => Voir les articles [search_items] => Chercher un bien à la vente [not_found] => Aucune propriété dans cette localité [not_found_in_trash] => Aucun résultat dans la corbeille [parent_item_colon] => [all_items] => Tous les biens à la vente [archives] => Tous les biens à la vente [attributes] => Attributs d’articles [insert_into_item] => Insérer dans la publication [uploaded_to_this_item] => Téléversés sur cette publication [featured_image] => Image mise en avant [set_featured_image] => Définir l’image mise en avant [remove_featured_image] => Supprimer l’image mise en avant [use_featured_image] => Utiliser comme image mise en avant [filter_items_list] => Filtrer la liste des articles [filter_by_date] => Filtrer par date [items_list_navigation] => Navigation de la liste des articles [items_list] => Liste des articles [item_published] => Publication mise en ligne. [item_published_privately] => Publication mise en ligne en privé. [item_reverted_to_draft] => Publication reconvertie en brouillon. [item_trashed] => Publication déplacée dans la corbeille. [item_scheduled] => Publication planifiée. [item_updated] => Publication mise à jour. [item_link] => Lien d’article [item_link_description] => Un lien vers une publication. [menu_name] => Biens à vendre [update_item] => Mettre à jour le bien à vendre [name_admin_bar] => Bien à vendre [template_name] => Élément unique : Bien à vendre ) [description] => Liste des biens à la vente [public] => 1 [hierarchical] => [exclude_from_search] => [publicly_queryable] => 1 [embeddable] => 1 [show_ui] => 1 [show_in_menu] => 1 [show_in_nav_menus] => 1 [show_in_admin_bar] => 1 [menu_position] => 5 [menu_icon] => dashicons-admin-home [capability_type] => page [map_meta_cap] => 1 [register_meta_box_cb] => [taxonomies] => Array ( ) [has_archive] => 1 [query_var] => realforce_prop-sale [can_export] => 1 [delete_with_user] => [template] => Array ( ) [template_lock] => [_builtin] => [_edit_link] => post.php?post=%d [cap] => stdClass Object ( [edit_post] => edit_page [read_post] => read_page [delete_post] => delete_page [edit_posts] => edit_pages [edit_others_posts] => edit_others_pages [delete_posts] => delete_pages [publish_posts] => publish_pages [read_private_posts] => read_private_pages [read] => read [delete_private_posts] => delete_private_pages [delete_published_posts] => delete_published_pages [delete_others_posts] => delete_others_pages [edit_private_posts] => edit_private_pages [edit_published_posts] => edit_published_pages [create_posts] => edit_pages ) [rewrite] => Array ( [slug] => acheter [with_front] => 1 [pages] => 1 [feeds] => 1 [ep_mask] => 1 ) [show_in_rest] => [rest_base] => [rest_namespace] => [rest_controller_class] => [rest_controller] => [revisions_rest_controller_class] => [revisions_rest_controller] => [autosave_rest_controller_class] => [autosave_rest_controller] => [late_route_registration] => ) [queried_object_id] => [request] => SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) LEFT JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) LEFT JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.post_id AND mt3.meta_key = ‘rfcrm_is_sold’ ) LEFT JOIN wp_postmeta AS mt4 ON ( wp_posts.ID = mt4.post_id ) LEFT JOIN wp_postmeta AS mt5 ON ( wp_posts.ID = mt5.post_id ) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (7)) AND ( wp_postmeta.meta_key = ‘rfcrm_creation_date’ AND ( mt1.meta_key = ‘rfcrm_external_id’ AND mt2.meta_key = ‘rfcrm_is_sold’ AND ( mt3.post_id IS NULL OR ( mt4.meta_key = ‘rfcrm_is_sold’ AND mt4.meta_value = ‘0’ ) OR ( ( mt5.meta_key = ‘rfcrm_is_sold’ AND mt5.meta_value = ‘1’ ) ) ) )) AND ((wp_posts.post_type = ‘realforce_prop-sale’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘acf-disabled’ OR wp_posts.post_status = ‘spam’))) GROUP BY wp_posts.ID ORDER BY CAST(mt2.meta_value AS CHAR) ASC, wp_postmeta.meta_value+0 DESC, CAST(mt1.meta_value AS CHAR) ASC LIMIT 20, 20 [posts] => Array ( [0] => WP_Post Object ( [ID] => 60377 [post_author] => 1 [post_date] => 2025-11-23 18:31:17 [post_date_gmt] => 2025-11-23 17:31:17 [post_content] =>

[post_title] => À vendre – Belle villa individuelle avec piscine au cœur du village [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => a-vendre-belle-villa-individuelle-avec-piscine-au-coeur-du-village [to_ping] => [pinged] => [post_modified] => 2026-06-01 17:30:17 [post_modified_gmt] => 2026-06-01 15:30:17 [post_content_filtered] => [post_parent] => 0 [guid] => https://valaur.ch/acheter/a-vendre-belle-villa-individuelle-avec-piscine-au-coeur-du-village/ [menu_order] => 0 [post_type] => realforce_prop-sale [post_mime_type] => [comment_count] => 0 [filter] => raw ) [1] => WP_Post Object ( [ID] => 59825 [post_author] => 1 [post_date] => 2025-03-14 14:41:15 [post_date_gmt] => 2025-03-14 13:41:15 [post_content] =>

[post_title] => A vendre sur plans – Villa individuelle avec garage double, en construction. [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => a-vendre-sur-plans-villa-individuelle-avec-garage-double-en-construction [to_ping] => [pinged] => [post_modified] => 2026-06-01 17:28:14 [post_modified_gmt] => 2026-06-01 15:28:14 [post_content_filtered] => [post_parent] => 0 [guid] => https://valaur.ch/acheter/a-vendre-sur-plans-villa-individuelle-avec-garage-double-en-construction/ [menu_order] => 0 [post_type] => realforce_prop-sale [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] => 60377 [post_author] => 1 [post_date] => 2025-11-23 18:31:17 [post_date_gmt] => 2025-11-23 17:31:17 [post_content] =>

[post_title] => À vendre – Belle villa individuelle avec piscine au cœur du village [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => a-vendre-belle-villa-individuelle-avec-piscine-au-coeur-du-village [to_ping] => [pinged] => [post_modified] => 2026-06-01 17:30:17 [post_modified_gmt] => 2026-06-01 15:30:17 [post_content_filtered] => [post_parent] => 0 [guid] => https://valaur.ch/acheter/a-vendre-belle-villa-individuelle-avec-piscine-au-coeur-du-village/ [menu_order] => 0 [post_type] => realforce_prop-sale [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 22 [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] => b3b080047919f7467239e99055e4cc97 [query_vars_changed:WP_Query:private] => 1 [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:9426910c9ed9a131f2ac84482696f211:0.72692000 17936416070.81043800 1793641607)