Title Page Background
DEBUG FN args: Array ( [0] => 1286 [1] => [2] => [3] => agent ) BEFORE: Site: 1286 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1286 Igate: njhud LocID: 1286 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1286 AND i.igate IN ('mihud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1286 [1] => [2] => [3] => lender ) BEFORE: Site: 1286 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1286 Igate: njhud LocID: 1286 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1286 AND i.igate IN ('mihud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1286 [1] => [2] => [3] => other ) BEFORE: Site: 1286 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1286 Igate: njhud LocID: 1286 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1286 AND i.igate IN ('mihud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

711 W M35
Gwinn, MI 49841

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $259,500
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1617 Square Feet
Agency: NEXTHOME SUPERIOR LIVING
Agency Phone: (906) 214-4267

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 6 acre(s)
Garage: Garage
Property Type: Residential-Manufactured Home
Year Built: 2006
Notes: Welcome to your potential new home. Nestled on over 6 wooded acres with plenty of privacy just outside of Gwinn. The front of the home has a screened in covered porch that leads to the front door. The moment you enter the spacious entryway the convenience of a hand washing sink along with counter space, and cabinets are available to accommodate your needs. The bright dining area is open to the kitchen and would make a great space for entertaining your guests. The kitchen has counterspace on either side with an island in the center of the room that is convenient for all your food preparation needs. The living room boasts a wood burning fireplace, a large window overlooking the natural beautiful scenery that surrounds the home. This home features 3-bedrooms and two bathrooms. The primary bedroom has a private attached bathroom with a lovely garden tub. A deck is situated off the living area to enjoy those U.P summer days and nights. The outdoor space has a combination wooded area, trails, open fields with wild berries, a few apple trees as well as a pear tree. Detached from the home is an outbuilding currently used for storage as well as a parking area. The possibilities for this space are endless with over 4000 sq.Ft . It features exposed brick with wood beams and high ceilings. It was once used as a mechanic shop in the early 1900's during the mining years in the Gwinn area. Updating to the roof was preformed around 2005 with metal roofing. Buyers must be preapproved for showings.
MlsNumber: --
ListingId: 50155453


Listing Provided By: NEXTHOME SUPERIOR LIVING, original listing
Phone: (906) 361-1414
Office Phone: (906) 214-4267
Agent Name: CANDI KJELLIN
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