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;

1 Clearwater Lane
Hodgen, OK 74939
Bob Bowman with United Country-Mixon Realty & Auctions, original listing - (918) 839-4717

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $89,000
Beds: 1
Baths: Full: 1
Status: Active
SqFt: 512 Square Feet
Agency: United Country-Mixon Realty & Auctions
Agency Phone: (918) 839-4717

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1996
Notes: Location: This is a very unique property that is nestled in the heart of the Ouachita National Forest in a beautiful valley setting between the Winding Stair Mountain Range to the South and Blue Mountain to the North. The property offers direct access to the 1.8 million acre Ouachita National Forest, which provides excellent hunting opportunities for whitetail deer, eastern wild turkey, black bear, wild hog and other small game as well as direct access to an impressive network of ATV, hiking and horseback riding trails that are operated and maintained by the US Forest Service. This property is located 1.5 miles West of Post Mountain Lake and less than 10 miles from Cedar Lake, which is where the last two Oklahoma state record largemouth bass were caught. Near-by towns include Heavener, Talihina, Big Cedar, Broken Bow and Hochatown. This property is about a 3.5 hour drive from Dallas, Texas. Location: 34.80442, -94.7637 Services to Property: This area is considered off-grid, meaning there are no public utilities available for connection. Cabins in off-grid locations typically rely on alternative systems such as solar power, generators, rainwater collection, water wells, and septic systems for their essential needs. Access to Property: The property is accessed by a county-maintained dirt US Forest Service Road (Game Track Road & Clearwater Road). This is an all-weather access road. The property is located behind an entrance gate which restricts access to the general public. Land: The cabin sits on 1 acres of level to gently sloping land. The property is covered with a mature stand of hardwood and evergreen timber that is native to south eastern Oklahoma including a diverse variety of oak trees, redbud, hickory, sweet gum, eastern red cedar and native shortleaf yellow pine. The East property line has frontage to the 1.8 million acre Ouachita National forest, which provides many recreational opportunities. Wildlife are frequently seen on the property as well as the adjoining National Forest. Off-Grid Cabin: There is a 24 ft x 24 ft off-grid cabin on the property with an 8 ft x 24 ft covered back porch. The cabin exterior is finished out with green metal roofing and Hardie board siding. The inside of the cabin in unfinished with walls framed in for a 14 x 16 living room, 10 x 16 bedroom, 3 x 4 closet, 8 x 10 kitchen and 5 x 8 bathroom. There is a wood burning stove in the living room. Agent's Comments: This "One of a Kind" property is an outdoorsman's paradise and, in my opinion, this property can be classified as true "Investment Grade Recreational Property". It is the ideal setting for a relaxing and peaceful weekend getaway from city life or even a full time residence to completely un-plug from society. This is a very unique recreational property that provides direct access to the 1.8 million acre Ouachita National Forest with hunting, horseback riding, hiking, ATV riding, camping and fishing. Disclosure: Seller is owner/agent.
MlsNumber: --
ListingId: 11502117


Listing Provided By: United Country-Mixon Realty & Auctions, original listing
Phone: (918) 839-4717
Office Phone: (918) 839-4717
Agent Name: Bob Bowman
Disclaimer: Copyright © 2025 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