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(((-82.96690312773438 42.18367263445347,-82.83712712675782 42.179093254550374,-82.83163396269532 42.1867253701326,-82.79249516875001 42.17196911548428,-82.8137811794922 42.16128140218995,-82.8247675076172 41.99819766545639,-82.92295781523438 41.98135581767896,-82.94973699003907 41.987991016913355,-83.00329533964845 42.02013641727871,-82.99848882109376 42.057363948248366,-82.97514287382813 42.056854129403746,-82.96690312773438 42.18367263445347)))', 4326).STIntersects(Geometry::STGeomFromText('point(' + cast(longitude as varchar(20)) + ' ' + cast(latitude as varchar(20)) + ')', 4326))=1) and sale_lease in ('sale') and status='a' and idx_approved=1
Query String: PageAction=ViewSubCat&URL=/communities/Essex/
Script Name: /index.asp