Title Page Background
DEBUG FN args: Array ( [0] => 1276 [1] => [2] => [3] => agent ) BEFORE: Site: 1276 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1276 Igate: njhud LocID: 1276 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 = 1276 AND i.igate IN ('mihud','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 = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1276 [1] => [2] => [3] => lender ) BEFORE: Site: 1276 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1276 Igate: njhud LocID: 1276 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 = 1276 AND i.igate IN ('mihud','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 = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1276 [1] => [2] => [3] => other ) BEFORE: Site: 1276 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1276 Igate: njhud LocID: 1276 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 = 1276 AND i.igate IN ('mihud','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 = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

6856 Five Mile Point
Allouez, MI 49805
DAVID HANSON with PREMIER REAL ESTATE, INC., original listing - (906) 786-5030

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,100,000
Beds: 2
Baths: Full: 1, ½: 1
Status: Active
SqFt: 1400 Square Feet
Agency: PREMIER REAL ESTATE, INC.
Agency Phone: (906) 786-5030

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 42 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1995
Notes: Overlooking Lake Superior’s northern coast, this well-crafted and carefully maintained log home presents awe-inspiring views and deluxe comfort. The red pine logs from Marquette County have been carefully fitted and showcase each tree’s character. Solid oak flooring from Dollar Bay, MI covers the main floor with open living room, dining and kitchen under a lofted ceiling. The open format is ideal for gathering and entertaining, then relaxing and quiet enjoyment by the fire. The Lake Superior stone chimney and fireplace is the centerpiece of this home. There’s even a few “Yooperlites” hidden in the stones. There are two fireplaces; one on the main floor and then a complimenting one in the basement gathering space. On the main floor you’ll find the main bedroom, a full bath with separate shower and bathtub, and a library den that leads you up to the loft. Each of these areas has inspiring views of the lake or forest. The basement level has a large gathering area with in-floor heating, a walk-out patio and a spacious finished bedroom and walk-in closet. The basement bathroom includes a sauna with electric stove. On the outside there is an extensive porch that wraps around 3 sides of the home. Imagine the cleansing breezes as you gaze into the Milky Way while Northern lights dance on the horizon. Breathtaking sunsets are a regular occurrence here. The 2 car garage has space for needed tools and equipment and boasts a workshop on the upper floor accessible from the upper porch. The ground floor breezeway leading to the garage has a full supply of firewood for the new owner. As you wander from the home, you can walk through the 40+ acres with varied terrain including meadows, wooded ridges, ponds and a nearby hunting blind. Across the road, descend the staircase to the pebble beach to search for agates and enjoy the waters of Lake Superior. (The lower section of the staircase was removed by a recent storm, but the beach is still accessible). Here, you are at the heart of all the wonders and outdoor adventures the Keweenaw has to offer! Roof re-shingled in 2015 on the forest side, then on the lake side in 2017, and garage in 2019 by WildKat Builders. Other updates to the home include: new Weil-McLain boiler in 2016, new AMTROL hot water maker in 2017, new submersible well pump installed at a depth of 364 feet in January 2022, new pressure tank in 2021, passing water test in 2022. Sale to include all four long lots/parcels (see outlined lots from the survey in pictures). Please be advised that security cameras are present on the premises and entering the property shall be considered consent to be recorded. Buyers must be pre-approved. Seller requests 72 hours response time on offers. Seller, at seller's sole discretion, with or without notice, reserves the right to set and/or modify offer deadlines.
MlsNumber: --
ListingId: 50175786


Listing Provided By: PREMIER REAL ESTATE, INC., original listing
Phone: (906) 420-4750
Office Phone: (906) 786-5030
Agent Name: DAVID HANSON
Disclaimer: Copyright © 2025 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