NOT LISTED FOR SALE

24380 County Road 476 Ishpeming, MI 49849

Ishpeming Area

Estimated Value: $426,000 - $849,199

4 Beds
4 Baths
4,670 Sq Ft
$132/Sq Ft Est. Value

Sale Details

Date Sold: December 5, 2023

Last sale price $675,000 $145 Per Sq Ft

Est. 9% decrease in value since last sale

Current estimated payment $4,237 / mo

3 Days on Market

Highlights

  • Water Views
  • Sauna
  • Craftsman Architecture
  • Guest House
  • 25 Acre Lot
  • Deck

About This Home

As of December 2023

Lodge home in Michigan's beautiful Upper Peninsula will captivate you from the moment you turn onto the private drive and enter this wooded estate. This custom crafted home is truly one of a kind, from the carved log beams at the entrance to the etched copper wrap around interior logs. Features include vaulted ceilings, soaring windows, huge outdoor decks, granite counters, indoor sauna, subzero refrigerator and freezer, wet bar, gas fireplace, in floor heat, outdoor wood fired boiler, backup generator and all appliances are included in the sale. The ground level is an expertly finished walk out basement with a two-car attached, heated garage. The main level features the large kitchen and dining area perfect for entertaining, the two-family rooms and a master suite. Upstairs has two bedrooms a bath and office space/den space. The home is located on 25 beautifully wooded acres that is a naturalists delight where flora and fauna overwhelm. The yard is a landscaped area around the buildings including a small apple orchard. Here you will see deer, turkey, grouse and many other woodland and waterfront animals. The acreage abuts corporate ownership with private water access on 250-acre Schweitzer Basin boasting walleye, panfish and pike fishing with great scenery. Additionally, this magnificent property has a three-car finished garage with an attached 2 BR apartment that is nearly as charming as the home. All of this splendid property just minutes from Ishpeming and only a half hour drive to Marquette. If you have been looking for a top quality, high end and unique home on acreage in Marquette County you have just found it. You have heard this adage before, but you must see this property to appreciates all it has to offer.

Last Agent to Sell the Property

Bob Sullivan

NORTHERN MICHIGAN LAND BROKERS License #UPAR-6502138854 Listed on: 10/16/2023

Last Buyer's Agent

ROBERT PLOTEZKA

KELLER WILLIAMS FIRST UP License #UPAR-6501417990

KELLER WILLIAMS FIRST UP

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Details

Home Type

  • Single Family

Year Built

  • Built in 2007

Lot Details

  • 25 Acre Lot
  • Lot Dimensions are 630x252x423x403x675
  • Wooded Lot
  • Garden

Parking

  • 5 Car Garage

Home Design

  • Craftsman Architecture
  • Wood Siding

Interior Spaces

  • 1.5-Story Property
  • Wet Bar
  • Ceiling height of 9 feet or more
  • Skylights
  • Decorative Fireplace
  • Gas Fireplace
  • Entryway
  • Great Room
  • Family Room
  • Living Room
  • Home Office
  • Recreation Room
  • Loft
  • Workshop
  • Sauna
  • Oven or Range
  • Home Gym
  • Water Views
  • Dryer

Flooring

  • Wood
  • Radiant Floor

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet
  • In-Law or Guest Suite
  • Bathroom on Main Level
  • 4 Full Bathrooms

Finished Basement

  • Walk-Out Basement
  • Interior and Exterior Basement Entry
  • Basement Window Egress

Outdoor Features

  • Deck
  • Patio
  • Separate Outdoor Workshop
  • Shed

Additional Homes

  • Guest House

Utilities

  • Zoned Heating
  • Boiler Heating System
  • Heating System Uses Wood
  • Heating System Uses Propane
  • Well
  • Liquid Propane Gas Water Heater
  • Septic Tank

Listing and Financial Details

  • Assessor Parcel Number 52-16-103-001-00

Home Details

Home Type

Single Family

Year Built

Built in 2007

Lot Details

25 Acres

Listing Details

  • Originating MLS: Upper Peninsula Assoc of Realtors
  • Class: RESIDENTIAL
  • Type: Residential
  • Type Of Property: Single Family
  • Architecture Style: Craftsman
  • Structure Style: 1 1/2 Story
  • Total Tax Amount: 1702
  • Total Tax Year: 2020
  • Year Built: 2007
  • Mail City: Ishpeming
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 1

