Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2172 AND i.igate IN ('usahud','okhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'okhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2172 AND i.igate IN ('usahud','okhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'okhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2172 AND i.igate IN ('usahud','okhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'okhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

18152 State Highway 74b
Washington, OK 73093
Braxton Heard with Homestead + Co, original listing - (405) 509-0541

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,200,000
Beds: 8
Baths: Full: 5
Status: Active
SqFt: 4631 Square Feet
Agency: Homestead + Co
Agency Phone: (405) 509-0541

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 110 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2021
Notes: Welcome to this incredible 110-acre MOL property offering the perfect blend of privacy, natural beauty, and versatile living spaces. Featuring two charming homes and several outbuildings/workshops, this expansive estate provides ample room for both relaxation and outdoor activities.<br /> <br /> The back home is spacious, providing generous living areas, an open floor plan, towering ceilings, and that great modern farmhouse feel. Perfect for family gatherings or quiet retreats! The front home offers an excellent opportunity for guest quarters, a mother-in-law suite, or additional rental income while still maintaining that great cottage feel. Both homes are surrounded by picturesque, tree-lined landscapes, adding to the sense of tranquility and seclusion.<br /> <br /> The land itself is a true gem, with lush woods, plenty of pasture, and ample amounts of space to explore. Lots of wildlife roam free out here and you are sure to see plenty of deer, turkey, and much more. Outbuildings provide convenient storage for all your outdoor equipment, making it ideal for those who enjoy farming, gardening, or recreational activities. With an enormous shop spanning a total of 70x60 storage wont be an issue. The main part of the shop itself is 36x60. There is a 16x60 lean as well as another 20x60 enclosed lean! There is also electric, power, plumbing, heating and cooling! The front house also has a 24x24 carport with additional storage.<br /> <br /> Whether you're looking for a peaceful retreat, a family compound, or a property with endless possibilities, this 110-acre estate is a rare find. Don’t miss the opportunity to own this stunning slice of nature in the up and coming town of Washington!
MlsNumber: --
ListingId: 1146243


Listing Provided By: Homestead + Co, original listing
Phone: (405) 509-0541
Office Phone: (405) 509-0541
Agent Name: Braxton Heard
Disclaimer: Copyright © 2024 MLSOK, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App