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;

1033 5th Street
Tawas City, MI 48763

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $465,000
Beds: 3
Baths: 3
Status: Active
SqFt: 2041
Agency: Tawas Sunshine Realty Co., Inc.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1994
Notes: Lake Huron access to over 300' of Sandy Beach and a Launch just steps away from your Up North cottage or home. With great views of Lake Huron from your home, large deck or gazebo. This property is located on a dead-end street and offers great privacy, and the property to the South is part of The Lake Huron Costal Preserve. This home was built in 1994 and has over 2,000 sq. ft. of living space. With 3 bedrooms, 2 on the main floor and the 3rd bedroom is located up in the loft with an open concept to the family room and living space below. The main floor living offers great views, cathedral ceilings, beautiful woodwork and beams the beautiful gas fireplace, hardwood flooring, 2 bedrooms, Living room, dining area, kitchen with bay window, full bath, half bath and utility room. The upstairs offers a large family room, electric fireplace, wood ceiling, sky lights, built in bookshelves, 3/4 bath and an open concept bedroom and lots of storage. With a 24' x 24' attached, finished and heated garage that also has a storage room and lots of built in cupboards with workspace. The home and 2nd garage were built on five lots approx. 83' x 250'. The exterior of the home is brick and vinyl and has a covered porch, large deck and a gazebo. The 24' x 24' detached barn style garage has a loft for additional storage, electric and a cement floor. This home includes the refrigerator, cook top, double oven, dishwasher, washer and dryer. City Water is a big plus and this home has it along with Septic System. This is a quality-built home that has a lot to offer. See Easement Description Document for info related to the Cedar Haven Resident Easement.
MlsNumber: 1919791


Listing Provided By: Tawas Sunshine Realty Co., Inc., original listing
Name: Tawas Sunshine Realty Co., Inc.
Phone: (989) 362-3401
Office Name: TAWAS SUNSHINE REALTY
Office Phone: (989) 362-3401
Agent Name: CRAIG MCMURRAY
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