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 lattlongchecked = 1 AND Latitude IS NOT NULL AND Longitude IS NOT NULL AND ( Geometry::STGeomFromText('MULTIPOLYGON(((-79.15475142655032 43.859267258506804,-79.14496672806399 43.83487852157677,-79.12453902420657 43.83871700424193,-79.13586867508548 43.86656955904741,-79.1398168867554 43.869415976274645,-79.14805663284915 43.861247631790256,-79.15475142655032 43.859267258506804)))', 4326).STIntersects(Geometry::STGeomFromText('POINT(' + CAST(Longitude AS VARCHAR(20)) + ' ' + CAST(Latitude AS VARCHAR(20)) + ')', 4326))=1) AND Sale_Lease IN ('Sale') AND Status='A'
Are you looking for something that is not your cookie cutter home and has a little more space. Have you ever lived in Cherrywood? Cherrywood is a great pocket in North Pickering. I live in West Cherrywood and have for the past 10 years or more. I love it !!!
If you would like more information about Cherrywood or living north of Finch Ave with each access to 407ETR and the 401, call or text me. It is a great area to raise a family.
Showing 0 properties out of 0 currently available on the market.
