err#-2147217871
err desc:Query timeout expired
sql:select id from propertiesfreeholdandcondos with (nolock) where 1=1 and lattlongchecked = 1 and latitude is not null and longitude is not null and ( Geometry::STGeomFromText('multipolygon(((-80.5538692275652 43.452526384266534,-80.5454578200945 43.444301127574725,-80.54631612697926 43.44174608533268,-80.56022069851247 43.437009624066356,-80.5659713546404 43.44255623236094,-80.5714645187029 43.44629523190745,-80.5538692275652 43.452526384266534)))', 4326).STIntersects(Geometry::STGeomFromText('point(' + cast(longitude as varchar(20)) + ' ' + cast(latitude as varchar(20)) + ')', 4326))=1) and sale_lease in ('sale') and type2 in ('att/row/twnhouse','condo apt','duplex','fourplex','house','single family','triplex','two apartment house') and status='a' and idx_approved=1
Query String: PageAction=ViewSubCat&URL=/neighbourhoods/Westvale/
Script Name: /index.asp