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

13 Duncan
Ahmeek, MI 49901
VERN HARLOCK with NORTHERN MICHIGAN LAND BROKERS - H, original listing - (906) 523-5575

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $120,000
Beds: 2
Baths: Full: 1, ½: 1
Status: Active
SqFt: 965 Square Feet
Agency: NORTHERN MICHIGAN LAND BROKERS - H
Agency Phone: (906) 523-5575

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Welcome to 13 Duncan St in Ahmeek, MI—an affordably priced 2-bedroom home offering comfort, charm, and a host of recent updates. As you approach the front of the house, you’ll be greeted by a cozy covered front porch, perfect for enjoying your morning coffee or unwinding in the evening. Step inside to find beautifully resurfaced original hardwood floors that bring warmth and character to the home. The layout flows seamlessly from the living room through the dining room, leading to a kitchen at the back of the house. The kitchen features a gas oven/range and a convenient island with a built-in dishwasher. From here, you can step out to the fenced-in backyard, providing a safe and secure space for children and pets to play. Upstairs, you’ll discover two comfortable bedrooms and a laundry room with a half bath, adding modern convenience by saving you the hassle of carrying laundry up and down the stairs. The full-size attic offers versatile space that can be transformed into a storage area, kids' playroom, artist studio, office, or whatever suits your needs. The basement, while typical, offers ample storage space, ensuring you have room for all your belongings. With a new roof installed in 2023 and a furnace replaced in 2018, two of the biggest concerns for homeowners are already taken care of, giving you peace of mind. In addition there is a ton of space in the attic for an office or artist's lounge (not included in Sq Ft count) This home is a wonderful opportunity to enjoy the benefits of living in the Keweenaw. Schedule your appointment today to see all that 13 Duncan St has to offer!
MlsNumber: --
ListingId: 50153137


Listing Provided By: NORTHERN MICHIGAN LAND BROKERS - H, original listing
Phone: (906) 370-1670
Office Phone: (906) 523-5575
Agent Name: VERN HARLOCK
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