NOT LISTED FOR SALE

26547 Celtic Dr Flat Rock, MI 48134

Estimated Value: $485,000 - $518,000

4 Beds
2.5 Baths
2,487 Sq Ft
$201/Sq Ft Est. Value

Last Sold November 19, 2024

Last sale price $486,000 $195 Per Sq Ft

Est. 3% increase in value since last sale

Current estimated payment $3,374/month

24 Days on Market

Highlights

  • Cathedral Ceiling
  • Home Office
  • Porch
  • Wood Flooring
  • Fenced Yard
  • 3 Car Attached Garage

About This Home

As of November 2024

Want that brand new home, but don't want to wait? Here is the perfect home for you! 2023 Custom-Built Home by CAMco Builders. 4 Beds, 2.5 Baths with Plumbing in the Basement for a 3rd Full-Bath and Egress Window in the Basement to allow for 5th Bedroom, Office with French Doors on First Floor, Custom Granite Counter Tops in Kitchen and Bathrooms, Wood Flooring on First Floor, Ceramic Tile in Bathrooms, New Stainless Steel Kitchen Appliances, New Washer and Dryer, New Ceiling Fans, 9' ceilings, Cathedral Ceiling in Kitchen, Dining Room and Living Room, New Security System, Sod installed on Front Lawn, 3-Car 31x21 Garage with 220 service, New White Vinyl Fencing, New Concrete Driveway and Patio. Home is still under Builder's Warranty. Open Concept Home with Large Kitchen, Dining and Living Room Area with Gas Fireplace. Make this your new Home for the Holidays!

Last Agent to Sell the Property

Dione Oerther

Key Realty One LLC - Roessler License #MCAR-6506049333 Listed on: 09/14/2024

Last Buyer's Agent

Katherine Guilbault

Real Estate One Plymouth License #6501436624

Real Estate One Plymouth

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 2023

Lot Details

  • 0.36 Acre Lot
  • Lot Dimensions are 89.43 x 174.38
  • Fenced Yard

Home Design

  • Brick Exterior Construction
  • Poured Concrete
  • Frame Construction
  • Vinyl Siding

Interior Spaces

  • 2,487 Sq Ft Home
  • 2-Story Property
  • Cathedral Ceiling
  • Ceiling Fan
  • Gas Fireplace
  • Entryway
  • Living Room with Fireplace
  • Home Office
  • Home Security System

Kitchen

  • Oven or Range
  • Microwave
  • Dishwasher
  • Disposal

Flooring

  • Wood
  • Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet

Laundry

  • Laundry Room
  • Dryer
  • Washer

Basement

  • Sump Pump
  • Basement Window Egress

Parking

  • 3 Car Attached Garage
  • Garage Door Opener

Outdoor Features

  • Patio
  • Porch

Utilities

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

Community Details

  • Celtic Farms Sub Subdivision

Listing and Financial Details

  • Assessor Parcel Number 58-089-02-0005-000

Home Details

Home Type

Single Family

Est. Annual Taxes

$7,823

Year Built

Built in 2023

Lot Details

0

Listing Details

  • Originating MLS: Southeastern Border Association of REALTORS
  • Class: RESIDENTIAL
  • Type Of Property: Single Family
  • Architecture Style: Conventional Frame
  • Structure Style: 2 Story
  • Total Tax Amount: 7823.33
  • Year Built: 2023
  • Mail City: Flat Rock
  • Special Features: NewHome
  • Property Sub Type: Detached
  • Stories: 2

Interior Features

  • Interior Amenities: 9 ft + Ceilings, Cable/Internet Avail., Cathedral/Vaulted Ceiling, Ceramic Floors, Hardwood Floors, Security System, Sump Pump, Walk-In Closet
  • Appliances: Dishwasher, Disposal, Dryer, Microwave, Range/Oven, Refrigerator, Washer
  • Fireplace: Yes
  • Fireplaces: Gas Fireplace, LivRoom Fireplace
  • Basement: Yes
  • Basement: Egress/Daylight Windows, Poured, Sump Pump
  • Bedrooms: 4
  • Bedroom 1: On 2nd Floor, Dimensions: 17 x 16
  • Bedroom 1 Floor Covering: Carpet
  • Bedroom 2: On 2nd Floor, Dimensions: 16 x 11
  • Bedroom 2 Floor Covering: Carpet
  • Bedroom 3: On 2nd Floor, Dimensions: 14 x 12
  • Bedroom 3 Floor Covering: Carpet
  • Bedroom 4: On 2nd Floor, Dimensions: 13 x 11
  • Bedroom 4 Floor Covering: Carpet
  • Full Bathrooms: 2
  • Total Bathrooms: 3
  • Bathroom 1: Dimensions: 11 x 10, On Level: Second, Flooring: Ceramic
  • Bathroom 2: Dimensions: 10 x 5, On Level: Second, Flooring: Ceramic
  • Room Types: Entry, First Floor Laundry, Living Room, Utility/Laundry Room, Primary Bedroom, Primary Bathroom, Home Office, First Flr Lavatory, Primary Bdrm Suite
  • Dining Room: On Main Floor, Dimensions: 20 x 11
  • Dining Room Floor Covering: Wood
  • Kitchen: On Main Floor, Dimensions: 15 x 11
  • Kitchen Floor Covering: Wood
  • Laundry: On Main Floor, Dimensions: 9 x 6
  • Laundry Room Floor Covering: Wood
  • Living Room: On Main Floor, Dimensions: 17 x 16
  • Living Room Floor Covering: Wood
  • Other Room1: Dimensions: 14x11, On Level: Main, Flooring: Carpet
  • Below Grade Sq Ft: 1249
  • Above Grade Finished Sq Ft: 2487
  • Total Finished Sq Ft: 2487
  • Half Bathrooms: 1

