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;

3101 Se Highway 63
Talihina, OK 74571
Melissa Blagg with Talihina Realty, original listing - (918) 413-0302

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $395,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Talihina Realty
Agency Phone: (918) 413-0302

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Nestled in the heart of Southeast Oklahoma, lies a well maintained 2017 Legacy home, set on 20 acres of picturesque land. This property, with its views of the nearby mountains, is more than just a house-it's serene place to call home. With 4 bedrooms and 3.5 baths, this home allows lots of space for a large family. The living room welcomes guests into the home and provides a cozy place for some quiet relaxation. The large kitchen is the heart of the home and has ample counter space to prepare family dinners with a sink in the built-in island. From the kitchen, step into your spacious den, the perfect place for family gatherings, game night or just quality time with friends and family. The dining area has a sliding glass door that opens up to the oversized covered back porch. Adjacent to the kitchen, an office nook provides a spot for productivity, while the laundry room with a convenient side entrance adds to the home's practicality. Wake up each morning in your master suite, where you have not one but two walk-in closets. The suite also features a dressing room with a sink, and a large bathroom complete with a garden tub and a separate shower. At the opposite end of the home, there are 3 bedrooms and 2 full sized bathrooms for kids or guests. From the front porch, you can sip your morning coffee while overlooking the lush front lawn. In the evenings, the large back porch becomes your personal haven, offering tranquil views of the hay meadow with a pond. Beyond the main house, the property boasts a massive 40x80 shop with 3 tall garage doors and overhang sheds on both sides, ideal for all your mechanic projects and storage needs. The storm cellar is located close to the back porch and provides peace of mind. This property also includes a second, smaller home. Though older, it holds great potential for renovation into a guest house or rental property, adding to the versatility of this already amazing estate. Life here places you just a short drive from Sardis Lake, where you can enjoy boating, fishing, and scenic trails. And with Dallas only 3.5 hours away, you have the perfect blend of seclusion and accessibility. This home isn't just a place to live; it's a place to create lasting memories. Contact us today to explore this exceptional piece of Southeast Oklahoma paradise and see how it can become the backdrop for the next chapter of your life.
MlsNumber: --
ListingId: 11327830


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