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

140 Tonkin
Ishpeming, MI 49849-9792
DANIEL MENARD with COLDWELL BANKER SCHMIDT REALTORS, original listing - (906) 225-5992

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $739,000
Beds: 5
Baths: Full: 2, ½: 1
Status: Active
SqFt: 1984 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: 2001
Notes: This beautiful 3-5 bedroom, 2.5 baths and 2 full kitchens home was originally built in 2001. Located 15 minutes from Ishpeming and adjacent to the Hoist Basin on non-Association acreage. Folks, this home was almost completely remodeled, expanded, and updated to the current owner's desires in the last 2 years. (See Virtual Tour) No expense was spared. Premium construction, materials and fixtures throughout. Large concrete patio apron as well as massive wrap around porch with spiral staircase accents this lovely home. 10-acre lot consisting of mainly maple, birch and massive white pines. Very private setting with beautiful, wooded views from all angles of this home. A large fenced garden area with sizable shed (previously a chicken coop) that features running water and electricity. 20'x19' detached, heated garage with 9' ceiling. 24'x30' pole building with water, electric and poured concrete floors. Plus, (3) additional 16'x16' lean-to bays for covered "toy" storage. Home mechanicals are as follows: New wall mounted NTI propane high efficiency indoor boiler with 6 zones and an on-demand water heater. Pex plumbing throughout. There is also a backup heating system in the "Hardy" stainless steel, outdoor, wood fired boiler that heats the whole house, garage and domestic hot water. This home features toasty in-floor heat throughout as well as central AC via a “heat pump” that is good to below zero degrees. All foam insulation in roof, walls and between floors! 200-amp main electric. Hidden fastener metal roof. All windows are low-E, argon filled and safety glass rated. Swedish "Valinge" premium 1/2" real oak flooring throughout. Ground level consists of the 'Summer Kitchen", with quartz countertops and birch cabinets that is great for processing garden harvests as well as entertainment overflow. A large cozy den, bedroom/office, mechanical room, laundry/storage and spacious tiled full bath round out this level. Main level has 9' ceilings and a large 'Great Room' with 3 picture windows overlooking the woods and garden area. There is also a high-efficiency Pacific Energy enamel wood stove which is capable of heating the entire main level. The spacious, open kitchen area offers all GE Cafe appliances, custom solid maple cabinets, a large eat-at island, granite countertops and ceramic tile floor throughout. Main level also offers a 1/2 bathroom and 1 bedroom/office/den. 3- entry doors on this level that provide access to the sprawling wrap around, covered, cedar deck/porch with tongue and groove ceilings. Upper level offers 2-3 additional bedrooms. Master suite with amazing views, 2nd bedroom/walk in closet, spacious master bath with soaking tub and a gorgeous custom tile (walk-in) digital 4- head shower. This level is rounded out with the last of the bedrooms and a 2nd laundry room. Laundry room also doubles as a craft room. Home is being sold with 10 acres. Survey is in progress.
MlsNumber: --
ListingId: 50173144


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