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;

944 Poplar
Hancock, MI 49930

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $225,000
Beds: 3
Baths: 3
Status: Pending
SqFt: 1409
Agency: STATE WIDE OF HOUGHTON

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1900
Notes: Inviting classic and cozy 3-bedroom home on a corner lot located in the City of Hancock. You will appreciate the large windows throughout that fills the home with light no matter the season. In the last several years, all the windows have been replaced, along with the roof on the main house, the furnace, and the water heater. Most recently, additional kitchen cabinets, open shelving, and a butcher block center island have been, bringing this amazing and functional space together. The newly refinished hardwood floors add beauty to the main floor. An 11x12 maintenance-free composite deck, accessible through patio doors in the dining room, is nestled behind the home to off street privacy. The shady front porch is the perfect place to spend a summer afternoon or to watch the sun set over the neighborhood. The heated rear entry to the house opens to the kitchen and has plenty of space with a closet and pantry. The upstairs has a full bath and 3 bedrooms. Each bedroom features large windows, ceiling fans, and spacious closets. Conveniently, this home has a bathroom on each level. There is a large, walk-up attic, great for storage or a potential bonus room. The full basement is clean and dry with a nice, private half-bath. The detached 24x28 garage has plenty of space for two vehicles and outdoor toys and equipment. Additionally, there is a 2-car concrete parking pad just west of the garage. The yard is nicely laid out for ease of care with plenty of space for enjoyment. The yard also boasts a producing plum and pear tree! Close to Maasto Hiito ski trail, schools, and the hospital. There is so much to appreciate about this turn-key home, see it today and make it yours tomorrow! Please allow 72 hours for response on offers.
MlsNumber: 50137250


Listing Provided By: STATE WIDE OF HOUGHTON, original listing
Name: STATE WIDE OF HOUGHTON
Phone: (906) 482-6955
Office Name: STATE WIDE OF HOUGHTON
Office Phone: (906) 482-6955
Agent Name: LISA MCKENZIE
Disclaimer: Copyright © 2024 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