NOT LISTED FOR SALE

26547 Celtic Dr Flat Rock, MI 48134

Flat Rock Area

Estimated Value: $450,000 - $516,000

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

Sale Details

Date Sold: November 19, 2024

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

Est. 3% decrease in value since last sale

Current estimated payment $3,307 / mo

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

3Sixty5 Realty License #6501436624

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 2023

Lot Details

  • 15,682 Sq Ft 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

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

Home Security

  • Home Security System
  • Storm Screens

Parking

  • 3 Car Attached Garage
  • Garage Door Opener
  • Driveway

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.36 Acres

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

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
Sep 14, 2024
Closed on
Nov 19, 2024
Sold by
Bought by
Seller's Agent
Dione Oerther
Key Realty One LLC - Roessler
Buyer's Agent
Katherine Guilbault
3Sixty5 Realty
List Price
$489,900
Sold Price
$486,000
Premium/Discount to List
-$3,900
-0.8%
Views
66
Current Estimated Value
$472,333

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
-1.72%
Original Mortgage
$496,449
Interest Rate
0.0654%
Mortgage Type
VA

Purchase Details

Listed on
Nov 28, 2023
Closed on
Feb 29, 2024
Sold by
Bought by
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
0.0669%
Mortgage Type
New Conventional

Purchase Details

Listed on
Nov 28, 2023
Closed on
Feb 28, 2024
Sold by
Bought by
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
0.0669%
Mortgage Type
New Conventional

Purchase Details

Closed on
Mar 24, 2021
Sold by
Bought by

Purchase Details

Closed on
Jun 19, 2018
Sold by
Bought by

Purchase Details

Closed on
Mar 7, 2012
Sold by
Bought by
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

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
$486,000 None Listed On Document
$445,885 Vanguard Title
$75,000 Vanguard Title
$288,000 Vanguard Title Company
$2,000 None Available
-- None Available
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 Borrower Loan Amount
Open $504,510
Closed $496,449
Previous Owner $356,708
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 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

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
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

  • Dione Oerther

    Seller's Agent in 2024

    Dione Oerther

    Key Realty One LLC - Roessler

    (734) 735-6224

    118 Total Sales

    Dione Oerther
    Section Image
  • Stacey Pardikes

    Seller's Agent in 2024

    Stacey Pardikes

    Harmony Home Real Estate Group

    (734) 437-4826

    131 Total Sales

    Stacey Pardikes
    Section Image
  • Katherine Guilbault

    Buyer's Agent in 2024

    Katherine Guilbault

    3Sixty5 Realty

    (313) 680-0577

    68 Total Sales

    Katherine Guilbault
    Section Image
See All Agents

Map

Source: Michigan Multiple Listing Service

MLS Number: 50155389

Michigan Multiple Listing Service

APN: 58-089-02-0005-000

Michigan Wayne County Flat Rock 48134

26547 Celtic Dr, Flat Rock, MI

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.

Michigan Multiple Listing Service 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
Your Personal Tour Guide

Ask me questions while you tour the home.