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

120 Mackinac
Harsens Island, MI 48028

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $479,900
Beds: 6
Baths: 3
Status: Active
SqFt: 3247
Agency: Re/Max Advisors

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: --
Notes: Home is in the process of being emptied out & cleaned. Inside pictures & video to come soon! 1st time on the market! Family Estate. Current owners' parents were married at St. Marks Church on the Island in 1968 & had their reception at the home when it was owned by a previous family member. Always lived-in year-round. Large Sprawling home with HUGE nicely groomed property. Close enough to the St. Clair River to have a view of passing freighters from EVERY room on the river side of the house, including the living room, dining room, kitchen, screened in porch & 3 of the upstairs beds, but far enough from the busy main road South Channel Drive to have a safe, quiet place for family gatherings, pets, ample room for children to play, parking for RV's, boats etc. River access via an easement that is only shared with the 2 other houses on the street. Perfect for fishing, swimming, a picnic or launching a small boat or Jet Ski. Directly across the river is Canada, specifically Walpole Island, a First Nation Native American Indian Reservation. 3 Lots total, property backs up to woods at the end of a short dead-end street & can be built on as desired. House is primarily as-it-was when built, other than standard maintenance, a new roof, driveway & addition of central heat & A/C. Keep the vintage charm or make it your own, the possibilities are only as endless as your imagination! CENTRAL A/C (on lower floor), CITY WATER, NATURAL GAS, SEPTIC, FIREPLACE, & DIRECT TV equipped. Walking distance to the quaint town of San Souci, where you'll pass Tashmoo Marina on the way, which was once Tashmoo Amusement Park, a favorite destination from 1871 to 1951 via steamships from Detroit &Port Huron, some of which is still standing. "Downtown" San Souci is straight out of a Mark Twain novel & features a Library, Museum & Historical Society, Market, Coffee Shop, Resale store, River Front Shop & soon to re-open historic San Souci Bar & Grill. If you're looking to get away from the hustle & bustle of city life, this location offers a level of History, natural beauty, peacefulness & serenity you'll be hard pressed to find anywhere else. The island is part of the largest freshwater delta in the world, while being within an hour or so from Detroit & its neighboring suburbs via car, which requires taking a short ferry trip to the mainland, increasing its privacy & exclusivity. If you're looking for an outdoorsy refuge to hunt, fish, boat etc, a quiet peaceful getaway, or just a step back to living in a time when things moved slower & people were more polite and friendly...Welcome Home! 1st Floor: •Attached Garage •Workshop w/Wood Burning Heater •Greenhouse (River View) •Breezeway w/ Screened in Porch (River View) •Outdoor Patio Slab (River View) •Kitchen w/Breakfast Area (River View) •Dining Room (River View) •Large Living Room w/FP (River View) •Bedroom •Office Nook •1/2 Bathroom •Full Bathroom 2nd Floor: •2 separate stairwells •5 Bedrooms (3 w/River View) •1/2 Bathroom
MlsNumber: 50121183


Listing Provided By: Re/Max Advisors, original listing
Name: Re/Max Advisors
Phone: (586) 725-1900
Office Name: RE/MAX Eclipse New Baltimore
Office Phone: (586) 725-1900
Agent Name: Laura Janski
Disclaimer: Copyright © 2024 Multiple Listing Service MiRealSource. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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 = 3327 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;
Real Estate Expert Photo for Eric Raymo
Eric Raymo
ASCIIeXp Realty
Call Today!: (810) 334-7268

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App