NOT LISTED FOR SALE

239 Queen's Creek Dr Frankenmuth, MI 48734

Estimated Value: $545,000 - $619,907

4 Beds
3 Baths
2,945 Sq Ft
$194/Sq Ft Est. Value

Last Sold January 31, 2020

Last sale price $440,000 $149 Per Sq Ft

Est. 30% increase in value since last sale

Current estimated payment $3,664/month

100 Days on Market

Highlights

  • New Construction
  • Ranch Style House
  • Porch
  • List Elementary Rated A-
  • Wood Flooring
  • Walk-In Closet

About This Home

As of January 2020

New custom design home by Ratti Builders. Home is Nearly 3000 sq. ft. of living space. Huge master suite with walk in closet, double ceramic master shower, finished basement, Energy Star rated home. 3 car plus attached garage. fireplace, Granite tops. 3.5 bath. Open floor plan, Large daylight windows in lower level with full bath and family room. Fully landscaped with sprinklers. Rear covered patio. Plenty of storage area. New home warranty with this purchase.

Last Listed By

Thomas Arthur

Welcome Home Realty License #BCRA-6504253235 Listed on: 10/14/2019

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 2019 | New Construction

Lot Details

  • 0.34 Acre Lot
  • Lot Dimensions are 90x165
  • Sprinkler System

Parking

  • 3 Car Garage

Home Design

  • Ranch Style House
  • Poured Concrete
  • Stone Siding
  • Vinyl Siding

Interior Spaces

  • Ceiling height of 9 feet or more
  • Basement

Flooring

  • Wood
  • Carpet
  • Ceramic Tile
  • Vinyl

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet
  • 3 Full Bathrooms

Outdoor Features

  • Patio
  • Porch

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Gas Water Heater

Listing and Financial Details

  • Assessor Parcel Number 03-11-6-25-2168-000

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,685

Year Built

Built in 2019 | New Construction

Lot Details

0

Listing Details

  • Originating MLS: Bay County REALTOR Association
  • Class: RESIDENTIAL CONDO
  • Type Of Property: Residential
  • Architecture Style: Ranch
  • Structure Style: 1 Story
  • New Construction: Yes
  • Year Built: 2019
  • Special Features: NewHome
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: 9 ft + Ceilings, Ceramic Floors, Walk-In Closet
  • Basement: Yes
  • Basement: Poured
  • Bedrooms: 4
  • Bedroom 1: On Main Floor, Dimensions: 19 x 16
  • Bedroom 1 Floor Covering: Carpet
  • Bedroom 2: On Main Floor, Dimensions: 12 x 13
  • Bedroom 2 Floor Covering: Carpet
  • Bedroom 3: On Main Floor, Dimensions: 12 x 12
  • Bedroom 3 Floor Covering: Carpet
  • Bedroom 4: On Lower Floor, Dimensions: 13 x 14
  • Bedroom 4 Floor Covering: Carpet
  • Bathrooms Description: MstrBdrm Full Bathroom
  • Full Bathrooms: 3
  • Total Bathrooms: 4
  • Below Grade Bathroom: 1
  • Bathroom 1: Dimensions: 12 x 15, On Level: Main, Flooring: Ceramic
  • Bathroom 2: Dimensions: 9 x 7, On Level: Main, Flooring: Ceramic
  • Bathroom 3: On Level: Basement, Flooring: Ceramic
  • Dining Room: On Main Floor, Dimensions: 15 x 14
  • Dining Room Floor Covering: Wood
  • Family Room: On Lower Floor, Dimensions: 17 x 20
  • Family Room Floor Covering: Carpet
  • Kitchen: On Main Floor, Dimensions: 14 x 14
  • Kitchen Floor Covering: Wood
  • Laundry: On Main Floor, Dimensions: 13 x 7
  • Laundry Room Floor Covering: Vinyl
  • Living Room: On Main Floor, Dimensions: 21 x 20
  • Living Room Floor Covering: Wood
  • Below Grade Sq Ft: 2210
  • Finished Below Grade Sq Ft: 735
  • Half Bathrooms: 1
  • Above Grade Finished Sq Ft: 2210
  • Total Finished Sq Ft: 2945

Exterior Features

  • Exterior: Stone, Vinyl Siding
  • Exterior Features: Lawn Sprinkler, Patio, Porch, Street Lights
  • Foundation: Basement
  • Frontage: 90
  • Road: Paved Street

Garage/Parking

  • Garage Spaces: 3
  • Parking: Garage
  • Garage: Yes

Utilities

  • Heating: Forced Air
  • Heating Fuel: Natural Gas
  • Sewer: Public Sanitary
  • Water: Public Water
  • Water Heater: Gas
  • Cooling: Central A/C

