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;

448073 E Cr 1640
Talihina, OK 74571
Lara Crank with Red River Realty and Auction, original listing - (580) 924-9595

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $500,000
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 1368 Square Feet
Agency: Red River Realty and Auction
Agency Phone: (580) 924-9595

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 40 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2014
Notes: This 2 bedroom, 2 bath home on 40 acres sits just 6 miles from town. This picturesque place has so much to offer, starting with a wonderfully designed home, shop building/barn, chicken house, and round pen. The home its self gives off a warm welcome to all who enter. The Kitchen and living area have a very nice clean, open, country design with vaulted ceilings, recessed LED lighting, and knotty pine that help set the stage. The kitchen cabinetry with the stone back splash complement each other beautifully. The stone framed fire place and the lighting from all the large windows in the living area really make this place feel like home. Large Family gatherings would be not problem in this home, plenty of room for the whole family. Several storage closets and coat closets to provide that additional storage that we all need for keeping things tidy are also located throughout the home. The Master bedroom has its own private full bathroom and is large in size. It also has a very nice closet design for hanging clothes and storing shoes to keep everything out of sight and off the floor. The guest bedroom is just across the hall, and is also very large in size and not far from the guest bathroom and also has a nicely designed closet. The home has a nice workable, flowing feel and truly is a must see. The home also comes with a very nice large front porch that with a few furnishings, would make a wonderful place for having that morning coffee and watching the sun rise. The Patio out front is also a great place for that evening night cap or for a wonderful cook out. The Workshop/Barn is 1800 Sq. ft. One could enclose the front, or just leave it as is and store your tractors, lawnmowers, and other equipment inside. The back of the shop is enclosed for storage, feed, or tack for the horses. There is a nice sized round pen made from cedar post and boards, a chicken house that is a 12X12 and 2 Large Ponds. The pond in the back has been stock with channel cat, crappie, large mouth bass, red ear and blue eared perch and has a solar aerator. The property is fenced with new fencing and post, cross fenced, has 9 gates on the property, plenty of trails for ATV or 4 wheeler, and lots of deer and other wild life for the avid hunter in the family. There is also 2 seasonal creeks for your children or grand children to enjoy during those hot summer months. This Property has several large pines that provide that secluded feeling, with town just a few miles away for all your local shopping needs. This property sits 15 minutes from the Ouachita National Forest, 20 minutes from Sardis Lake, and 35 Minutes from Robbers Cave National Park. Call today to see this property 9one8 eight3nine 13zero5
MlsNumber: --
ListingId: 11399631


Listing Provided By: Red River Realty and Auction, original listing
Phone: (580) 924-9595
Office Phone: (580) 924-9595
Agent Name: Lara Crank
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