SELECT TOP 500 ID, Apt_Unit, IDX_Approved,Address, Municipality, MLS_Number,Longitude,Latitude,Sale_Lease,ImagePathOfFirstImage,Photos_Updated_Timestamp,Listing_Agent,Agent_ID,Remarks_For_Clients, Approximate_Square_Footage, List_Price, Bedrooms,Bedrooms_Plus, Washrooms, List_Broker FROM PropertiesFreeholdAndCondos Where (IDX_Approved=1) AND (IDX_Approved=1) AND Status = 'A' AND Area = 'Durham' AND Municipality = 'Uxbridge' AND Municipality_District = 'Uxbridge' AND (Community = 'Rural Uxbridge' OR Community = 'Uxbridge') AND Type2 = 'Detached' AND List_Price >= '700000' AND Sale_Lease = 'Sale' ORDER BY CreatedOnDate DESC