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

49345 Us Highway 41
Hancock, MI 49930
GINGER STROUBE with RE/MAX DOUGLASS R.E.-H, original listing - (906) 482-1000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $225,000
Beds: 3
Baths: Full: 2
Status: Active Under Contract
SqFt: 1152 Square Feet
Agency: RE/MAX DOUGLASS R.E.-H
Agency Phone: (906) 482-1000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Garage: Garage
Property Type: Residential-Manufactured Home
Year Built: 1983
Notes: SO MUCH TO OFFER This Quincy Township gem offers so much to love, ideally situated across from the scenic lookout on historic Quincy Hill. The 1983 Liberty home has been thoughtfully updated, blending modern comforts with practical enhancements. Step into a beautifully renovated kitchen featuring granite tile countertops, new cabinetry, stainless steel appliances, and a convenient snack bar—perfect for everyday living and entertaining. The spacious primary bedroom includes an updated en-suite bath, complete with a corner shower, and a large vanity topped with sleek quartz. On the opposite side of the home, you'll find two additional bedrooms with ample closet space, served by a second full bath, creating a well-balanced layout for family or guests. Additional highlights include a 24x24 detached garage with a workbench, new roof and garage door (2021), and a generous 12x25 storage shed with a durable galvanized metal roof. The home's crawlspace was encapsulated and insulated with foam in 2018 for enhanced energy efficiency and comfort year-round. Energy-conscious buyers will appreciate the existing net metering agreement with UPPCO—just contact the utility to transfer the setup. Don't miss the opportunity to own this unique conveniently located property in a picturesque setting with a strong list of updates and features. NOTICE: All information believed accurate but not warranted. Buyer recommended to inspect & verify all aspects of the property & bares all risks for any inaccuracies including but not limited to estimated acreage, lot location/size, square footage, utilities (availability & costs associated). Real estate taxes are subject to change(possibly significant) & municipality reassessment after sale. Buyer should NOT assume that buyer’s tax bills will be similar to the seller’s current tax bills. Taxes are not zero. OFFERS: 72 hours response time requested on offers. Pre-approval letter or proof of funds to accompany all offers. Seller, at seller's sole discretion, with or without notice, reserves the right to set and/or modify offer submission & response deadlines.
MlsNumber: --
ListingId: 50174638


Listing Provided By: RE/MAX DOUGLASS R.E.-H, original listing
Phone: (906) 370-3574
Office Phone: (906) 482-1000
Agent Name: GINGER STROUBE
Disclaimer: Copyright © 2025 Upper Peninsula Association of Realtors. 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