err#-2147217900
err desc:Incorrect syntax near the keyword 'and'.
sql:select count(id) as intx from propertiesfreeholdandcondos with (nolock) where status = 'a' and municipality='halton hills' and type2='vacant land' and list_price >=1119000 and list_price <=1159000 and bedrooms >= and washrooms >= 0
Query String: PageAction=ViewListing&MLS=W4304894
Script Name: /index.asp