$505,000
SOLD OCT 30, 2025

27003 Celtic Dr Flat Rock, MI 48134

4 Beds
2.5 Baths
2,575 Sq Ft
0.42 Acres

Recently Sold

$196 Per Sq Ft

3% Below List Price

51 Days on Market

Highlights

  • 0.42 Acre Lot
  • Freestanding Bathtub
  • No HOA
  • Cape Cod Architecture
  • Great Room
  • Home Office

About This Home

As of October 2025

Built in 2021 with over $30K in upgrades. Features include main floor primary suite with ceramic tile bath & freestanding soaking tub, 8'-10' poured basement walls, bath prep & generator transfer switch, 3-car garage with upgraded 16' x 7' & 8'x7' insulated door, Pella windows & 3'' Millican Newtown Plank flooring. Kitchen includes granite countertops & soft-close cabinets. The Greatroom features a high ceiling, fireplace with upgraded Embradora Dark surround, interior TV plug, & dual-story windows with motorized blinds. Elegant stained stair railing, recessed lights, ceiling fans, French doors at study, laundry room cabinets, upgraded carpet padding, and more. Home also has in ground sprinkler system. Full list of upgrades in attachments or available upon request. Data & measurements approx. & not guaranteed. BUYER/BATVI.

Last Agent to Sell the Property

Katja Classic

RE/MAX Classic License #6501393978 Listed on: 08/23/2025

RE/MAX Classic

Co-Listed By

Theresa Shrader

RE/MAX Classic License #6501220510

Last Buyer's Agent

Shane Atkinson

@properties Christie's Int'l R.E. Royal Oak License #6501422115

@properties Christie's Int'l R.E. Royal Oak

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $11,919

Year Built

  • Built in 2021

Lot Details

  • 0.42 Acre Lot
  • Lot Dimensions are 101 x 156 x 157 x 120

Parking

  • 3 Car Attached Garage
  • Front Facing Garage

Home Design

  • Cape Cod Architecture
  • Brick Exterior Construction
  • Asphalt Roof
  • Aluminum Siding
  • Vinyl Siding

Interior Spaces

  • 2,575 Sq Ft Home
  • 2-Story Property
  • Ceiling Fan
  • Recessed Lighting
  • Great Room
  • Living Room with Fireplace
  • Dining Area
  • Home Office

Kitchen

  • Range
  • Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms | 1 Main Level Bedroom
  • Freestanding Bathtub
  • Soaking Tub

Laundry

  • Laundry Room
  • Laundry on main level
  • Dryer
  • Washer

Basement

  • Basement Fills Entire Space Under The House
  • Stubbed For A Bathroom

Utilities

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

Community Details

  • No Home Owners Association

Home Details

Home Type

Single Family

Est. Annual Taxes

$11,919

Year Built

Built in 2021

Lot Details

0

Parking

3

Listing Details

  • Property Sub-Type: Single Family Residence
  • Property Type: Residential
  • New Construction: No
  • ArchitecturalStyle: Cape Cod
  • Stories: 2
  • Year Built: 2021
  • Location Property Info:Property Sub-Type: Single Family Residence
  • OfficeContract Info:List PriceSqFt2: 198.02
  • General Property Info:New Construction2: No
  • General Property Info:Lot Dimensions: 101 x 156 x 157 x 120
  • General Property Info:Waterfront3: No
  • General Property Info:Basement: Yes
  • General Property Info:Total Fin SqFt All Levels: 2575.0
  • General Property Info:Main Level Primary: Yes
  • Tax Info:Annual Property Tax: 11919.0
  • Heat Type:Forced Air: Yes
  • Air Conditioning:Central Air: Yes
  • Substructure:Full: Yes
  • Appliances Dryer: Yes
  • Appliances Refrigerators: Yes
  • Washers: Yes
  • Heat Source:Natural Gas3: Yes
  • General Property Info:Total Fireplaces: 1.0
  • Sewer:Public: Yes
  • Water:Public2: Yes
  • General Property Info:Fireplace: Yes
  • Additional Items:Ceiling Fans: Yes
  • Appliances Microwave: Yes
  • Water Heater:Natural Gas4: Yes
  • Roofing:Asphalt2: Yes
  • Additional Items:Generator Hook-up: Yes
  • General Property Info:SqFt Above Grade: 2575.0
  • Laundry Features Laundry Room: Yes
  • Laundry Features Main Level: Yes
  • General Property Info Garage YN: Yes
  • Architectural Style Cape Cod: Yes
  • Remarks Misc: Public Remarks: Built in 2021 with over $30K in upgrades. Features include main floor primary suite with ceramic tile bath & freestanding soaking tub, 8'-10' poured basement walls, bath prep & generator transfer switch, 3-car garage with upgraded 16' x 7' & 8'x7' insulated door, Pella windows & 3'' Millican Newtown Plank flooring. Kitchen includes granite countertops & soft-close cabinets. The Greatroom features a high ceiling, fireplace with upgraded Embradora Dark surround, interior TV plug, & dual-story windows with motorized blinds. Elegant stained stair railing, recessed lights, ceiling fans, French doors at study, laundry room cabinets, upgraded carpet padding, and more. Home also has in ground sprinkler system. Full list of upgrades in attachments or available upon request. Data & measurements approx. & not guaranteed. BUYER/BATVI.
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Appliances: Dishwasher, Disposal, Dryer, Microwave, Range, Refrigerator, Washer
  • Interior Amenities: Ceiling Fan(s)
  • Fireplace Features: Living Room
  • Fireplace: Yes
  • Fireplaces: 1
  • Total Bedrooms: 4
  • Main Level Bedrooms: 1
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bathrooms: 3
  • Basement: Full
  • LivingArea: 2575.0
  • General Property Info:Stories2: 2.0
  • Basement Rooms:Total Basement SQFT: 1558.0
  • Appliances Range: Yes
  • Fireplace:Living: Yes
  • Appliances Dishwasher: Yes
  • Additional Items:Basement Plumbed for Bath: Yes

