I think the title accurately describes what I'm trying to achieve.

update:

=IFERROR(QUERY(HousingData, 
 "select C,B,A,G 
  where G <= "&B3& 
  IF(B4="Y", " and D = '"&B4&"'", )&
  IF(B5="Y", " and E = '"&B5&"'", )& 
  IF(B6="Y", " and F = '"&B6&"'", )&
  IF(B7="Y", " and J = '"&B7&"'", ), 0), "No houses found.")