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 ('Ajax') 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'
Search Homes in Ajax, Ontario in need of some TLC. Original Owners, Fixer Uppers, Renovators Dreams. If some hard work and renovations don't scare you, these may be the homes for you.
Showing 12 properties out of 13 currently available on the market.