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;

255 Wilderness Way
Crystal Falls, MI 49920

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $289,999
Beds: 3
Baths: 3
Status: Pending
SqFt: 2359
Agency: U.P Riverland Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Property Type: Residential
Year Built: 1991
Notes: Fish - hunt - relax at this peaceful 3BD/ 2-1/2 bath home, located on a private dead-end road and situated on 10.74 acres with 250' of gently flowing, Paint River frontage. This is the whole package! Spacious main level floor plan with an upstairs bedroom and full bath. Main level has the kitchen, large living room with wood burning fireplace, half-bath, laundry, guest bedroom and primary suite which has patio doors out to the covered porch overlooking the river. In addition, there is a 22' x 23' 'bonus' room that could be partitioned for multi-purpose use. (Movie theatre, game room, laundry, office, extra bedrooms - whatever suits you). The 'Florida' room is off the kitchen and overlooks the very large front lawn and the beautiful Paint River. There are two fenced in areas for gardens or small pets. There are apple trees suitable for making apple pies and Hardwood Maples for those who would like to get into sapping for maple syrup. There is a trail through the acreage suitable for a vehicle, but what a pleasant walk it is. In addition to the heated 2-car attached garage, there is another 2-car detached garage, heated with a wood stove. The 16'x20' two-story storage shed allows for overflow of storage. Asphalt driveway, horseshoe court, and 2 firepits. The 12' aluminum boat, newer wood splitter, 7+ chords of wood, the pier, and the snowblower are just a few of the bonuses. Extra list of features/amenities available.
MlsNumber: 50139029


Listing Provided By: U.P Riverland Realty, original listing
Name: U.P Riverland Realty
Phone: (906) 265-9921
Office Name: U.P. RIVERLAND REALTY
Office Phone: (906) 265-9921
Agent Name: PUNNER FRANZENE
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