MINIMUM BEDROOMS
None
1 Bedroom
2 Bedrooms
3 Bedrooms
4 Bedrooms
5+ Bedrooms
MINIMUM PRICE
£0
£100
£200
£300
£400
£500
£600
£700
£800
£900
£1000
£1100
£1200
£1300
£1400
£1500
£1600
£1700
£1800
£1900
£2000
£2500
£3000
MAXIMUM PRICE
£0
£100
£200
£300
£400
£500
£600
£700
£800
£900
£1000
£1100
£1200
£1300
£1400
£1500
£1600
£1700
£1800
£1900
£2000
£2500
£3000
TYPE
Not Specified
SELECT * FROM propertyType WHERE propertyTypeID = 27
Semi-Detached
SELECT * FROM propertyType WHERE propertyTypeID = 26
End of Terrace
SELECT * FROM propertyType WHERE propertyTypeID = 35
Maisonette
SELECT * FROM propertyType WHERE propertyTypeID = 31
Ground Flat
SELECT * FROM propertyType WHERE propertyTypeID = 47
Cottage
SELECT * FROM propertyType WHERE propertyTypeID = 50
Apartment
SELECT * FROM propertyType WHERE propertyTypeID = 25
Terraced
SELECT * FROM propertyType WHERE propertyTypeID = 32
Flat
SELECT * FROM propertyType WHERE propertyTypeID = 46
Town House
SELECT * FROM propertyType WHERE propertyTypeID = 33
Studio
SELECT * FROM propertyType WHERE propertyTypeID = 28
Detached
AREA
Not Specified
Sutton Coldfield
Walsall
Tamworth
Birmingham
Lichfield
