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

44774 Yeller Tan Lane
Talihina, OK 74571
Melissa Blagg with Talihina Realty, original listing - (918) 413-0302

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $695,000
Beds: 4
Baths: Full: 1, ½: 1
Status: Active
SqFt: 1924 Square Feet
Agency: Talihina Realty
Agency Phone: (918) 413-0302

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 42 acre(s)
Garage: Garage
Property Type: Residential-Farm
Year Built: 2005
Notes: Welcome to your dream horse property! Nestled in the heart of Southeast Oklahoma, this exquisite 4-bedroom, 2-bath ranch house offers the ultimate combination of privacy, functionality, and natural beauty. As you travel down your semi-private driveway, you'll immediately sense the peacefulness of this secluded oasis, surrounded by large landowners, ensuring tranquility and uninterrupted views. Set on 42 lush acres, this property is a horse lover's paradise. The land is completely fenced, featuring a perfect mix of open pasture, ideal for grazing, and wooded areas that offer excellent hunting opportunities. A picturesque pond adds to the charm and provides a reliable water source for your livestock. The ranch comes equipped with a well-designed, metal-sided horse barn that includes four spacious horse stalls, each with its own feed/tack room. Additional sheds are available for livestock and storage, ensuring that your animals have all the space and protection they need. The unique farm-style home is a blend of rustic farm-house charm and modern comfort. Hardwood floors run throughout the house, adding warmth and character to every room. The oversized master suite serves as a cozy retreat, perfect for unwinding after a day of ranching. The commercial-grade cook stove and refrigerator in the kitchen make meal preparation a breeze, whether you're cooking for your family or hosting a gathering. Central heat and air, along with a Generac backup generator, provide year-round comfort and peace of mind, ensuring that you are well-prepared for any situation. Step outside to the elevated covered back porch, where you can take in the breathtaking views of your ranch and the surrounding mountains. Whether you're enjoying a peaceful morning coffee or watching the sun set over the horizon, this spot will quickly become your favorite place to relax. This ranch is not just a property; it's a lifestyle. If you're looking for a serene setting, exceptional privacy, and a well-appointed home designed with the horse enthusiast in mind, this is the place for you. Don't miss out on this rare opportunity to own a piece of paradise in Southeast Oklahoma! Location, Location, Location! Only 20 minutes to Sardis Lake boat ramp, 10 minutes to the Ouachita National Forest, Within 30 minutes of multiple equestrian trails and local state parks, 40 minutes to Hochatown and Beavers Bend (Broken Bow Lake), within 3.5 hours to DFW or OKC
MlsNumber: --
ListingId: 11338989


Listing Provided By: Talihina Realty, original listing
Phone: (918) 413-0302
Office Phone: (918) 413-0302
Agent Name: Melissa Blagg
Disclaimer: Copyright © 2024 My State MLS. 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