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 Sale_Lease IN ('Lease') AND Status='A'
Looking to move to Pickering? Can't buy and looking to rent? This page has all the available rentals in Pickering, from Basement Apartments, Condos or full Homes. Rental Applications and Credit Reports will need to be provided with Offer to Lease. If you are looking to rent something or have a property to rent, we are here to assist you in all your rental needs.
Showing 123 properties out of 147 currently available on the market.