Constance Reppuhn
Century 21 Signature Saginaw
(989) 270-0808
253 Total Sales
2 in Frankenmuth
$242K - $453K Price Range
449 Queens Creek Dr E Frankenmuth, MI 48734
Frankenmuth Area
3
Beds
2.5
Baths
2,547
Sq Ft
0.26
Acre Lot
Highlights
- New Construction
- Contemporary Architecture
- Wood Flooring
- Lorenz C. List Elementary Rated A
- Cathedral Ceiling
- Main Floor Bedroom
About This Home
As of October 2025Modern Luxury Meets Small-Town Charm – by Cobblestone Homes in Frankenmuth Welcome to a stunning custom-built residence by Cobblestone Homes, where modern elegance, craftsmanship, and energy efficiency come together in one of Michigan’s most desirable communities—within the city limits of charming Frankenmuth. This 2,547 sq ft contemporary home blends sophisticated design with everyday comfort, featuring 3 spacious bedrooms, 2.5 baths, and a main-floor primary suite complete with dual walk-in closets and a spa-style en suite bath with a custom-tiled shower. Step into a breathtaking 2-story grand entryway that flows seamlessly into the 12-foot-ceiling great room, highlighted by expansive custom Andersen windows and beautiful stonework that bring the outdoors in. Overlooking a peaceful rural landscape, the home offers both serenity and style. The chef’s kitchen is a showstopper—complete with quartz countertops, a matching full-height quartz backsplash, premium cabinetry, and a large island ideal for entertaining. The home features a wall oven and cooktop. A dedicated main-floor office, second-story living room, and open loft provide flexible space for remote work, relaxation, or family time. Additional features include: 3-car garage with ample storage Rear covered porch for all-weather outdoor enjoyment Generously sized bedrooms with abundant natural light Professional landscaping and full irrigation system Built beyond ENERGY STAR standards with Cobblestone’s exclusive insulation package for ultimate comfort and efficiency This home is the perfect blend of modern design, energy-conscious construction, and small-town luxury living—all nestled in the heart of Frankenmuth. Don't miss this rare opportunity to build or own a one-of-a-kind home in one of Michigan’s most sought-after communities.
Last Agent to Sell the Property
Cobblestone Realty LLC License #SBR-6501396888 Listed on: 06/16/2025
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 2025 | New Construction
Lot Details
- 11,326 Sq Ft Lot
- Lot Dimensions are 90 x 129
- Sprinkler System
Home Design
- Contemporary Architecture
- Poured Concrete
- Wood Siding
- Stone Siding
- Vinyl Siding
- Radon Mitigation System
Interior Spaces
- 2,547 Sq Ft Home
- 1.5-Story Property
- Sound System
- Cathedral Ceiling
- Ceiling Fan
- Electric Fireplace
- Entryway
- Great Room
- Home Office
- Loft
Kitchen
- Oven or Range
- Microwave
- Dishwasher
- Disposal
Flooring
- Wood
- Carpet
- Ceramic Tile
Bedrooms and Bathrooms
- 3 Bedrooms
- Main Floor Bedroom
- Walk-In Closet
Unfinished Basement
- Sump Pump
- Basement Window Egress
Parking
- 3 Car Direct Access Garage
- Garage Door Opener
- Driveway
Eco-Friendly Details
- Air Cleaner
Outdoor Features
- Patio
- Porch
Schools
- Frankenmuth Elementary And Middle School
- Frankenmuth High School
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Natural Gas
- Gas Water Heater
Community Details
- Kingsbrook Place Subdivision
Listing and Financial Details
- Assessor Parcel Number 03-11-6-25-2186-000
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
Listed on
Jun 16, 2025
Closed on
Oct 24, 2025
Sold by
Cobblestone Homes Llc
Bought by
Seller's Agent
Marshall Mannion
Cobblestone Realty LLC
Buyer's Agent
Coleen Hetzner
Century 21 Signature - Frankenmuth
List Price
$704,460
Sold Price
$704,460
Views
21
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$19,540
Avg. Annual Appreciation
3.40%
Original Mortgage
$500,000
Outstanding Balance
$496,142
Interest Rate
6.26%
Mortgage Type
New Conventional
Estimated Equity
$229,358
Purchase Details
Closed on
Apr 3, 2025
Sold by
Wellman Wayne
Bought by
Cobblestone Homes Llc
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Frankenmuth, MI
-
Constance Reppuhn
-
Mike Blake
Mike Blake
Epique Realty
(586) 400-2759
266 Total Sales
1 in Frankenmuth
$311,000 Price
-
Lynn Moore
Lynn Moore
Berkshire Hathaway HomeServices
(989) 341-8581
182 Total Sales
2 in Frankenmuth
$304K - $334K Price Range
-
Linda Sarmiento
Linda Sarmiento
Berkshire Hathaway HomeServices Michigan Real Estate
(989) 484-9859
434 Total Sales
1 in Frankenmuth
$92,500 Price
-
Doris Leal
Doris Leal
Berkshire Hathaway HomeServices
(989) 270-0538
46 Total Sales
1 in Frankenmuth
$260,000 Price
-
Joshua Moore
Joshua Moore
Berkshire Hathaway HomeServices
(989) 607-0321
218 Total Sales
2 in Frankenmuth
$304K - $334K Price Range
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 | Type | Sale Price | Title Company |
|---|---|---|---|
| Warranty Deed | $704,460 | None Listed On Document | |
| Warranty Deed | $70,000 | None Listed On Document |
Source: Public Records
Mortgage 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 | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $500,000 | New Conventional |
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 |
|---|---|---|---|---|
| 10/24/2025 10/24/25 | Sold | $704,460 | 0.0% | $277 / Sq Ft |
| 06/27/2025 06/27/25 | Pending | -- | -- | -- |
| 06/16/2025 06/16/25 | For Sale | $704,460 | -- | $277 / Sq Ft |
Source: Michigan Multiple Listing Service
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 | $275 | $356,700 | $0 | $0 |
| 2025 | $105 | $27,900 | $0 | $0 |
| 2024 | $102 | $26,900 | $0 | $0 |
| 2023 | $119 | $33,500 | $0 | $0 |
| 2022 | $232 | $32,400 | $0 | $0 |
| 2021 | $217 | $27,200 | $0 | $0 |
| 2020 | $213 | $20,900 | $0 | $0 |
| 2019 | $205 | $22,200 | $0 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
Marshall Mannion
Seller's Agent in 2025
Marshall Mannion
Cobblestone Realty LLC
(989) 513-9632
53 Total Sales
-
Coleen Hetzner
CH
Buyer's Agent in 2025
Coleen Hetzner
Century 21 Signature - Frankenmuth
(989) 295-7718
234 Total Sales
Map
Source: Michigan Multiple Listing Service
MLS Number: 50178560
APN: 03-11-6-25-2186-000
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
Source MLS: MiRealSource
Provided through IDX via MiRealSource. Courtesy of MiRealSource Shareholder. Copyright MiRealSource.
The information published and disseminated by MiRealSource is communicated verbatim, without change by MiRealSource, as filed with MiRealSource by its members. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified.
Copyright 2026 MiRealSource. All rights reserved. The information provided hereby constitutes proprietary information of MiRealSource, Inc. and its shareholders, affiliates and licensees and may not be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopy, recording, scanning or any information storage and retrieval system, without written permission from MiRealSource, Inc.
Nearby Homes
- 334 Queens Creek Dr W
- 192 Queen's Creek Dr
- 184 Queens Creek Dr W
- 373 Block St
- 248 Frank Rd
- 343 Frank Rd
- 700 E Genesee St Unit B10
- 480 E Genesee St
- 306 Sunburst Dr
- 405 Nickless St
- 150 Parker St
- 240 W Tuscola Unit 4 St Unit 4
- 240 W Tuscola Unit 3 St
- 240 W Tuscola St Unit 15
- 240 W Tuscola St Unit 9
- 240 W Tuscola St Unit 2
- 240 W Tuscola St Unit 13
- 128 Beyerlein St
- 12563 E Townline Rd
- 437 W Schleier St Unit 1
Your Personal Tour Guide
Ask me questions while you tour the home.