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