SELECT TOP 500 IDX_Approved,ID, Apt_Unit, Address, Municipality, Apt_Unit, MLS_Number,Longitude,Latitude,Sale_Lease,ImagePathOfFirstImage,Photos_Updated_Timestamp,Listing_Agent,Agent_ID, Approximate_Square_Footage, List_Price, Remarks_For_Clients, Bedrooms,Bedrooms_Plus, Washrooms, List_Broker FROM PropertiesFreeholdAndCondos Where (IDX_Approved=1) AND (IDX_Approved=1) AND 1=1 AND Municipality IN ('Pickering') AND (Remarks_For_Clients LIKE '%as is%' OR Remarks_For_Clients LIKE '%Fixer Upper%' or Remarks_For_Clients LIKE '%handy man special%' or Remarks_For_Clients LIKE '%calling all contractors%' or Remarks_For_Clients LIKE '%contractors dream%' or Remarks_For_Clients LIKE '%calling all builders%' or Remarks_For_Clients LIKE '%needs TLC%' or Remarks_For_Clients LIKE '%Tender Love and Care%' or Remarks_For_Clients LIKE '%Original Owner%' or Remarks_For_Clients LIKE '%Same Family for%')AND Sale_Lease IN ('Sale') AND Status='A'