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

50225 S Superior
Atlantic Mine, MI 49905
KEVIN LIIMATTA with STATE WIDE OF HOUGHTON, original listing - (906) 482-6955

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $475,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 2140 Square Feet
Agency: STATE WIDE OF HOUGHTON
Agency Phone: (906) 482-6955

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 12 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2005
Notes: Own a beautiful piece of the country with a picturesque red pine driveway entrance! Drive through the red pine trees at the road to your 4BR/3BA home, built in 2005, heated by a backup wood boiler (if you want); the home also has a wonderful propane hot water system for heat. All the desired comforts for home: a beautiful kitchen that is open to the living and dining rooms, a bonus office/den or family room, and 4 BRs upstairs, split between two different 2nd floors to help preserve the peace and quiet (3 on main side, 1 other side). All the bedrooms have large closets. The main level office/den could easily be a main floor 5th bedroom. Premium laminate flooring in kitchen and dining area, and a fresh neutral color palette make the home very calming. The home has a 1-car attached garage, complete with heat from the wood boiler (in garage). The seller added a huge basement family room for extra family space. The basement also has the mechanicals, and a lot of built in storage and small workshop area. Seller has installed dimming switches on most lights in the home. The back of the parcel has a small apple orchard, raspberry & blueberry bushes. There is a small gardening shed in the backyard, as well as a round top storage tent. The seller's own inspection when purchasing yielded a very clean inspection report. This home is very nice--it sits in a post card like setting of red pine and aspen trees. The home shows very well. High efficiency hot water boiler is a backup to the home's propane heat; seller has heated all winter with about 4 cords of wood using the wood boiler in garage. The wood boiler has redundant safety systems on it and can provide both hot water heat and domestic hot water for the family. Main floor bath is combo laundry room, sink, toilet & shower. Seller may have audio and video surveillance devices on site--entry to show the property is consent to these devices being present and in use.
MlsNumber: --
ListingId: 50176092


Listing Provided By: STATE WIDE OF HOUGHTON, original listing
Phone: (906) 370-4440
Office Phone: (906) 482-6955
Agent Name: KEVIN LIIMATTA
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