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 ('Ajax') AND lattlongchecked = 1 AND Latitude IS NOT NULL AND Longitude IS NOT NULL AND ( 6371 * acos( cos( radians(43.91121287274657) ) * cos( radians( Latitude ) ) * cos( radians( Longitude ) - radians(-79.03167915370432) ) + sin( radians(43.91121287274657) ) * sin( radians( Latitude ) ) ) ) * 1000 < 780.4465696249333 AND Sale_Lease IN ('Sale') AND Status='A'
Deer Creek Homes For Sale in Ajax, Ajax Homes for Sale in Deer Creek
Looking for a Coughlan Home near Deer Creek Golf & Country Club in Ajax?
This is exclusively listing only the homes on Buggey Lane. If nothing is showing up, there is nothing there for sale. If you want to be notified when a new listing comes out on Buggey Lane, just let me know and I will make sure you are notified the day it comes out.
North Ajax ~ Deer Creek Estates ~ Buggey Lane Homes are an exclusive enclave of prestige homes backing on to Deer Creek Golf and Country Club.
Showing 1 properties out of 1 currently available on the market.
