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 = 2132 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 = 2132 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 = 2132 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;

5174 Silo Road
Durant, OK 74701
Brian Allen with Epique Realty, original listing - (888) 560-3964

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $750,000
Beds: 5
Baths: Full: 2
Status: Active
SqFt: 2688 Square Feet
Agency: Epique Realty
Agency Phone: (888) 893-3537

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 52 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1910
Notes: Welcome to Robbers Roost: A Historic Treasure on 52 Acres with Modern Comforts!<br /> <br /> Originally built in 1910, this beautifully remodeled two-story farmhouse sits on 52 acres (MOL) of rolling hills, providing stunning sunrises and sunsets that paint the sky with breathtaking colors each day. Nestled in a tranquil setting, this property offers the perfect combination of peace, privacy, and opportunity. It features an early 1900s barn, ideal for those interested in farming or raising livestock, and a stocked 2-acre pond, perfect for fishing or simply enjoying the serene water views.<br /> <br /> This home is the ideal blend of historical charm and modern convenience, thanks to several key upgrades. The entire house has been rewired, providing both safety and modern functionality. A brand-new HVAC system ensures comfortable temperatures year-round, while an updated septic system and new water heater offer reliability for everyday living. Water quality is top-notch with a whole-house filtration system as well as an under-sink kitchen water filter, complete with a separate drinking water faucet.<br /> <br /> Inside, you’ll find a thoughtfully remodeled kitchen that seamlessly blends historical character with contemporary amenities, creating a warm and welcoming space for any home chef. With its spacious layout, this home is perfect for large families or those who love to entertain. The generously sized living areas ensure there’s room for everyone to relax. The bathrooms have been updated to offer a harmonious blend of old-world charm and modern luxury, making them a perfect retreat for unwinding at the end of the day.<br /> <br /> Whether you're looking to enjoy a peaceful rural lifestyle or start your own micro-farm, Robbers Roost offers endless possibilities. With too many features to list, you won’t want to miss out on this one-of-a-kind property. Schedule your private tour today and be sure to explore the 3D virtual tour to experience all that Robbers Roost has to offer!
MlsNumber: --
ListingId: 2436132


Listing Provided By: Epique Realty, original listing
Phone: (888) 560-3964
Office Phone: (888) 560-3964
Agent Name: Brian Allen
Disclaimer: Copyright © 2024 MLS Technology, 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