err#-2147467259
err desc:Transaction (Process ID 703) 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.71283414959908 45.40254804714424,-75.72201803326607 45.39959505543274,-75.72939947247505 45.395798125016285,-75.73489263653755 45.388926840480536,-75.75463369488716 45.37041843760903,-75.75789526104927 45.37614644087407,-75.75866773724556 45.37777429382285,-75.76227262616158 45.37735226237295,-75.76407507061958 45.37693022777321,-75.76725080609322 45.37795516347998,-75.76924838125706 45.380185841682085,-75.77572859823704 45.38380297062277,-75.75901105999947 45.40664582074424,-75.73532178997993 45.41694920255326,-75.7211597263813 45.41875661958769,-75.7255370914936 45.411406096232504,-75.71283414959908 45.40254804714424)))', 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/kitchissippi/
Script Name: /index.asp