Found the issue, I think the hidden field setting is the culprit _yoast_wpseo_meta-robots-noindex NOT EQUALS 1.
When I dropped this configuration the post shows up.
I set this up on Frontend Search Settings > Custom Field > _yoast_wpseo_meta-robots-noindex (Post meta) NOT EQUALS 1
with the hope that all non indexed post/page will not show up on search.
Is the search using some sort of inner join, that if the post does not have this meta will not get included (post that is indexed will not have this meta _yoast_wpseo_meta-robots-noindex=1). I am not sure why having this config restrict that real estate post to show up.
Please advise.