Title Page Background
DEBUG FN args: Array ( [0] => 642 [1] => [2] => [3] => agent ) BEFORE: Site: 642 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 642 Igate: njhud LocID: 642 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 642 AND i.igate IN ('tnhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 642 [1] => [2] => [3] => lender ) BEFORE: Site: 642 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 642 Igate: njhud LocID: 642 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 642 AND i.igate IN ('tnhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 642 [1] => [2] => [3] => other ) BEFORE: Site: 642 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 642 Igate: njhud LocID: 642 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 642 AND i.igate IN ('tnhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

3183 W Mitchell
Hanover, IL 61041
STEPHEN "HENRY" CLAY with JIM SULLIVAN REALTY, original listing - (815) 947-9040

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $899,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 1906 Square Feet
Agency: JIM SULLIVAN REALTY
Agency Phone: (815) 947-9040

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 59 acre(s)
Garage: Garage
Property Type: Farm-Farm
Year Built: --
Notes: Beautiful Heart Built custom built 3 BR 3 Bath log home on 60-acre recreational property located in the heart of Jo Daviess County. Nestled in the hills between Elizabeth and the Galena Territory, this property is among the picturesque valley views witnessed from the popular Scenic overlook on Hwy 20. This valley is quite possibly one of the most beautiful valleys in all of Illinois. Surrounded by hills, mature forests and abundant wildlife, it is an ideal location to become immersed in nature. Whether used as a getaway or permanent residence, in this serene setting, you cannot help but relax and have fun. This magnificent home has 3 floors with the primary living area on the main level. Beautiful hardwood floors that have been fully restored in 2024, a kitchen large enough to impress any chef that boasts high-quality, black granite counter tops, and stainless appliances. The lower level is fully finished with a gas fireplace, large bedroom, full bath, and a laundry/utility room. The upper level hosts the primary bedroom suite, with a spacious loft area, and a patio door that accesses a wonderful wrap around deck fully rebuilt in 2024. There is a beautiful staircase built using half logs that overlooks the great room below used to access this level. The property includes 2 large sheds that can be utilized for a multitude of purposes. The primary shed/garage has an asphalt floor and a fully functional workshop with a heated area, full bath, and large overhead doors on both ends. Adjacently, another large shed was built as a horse-riding arena with a sand floor. There is also a ¾ acre stocked pond. The game fish includes largemouth bass, crappie, and bluegill to mention a few. With all 60 acres accessible, this is the perfect property for ATV and snowmobile enthusiasts. Additionally, hunting here is world class. The Conservation area Tapley Woods, borders the property, along with endless fields of hay and cropland. In addition, the property has a grid tied solar array professionally built by Eagle Point Solar which offset electrical costs. Most months, solar produces more electricity than the home uses. Recent updates include a new patio door on the main level, new railings on the front deck, new LED lighting and ceiling fans, and the new upper deck and refinished hardwood floors mentioned above. This is truly a beautiful unique property that must be seen to truly appreciate.
MlsNumber: --
ListingId: 202407023


Listing Provided By: JIM SULLIVAN REALTY, original listing
Phone: (815) 291-7915
Office Phone: (815) 947-9040
Agent Name: STEPHEN "HENRY" CLAY
Disclaimer: Copyright © 2025 Rockford Area 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