C
Seller's Agent in 2025
Coleen Hetzner
Century 21 Signature - Frankenmuth
(989) 295-7718
130 in this area
234 Total Sales
Estimated Value: $858,000 - $984,412
Step into luxurious family living and year-round entertainment in this stunning, custom-designed executive-style home, ideally located in the heart of Frankenmuth. Flooded with natural light and thoughtfully designed with soaring vaulted ceilings, designer lighting, and inviting fireplaces, every room radiates warmth and sophistication. The expansive great room is the perfect place to unwind, offering direct access to an upper-level deck—also accessible from the serene primary suite. This retreat features a spa-inspired ensuite and an enviable, celebrity-sized walk-in closet. At the heart of the home is a chef’s dream kitchen, complete with high-end appliances, a spacious island, granite countertops, a wet bar, walk-in pantry, and ample cabinetry. Designed for both everyday living and effortless entertaining, the kitchen anchors a unique floor plan ideal for hosting family and friends. The bright and airy lower level is equally impressive, boasting daylight windows, tall ceilings, and generous space to relax or entertain. Enjoy movie nights in the home theater, prepare meals in the second full kitchen, or gather in the expansive recreation area. Oversized sliding doors lead to your private backyard oasis—featuring a fenced-in pool, swim-up bar, and a cabana for ultimate outdoor enjoyment. Additional highlights include a dedicated home office, a fitness room, a spacious three-car garage, and a large private lot. Located just minutes from highly-rated Frankenmuth Schools, this home truly offers it all. With luxury, comfort, and style at every turn, you may never want to leave.
Last Agent to Sell the Property
Century 21 Signature - Frankenmuth License #SBR-6501253176 Listed on: 11/05/2024
Last Buyer's Agent
Century 21 Signature - Frankenmuth License #SBR-6501253176 Listed on: 11/05/2024
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 |
|---|---|---|---|
| Kern Jeremy J | $865,000 | None Listed On Document | |
| Jeremy J Kern And Sara A Kern Revocable Trust | -- | None Listed On Document | |
| Sareen Nishtha | $850,000 | Crossroads Title | |
| Stapleton Holly | $670,000 | None Available | |
| Anscomb Michael A | $50,000 | First American Title Insuran |
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 | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Kern Jeremy J | $769,850 | |
| Previous Owner | Sareen Nishtha | $850,000 | |
| Previous Owner | Stapleton Holly | $569,500 | |
| Previous Owner | Anscomb Michael A | $320,000 |
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 07/10/2025 07/10/25 | Sold | $865,000 | -3.9% | $108 / Sq Ft | |
| 06/13/2025 06/13/25 | Pending | -- | -- | -- | |
| 05/20/2025 05/20/25 | Price Changed | $899,900 | -5.3% | $113 / Sq Ft | |
| 04/02/2025 04/02/25 | Price Changed | $949,900 | -0.5% | $119 / Sq Ft | |
| 12/10/2024 12/10/24 | Price Changed | $955,000 | -3.0% | $120 / Sq Ft | |
| 11/05/2024 11/05/24 | For Sale | $985,000 | +15.9% | $123 / Sq Ft | |
| 03/03/2022 03/03/22 | Sold | $850,000 | -5.5% | $107 / Sq Ft | View Prior Sale |
| 02/04/2022 02/04/22 | Pending | -- | -- | -- | |
| 01/28/2022 01/28/22 | For Sale | $899,000 | +34.2% | $113 / Sq Ft | |
| 05/16/2019 05/16/19 | Sold | $670,000 | -4.3% | $135 / Sq Ft | View Prior Sale |
| 04/10/2019 04/10/19 | Pending | -- | -- | -- | |
| 01/05/2019 01/05/19 | Price Changed | $699,900 | -3.4% | $141 / Sq Ft | |
| 12/06/2018 12/06/18 | Price Changed | $724,900 | -3.3% | $146 / Sq Ft | |
| 12/03/2018 12/03/18 | For Sale | $749,900 | -- | $151 / Sq Ft |
| 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 |
|---|---|---|---|---|
| 2025 | $10,367 | $600,800 | $0 | $0 |
| 2024 | $10,057 | $504,300 | $0 | $0 |
| 2023 | $11,712 | $423,300 | $0 | $0 |
| 2022 | $14,163 | $432,800 | $0 | $0 |
| 2021 | $13,069 | $395,700 | $0 | $0 |
| 2020 | $12,810 | $388,600 | $0 | $0 |
| 2019 | $9,888 | $364,000 | $0 | $0 |
| 2018 | $6,715 | $331,600 | $0 | $0 |
| 2017 | $8,136 | $277,800 | $0 | $0 |
| 2016 | $8,032 | $257,300 | $0 | $0 |
| 2014 | -- | $243,000 | $0 | $197,500 |
| 2013 | -- | $170,100 | $0 | $0 |
C
Seller's Agent in 2025
Coleen Hetzner
Century 21 Signature - Frankenmuth
(989) 295-7718
130 in this area
234 Total Sales
Buyer's Agent in 2022
Holly Reinke
Berkshire Hathaway HomeServices
(989) 860-1020
2 in this area
99 Total Sales
Seller's Agent in 2019
Darren Peterfi
Exclusive House of Real Estate
(810) 498-4016
253 Total Sales
Buyer's Agent in 2019
Sherry Morris
RE/MAX
(810) 223-6291
14 in this area
138 Total Sales
Source: Michigan Multiple Listing Service
MLS Number: 50160328
APN: 03116252139000
Ask me questions while you tour the home.