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

Blue Mountain Road
Hodgen, OK 74939
Trina R. Ward with RE/MAX Champion Land, original listing - (918) 552-9100

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $530,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: RE/MAX Champion Land
Agency Phone: (918) 552-9100

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 177 acre(s)
Property Type: Land-Other
Year Built: --
Notes: BLUE MOUNTAIN NATIONAL FOREST: From the east point of Blue Mountain down to the shadows of Short Hollow and the headwaters of Conser Creek, this property is what describes the serenity of Southeast Oklahoma. and adjoins the National Forest at points on the north and west boundary. <br /> LOCATION: Located in LeFlore County, Southeast Oklahoma. The property is in the beautiful Ouachita Mountains and backs up to the Ouachita National Forest on two sides. The Holson Valley game management area is just south and the National Forest contact on the west. Cedar Lake, home of the state record largemouth bass, is less than 2 miles to the southeast. The Black Fork River, the home of Oklahomas best kept smallmouth bass secret is approximately 5 miles east. <br /> SITE: 177 acres m/l of mature forest, with the typical SE Oklahoma mixture of deciduous and evergreen mix. A very desirable terrain diversity, portions nearly level to a moderate sloping. Conser Creek enters the property on the southwest portion, exiting on the northeast. Bordered by National Forrest along part of the west as well as north boundary. <br /> IMPROVEMENTS: Cabin, approximately 16X20 in good shape, sitting on the knoll on northern portion. Just an excellent site, easy access from Blue Mountain Road across a beautiful saddle loaded with mature woods, dropping in all directions to the lower elevation. <br /> USAGE: Homestead, cabin-sites, camping, hunting, hiking, equine, just enjoying nature. Electric on E side. <br /> WILDLIFE: Whitetail deer, eastern wild turkey, squirrel, and black bear. <br /> COMMENTS: A unique property offering just about everything an outdoors person could want in a recreation property. Good access, electric, isolation, National Forest, wildlife galore, mature woods, creek, terrain diversity, cabin.
MlsNumber: --
ListingId: 2434289


Listing Provided By: RE/MAX Champion Land, original listing
Phone: (918) 658-8010
Office Phone: (918) 552-9100
Agent Name: Trina R. Ward
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.


Local Real Estate Expert

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 = 2165 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;
Real Estate Expert Photo for Barry Fitch
Barry Fitch
ASCIICENTURY 21 First Choice Realty
Call Today!: (918) 564-1042

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App