Welcome to Frankenmuth, where the perfect balance of country charm and modern living awaits you at this newly constructed Cobblestone Home. Designed with attention to detail, this sprawling ranch offers a generous 1817 square feet of comfortable living space, perfectly suited for families, retirees, or anyone looking for a peaceful retreat without sacrificing convenience. Size: 1817 sq ft Bedrooms: 3 Spacious Bedrooms Bathrooms: 2 Full Bathrooms and 1 Half Bathroom Basement: Large 9-foot non-finished Basement Garage: Attached 3rd Car Garage Outdoor Space: Covered Porch with stunning views of the Frankenmuth countryside Community: Sidewalks throughout providing a friendly neighborhood atmosphere Landscaping: Full landscaping package including a sprinkler system for easy maintenance Construction: Under construction with a completion for Summer of 2025, ensuring a brand-new living experience
Sold for $599,900 on 09/15/25
$599,900
504 Queens Creek Dr, Frankenmuth, MI 48734
3beds
1,817sqft
Single Family Residence
Built in 2025
0.34 Acres Lot
$606,500 Zestimate®
$330/sqft
$-- Estimated rent
Owner options
What's special
Zillow last checked: 8 hours ago
Listing updated: September 29, 2025 at 08:18am
Listed by:
Marshall C Mannion 989-692-0210,
Cobblestone Realty LLC
Bought with:
Crystal Hines, 6501446585
Red Fox Realty LLC
Source: MiRealSource,MLS#: 50169143
Originating MLS: Saginaw Board of REALTORS
Originating MLS: Saginaw Board of REALTORSFacts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
Primary bedroom
- Level: First
Bedroom 1
- Features: Carpet
- Level: First
- Area: 195
- Dimensions: 15 x 13
Bedroom 2
- Features: Carpet
- Level: First
- Area: 143
- Dimensions: 13 x 11
Bedroom 3
- Features: Carpet
- Level: First
- Area: 132
- Dimensions: 12 x 11
Bathroom 1
- Features: Ceramic
- Level: First
- Area: 104
- Dimensions: 8 x 13
Bathroom 2
- Features: Laminate
- Level: First
- Area: 40
- Dimensions: 8 x 5
Dining room
- Features: Laminate
- Level: First
- Area: 132
- Dimensions: 12 x 11
Kitchen
- Features: Laminate
- Level: First
- Area: 104
- Dimensions: 13 x 8
Living room
- Features: Laminate
- Level: First
- Area: 288
- Dimensions: 18 x 16
Heating
- Forced Air, Natural Gas
Cooling
- Ceiling Fan(s), Central Air
Appliances
- Included: Dishwasher, Disposal, Microwave, Range/Oven, Gas Water Heater
- Laundry: First Floor Laundry, Laundry Room
Features
- High Ceilings, Cathedral/Vaulted Ceiling, Radon Mitigation System, Sump Pump, Walk-In Closet(s), Pantry
- Flooring: Ceramic Tile, Laminate, Carpet
- Basement: Daylight,Concrete,Radon System,Sump Pump,Unfinished
- Number of fireplaces: 1
- Fireplace features: Gas
Interior area
- Total structure area: 3,524
- Total interior livable area: 1,817 sqft
- Finished area above ground: 1,817
- Finished area below ground: 0
Property
Parking
- Total spaces: 3
- Parking features: 3 or More Spaces, Covered, Attached, Electric in Garage, Garage Door Opener
- Attached garage spaces: 3
Features
- Levels: One
- Stories: 1
- Patio & porch: Porch
- Exterior features: Lawn Sprinkler, Sidewalks, Street Lights
- Frontage type: Road
- Frontage length: 90
Lot
- Size: 0.34 Acres
- Dimensions: 90 x 165
- Features: Deep Lot - 150+ Ft., City Lot, Cleared, Sidewalks, Subdivision
Details
- Parcel number: 03116252212000
- Zoning description: Residential
- Special conditions: Private
- Other equipment: Air Cleaner
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Craftsman
- Property subtype: Single Family Residence
Materials
- Other, Stone, Vinyl Siding, Vinyl Trim, Wood Siding
- Foundation: Basement, Concrete Perimeter
Condition
- New Construction
- New construction: Yes
- Year built: 2025
Details
- Warranty included: Yes
Utilities & green energy
- Electric: 200+ Amp Service
- Sewer: Public Sanitary
- Water: Public
- Utilities for property: Cable Available, Electricity Connected, Internet DSL Available, Natural Gas Connected, Sewer Connected, Underground Utilities, Water Connected
Community & neighborhood
Location
- Region: Frankenmuth
- Subdivision: Kings Brook Place
Other
Other facts
- Listing agreement: Exclusive Right To Sell
- Listing terms: Cash,Conventional,Conventional Blend,FHA,FHA 203K
- Road surface type: Paved