err desc:Transaction (Process ID 1590) was deadlocked on lock | communication buffer 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 (Address LIKE '%Barrie%' OR Municipality LIKE '%Barrie%' OR Postal_Code LIKE '%Barrie%' OR MLS_Number LIKE '%Barrie%' OR Community LIKE '%Barrie%' ) AND (List_Price >=574000) AND (List_Price <=774000) AND Type2 = 'House' AND Sale_Lease = 'Sale' AND IDX_Approved=1
Query String: PageAction=searchresult&SortOrder=highest&searchDetails=Barrie&priceRangeFrom=574000&priceRangeTo=774000&Type2=House
Script Name: /index.asp