Lot Info

  • Assessor Parcel Number: 03-11-6-25-2168-000
  • Location: Subdivision
  • Lot Dimensions: 90x165
  • Acreage: 0.34

Tax Info

  • Summer Tax: Year: 2019, Amount: $714.67
  • Winter Tax: Year: 2018, Amount: $711.45
  • Taxable Value: 25000
  • Total Tax: Year: 2019, Amount: $1,426.12
  • SEV Year: 2019

MLS Schools

  • School District: Frankenmuth School District

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Aug 8, 2024
Sold by
Murtha Patrick and Murtha Kathleen
Bought by
Patrick J Murtha And Kathleen M Murtha Living
Total Days on Market
100
Current Estimated Value
$572,727

Purchase Details

Closed on
Jun 24, 2022
Sold by
Wortman Daniel L
Bought by
Murtha Patrick and Murtha Kathleen

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$250,000
Interest Rate
5.1%
Mortgage Type
New Conventional

Purchase Details

Listed on
Oct 14, 2019
Closed on
Feb 5, 2020
Sold by
Wortman Daniel
Bought by
Wortman Daniel L
Seller's Agent
Thomas Arthur
Welcome Home Realty
Buyer's Agent
Coleen Hetzner
Century 21 Signature - Frankenmuth
List Price
$498,900
Sold Price
$440,000
Premium/Discount to List
-$58,900
-11.81%

Home Financials for this Owner

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

Purchase Details

Listed on
Oct 14, 2019
Closed on
Jan 31, 2020
Sold by
Ratti Gary
Bought by
Wortman Daniel
Seller's Agent
Thomas Arthur
Welcome Home Realty
Buyer's Agent
Coleen Hetzner
Century 21 Signature - Frankenmuth
List Price
$498,900
Sold Price
$440,000
Premium/Discount to List
-$58,900
-11.81%

Purchase Details

Closed on
Feb 2, 2016
Sold by
Bavarian Builders Inc and Frank Randall L
Bought by
Wellman Wayne

Range of Values:

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

Similar Home in Frankenmuth, MI

  • 9763 Beech Tree Ln, Frankenmuth, MI 48734

    $649,900

    • 5 Beds
    • 4.5 Baths
    • 3,340 Sq Ft
    • 9763 Beech Tree Ln
    • Frankenmuth, MI

    Tucked away on an acre-plus, tree-covered lot, this stunning five-bedroom estate offers the perfect blend of space, privacy, and charm in a quiet, picturesque neighborhood. Located in the highly sought-after Frankenmuth School District, this home is as impressive inside as it is outside!Step through the front door, and you’re greeted by a grand, open layout featuring soaring 17.5-foot ceilings in

    Andrew Keller Knockout Real Estate

    Section Image

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Patrick J Murtha And Kathleen M Murtha Living -- None Listed On Document
Murtha Patrick $530,000 Crossroads Title
Wortman Daniel L -- None Available
Wortman Daniel $460,000 None Available
Wellman Wayne $465,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Murtha Patrick $250,000
Previous Owner Ratti Gary $333,750
Previous Owner Ratti Gary $62,500
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
01/31/2020 01/31/20 Sold $440,000 -4.7% $149 / Sq Ft
01/22/2020 01/22/20 Pending -- -- --
01/19/2020 01/19/20 Price Changed $461,900 -3.8% $157 / Sq Ft
01/15/2020 01/15/20 Price Changed $479,900 +0.8% $163 / Sq Ft
01/15/2020 01/15/20 Price Changed $475,900 -2.1% $162 / Sq Ft
12/12/2019 12/12/19 Price Changed $485,900 -1.2% $165 / Sq Ft
11/14/2019 11/14/19 Price Changed $491,900 -1.4% $167 / Sq Ft
10/14/2019 10/14/19 For Sale $498,900 -- $169 / Sq Ft
Source: Bay County Realtor® Association MLS

Tax History Compared to Growth

Source: Public Records

Tax History

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
2024 $5,685 $251,800 $0 $0
2023 $6,617 $238,400 $0 $0
2022 $8,826 $243,800 $0 $0
2021 $8,145 $222,600 $0 $0
2020 $7,864 $216,200 $0 $0
2019 $1,374 $25,000 $0 $0
2018 $659 $25,000 $0 $0
2017 $1,279 $25,000 $0 $0
2016 $1,429 $25,000 $0 $0
2014 -- $25,000 $0 $0
2013 -- $25,000 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Bay County Realtor® Association MLS

MLS Number: 31397529

Bay County Realtor® Association MLS

APN: 03116252168000