err#-2147467259<br>err desc:Transaction (Process ID 472) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.<br>sql:SELECT TOP 50 ID, List_Price, Photos_Updated_Timestamp, Address, Municipality, MLS_Number, List_Broker, Listing_Agent, Bedrooms, Bedrooms_Plus, Washrooms, ImagePathOfFirstImage, Sale_Lease  FROM PropertiesFreeholdAndCondos Where Status = 'A' AND List_Broker = 'RE/MAX Escarpment  Realty Inc., Brokerage' AND (Agent_ID != '0' OR Agent_ID IS NULL) AND IDX_Approved = 1  AND Board IN(14) AND Sale_Lease = 'Sale'  ORDER BY ID DESC<br>Query String: <br>Script Name: /index.asp<br>