SELECT TOP 500 ID, Apt_Unit, IDX_Approved,Address, Municipality, MLS_Number,Longitude,Latitude,Sale_Lease,ImagePathOfFirstImage,Photos_Updated_Timestamp,Listing_Agent,Agent_ID,Remarks_For_Clients, Approximate_Square_Footage, List_Price, Bedrooms,Bedrooms_Plus, Washrooms, List_Broker FROM PropertiesFreeholdAndCondos Where (IDX_Approved=1) AND (IDX_Approved=1) AND Status = 'A' AND Area = 'Durham' AND Municipality = 'Ajax' AND Type2 = 'Condo Apt' AND Sale_Lease = 'Sale' ORDER BY CreatedOnDate DESC
Ajax Condos For Sale, Ajax MLS Listings of Condos For Sale, Search Ajax Condos
Find all available condos for sale in Ajax, Ontario. 2 Westney Rd., Cumberland Lane S., Lake Driveway and more. All sold listings are removed once firm. Condos are quickly becoming the best way to get into the real estate market. Ajax has some wonderful pockets available. Close to the 401 and GO Station. For any information on these condos or others, please do not hesitate to contact me.