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

466570 Highway 101
Sallisaw, OK 74955
Brian Wright with Century 21 Wright Real Estate, original listing - (918) 456-5288

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $995,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 2400 Square Feet
Agency: Century 21 Wright Real Estate
Agency Phone: (918) 456-5288

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 147 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1987
Notes: Dive into the world of equestrian living with this exciting horse property nestled in the heart of North East Oklahoma! Formerly a thriving Thoroughbred Ranch, this picturesque estate boasts everything your equine companions need for a life of comfort and adventure. Set upon sprawling acres of pasture land, this property offers a haven for horses and horse enthusiasts alike. Five separate pastures provide ample space for grazing, while sturdy corrals ensure safety and security. Spacious 60x80 Horse Barn, featuring 6 cozy stalls adjacent to 3 Pipe Fence Runs. A massive 80x100 Hay Barn or Implement Shop provides ample storage for feed and equipment. Lush Bermuda Grass blankets the landscape, offering a soft and inviting terrain for your horses to roam. Two serene ponds dot the landscape, adding a touch of tranquility. And for those hot summer days, Sallisaw Creek runs along the East property line, offering the perfect spot for crawdad hunting and refreshing splashes. Plus, it serves as a reliable year-round water source for your horses. Conveniently located just 7 miles north of Sallisaw and with easy access from a paved highway, this property combines rural charm with accessibility. The flat land ensures a smooth entrance, while its central location makes it a prime spot for both convenience and privacy. As if that weren't enough, a spacious 2400 sq ft house is included in the deal! With its charming Hacket Stone exterior, large deck, and endless potential, this home is a blank canvas waiting for your personal touch. Boasting four bedrooms, three baths, and two living areas, it offers plenty of space for you and your family. While the home is solid, it awaits the craftsmanship of a handyman to unlock its full potential. Imagine the possibilities as you transform this house into the country retreat of your dreams, all while enjoying the unparalleled beauty and serenity of your own private horse property!
MlsNumber: --
ListingId: 1072327


Listing Provided By: Century 21 Wright Real Estate, original listing
Phone: (918) 456-5288
Office Phone: (918) 456-5288
Agent Name: Brian Wright
Disclaimer: Copyright © 2024 Fort Smith Board of Realtors. 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