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(((-75.7551097869873 45.404657232443576,-75.7490587234497 45.40158382192321,-75.74811458587646 45.40080037681396,-75.74734210968018 45.39950465529261,-75.7421064376831 45.39727473938422,-75.73781490325928 45.39040363438905,-75.73378086090088 45.38995155871914,-75.7426643371582 45.38139157704204,-75.74790000915527 45.37988440382442,-75.74978828430176 45.38229586168782,-75.7487154006958 45.383200131869984,-75.74987411499023 45.38540046222898,-75.7518482208252 45.38494834654318,-75.75377941131592 45.38847475299871,-75.75296401977539 45.39037349612355,-75.7536506652832 45.3920310768612,-75.75850009918213 45.38983100459648,-75.76064586639404 45.39326669632959,-75.76236248016357 45.39284478052407,-75.76180458068848 45.39926358754512,-75.7551097869873 45.404657232443576)))', 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: Page=2&PageAction=ViewSubCat&URL=/communities/westboro/
Script Name: /index.asp