Title Page Background
DEBUG FN args: Array ( [0] => 1235 [1] => [2] => [3] => agent ) BEFORE: Site: 1235 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1235 Igate: njhud LocID: 1235 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1235 AND i.igate IN ('gahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1235 [1] => [2] => [3] => lender ) BEFORE: Site: 1235 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1235 Igate: njhud LocID: 1235 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1235 AND i.igate IN ('gahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1235 [1] => [2] => [3] => other ) BEFORE: Site: 1235 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1235 Igate: njhud LocID: 1235 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1235 AND i.igate IN ('gahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

00 Cedar Lake Rd
Greenbush, MI 48738
Hunter Tonti with Mossy Oak Properties Michigan Outdoors, original listing -

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $180,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Mossy Oak Properties Michigan Outdoors
Agency Phone:

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 45 acre(s)
Garage: Garage
Property Type: Land-Other
Year Built: --
Notes: Turnkey 45+-Acre Recreational Paradise in Greenbush, MI - Buildable, Private, and Loaded with Opportunity Nestled just north of the charming town of Oscoda, this stunning 45+-acre parcel in Greenbush, Michigan, offers the perfect balance of seclusion, accessibility, and outdoor adventure. Fully buildable with power, high-speed internet, and natural gas available at the road, this property is ready for your dream cabin, year-round home, or ultimate up north getaway. A well-maintained trail system winds throughout the acreage, providing effortless access to every corner of the land. A locked gate at the front entrance ensures privacy and security, while the land itself is a true haven for wildlife. Deer, turkeys, grouse, and even bobcats and black bears call this property home-making it a turnkey hunting retreat with multiple comfortable ground blinds and treestands already in place. Trophy Michigan whitetail bucks are known to frequent the area, adding to the property's allure for serious hunters. Along the front of the property, a scenic wetland area runs north-south, providing ideal habitat for ducks and geese and the potential for excellent waterfowl hunting. Outdoor recreation opportunities abound, with Cedar Lake-an all-sports, year-round fishing and boating destination-located just across the road. You're also minutes from Lake Huron's pristine public beaches in Oscoda and Harrisville, as well as the world-renowned Au Sable River, a mecca for trout and smallmouth bass fishing. For off-road enthusiasts, the property sits just northeast of the Grayling State Forest, offering direct access to endless trail-riding and UTV/ATV exploration. Calling All Golfers!! Just seconds away is the beautiful Lakewood Shores Golf Course & Resort. This resort does not have just one course, instead it hosts THREE full courses along with a 4th course being a family friendly pitch-and-putt course! Whether you're seeking a premier hunting camp, a family-friendly base for northern Michigan adventures, or a secluded location to build your dream home, this one-of-a-kind property delivers on all fronts. Don't miss this rare opportunity to own a piece of northern Michigan paradise-turnkey, buildable, and ready to enjoy.
MlsNumber: --
ListingId: 11502028


Listing Provided By: Mossy Oak Properties Michigan Outdoors, original listing
Agent Name: Hunter Tonti
Disclaimer: Copyright © 2025 My State 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