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

152 White Bear
Negaunee, MI 49866
PAULA LUTEY with COLDWELL BANKER SCHMIDT REALTORS, original listing - (906) 225-1136

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $519,900
Beds: 4
Baths: Full: 2, ½: 1
Status: Active Under Contract
SqFt: 2736 Square Feet
Agency: COLDWELL BANKER SCHMIDT REALTORS
Agency Phone: (906) 225-5992

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2002
Notes: Private, wooded setting on 10 acres! This lovely 4 bedroom, 3 bath home offers space galore inside and out! As you approach the home you will be welcomed by a covered front porch that leads you to a grand, two story foyer and opens to the formal living room & dining room, then extends to a large, family room that overlooks the backyard. A two sided fireplace warms up the space that opens to a large breakfast nook and enormous kitchen. A large island and ample cabinets and countertop space will make meal prep. a breeze while you can gaze out the kitchen window and overlook the private, wooded back yard with year round creek in the distance. A large deck is located conveniently off this area that is perfect for large gatherings, or just simply relaxing while watching a variety of wildlife in your own personal wooded wonderland. The main floor has been updated with new flooring as well as a fresh coat of paint and includes a 1/2 bath, as well as main floor laundry/mud room that also leads to the backyard. The large 2 car attached garage is conveniently located off the kitchen for easy grocery unloading. You will find 4 large bedrooms on the 2nd floor as well as an updated hall bath that features beautiful marble tile floors, new double vanity and shower. The large windows highlight the views from every room and allow an abundance of natural light to flow through the home. The primary suite includes a jetted tub, heated marble floors and updated tile shower as well as a 10x10 massive closet. There is ample storage throughout the home, as well as a full, partially finished, walk-out basement that includes a roughed in bathroom area, legal egress windows to add another bedroom or home office as well as plenty of space for rec.room, fitness area, bar or even enough room for an in-law suite or amazing guest quarters. A 30 x 48 pole building provides storage space for all your recreational toys and if you care to raise your own chickens there is already a coop in place and plenty or room for gardening! This property is certainly an outdoor enthusiast dream with easy access to year round recreational opportunities near the dead river & many hiking and biking trails, yet you are just moments from Marquette and Negaunee.
MlsNumber: --
ListingId: 50172975


Listing Provided By: COLDWELL BANKER SCHMIDT REALTORS, original listing
Phone: (906) 869-3611
Office Phone: (906) 225-1136
Agent Name: PAULA LUTEY
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