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

414548 Highway 266
Council Hill, OK 74428
Stephanie Fine with Porches and Pastures, original listing - (918) 923-3727

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $559,000
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 1456 Square Feet
Agency: Porches and Pastures
Agency Phone: (918) 923-3727

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 48 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1960
Notes: ESCAPE TO THE TRANQUILITY OF THE COUNTRYSIDE!! Nestled on 48.57 picturesque acres (+/-) and bordering Corps of Engineers' land, this property is a haven for hunting, fishing, and all kinds of outdoor activities. The updated home boasts a spacious kitchen, perfect for preparing delicious meals for family and friends. The primary suite features a large en suite with a relaxing whirlpool tub, offering a luxurious retreat. In addition, the property includes an impressive 40x80 shop building with a 20x40 covered patio/awning, providing endless possibilities for customization. There's potential for a living area, kitchenette, bedroom/bunkroom, and bathroom, making it perfect for guests or additional living space. This property provides the perfect setting to unwind and enjoy nature's beauty. The serene pond adds to the tranquil atmosphere, making it a great spot for fishing or simply relaxing while surrounded by nature. With its wide-open land and ample water sources, this property offers endless possibilities for farming or gardening. Conveniently located with easy access to Checotah, Eufaula, and just a short drive to Tulsa, this property offers both seclusion and accessibility. Don’t miss out on this rare opportunity to OWN YOUR OWN SLICE OF PARADISE! Call today to schedule your private viewing and experience the beauty and potential of this remarkable property!
MlsNumber: --
ListingId: 2417960


Listing Provided By: Porches and Pastures, original listing
Phone: (918) 470-5122
Office Phone: (918) 923-3727
Agent Name: Stephanie Fine
Disclaimer: Copyright © 2024 MLS Technology, 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