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;

17902 Tapiola
Chassell, MI 49916

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $354,900
Beds: 2
Baths: 3
Status: Active
SqFt: 1369
Agency: Douglass Real Estate, Inc DBA RE/MAX Douglass Real

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential
Year Built: 1979
Notes: Welcome to your 2+ bed, 3 full bath, dream country ranch retreat, situated on a 2.2+/- acre lot and conveniently located close to Houghton and Chassell. This charming home has been fantastically remodeled, completed just 3 weeks ago. As you step inside, you'll immediately notice the open layout, new paint and flooring throughout the home, and a striking new woodstove with a beautifully crafted custom hearth and exposed brick chimney. The adjacent areas consist of a formal dining area and a relaxing living room. Tucked away behind the dining room is an additional bonus space great for more storage or a private office. Further on the main floor, is the recently and exceptionally renovated kitchen with custom cabinets, accent wall, tile backslash, and high-end appliances all less than 1-year-old. The main floor also includes a laundry room with 2-year-old appliances which also allows for direct access to the 2-car attached garage. In addition to the cozy woodstove, preferred by the sellers, a propane heating system is also used for warmth during colder months, while the geothermal system keeps the home comfortably cool in the summer. The lower level of the home offers even more space, with a family room (currently used as a bedroom), an electric sauna/full bathroom, and a bonus room/non-conforming bedroom (currently used as an exercise room). The lower level also features a large unfinished area with direct access to the garage, providing a lot of storage area as well as a lot of potential for more living space if the buyer wants to expand the home interior in the future. For those with green thumbs, the yard includes fruit trees and plenty of room to add a garden. There is also a nice-sized chicken coop ready for chickens to provide delicious eggs for the family. Another standout feature of this property is the second garage, complete with a concrete floor, 50-amp service, and a wood stove. Don't miss this incredible country home with modern amenities! Note: Sellers have a 3.3% assumable loan.
MlsNumber: 50139242


Listing Provided By: Douglass Real Estate, Inc DBA RE/MAX Douglass Real, original listing
Name: Douglass Real Estate, Inc DBA RE/MAX Douglass Real
Phone: (906) 482-1000
Office Name: RE/MAX DOUGLASS R.E.-H
Office Phone: (906) 482-1000
Agent Name: ADAM SHIREY
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