err#-2147467259
err desc:Transaction (Process ID 165) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
sql:SELECT Count(ID) AS intX FROM PropertiesFreeholdAndCondos Where Status = 'A' AND Board IN(20,16,44,30,144,41,51,17,15,14,82,86,85) AND (Address LIKE '%Waterloo%' OR Municipality LIKE '%Waterloo%' OR Postal_Code LIKE '%Waterloo%' OR MLS_Number LIKE '%Waterloo%' OR Community LIKE '%Waterloo%' ) AND (List_Price >=384500) AND (List_Price <=404500) AND Type2 = 'Condo Apt' AND Sale_Lease = 'Sale' AND IDX_Approved=1
Query String: PageAction=searchresult&SortOrder=highest&ShowSoldMessage=1&searchDetails=Waterloo&Type2=Condo%20Apt&sale_lease=Sale&pricerangefrom=384500&pricerangeto=404500
Script Name: /index.asp