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

1110 Oak Ridge Circle Road
Comins, MI 48619
Jodi Goff with EXP Realty LLC, original listing - (888) 501-7085

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $160,000
Beds: --
Baths: --
Status: Active Under Contract
SqFt: --
Agency: EXP Realty LLC
Agency Phone: (888) 501-7085

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 39 acre(s)
Property Type: Land-Other
Year Built: --
Notes: 40 Acres PLUS a rustic cabin...Nestled in the heart of the beautiful Montmorency County, this stunning hunting land is the perfect escape for outdoor enthusiasts. With 40 acres of rolling terrain, wooded areas, and open fields, this property offers a perfect balance of natural beauty and wildlife habitats.<br /> <br /> As you enter the property, you'll be greeted by a charming rustic cabin that sits at the edge of the woods. This cabin is perfect for hunters who want to spend a few days in the wilderness and enjoy the peace and serenity of the great outdoors. The cabin features a cozy living room, a fully equipped kitchen, two comfortable bedrooms, and a bathroom. The cabin is powered by a generator and has a well and septic system, ensuring a comfortable stay for those looking to escape the city and immerse themselves in nature.<br /> <br /> The property's topography is diverse, with wooded areas, meadows, and wetlands, providing excellent habitats for game species such as white-tailed deer, black bear, wild turkey, grouse, and small game. The property is surrounded by other large tracts of land, ensuring that the wildlife population remains plentiful and abundant. The property also includes several tree stands and blinds, perfect for those who want to hunt for big game.<br /> <br /> The property's location is ideal for those who enjoy outdoor activities such as hiking, bird watching, and fishing. The nearby Au Sable River is a renowned trout fishing destination, and the Huron National Forest is just a short drive away, providing ample opportunities for hiking and camping.<br /> <br /> This cabin & acreage is an ideal escape for outdoor enthusiasts looking for a private and serene retreat. With its beautiful natural surroundings, ample wildlife, and comfortable amenities, this property is a rare find that is sure to impress even the most discerning buyer.
MlsNumber: --
ListingId: 20230016711


Listing Provided By: EXP Realty LLC, original listing
Phone: (810) 577-4502
Office Phone: (888) 501-7085
Agent Name: Jodi Goff
Disclaimer: Copyright © 2024 Realcomp Limited II. 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