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;

22078 Conser
Hodgen, OK 74937
Trina R. Ward with RE/MAX Champion Land, original listing - (918) 552-9100

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $260,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: 65 acre(s)
Property Type: Land-Other
Year Built: --
Notes: CONSER Rd 65 Acres Near the Quachita National Forest & Cedar Lake!<br /> Great opportunity for a slice of the Oklahoma dream with all the desires of country living. On the edge of the small rural community of Hodgen, Oklahoma, within 1.5 miles to the Ouachita National Forest & minutes to the 86 acres Cedar Lake known for the starting point of the Winding Stair Mountain Equestrian Trails. <br /> SITE: 65 acres m/l of mostly woods and raw nature. Property slopes from Conser Road and levels off smoothly to the back 40 acres, which would be an excellent place for your home-site. Garden spot with good soils would be a plus for all your spring and fall plantings.<br /> IMPROVEMENTS: Raw land can customize to your personal specifications.<br /> UTILITIES: Electric on both south and west property lines. Rural water lines on the south property line. Nearest water well across Conser Rd is at 110 ft with water level at 35 ft, as reference only. Local broadband service providers, cell companies, and Starlink deliver high-capacity service here. <br /> COVER: The property is presently populated with mature oak, hickory, sycamore, and loblolly pine timber proving that nature is present but could be altered to your desire and needs. One pond on the property and a wet weather stream lies on the northern part which is perfect for wildlife habitat.<br /> ACCESS: Well-maintained paved county road.<br /> MINERALS: none<br /> WATER/STREAMS: 1 pond, wet weather stream, rural water.<br /> COMMENTS: The aesthetics of this property are off the charts with the seclusion, trees, privacy, pond, hunting, primary home-site/cabin potential, or a second home, truly endless opportunities. Very good location and close to many attractions but the reality of total privacy/seclusion. This could be whatever you want it to be, primary home site, have your own shooting range, wildlife camp, horse haven or just your private get-a-way place. A very well-located tract that could be your premier show property. Make this your own slice of Oklahoma!!
MlsNumber: --
ListingId: 2435297


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