Exterior Features

  • Exterior: Brick, Vinyl Siding
  • Exterior Features: Fenced Yard, Patio, Porch, Storms/Screens, Fence Owned
  • Foundation: Basement
  • Frontage: 89
  • Road: City/County, Curbed, Paved Street
  • Frontage Type: Road

Garage/Parking

  • Garage: Attached Garage, Electric in Garage, Gar Door Opener
  • Garage Spaces: 3
  • Parking: 3 or More Spaces, Garage, Paved Driveway
  • Garage: Yes

Utilities

  • Heating: Forced Air
  • Heating Fuel: Natural Gas
  • Sewer: Public Sanitary
  • Water: Public Water
  • Water Heater: Gas
  • Cooling: Ceiling Fan(s), Central A/C

Lot Info

  • Assessor Parcel Number: 58-089-02-0005-000
  • Zoning: Residential
  • Lot Description: Deep Lot - 150+ Ft., Large Lot - 65+ Ft.
  • Lot Dimensions: 89.43 x 174.38
  • Acreage: 0.36
  • Geo Subdivision: MI
  • Site/Lot Features: Subdivision

Tax Info

  • Summer Tax: Year: 2024, Amount: $7,260.28
  • Winter Tax: Year: 2023, Amount: $563.05
  • Total Tax: Amount: $7,823.33

MLS Schools

  • School District: Flat Rock Community Schools

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Sep 14, 2024
Closed on
Nov 19, 2024
Sold by
Liedel Robert and Liedel Amy
Bought by
Tardiff Christopher and Tardiff Emily
Seller's Agent
Dione Oerther
Key Realty One LLC - Roessler
Buyer's Agent
Katherine Guilbault
Real Estate One Plymouth
List Price
$489,900
Sold Price
$486,000
Premium/Discount to List
-$3,900
-0.8%
Views
66
Current Estimated Value
$499,667

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$13,667
Avg. Annual Appreciation
2.55%

Purchase Details

Listed on
Nov 28, 2023
Closed on
Feb 29, 2024
Sold by
Camco Building Solutions Llc
Bought by
Liedel Robert and Liedel Amy
Seller's Agent
Stacey Pardikes
Harmony Home Real Estate Group
Buyer's Agent
Dione Oerther
Key Realty One LLC - Roessler
List Price
$445,000
Sold Price
$445,885
Premium/Discount to List
$885
0.2%
Views
30

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
12.90%
Original Mortgage
$356,708
Interest Rate
6.69%
Mortgage Type
New Conventional

Purchase Details

Listed on
Nov 28, 2023
Closed on
Feb 28, 2024
Sold by
Celtic Farms Development Llc
Bought by
Camco Building Solutions Llc
Seller's Agent
Stacey Pardikes
Harmony Home Real Estate Group
Buyer's Agent
Dione Oerther
Key Realty One LLC - Roessler
List Price
$445,000
Sold Price
$445,885
Premium/Discount to List
$885
0.2%
Views
30

Home Financials for this Owner

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

Purchase Details

Closed on
Mar 24, 2021
Sold by
Simeon Services Inc
Bought by
Celtic Farms Development Llc

Purchase Details

Closed on
Jun 19, 2018
Sold by
N A Mans And Sons Inc
Bought by
Simeron Srvices Inc

Purchase Details

Closed on
Mar 7, 2012
Sold by
Celtic Farms Development Llc
Bought by
N A Mans & Sons Inc
Source: Public Records

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 Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Tardiff Christopher $486,000 None Listed On Document
Liedel Robert $445,885 Vanguard Title
Liedel Robert $445,885 Vanguard Title
Camco Building Solutions Llc $75,000 Vanguard Title
Camco Building Solutions Llc $75,000 Vanguard Title
Celtic Farms Development Llc $288,000 Vanguard Title Company
Simeron Srvices Inc $2,000 None Available
N A Mans & Sons Inc -- None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Liedel Robert $356,708
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
11/19/2024 11/19/24 Sold $486,000 -0.8% $195 / Sq Ft
10/08/2024 10/08/24 Pending -- -- --
09/14/2024 09/14/24 For Sale $489,900 +9.9% $197 / Sq Ft
03/04/2024 03/04/24 Sold $445,885 0.0% $179 / Sq Ft View Prior Sale
12/02/2023 12/02/23 Pending -- -- --
12/02/2023 12/02/23 Off Market $445,885 -- --
11/28/2023 11/28/23 For Sale $445,000 -- $179 / Sq Ft
Source: Michigan Multiple Listing Service

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
2025 $9,074 $212,200 $0 $0
2024 $7,260 $173,900 $0 $0
2023 $1,391 $33,500 $0 $0
2022 $1,860 $25,500 $0 $0
2021 $1,591 $23,300 $0 $0
2020 $1,571 $23,200 $0 $0
2019 $1,534 $21,000 $0 $0
2018 $739 $15,700 $0 $0
2017 $626 $17,900 $0 $0
2016 $1,003 $16,900 $0 $0
2015 $1,363 $16,300 $0 $0
2013 $1,320 $13,200 $0 $0
2012 $800 $11,700 $11,700 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Michigan Multiple Listing Service

MLS Number: 50155389

Michigan Multiple Listing Service

APN: 58-089-02-0005-000