query all posts published by certain user id

Question

You are querying for post author with ID 8 and also you are telling to match the post type to property post type and also post_status to be either publish, acf-disabled, private.

Check your post that didn’t be return for the above and will found the
reason.

SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  WHERE 1=1  AND 

wp_posts.post_author IN (8)  AND
wp_posts.post_type="property" AND
(wp_posts.post_status="publish" OR
 wp_posts.post_status="acf-disabled" OR
 wp_posts.post_status="private"
)  
ORDER BY wp_posts.post_date DESC LIMIT 0, 10"