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 = 1262 AND i.igate IN ('usahud','mdhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mdhud', 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 = 1262 AND i.igate IN ('usahud','mdhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mdhud', 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 = 1262 AND i.igate IN ('usahud','mdhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mdhud', 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;

11850 Us-31
Traverse City, MI 49643

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $674,900
Beds: --
Baths: --
Status: Active
SqFt: 1920
Agency: Five Star Real Estate - Front St TC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Commercial
Year Built: 1985
Notes: A beautifully updated farmhouse and a COMMERCIAL 30’x64’ building for a business, or rent (AIR BNB potential) or play toys for use in back mowed 3 acres that’s framed by 6ft privacy fence. Even a small Barn for pet farm animals. This property shines inside and out. Truly a fantastic place to roam with your toys, soak up the rays during the day. Just minutes to Green Lake boat launch & beaches. Just 10 minutes to Chum Corners. This homestead offers superior proximity for so many things. From the moment you step inside the home you are greeted by a beautiful tile entrance that will lead you into a modernized farmhouse that anyone can appreciate. The kitchen is the centerpiece of the home - in the last two years, it was taken down to the studs, Gorgeous shaker cabinetry, tile backsplash, quartz countertops, LG stainless appliances, mahogany wood island counter and luxury vinyl, flooring throughout the whole house. Beyond that this 1,950 sq. ft.house was stripped down inside-out to add All NEW electrical, LED lighting throughout, fireplace, fixtures, sound barrier insulation, drywall, plumbing, 3 New tile Bathrooms. NEW Windows, Doors, Siding, Roof, Lg. Covered Porch wired for hot tub, 2 Decks, 1 w/Pergola and NEW 95+ gas Heating system, A/C unit, Hot Water is tankless -circulating just to name a few updates. Outside all New Septic system. A Wonderful property! Has 20X30 finished garage ! The Commercial Building has water, and it’s own septic system, plus - Recently it had a Complete makeover with New gas furnace, new doors, insulated and dry wall, new roof. There is so much more to learn and we can't wait to share this special property and find its new owner, that the whole family will enjoy it !!!
MlsNumber: 1921466


Listing Provided By: Five Star Real Estate - Front St TC, original listing
Name: Five Star Real Estate - Front St TC
Phone: (231) 778-1200
Office Name: Five Star Real Estate - Front St TC
Office Phone: (231) 778-1200
Agent Name: Casha Sizemore
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