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 ( 6371 * acos( cos( radians(43.76313516700101) ) * cos( radians( Latitude ) ) * cos( radians( Longitude ) - radians(-79.23538970921072) ) + sin( radians(43.76313516700101) ) * sin( radians( Latitude ) ) ) ) * 1000 < 5365.620355882453 AND Status='A'
Scarborough Homes For Sale, MLS Listings of Homes for Sale in Scarborough Ontario

Showing 966 properties out of 1130 currently available on the market.

To view additional 164 properties please login or click here to create a free account.

INTERCITY REALTY INC., BROKERAGE 2901 Lawrence Ave E, Toronto