err#-2147467259
err desc:Transaction (Process ID 98) 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(14, 15) AND (Address LIKE '%Grimsby%' OR Municipality LIKE '%Grimsby%' OR Postal_Code LIKE '%Grimsby%' OR MLS_Number LIKE '%Grimsby%' OR Community LIKE '%Grimsby%' ) AND (List_Price >=224900) AND (List_Price <=424900) AND Type2 = 'Att/Row/Twnhouse' AND Sale_Lease = 'Sale' AND IDX_Approved=1
Query String: PageAction=searchresult&SortOrder=highest&searchDetails=Grimsby&priceRangeFrom=224900&priceRangeTo=424900&Type2=Att/Row/Twnhouse
Script Name: /index.asp