err#-2147467259
err desc:Transaction (Process ID 199) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
sql:SELECT ID FROM PropertiesFreeholdAndCondos WHERE Board IN(17,82,47,110,14,43) AND 1=1 AND lattlongchecked = 1 AND Latitude IS NOT NULL AND Longitude IS NOT NULL AND ( Geometry::STGeomFromText('MULTIPOLYGON(((-79.71446549905522 44.41832090141009,-79.72313439859136 44.41458120876358,-79.72107446206792 44.41139308520866,-79.72819840921147 44.4096150177353,-79.72931420816167 44.408817935458856,-79.72725427163823 44.407162421942466,-79.7240785361646 44.40372861538977,-79.72575920826785 44.4022937151082,-79.72558754689089 44.401680499115855,-79.72399967915408 44.40143521091923,-79.72219723469607 44.40177248192446,-79.7193219066321 44.398430347050386,-79.71447247273318 44.40042338623776,-79.70829266283545 44.40232437585606,-79.70739144060644 44.403152206816365,-79.70309990618262 44.40496113000058,-79.70816391713015 44.41057150250283,-79.71391457325808 44.416978318336774,-79.71446549905522 44.41832090141009)))', 4326).STIntersects(Geometry::STGeomFromText('POINT(' + CAST(Longitude AS VARCHAR(20)) + ' ' + CAST(Latitude AS VARCHAR(20)) + ')', 4326))=1) AND Type2 IN ('Agriculture','Att/Row/Twnhouse','Condo Apt','Duplex','Fourplex','Garden Home','Hospitality','House','Mobile/Trailer','Modular','Multi-Family','Other','Single Family','Triplex','Two Apartment House','Unknown','Vacant Land') AND Status='A' AND IDX_Approved=1
Query String: Page=2&PageAction=ViewSubCat&URL=/smart-search/school-zones/west-bayfield-elementary-school/
Script Name: /index.asp