Exterior Features

  • Construction Materials: Aluminum Siding, Brick, Vinyl Siding
  • Exclusions: 3 TV mounts
  • List Price: 509900.0
  • Road Surface Type: Paved
  • Roof: Asphalt
  • Waterfront: No
  • Exterior Material:Vinyl Siding: Yes
  • Access Feat:Accessibility Features2: No
  • Driveway Paved: Yes
  • Exterior Material:Aluminum Siding: Yes
  • Exterior Material:Brick: Yes

Garage/Parking

  • Attached Garage: Yes
  • Garage Spaces: 3.0
  • Garage: Yes
  • Parking Features: Garage Faces Front, Attached
  • Parking Features Attached2: Yes
  • Parking Features:Garage Faces Front: Yes
  • General Property Info:Garage Spaces: 3.0

Utilities

  • Cooling: Central Air
  • Cooling: Yes
  • Heating: Forced Air
  • Heating: Yes
  • Laundry Features: Laundry Room, Main Level
  • Sewer: Public
  • Water Source: Public

Lot Info

  • Lot Size Acres: 0.42
  • Lot Size Area: 0.42
  • Lot Dimensions: 101 x 156 x 157 x 120
  • Lot Size Sq Ft: 18295.0

Tax Info

  • Tax Annual Amount: 11919.0
  • Tax Year: 2024

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 1, 2021
Closed on
Sep 3, 2021
Sold by
Trowbridge Homes Of Cobblestone Llc
Bought by
Smith Tameka and Haynes Reginald
Seller's Agent
Theresa Shrader
RE/MAX Classic
Buyer's Agent
John Marker
National Realty Centers, Inc
Sold Price
$400,220

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.44%
Original Mortgage
$1,500,000
Outstanding Balance
$1,364,888
Interest Rate
2.8%
Mortgage Type
Construction
Estimated Equity
-$859,693

Purchase Details

Listed on
May 1, 2021
Closed on
Sep 2, 2021
Sold by
Celtic Farms Development Llc
Bought by
Trowbridge Homes Of Cobblestone Llc
Seller's Agent
Theresa Shrader
RE/MAX Classic
Buyer's Agent
John Marker
National Realty Centers, Inc
Sold Price
$400,220

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,500,000
Outstanding Balance
$1,364,888
Interest Rate
2.8%
Mortgage Type
Construction
Estimated Equity
-$859,693
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 Type Sale Price Title Company
Warranty Deed $400,220 None Available
Quit Claim Deed -- None Available
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $1,500,000 Construction
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
10/30/2025 10/30/25 Sold $505,000 -1.0% $196 / Sq Ft
10/13/2025 10/13/25 Pending -- -- --
09/25/2025 09/25/25 Price Changed $509,900 -1.9% $198 / Sq Ft
08/23/2025 08/23/25 For Sale $519,900 +29.9% $202 / Sq Ft
09/03/2021 09/03/21 Sold $400,220 -- $158 / Sq Ft View Prior Sale
05/01/2021 05/01/21 Pending -- -- --
Source: MichRIC

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,648 $249,300 $0 $0
2024 $9,368 $256,500 $0 $0
2023 $8,933 $224,900 $0 $0
2022 $10,821 $198,500 $0 $0
2021 $655 $34,800 $0 $0
2020 $739 $34,800 $0 $0
2019 $717 $31,500 $0 $0
2018 $501 $23,400 $0 $0
2017 $444 $18,000 $0 $0
2016 $685 $17,000 $0 $0
2015 $923 $16,400 $0 $0
2013 $894 $13,300 $0 $0
2012 $804 $11,800 $11,800 $0
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: MichRIC

MLS Number: 25043035

MichRIC

APN: 58-089-02-0023-000