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

13557 E Main
Sidnaw, MI 49961
Timothy Keohane with Great Lakes & Land Real Estate Co, Inc - Marquette, original listing - (906) 228-9312

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $78,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Great Lakes & Land Real Estate Co, Inc - Marquette
Agency Phone: (906) 228-9312

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 38 acre(s)
Property Type: Residential-Other
Year Built: --
Notes: MICHIGAN VACANT RECREATIONAL LAND, AND OLD HOMESTEAD FOR SALE! - This SALE WILL INCLUDE a 38+/- acre parcel which is located in Duncan Township, in South-Eastern Houghton County, on the outskirts of the un-incorporated Village of Sidnaw. - The parcel is adjacent to part of the 988,000 acre Ottawa National Forest, where wildlife is abundant. Black bear, Moose, Whitetail deer, Timber wolves, Bald eagles, Coyotes, Foxes, Beaver and Loons are at home here. - Sidnaw Creek, a Type 1 Trout River, and tributary of the Sturgeon River, and the Erickson Creek runs through the property. - The Bergland to Sidnaw Multi-Use Rail Trail runs next to the parcel for ATVs, Horseback riding, and Snowmobiling. - THE SALE ALSO INCLUDES A larger Four-Bedroom Home located in the Village of Sidnaw, which needs considerable work. It has been used infrequently for seasonal Family get-a-ways, and is being sold “As Is”, “Where Is”. It could be rehabbed to make a shared home for a group of hunters or anglers. - The community's name is derived from an American Indian word meaning "small hill by a creek". Sidnaw was founded by lumber companies harvesting white pine in the area. The Village was platted in 1889, and shows up on early maps as a station on the Duluth, South Shore and Atlantic Railway. In 1920, Henry Ford built a lumber camp there, which became the epicenter of Henry Ford's logging empire. - Today the area is known for its recreational opportunities - You can travel in almost any direction and find access to recreational activities. The Sturgeon River, Gorge, and Falls are nearby, and offer prime trout fishing. A section of the North County National Scenic Trail for hiking and backpacking, and the Deer Marsh Interpretive Hiking Trail are minutes away. Other trails for hiking are the Sturgeon Falls, Bears Den, and Pine Bluff Trails. Over 25,000 Snowmobilers travel in the area along the Sidnaw Rail Trail. The nearby Grooms-Prickett Airport has the Labor Day Fly-Ins of rebuilt WWII planes. - Owned by one Family for many, many, years – It’s time to pass this legacy property on to New Owners. Contact Us For Information Today!
MlsNumber: --
ListingId: 50115876


Listing Provided By: Great Lakes & Land Real Estate Co, Inc - Marquette, original listing
Phone: (906) 228-9312
Office Phone: (906) 228-9312
Agent Name: Timothy Keohane
Disclaimer: Copyright © 2024 LandLeader. 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