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

340 Fairbanks
Crystal Falls, MI 49920

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $345,900
Beds: 2
Baths: 3
Status: Active
SqFt: 2136
Agency: RE/MAX North Country

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1987
Notes: Check out this spacious ranch style home with lots of room for kids or company in the finished basement. House is set on almost 1 acre conveniently located in the Western Location close to the Crystal Falls golf course. This home features a large master suite on the main level and a 2nd potential bedroom currently being used as a home salon business with an outside entry and concrete parking area. In addition there are 3 to 5 finished rooms used as bedrooms in the basement. This home has been well maintained with recent updates including a newer roof and a beautifully remodeled kitchen with a large granite island and tons of cabinets including a massive stainless-steel full-size refrigerator- freezer combination. Ceramic tile flooring carries on throughout the home. An attractive oak beamed half wall separates the Kitchen -Dining area from the Living room. Nice conversation area around the gas fireplace which then opens to the rest of the living room. Main floor master suite has a huge closet with plenty of shelving. There is a tiled walk-in shower with built-in bench in the master bath. The basement is mostly finished with 3 large non-conforming bedrooms (no egress windows). All three of these rooms have large walk-in closets, two of which have been converted to extra sleeping space. There is also a weight room in the finished basement along with a workshop that has direct access to the attached garage. Above the garage you will find plenty of attic storage space. Home is well insulated with 2x6 construction and added Styrofoam insulation. Enjoy the fenced patio area with a stately outdoor brick fireplace to gather around when the evenings are cooler. The corner lot has lots of mature pine trees. Did I mention there is a lit basketball court?
MlsNumber: 50136911


Listing Provided By: RE/MAX North Country, original listing
Name: RE/MAX North Country
Phone: (906) 875-6331
Office Name: RE/MAX NORTH COUNTRY
Office Phone: (877) 875-6331
Agent Name: DANELLE DOVE
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