BedsTotal Ge 0 And (BathsTotal Ge 0.0) And(PropertyType Eq 'F' Or PropertyType Eq 'G') And (City Eq 'Mangilao') And (ListPrice Ge 0.0 And ListPrice Le 10000000000.0) And (BuildingAreaTotal Ge 0.0) And (MlsStatus Eq 'Active' Or MlsStatus Eq 'Pending')