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

Tbd Little Lake
Gwinn, MI 49841
JAMES HAMMILL with GREAT LAKES & LAND OF MARQUETTE, INC., original listing - (906) 228-9312

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $325,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: GREAT LAKES & LAND OF MARQUETTE, INC.
Agency Phone: (906) 228-9312

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 485 acre(s)
Property Type: Land-Other
Year Built: --
Notes: Upper Peninsula Vacant Land For Sale! This 485-acre parcel of land is in a prime location for a base in the heart of the U.P. Build a cabin or year-round home along the property along the county road, or other potential building sites in upland areas of the property. Less than 30 miles from Marquette (on the Lake Superior shore) for shopping, entertainment, cultural experiences, and Northern Michigan University. Sawyer International Airport is nearby (approx. 10 miles by road) for business trips or vacation getaways. The Little Lake State Forest Campground is less than 2 miles from the property where you can camp (if you don't want to build a camp or house on your property), and also has a boat launch for Little Lake to fish for walleye and panfish. G Route ORV Trail is located 5 miles west of the campground. If you prefer to stay and recreate on your own property, you can make your own trails on the property for ATV use, hiking, cross-country skiing, or snowmobiling. Hunt for deer, bear, bobcats, and hare in this excellent habitat. These wooded wetlands provide habitat for over 80 species of mammals and birds. Some of the non-game wildlife you might see include moose, wolves, eagles, woodland raptors, songbirds, turtles, lizards, and many others. Sawmill Creek, a tributary to the Escanaba River (an important fishery) transects the 485 acres with about a mile of frontage. A unique feature on a small 1-2 acre pond in the southwest area of the parcel, is that it is filled by an artesian spring. Four Hundred Eighty acres of these 485 acres is in Michigan's Qualified Forest Program, which allows for a tax abatement on this acreage (QFP does not require landowner to allow others access to property). Property abuts State of Michigan land, and many acres of private and corporate land in the Commercial Forest Act that are available to the public. This acreage is part of a larger, ecologically important area, locally called the Sawmill Creek Wooded-Wetland Complex, with thousands of acres of the wildest country in the U.P. within and to the south of this property.
MlsNumber: --
ListingId: 50152868


Listing Provided By: GREAT LAKES & LAND OF MARQUETTE, INC., original listing
Phone: (906) 228-9312
Office Phone: (906) 228-9312
Agent Name: JAMES HAMMILL
Disclaimer: Copyright © 2024 Upper Peninsula Association of Realtors. 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