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

1569 Little Avenue
National City, MI 48748

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $210,000
Beds: 2
Baths: 3
Status: Active
SqFt: 1386
Agency: eXp Realty LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1955
Notes: Your Primary Home with access to the 248 acre all-sports Sand Lake directly across the street (Little Ave) or full access just down Indian Lk Rd to the Sand Lake Recreational Area of the Huron National Forest. The main home boasts 2 bedrooms, 2 baths with a large (22x38) detached garage (entry off Indian Lake Rd) that hosts a heated 12x22 bunkhouse. Accessed while outside is an additional 10x10 bath house with a 3/4 bath. The 2 main home bedrooms offer spacious closets and the master has a window a/c unit. There is a functioning wood burning stove inserted into the fireplace surround. If you enjoy gardening there is a fenced-in area for your gardening pleasure or it could be used as a dog-run area. The main entry is accessed from the driveway onto a nice porch for a sitting area. The laundry room also has a 1/2 bath which was updated in 2021. The plumbing was updated in 2019 by the previous owner as well the metal roof on the home, garage and bathhouse were installed in 2016. Sit with your friends or in the quiet by yourself in the well lit Florida room where you have a small view of Sand Lake. If you enjoy dining out there are several choices: Sand Lake Micro Brewery, Sand Lake Bar & Restaurant and the newly opened Galli's. If you enjoy water sports or ice fishing, you are in luck as there are 7 lakes surrounding National City. (Sand Lk, Island Lk, Little Island Lk, Indian Lk, Round Lk, Bass Lk, & Floyd Lk.) Just about a 15 minute ride into East Tawas shopping, dining and Lake Huron too. This listing may even offer the opportunity to build another home onto the Indian Lk Rd side which has its own tax id # 051-W11-003-029-00.
MlsNumber: 1922056


Listing Provided By: eXp Realty LLC, original listing
Name: eXp Realty LLC
Phone: (888) 501-7085
Office Name: EXP REALTY
Office Phone: (888) 501-7085
Agent Name: MATT SKIBA
Disclaimer: Copyright © 2024 Northern Great Lakes Realtors MLS. 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