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 = 642 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 = 642 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 = 642 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;

9294 S Gamble Hill
Elizabeth, IL 61028
BRANDON BEYER with JIM SULLIVAN REALTY, original listing - (815) 947-9040

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,600,000
Beds: 3
Baths: Full: 1, ½: 1
Status: Active
SqFt: 2083 Square Feet
Agency: JIM SULLIVAN REALTY
Agency Phone: (815) 947-9040

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 346 acre(s)
Property Type: Farm-Farm
Year Built: --
Notes: Recreational buyers and wildlife enthusiasts take note-this is a generational opportunity to acquire one of the most diverse and distinguished large acre recreational properties that you will find anywhere in the Midwest. This 346.52 +/- acre farm offers everything from a private 28 acre lake along with various other sloughs and ponds, almost one mile of Rush Creek frontage, multiple stands of towering pine trees, and dramatic hardwood ridges and valleys with some incredible views across the property and beyond. A tale of two sides-the west side of the property features a large ridge with approximately 120 acres of hardwoods and upland game. The east side sits down the Rush Creek valley and showcases scattered wetlands and a mix of low lying tree species, open grasslands, scattered stands of pines and an abundance of waterfowl species. The topography offers many natural funnels and pinch points that hunters could use to their strategic advantage as well as many openings that could be converted to large food plots including approximately 55 acres that are currently in row crop production. Sitting just off the shore of the lake is a 3 bedroom, 1.5 bath cabin with a large master bedroom, a cozy great room with a wood burning fireplace, and a 3 season room facing the lake that would be the ultimate spot to relax and immerse yourself in the sights and sounds of nature. This property is conveniently located a half hour from downtown Galena, 3 hours to downtown Chicago, 3 hours to downtown Milwaukee, 2 hours to downtown Madison, and just 1.5 hour from the Quad Cities. There are no amount of words or photographs that could capture everything that this property has to offer. It is a once in a lifetime opportunity and a MUST see for the serious buyer looking to acquire their own private wildlife oasis.
MlsNumber: --
ListingId: 202405274


Listing Provided By: JIM SULLIVAN REALTY, original listing
Phone: (815) 275-3612
Office Phone: (815) 947-9040
Agent Name: BRANDON BEYER
Disclaimer: Copyright © 2024 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