Skip main navigation
Sold for $486,000
  • $486,000

    26547 Celtic Dr, Flat Rock, MI 48134

    4beds
    2,487sqft
    Single Family Residence
    Built in 2023
    0.36 Acres Lot
    $516,600 Zestimate®
    $195/sqft
    $3,812 Estimated rent

    Home value

    $516,600

    $486,000 - $548,000

    $3,812/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $3,812/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $3,812/mo

    Rent Zestimate®

    Refinance and save

    $3,412/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $3,412/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    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!

    Zillow last checked:

    Listing updated:

    Listed by:

    Dione Oerther 734-735-6224,

    Berkshire Hathaway Home Service Kee Realty

    Bought with:

    Katherine Guilbault, 6501436624

    Real Estate One-Plymouth

    Source: MiRealSource,MLS#: 50155389MLS LogoOriginating MLS: Southeastern Border Association of REALTORS

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Bathrooms: 3
    • Full bathrooms: 2
    • 1/2 bathrooms: 1
    Rooms
    • Room types: Entry, Laundry, Living Room, Utility/Laundry Room, Master Bedroom, Master Bathroom, Office, First Flr Lavatory
    Bedroom 1
    • Features: Carpet
    • Level: Second
    • Area: 272
    • Dimensions: 17 x 16
    Bedroom 2
    • Features: Carpet
    • Level: Second
    • Area: 176
    • Dimensions: 16 x 11
    Bedroom 3
    • Features: Carpet
    • Level: Second
    • Area: 168
    • Dimensions: 14 x 12
    Bedroom 4
    • Features: Carpet
    • Level: Second
    • Area: 143
    • Dimensions: 13 x 11
    Bathroom 1
    • Features: Ceramic
    • Level: Second
    • Area: 110
    • Dimensions: 11 x 10
    Bathroom 2
    • Features: Ceramic
    • Level: Second
    • Area: 50
    • Dimensions: 10 x 5
    Dining room
    • Features: Wood
    • Level: Main
    • Area: 220
    • Dimensions: 20 x 11
    Kitchen
    • Features: Wood
    • Level: Main
    • Area: 165
    • Dimensions: 15 x 11
    Living room
    • Features: Wood
    • Level: Main
    • Area: 272
    • Dimensions: 17 x 16
    Office
    • Level: Main
    • Area: 154
    • Dimensions: 14 x 11
    Heating
    • Forced Air, Natural Gas
    Cooling
    • Ceiling Fan(s), Central Air
    Appliances
    • Included: Dishwasher, Disposal, Dryer, Microwave, Range/Oven, Refrigerator, Washer, Gas Water Heater
    • Laundry: First Floor Laundry, Laundry Room, Main Level
    Features
    • High Ceilings, Cathedral/Vaulted Ceiling, Sump Pump, Walk-In Closet(s)
    • Flooring: Ceramic Tile, Hardwood, Wood, Carpet
    • Windows: Storms/Screens
    • Basement: Daylight,Concrete,Sump Pump
    • Number of fireplaces: 1
    • Fireplace features: Gas, Living Room
    Interior area
    • Total structure area: 3,736
    • Total interior livable area: 2,487 sqft
    • Finished area above ground: 2,487
    • Finished area below ground: 0

    Property

    Parking
    • Total spaces: 3
    • Parking features: 3 or More Spaces, Garage, Driveway, Attached, Electric in Garage, Garage Door Opener
    • Attached garage spaces: 3
    Features
    • Levels: Two
    • Stories: 2
    • Patio & porch: Patio, Porch
    • Fencing: Fenced,Fence Owned
    • Frontage type: Road
    • Frontage length: 89
    Lot
    • Size: 0.36 Acres
    • Dimensions: 89.43 x 174.38
    • Features: Deep Lot - 150+ Ft., Large Lot - 65+ Ft., Subdivision
    Details
    • Parcel number: 58089020005000
    • Zoning description: Residential
    • Special conditions: Private

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Conventional Frame
    • Property subtype: Single Family Residence
    Materials
    • Brick, Vinyl Siding
    • Foundation: Basement, Concrete Perimeter
    Condition
    • Year built: 2023

    Utilities & green energy

    • Electric: 220 Volts in Garage
    • Sewer: Public Sanitary
    • Water: Public
    • Utilities for property: Cable/Internet Avail.

    Community & HOA

    Community
    • Security: Security System
    • Subdivision: Celtic Farms Sub
    HOA
    • Has HOA: No
    Location
    • Region: Flat Rock

    Financial & listing details

    • Price per square foot: $195/sqft
    • Tax assessed value: $173,900
    • Annual tax amount: $7,823
    • Date on market: 9/15/2024
    • Cumulative days on market: 24 days
    • Listing agreement: Exclusive Right To Sell
    • Listing terms: Cash,Conventional,FHA,VA Loan
    • Road surface type: Paved

    Price history

    DateEventPrice
    11/19/2024Sold$486,000-0.8%$195/sqft
    Source: MiRealSource #50155389 Report a problem
    10/8/2024Pending sale$489,900$197/sqft
    Source: MiRealSource #50155389 Report a problem
    9/15/2024Listed for sale$489,900+9.9%$197/sqft
    Source: MiRealSource #50155389 Report a problem
    3/4/2024Sold$445,885+0.2%$179/sqft
    Source: Realcomp II #20230100248 Report a problem
    1/10/2024Pending sale$445,000$179/sqft
    Source: Realcomp II #20230100248 Report a problem
    1/3/2024Listing removed--
    Source: Realcomp II #20230100248 Report a problem
    12/5/2023Pending sale$445,000$179/sqft
    Source: Realcomp II #20230100248 Report a problem
    11/28/2023Listed for sale$445,000+44804.1%$179/sqft
    Source: Realcomp II #20230100248 Report a problem
    5/18/2012Sold$991
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025-- $173,900 +419.1%
    2024-- $33,500 +31.4%
    2023-- $25,500 +9.4%
    2022-- $23,300 +0.4%
    2021-- $23,200
    2020$1,571 +49.4%$23,200 +10.5%
    2019$1,052 $21,000 +33.8%
    2018$1,052 $15,700 -12.3%
    2017-- $17,900 +5.9%
    2016$800 $16,900 +3.7%
    2015$800 -39.4%$16,300 +23.5%
    2013$1,320 +65.1%$13,200 +12.8%
    2012$800 $11,700 -6.4%
    2010-- $12,500
    Find assessor info on the county website

    Neighborhood: 48134

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • District: Flat Rock Community Schools

    Source: MiRealSource. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $516,600
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $516,600