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='hamilton' and type2='industrial' and list_price >=1079900 and list_price <=1119900 and bedrooms >= and washrooms >= 1
Query String: PageAction=ViewListing&MLS=X5844289
Script Name: /index.asp