Title Page Background
DEBUG FN args: Array ( [0] => 1236 [1] => [2] => [3] => agent ) BEFORE: Site: 1236 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1236 Igate: njhud LocID: 1236 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 = 1236 AND i.igate IN ('tnhud','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 = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1236 [1] => [2] => [3] => lender ) BEFORE: Site: 1236 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1236 Igate: njhud LocID: 1236 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 = 1236 AND i.igate IN ('tnhud','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 = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1236 [1] => [2] => [3] => other ) BEFORE: Site: 1236 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1236 Igate: njhud LocID: 1236 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 = 1236 AND i.igate IN ('tnhud','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 = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

N7062 Maple Tree Lane
Au Train, MI 49806-9613
ROBERT ANDERSON with KELLER WILLIAMS NORTHERN MICHIGAN, original listing - (906) 273-1183

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $395,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 2725 Square Feet
Agency: KELLER WILLIAMS NORTHERN MICHIGAN
Agency Phone: (231) 947-8200

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Manufactured Home
Year Built: 2014
Notes: Welcome to this charming 3-bedroom, 2-bathroom home in AuTrain. Very well-maintained home has everything located on the main floor for easy access and comfortable living. This 4337 sq ft home is move-in condition and offers a thoughtful blend of comfort, quality construction, and open concept with a warm, relaxing atmosphere. The main floor features a convenient, enjoyable kitchen with great appliances including NG range, SS refrigerator and ample counter space, and open dining and living room access. A large new patio off the dining room/kitchen area contains a hot tub for relaxation and enjoying the evening breeze. The spacious living room lets you relax by the cozy NG fireplace, creating a welcoming atmosphere. The home has two full bathrooms, with the primary bath having a stunning corner soaking tub and full shower. The laundry area is located next to the primary bedroom with a washer and dryer included. The expansive 1470 sq ft open basement with 9 foot ceiling will allow you to add additional bedrooms, a fitness center, recreation room, and office space for those working from home. The basement contains an egress window and an easy access staircase to the garage. Home is equipped with a 13KW back-up generator and Central air conditioning. A 30 X 40 Cleary pole building with 220A electrical service, 12ft OH door, and concrete floor is located adjacent to the home for the hobbyist or storage for the outdoor toys and equipment. The home is located ½ mile from AuTrain Lake, just west of AuTrain-Forest Road. This is a looped road where home residents make up most of the road traffic. This property has two lots, .92A, a very private, quiet, desirable neighborhood perfect for a family. Location has a covenant in place to ensure property guidelines are followed. AuTrain location is a great place for outdoor enthusiasts. Known for great kayaking on the AuTrain River and fishing on the AuTrain Lake in addition to great snowmobiling trails across the U.P. This property is not waterfront, however has deeded access to the AuTrain Lake. In addition, AuTrain Boat Launch is located one mile away for your convenience. AuTrain is located 24 miles from Marquette for convenient access to downhill skiing, mountain bike trails, and convenient shopping in downtown Marquette. Make your appointment to see this lovely, well-maintained home today. You won’t be disappointed!!
MlsNumber: --
ListingId: 50174293


Listing Provided By: KELLER WILLIAMS NORTHERN MICHIGAN, original listing
Phone: (906) 362-8388
Office Phone: (906) 273-1183
Agent Name: ROBERT ANDERSON
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