Interior Features

  • Interior Amenities: 9 ft + Ceilings, Hardwood Floors, Walk-In Closet, Wet Bar/Bar, Skylights, Spa/Sauna
  • Appliances: Dryer, Range/Oven, Refrigerator
  • Fireplace: Yes
  • Fireplaces: Gas Fireplace, Decorative Fireplace
  • Basement: Yes
  • Basement: Egress/Daylight Windows, Finished, Outside Entrance, Walk Out, Interior Access
  • Bedrooms: 4
  • Bedroom 1: On Main Floor, Dimensions: 14 x 22
  • Bedroom 2: On Upper Floor, Dimensions: 12 x 14
  • Bedroom 3: On Upper Floor, Dimensions: 11 x 14
  • Bedroom 4: On Lower Floor, Dimensions: 9 x 14
  • Full Bathrooms: 4
  • Total Bathrooms: 4
  • Bathroom 1: Dimensions: 8 x 9, On Level: Lower
  • Bathroom 2: Dimensions: 5 x 11, On Level: Main
  • Bathroom 3: Dimensions: 9 x 13, On Level: Main
  • Bathroom 4: Dimensions: 5 x 7, On Level: Upper
  • Room Types: Entry, Exercise Room, Family Room, First Floor Laundry, Great Room, In-Law/AuPair/Ste, Living Room, Loft, Recreation Room, Workshop, Home Office, First Flr Full Bathroom
  • Breakfast Nook: On Main Floor, Dimensions: 9 x 16
  • Dining Room: On Main Floor, Dimensions: 27 x 9
  • Kitchen: On Main Floor, Dimensions: 13 x 22
  • Living Room: On Main Floor, Dimensions: 27 x 22
  • Below Grade Sq Ft: 1250
  • Finished Below Grade Sq Ft: 1250
  • Above Grade Finished Sq Ft: 3420
  • Total Finished Sq Ft: 4670

Exterior Features

  • Exterior: Wood
  • Exterior Features: Deck, Patio, Garden Area
  • Foundation: Basement
  • Frontage: 630
  • Road: City/County, Paved Street, Year Round
  • Water Features: Water View
  • Out Buildings: Shed, Garage(s), Guest House, Workshop
  • Frontage Type: Road

Garage/Parking

  • Garage: Attached Garage
  • Garage Spaces: 5
  • Parking: 3 or More Spaces, Garage
  • Garage: Yes

Utilities

  • Heating: Boiler, Zoned Heating, Radiant Floor
  • Heating Fuel: LP/Propane Gas, Wood
  • Sewer: Septic
  • Water: Private Well
  • Water Heater: Propane Hot Water

Lot Info

  • Assessor Parcel Number: 52-16-103-001-00
  • Zoning: Residential
  • Lot Dimensions: 630x252x423x403x675
  • Acreage: 25
  • Geo Subdivision: MI
  • Site/Lot Features: Wooded

Tax Info

  • Summer Tax: Year: 2020, Amount: $918.00
  • Winter Tax: Year: 2020, Amount: $784.00
  • Total Tax: Year: 2020, Amount: $1,702.00

MLS Schools

  • School District: NICE Community Schools

Ownership History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Name Owned For Owner Type

Purchase Details

Closed on
Jul 11, 2024
Sold by
Bought by
Current Estimated Value
$615,066

Purchase Details

Listed on
Oct 16, 2023
Closed on
Dec 5, 2023
Sold by
Bought by
Seller's Agent
Bob Sullivan
NORTHERN MICHIGAN LAND BROKERS
Buyer's Agent
ROBERT PLOTEZKA
KELLER WILLIAMS FIRST UP
List Price
$725,000
Sold Price
$675,000
Premium/Discount to List
-$50,000
-6.9%
Views
24

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
-3.37%

Purchase Details

Closed on
Jun 17, 1999
Bought by
Source: Public Records

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Buyer Sale Price Title Company
-- None Listed On Document
$675,000 Transnation Title Agency
-- --
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft
12/05/2023 12/05/23 Sold $675,000 -6.9% $145 / Sq Ft
10/16/2023 10/16/23 For Sale $725,000 -- $155 / Sq Ft
Source: Upper Peninsula Association of REALTORS®

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2026 $10,356 $390,200 $0 $0
2025 $3,829 $388,700 $0 $0
2024 $37 $246,500 $0 $0
2023 $769 $223,400 $0 $0
2022 $1,542 $161,700 $0 $0
2021 $1,493 $173,300 $0 $0
2020 $1,476 $161,700 $0 $0
2019 $1,451 $159,000 $0 $0
2018 $1,485 $147,250 $0 $0
2017 $1,006 $45,200 $0 $0
2016 $1,004 $45,200 $0 $0
2015 -- $45,200 $0 $0
2014 -- $45,200 $0 $0
2012 -- $48,100 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Upper Peninsula Association of REALTORS®

MLS Number: 50125216

Upper Peninsula Association of REALTORS®

APN: 52-16-103-001-00

Your Personal Tour Guide

Ask me questions while you tour the home.