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