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 = 675 AND i.igate IN ('usahud','ilhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 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 = 675 AND i.igate IN ('usahud','ilhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 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 = 675 AND i.igate IN ('usahud','ilhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 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;

221 Lusk Rd
Golconda, IL 62938
Maureen Stafford with Hunt and Farm Realty, original listing - (618) 559-2967

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $435,500
Beds: 3
Baths: Full: 1
Status: Active
SqFt: 1200 Square Feet
Agency: Hunt and Farm Realty
Agency Phone: (618) 559-2967

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 67 acre(s)
Garage: Garage
Property Type: Farm-Farm
Year Built: 1992
Notes: Check out the expansive views on this multi-use property located in the heart of the War Bluff horseback riding area. 67 +/- acres with approximately 33 acres in woods with young hardwoods, 30 acres of open fields for crops and hay, 4 acres of residential and former campground area. Established trails through the woods make touring the property easy and scenic. The campground with 10 campsites and 30' x 24' club house with kitchen and bathroom could be brought back to life and your dream of having recreational property adjacent to the Shawnee National Forest could come true! Beautiful building site for your home or weekend cabin, 36 x 26 pole barn with concrete floor, electricity and a lean to will hold all your toys. 3 bedroom/1 bathroom home on property is being sold as-is. This property is located just 8 miles from Golconda, Illinois, which has a newly remodeled grocery store, hardware store, library, USPS, Dollar General, Golconda Marina, and multiple restaurants and taverns. The 9-Day Trail Ride near One-Horse Gap takes place annually just down the road from this property and the many Shawnee National Forest attractions in the area include Garden of Gods, Iron Furnace, Rim Rock, Lake Glendale Recreational Area. This property has been owned by the same family for almost 200 years and this is the first time it has been listed with a real estate brokerage. There is a survey on record at the courthouse and corners were easily located.
MlsNumber: --
ListingId: 11393863


Listing Provided By: Hunt and Farm Realty, original listing
Phone: (618) 599-0586
Office Phone: (618) 559-2967
Agent Name: Maureen Stafford
Disclaimer: Copyright © 2024 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