WP_Query Object( [query] => Array ( [paged] => 2 [post_type] => realforce_prop-sale [lang] => en ) [query_vars] => Array ( [paged] => 2 [post_type] => realforce_prop-sale [lang] => en [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] => en [order] => DESC ) [tax_query] => WP_Tax_Query Object ( [queries] => Array ( [0] => Array ( [taxonomy] => language [terms] => Array ( [0] => en ) [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] => en ) [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] => Properties sale [labels] => stdClass Object ( [name] => Properties sale [singular_name] => Property sale [add_new] => Add new [add_new_item] => Add new property sale [edit_item] => Edit property sale [new_item] => New Post [view_item] => View property sale [view_items] => View Posts [search_items] => Search property sale [not_found] => Not found [not_found_in_trash] => Not found in trash [parent_item_colon] => [all_items] => All properties sale [archives] => All properties sale [attributes] => Post Attributes [insert_into_item] => Insert into post [uploaded_to_this_item] => Uploaded to this post [featured_image] => Featured image [set_featured_image] => Set featured image [remove_featured_image] => Remove featured image [use_featured_image] => Use as featured image [filter_items_list] => Filter posts list [filter_by_date] => Filter by date [items_list_navigation] => Posts list navigation [items_list] => Posts list [item_published] => Post published. [item_published_privately] => Post published privately. [item_reverted_to_draft] => Post reverted to draft. [item_trashed] => Post trashed. [item_scheduled] => Post scheduled. [item_updated] => Post updated. [item_link] => Post Link [item_link_description] => A link to a post. [menu_name] => Properties sale [update_item] => Update property sale [name_admin_bar] => Property sale [template_name] => Single item: Property sale ) [description] => Properties sale list [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 (16327)) 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] => 60376 [post_author] => 1 [post_date] => 2025-11-23 18:31:17 [post_date_gmt] => 2025-11-23 17:31:17 [post_content] => Located in a quiet and leafy residential area on the edge of an agricultural zone, this beautiful detached villa with garden enjoys a privileged setting, just a short walk from all the amenities of the charming village of Trélex (center, public transport, shops, restaurant, and school).

[post_title] => For Sale – Beautiful Detached Villa with Swimming Pool in the Heart of the Village [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => for-sale-beautiful-detached-villa-with-swimming-pool-in-the-heart-of-the-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/for-sale-beautiful-detached-villa-with-swimming-pool-in-the-heart-of-the-village/ [menu_order] => 0 [post_type] => realforce_prop-sale [post_mime_type] => [comment_count] => 0 [filter] => raw ) [1] => WP_Post Object ( [ID] => 59824 [post_author] => 1 [post_date] => 2025-03-14 14:41:15 [post_date_gmt] => 2025-03-14 13:41:15 [post_content] =>

[post_title] => For Sale – Stunning contemporary Villa under construction with double garage [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => for-sale-stunning-contemporary-villa-under-construction-with-double-garage [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/for-sale-stunning-contemporary-villa-under-construction-with-double-garage/ [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] => 60376 [post_author] => 1 [post_date] => 2025-11-23 18:31:17 [post_date_gmt] => 2025-11-23 17:31:17 [post_content] => Located in a quiet and leafy residential area on the edge of an agricultural zone, this beautiful detached villa with garden enjoys a privileged setting, just a short walk from all the amenities of the charming village of Trélex (center, public transport, shops, restaurant, and school).

[post_title] => For Sale – Beautiful Detached Villa with Swimming Pool in the Heart of the Village [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => for-sale-beautiful-detached-villa-with-swimming-pool-in-the-heart-of-the-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/for-sale-beautiful-detached-villa-with-swimming-pool-in-the-heart-of-the-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] => 804c2b847b1cfdd527f6c0946cd8320b [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:4de6032fa6c4e0a546e288b1b6b8d00e:0.12569900 17935310360.20677800 1793531036)