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

1012 Crestwood
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: $359,900
Beds: 3
Baths: Full: 2
Status: Active Under Contract
SqFt: 1240 Square Feet
Agency: RE/MAX DOUGLASS R.E.-H
Agency Phone: (906) 482-1000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1982
Notes: WELCOME to this coveted ranch-style home located in the desirable Sylvan Estates neighborhood! With a spacious and functional layout, this well-maintained property offers comfortable living both inside and out. The main level features two bedrooms and a full bath, a generously sized living room perfect for gatherings, and a large kitchen complete with stainless steel appliances—including a brand-new dishwasher installed in 2024. Step outside from the living room onto a deck that spans the back of the home, ideal for entertaining or relaxing while enjoying the surrounding nature. Downstairs, the walk-out basement provides additional living space with a large family room featuring a cozy fireplace and built-in shelving. You'll also find a spacious third bedroom and a luxurious bathroom equipped with a separate shower and a jetted tub. This home has been thoughtfully updated over the years, with new windows installed in 2012 and LP Smart siding added in 2013. The oversized attached two-car garage includes updated springs and cables on the garage door for added convenience. A sprinkler system is in place, though the current owners have not used it in years and cannot confirm its condition. A large back yard with storage shed adds fun, privacy and convenience. Ideally located just minutes from schools, the hospital, hiking and snowmobile trails, and all the amenities the area has to offer, this home blends comfort, convenience, and charm in one inviting package. 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: 50174687


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