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','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 = 1286 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 = 1286 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;

7466 Honeysuckle
Republic, MI 49879
DANIEL MENARD with COLDWELL BANKER SCHMIDT REALTORS, original listing - (906) 225-5992

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $350,000
Beds: 2
Baths: Full: 1
Status: Active
SqFt: 960 Square Feet
Agency: COLDWELL BANKER SCHMIDT REALTORS
Agency Phone: (906) 225-5992

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 49 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2005
Notes: An amazing 2762' of frontage on the Majestic Michigamme River and year-round access to 49 acres of fabulous recreational/hunting property!!! Excellent cell phone service and barely 1 mile from Highway M95. For the Mountain Biker or the ORV/Snowmobiler enthusiasts, both The Iron Ore Heritage Bike Trail and the #5 ORV/Snowmobile trail are only minutes away in North Republic. Deer, grouse, turkey, ducks, geese, bear, and multiple species of fish all inhabit this area. The Lodge consists of 2- bedrooms, 1- full bath and a large open kitchen/dining/living room area with bar for entertaining. Second bedroom is also plumbed with laundry hook-ups. Full electrical service, over-sized septic (to accommodate an additional 3 bedroom home overlooking the river), indoor electric sauna, refrigerator, stove and microwave. Beer keg cooler/tapper and dishwasher (of unknown functionality). 24'x60' pole building, wired with its own electrical panel & plumbed for in-floor heat. Perfect for storage of all your recreational toys :) A second cleared "Waterfront" building site on the SW side of the property with its own electricity. Power buried over to a temporary meter base with a 100a. breaker box and GFCI outlet. 2- Gravel pits for all your road maintenance needs. This property was once used for potato farming and more recently operated as Republic Ridge Hunting Resort and Shooting Club. Zoned WR-2 with multiple conditional uses available. Property starts approx. 100 yds from gravel County Road LI. Easy year-round access with a plow or tractor. Great property for a hunting/fishing camp or ??? Deer pictures are from the 2023 Rifle and Muzzle hunting season. New drilled well September 2024. Showings by appointment only. Taxes will change with purchase and are not $0. This information has been secured from sources we believe to be reliable, but we make no representation or warranties, expressed or implied, as to the accuracy of the information. References to square footage, lot size and dimensions are approximate. Buyer must verify the information and bears all risk for inaccuracies.
MlsNumber: --
ListingId: 50129661


Listing Provided By: COLDWELL BANKER SCHMIDT REALTORS, original listing
Phone: (906) 360-1964
Office Phone: (906) 225-5992
Agent Name: DANIEL MENARD
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