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.84042813696288 42.31982250276816,-82.87338712133788 42.32972196087702,-82.89192655004882 42.334036621791434,-82.8963897458496 42.33378282640149,-82.8908965817871 42.312714238886784,-82.90016629614257 42.31246035747017,-82.89810635961913 42.30205033765524,-82.8960464230957 42.28757501090718,-82.90291287817382 42.28859093185717,-82.89947965063476 42.275382681562206,-82.9070327512207 42.274366547623025,-82.90840604223632 42.24158744433566,-82.92694547094726 42.242349942578166,-82.93896176733398 42.24311243160596,-82.95475461401367 42.24844959678789,-82.96368100561523 42.24616229557005,-82.97501065649413 42.242349942578166,-82.98256375708007 42.23497874024528,-82.99183347143554 42.233199355506784,-82.99801328100585 42.23548712667044,-83.0004165402832 42.18335621604652,-82.87647702612304 42.18004890283341,-82.87029721655273 42.30484343877241,-82.86995389379882 42.31220647502941,-82.84248807348632 42.30738251407938,-82.84042813696288 42.31982250276816)))', 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/tecumseh/
Script Name: /index.asp