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

414315 E 1080 Road
Checotah, OK 74426
Stephanie Abbott with RE/MAX Preferred, original listing - (405) 751-4848

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $975,000
Beds: 4
Baths: Full: 4
Status: Active
SqFt: 2788 Square Feet
Agency: RE/MAX Preferred
Agency Phone: (405) 751-4848

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 108 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2000
Notes: Unbelievable 108+/- acres with 4 ponds, custom home, PLUS apartment/office/studio/guest house, 2 barns, loafing sheds, lean to’s…Everything ready to run cows, cut hay, store treasures, work from home, entertain guests, ROOM TO ROAM! Main house boasts 3 bedrooms, each with on suite bathroom, formal living room AND den, formal dining AND cozy breakfast room, good sized utility room with storage. GORGEOUS kitchen; Island with prep sink, oak cabinets, pantry, on-trend checkerboard tile flooring, smooth top electric ceramic stove and separate built-in oven, view of back pasture from kitchen sink window. Fantastic front porch, impressive entry gate. Apartment with bedroom, bathroom and oversized office/living/gameroom connected to house by breeze way is perfect for guest space, separate living quarters, gym, studio, hobby area or home business. Commercial steel construction, roof replaced end of 2024. 30 x 40 barn with concrete floor, oversized doors and heat has its own electric meter. Easy access to Lake Eufaula boating, swimming, golfing. Checotah schools. Meticulously cleaned and cared for home, barns and pastures. Refrigerator, washer and dryer to remain with acceptable offer. Minerals and hay bins reserved.
MlsNumber: --
ListingId: 1153035


Listing Provided By: RE/MAX Preferred, original listing
Phone: (405) 751-4848
Office Phone: (405) 751-4848
Agent Name: Stephanie Abbott
Disclaimer: Copyright © 2025 MLSOK, 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