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 ('mihud','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 = 'mihud', 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 ('mihud','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 = 'mihud', 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 ('mihud','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 = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

3175 W Mitchell
Hanover, IL 61041
ANDY KLEMMT with CHOICE REALTY, original listing - (815) 777-3100

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $950,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: CHOICE REALTY
Agency Phone: (815) 777-3100

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 62 acre(s)
Property Type: Land-Other
Year Built: --
Notes: Located at the end of Mitchell Road with great views into the village of Elizabeth. Ideal Building site! Great Exposure for a full finished basement. . Must see to appreciate. River Ridge School District. Located in the heart of Jo Daviess County. Nestled in the hills between Elizabeth and Galena Territory, perched upon 62 acres of verdant grassland, high elevation and rolling hills featuring a private pond, breathtaking vistas for miles and amazing panoramas highlighting the stunning beauty of the surrounding Jo Daviess County. This property is among the picturesque valley views witnessed from the popular Scenic Overlook on Hwy 20. This valley is quite possibly the most beautiful valley in all of Illinois. Surrounded by hills, mature forests and abundant wildlife, it's an ideal location to become immersed in nature. Whether used to build as a getaway or permanent residence, in this serene setting, you can’t help but relax, have fun and enjoy life. Seasonal stream on property along with spring fed stocked pond. 45 plus acres of income. Electric on the property, but not yet connected. Well & septic would be needed to build. There is a 30 x 80 pole barn on property. With the close proximity to The Galena Territory Association (GTA) ; with ownership of a vacant lot & affordable membership you would have access to all of the GTA Amenities: Owners' Club with indoor and outdoor pools, fitness facility, outdoor tennis, multi-sport gym and game room. Lake Galena and the Marina Complex, The Shenandoah Riding Center along with the 24-mile Trail System and Greenspace provide over 1,900 acres of year-round outdoor recreation. and all of this is just a short drive to the restaurants, championship golf, and spa facilities of Eagle Ridge Resort & Spa on the GTA grounds.
MlsNumber: --
ListingId: 202404933


Listing Provided By: CHOICE REALTY, original listing
Phone: (815) 291-8911
Office Phone: (815) 777-3100
Agent Name: ANDY KLEMMT
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