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.16721433078006 43.849858502048384,-79.16433900271609 43.843266058472445,-79.1303709562529 43.85202487373553,-79.13534913618454 43.86392781253414,-79.1453913267363 43.86318521364665,-79.15496144850144 43.85860564943614,-79.16721433078006 43.849858502048384)))', 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'
Searching for a home in Cherrywood? It's a great neighbourhood - I know because I live there. If you are thinking of selling, what better way than to work with someone who lives in the area and knows all about it. If you would like a free evaluation of your please don't hesitate to reach out !
Showing 2 properties out of 2 currently available on the market.
