err#-2147467259
err desc:Transaction (Process ID 549) 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(125, 76) AND 1=1 AND lattlongchecked = 1 AND Latitude IS NOT NULL AND Longitude IS NOT NULL AND ( Geometry::STGeomFromText('MULTIPOLYGON(((-75.5758872628212 45.47361429775641,-75.57777553796768 45.45627757127798,-75.58309704065323 45.452424241343095,-75.59202343225479 45.439537757286175,-75.60506969690323 45.43243086675879,-75.59974819421768 45.427130230162774,-75.59511333703995 45.41905785013546,-75.61124950647354 45.4143584705806,-75.61416774988174 45.41953981566926,-75.62223583459854 45.42303394275456,-75.63305050134659 45.43363548747066,-75.61262279748917 45.441103561983816,-75.62584072351456 45.464826206909045,-75.5758872628212 45.47361429775641)))', 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','Garden Home','House','Modular','Multi-Family','Single Family','Triplex','Two Apartment House') AND Status='A' AND IDX_Approved=1
Query String: PageAction=ViewSubCat&URL=/communities/beacon-hill-cyrville/
Script Name: /index.asp