err#-2147467259
err desc:Transaction (Process ID 57) 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.70004537701607 45.42719046746577,-75.67395284771919 45.416768457667864,-75.66253736615181 45.41712994686011,-75.66828802227974 45.4222507951412,-75.67112043499947 45.4286963791495,-75.64777448773384 45.43050342013797,-75.6486327946186 45.43435824755581,-75.65180853009224 45.43965820534411,-75.64846113324165 45.44056155758287,-75.66494062542915 45.44893193366569,-75.66863134503365 45.4473663462367,-75.6706054508686 45.44339196760725,-75.67189291119576 45.4419466695916,-75.67386701703072 45.441224006699144,-75.67661359906197 45.43971842927667,-75.67884519696236 45.437309421835614,-75.68888738751411 45.437068515434795,-75.69266393780708 45.438273037153984,-75.69283559918404 45.44068200345527,-75.7003028690815 45.44248866068641,-75.70365026593208 45.4272507047045,-75.70004537701607 45.42719046746577)))', 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','Commercial Mix','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/rideau-vanier/
Script Name: /index.asp