err#-2147467259
err desc:Transaction (Process ID 177) 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.62687069177628 45.468799075209894,-75.67854076623917 45.460732655800314,-75.69725185632706 45.44905236166804,-75.69896847009659 45.44170578298928,-75.69090038537979 45.437249195331844,-75.6831756234169 45.43736964827514,-75.6780257821083 45.43833326256496,-75.67620791494846 45.440079771522065,-75.67500628530979 45.44038088829218,-75.67354716360569 45.44137456223175,-75.67148722708225 45.442187555165454,-75.67084349691868 45.44291020571599,-75.67015685141087 45.44507810182915,-75.66968478262424 45.44555984520757,-75.6542781740427 45.44528886506341,-75.65041579306126 45.4398689888268,-75.65367735922337 45.438815063538925,-75.65238989889622 45.43673726745431,-75.65157450735569 45.436165107271684,-75.65037287771702 45.432009243435076,-75.6493429094553 45.432009243435076,-75.6493429094553 45.42999143106494,-75.67110098898411 45.42854578978903,-75.667839422822 45.42228091640412,-75.66247500479221 45.41700945071982,-75.65638102591038 45.41764205258774,-75.65148867666721 45.419118096052166,-75.63513793051243 45.42032300088725,-75.64118899405003 45.43095517134557,-75.61226405203342 45.441224006699144,-75.62687069177628 45.468799075209894)))', 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: Page=3&PageAction=ViewSubCat&URL=/communities/rideau-rockliffe/
Script Name: /index.asp