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

1001 E D
Iron Mountain, MI 49801

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $249,900
Beds: 3
Baths: 2
Status: Pending
SqFt: 2472
Agency: Leeds Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1973
Notes: Discover your dream home on Iron Mountain's east side! This meticulously maintained residence boasts a perfect blend of charm and modern updates. With 3 bedrooms and 2 bathrooms, this spacious home is situated on a large, inviting corner lot, offering ample space both inside and out. Step inside to discover a haven of comfort and style. You'll immediately notice the many updates throughout, including remodeled bathrooms, newer flooring, and freshly painted interiors. The kitchen, which boasts a built-in desk area, has been updated to modernize the space, while maintaining the beautiful granite countertops. Every detail has been carefully attended to, from the replaced trims and doors to the beautiful built-ins that add both character and functionality. Natural light floods the open, spacious floor plan, creating a warm and inviting atmosphere. Enjoy cozy evenings gathered around the freestanding wood stove in the family room, or entertain guests in the seamlessly flowing living spaces. Nestled on a quiet dead-end street, this home offers peace and tranquility. Outside, the property is beautifully landscaped with flowering shrubs, trees, fruit trees, flower bulbs, and perennials, creating a serene outdoor oasis. The two-car attached heated garage provides convenience and ample storage space, while the patio area off the dining area is ideal for grilling and relaxing on warm summer evenings. Plus, rest assured knowing that this smoke and pet-free home is ready for you to move in and make your own. Don't miss your chance to own this exceptional property – schedule your showing today and experience the best of Iron Mountain living! Storage shed, washer, dryer, stove, refrigerator, microwave, 2 free-standing air conditioners, water softeners, and mirrors in bath are included. Vise on work bench and cabinet base in workshop area not included.
MlsNumber: 50139490


Listing Provided By: Leeds Real Estate, original listing
Name: Leeds Real Estate
Phone: (906) 779-5333
Office Name: LEEDS REAL ESTATE
Office Phone: (906) 779-5333
Agent Name: LINDA PLUMLEY
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