User-1557807525 posted
You will be have select * from [Properties] in you data adapter fill
have a drop down to have options to give full list 3 bedroom 2 bedroom single bedroom
and values for the drop are 0, 3, 2, 1
Before adapter fill check for the drop down value if it is 0 then do the normal way
or else
have a adapter to select * from [Properties] where bedroomtype = value (selectedvalue from the combobox)