Best way to sort estates and query them (for rent? yes/no. contains office space? yes/no)?

You can certainly use the Advanced Fields plugin for this type of functionality – you’ll just need to add a few lines to the query that creates your custom pages. I found the documentation on checkboxes from ACF to be helpful. Scroll through the code examples at the bottom of the page and you’ll see this:

/*
 * Query posts for a checkbox value.
 * This method uses the meta_query LIKE to match the string "red" to 
 * the database value a:2:{i:0;s:3:"red";i:1;s:4:"blue";} (serialized array)
 * The above value suggests that the user selected "red" and "blue" from 
 * the checkbox choices
 */
 $posts = get_posts(array(
    'meta_query' => array(
        array(
            'key' => 'field_name', // name of custom field
            'value' => '"red"', // matches exaclty "red", 
                //not just red. This prevents a match for "acquired"
            'compare' => 'LIKE'
        )
    )
));

if( $posts )
{
    //...
}

You can modify this code to work with a WP_Query as well.

Related Posts: