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;

2003 W Hanover Road
Hanover, IL 61041
Amanda Wycoff with BHHS Central Illinois, REALTORS, original listing - (309) 663-7653

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,750,000
Beds: --
Baths: --
Status: Active
SqFt: 15000 Square Feet
Agency: BHHS Central Illinois, REALTORS
Agency Phone: (309) 663-7653

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Commercial Sale-Mixed Use
Year Built: 2008
Notes: This phenomenal Investment Opportunity on 112 Acres in the Galena Hills with a 5-acre Lake, 3 Exquisite Lodges, and a Winery! Breathtaking views of the Galena Territory make this property an ideal choice for weddings, special events, and even the prospect of a future resort. Actively thriving as Rocky Waters Vineyard & Winery, an award-winning 25-acre vineyard with the potential to expand up to 60 acres, this property offers turn-key income potential. However, if the new owners prefer not to be Winemakers, the sellers will "grapefully escape" and will remove the vines and equipment to allow the new owners to create their own dream. This estate provides three beautifully crafted homes, including a 15,000 sq ft luxurious main lodge with room for conversion into a bed & breakfast and an additional apartment. The Lodge features magnificent views & wrap-around decks for an immersive outdoor living experience, an exquisite gourmet kitchen, and a lower-level event space for up to 115 people. The Manager's Residence is placed on a specified 5 acres and offers 5 bedrooms, 3.5 baths, and a finished walk-out basement. The Fisherman's Cabin sleeps 10 and currently serves as an in-demand VRBO rental. This estate has been lovingly cared for by the same family since its creation. Rocky Waters is not only a rare investment opportunity but when the torch is passed, the new owners will be gifted peace of mind regarding quality, maintenance & attention to detail in every square foot. Indeed a dream come true! A plethora of additional information is available upon request!
MlsNumber: --
ListingId: 11895706


Listing Provided By: BHHS Central Illinois, REALTORS, original listing
Phone: (309) 242-2647
Office Phone: (309) 663-7653
Agent Name: Amanda Wycoff
Disclaimer: Copyright © 2024 Midwest Real Estate Data, LLC. 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