err#-2147467259
err desc:Transaction (Process ID 191) 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(24) AND (Address LIKE '%CLEARVIEW%' OR Municipality LIKE '%CLEARVIEW%' OR Postal_Code LIKE '%CLEARVIEW%' OR MLS_Number LIKE '%CLEARVIEW%' OR Community LIKE '%CLEARVIEW%' ) AND (List_Price >=339000) AND (List_Price <=359000) AND Type2 = 'House' AND Sale_Lease = 'Sale' AND IDX_Approved=1
Query String: PageAction=searchresult&SortOrder=highest&ShowSoldMessage=1&searchDetails=CLEARVIEW&Type2=House&sale_lease=Sale&pricerangefrom=339000&pricerangeto=359000
Script Name: /index.asp