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

7862 E County Road 1195
Wetumka, OK 74883
Eric Zellers with Keller Williams Advantage, original listing - (918) 712-2252

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $829,000
Beds: 4
Baths: Full: 4
Status: Active
SqFt: 2892 Square Feet
Agency: Keller Williams Advantage
Agency Phone: (918) 712-2252

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 160 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1998
Notes: WELCOME TO COUNTRY LIVING AT ITS FINEST! Through the gated entry, you're greeted by a country-style home spanning nearly 2,900 sq. ft. This charming residence has 4 beds and 4 baths, nestled on approximately 160 acres of fully fenced land—ideal for those dreaming of starting their own family ranch with great recreational opportunities as well. This acreage comes with a detached shop perfect for storing equipment, hunting supplies, and other items. Included also is a lean-to and corrals designed for cattle. Two ponds add convenience for watering livestock and wildlife, making the land fully functional and ready for use. Inside the home you’ll find a cozy living area. The master suite features his-and-her sinks and a large jetted tub, while the other bedrooms are spacious and comfortable for family or guests. Mudroom connecting to the garage adds to the functionality for life on land. Home boasts a low-maintenance full metal roof. The land is spacious and diverse providing ample land for livestock and the perfect mix of habitat for wildlife including trophy deer, turkey, and wild hogs. The rolling terrain and mature hardwoods creates the opportunity for developing food plots and strategic hunting locations. The front yard is enclosed by a charming white 3-rail fence while the backyard is secured by chain link fencing—providing a safe space for children or smaller animals to play away from livestock. Imagine yourself starting your day on the wrap-around porch, sipping your morning coffee as the sun rises, or winding down in the evening with iced tea, watching the sunset over your vast property. Located off a quiet country road, the property offers easy access to Hwy 27 and proximity to I-40 and Hwy 75, urban amenities are just a short drive away. Plus, Wetumka Lake is less than 2 miles away, making it the perfect spot for water enthusiasts to fish, boat, or kayak in no time. Looking for the perfect family ranch/recreational acreage? This is the property for you!
MlsNumber: --
ListingId: 2435258


Listing Provided By: Keller Williams Advantage, original listing
Phone: (918) 948-9372
Office Phone: (918) 712-2252
Agent Name: Eric Zellers
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