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

106181 N 3810 Road
Okemah, OK 74859
April Curry with OK Real Estate LLC, original listing - (918) 623-0200

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $491,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 2911 Square Feet
Agency: OK Real Estate LLC
Agency Phone: (918) 623-0200

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 40 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1997
Notes: Nestled in a tranquil, wooded 40 acre m/l landscape, this custom-built, meticulously-maintained four bedroom, three and one-half bath home is the perfect blend of privacy and sophistication. Surrounded in mature trees-including towering pines, many hardwoods, and a stunning maple in the front yard-this home offers a serene escape with nature at every turn. The home has had many new recent updates including new travertine flooring, two new HVAC systems with in-home dehumidifier, thermal windows and patio door to provide energy and efficiency. The kitchen has some new appliances including Kitchen aide refrigerator and trash compactor. The property has a 24/7 camera surveillance system installed for added security and monitoring. Step into the veranda for peaceful outdoor living and relaxation or explore the scenic trails throughout the property. There are two ponds including one with beautiful boulders along the edge. An ideal property for the nature or hunting enthusiasts. A breezeway connects the home to a detached garage equipped with new built-in metal cabinetry offering plenty of storage and convenience. The garage also offers a walk-in storm shelter and automatic overhead door. With high-speed internet in place, this property combines the seclusion of a nature retreat with modern connectivity- also being only 5 miles from the amenities of town. With numerous updates and thoughtful design, this property is more than a home-it's a lifestyle. The owner has recently added professionally-installed barbed wire fencing to much of the property line. The property has had a recent survey completed and a biologist report to share with the new buyer. The property is furnished with the following utilities: East Central Electric, EcoLink fiber internet, Okfuskee County rural water district 3, and propane. This property is centrally located between Tulsa and Oklahoma City as well as easy access to Interstate 40 for the commuter.
MlsNumber: --
ListingId: 1142842


Listing Provided By: OK Real Estate LLC, original listing
Phone: (918) 623-0200
Office Phone: (918) 623-0200
Agent Name: April Curry
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