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 = 1265 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 = 1265 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 = 1265 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;

57144 Palosaari
Calumet, MI 49913

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $749,000
Beds: 4
Baths: 4
Status: Active
SqFt: 5376
Agency: NORTHERN MICHIGAN LAND BROKERS - H

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 11 acre(s)
Property Type: Residential
Year Built: 2002
Notes: Enjoy your Upper Peninsula living in this spacious, custom-built family home. A 4BR, 4BA home on over 11 acres in a private, country setting just outside of Calumet. This 5,376 square feet home features an expansive living space and recreational opportunities galore with a 48’x93’ concrete recreation pad for basketball, hockey, pickleball, and a little league baseball field in the backyard. Enter the home into the grand foyer with direct access to the 2nd floor by a double stairway or into the open dining and kitchen area. The master bedroom suite has a large bathroom area with a double vanity and two walk-in closets on the main floor. The living room is directly off the kitchen for family gatherings. The family room is a large, open space for gathering with family and friends and relaxing by the fireplace. It has an open 2nd floor loft for indoor recreation and workout space. There is built-in cabinetry along the wall for additional storage. The mudroom entrance from the attached garage leads to the main floor laundry room with built-in cabinets and ample countertop space. The sauna, two bathrooms, and a changing room for outdoor activities complete the main floor space. The 2nd floor has a sitting room, access to the balcony deck, 3 additional bedrooms, a bathroom with Jacuzzi tub, and access to the 3rd floor bonus room. The home and property have been well maintained, including a new roof in 2021 and a new deck and patio in 2023. This home is a short drive to Michigan Tech University, the area hospitals, and all that the Houghton and Calumet area has to offer. This is your opportunity to own a special, one-of-a-kind property!
MlsNumber: 50118809


Listing Provided By: NORTHERN MICHIGAN LAND BROKERS - H, original listing
Name: NORTHERN MICHIGAN LAND BROKERS - H
Phone: (906) 523-5575
Office Name: NORTHERN MICHIGAN LAND BROKERS - H
Office Phone: (906) 523-5575
Agent Name: CRAIG KANGAS
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