26787 Celtic Dr, Flat Rock, MI 48134
OFF MARKET

26787 Celtic Dr
Flat Rock, MI 48134

  • 3 Beds
  • 2.5 Baths
  • 2,175 sqft (on 0.33 acres)

$489,400

Trulia Estimate
as of Aug 25, 2026
Est. Refi. Payment $3,319/mo*

$489,400

Trulia Estimate
as of Aug 25, 2026
Est. Refi. Payment $3,319/mo*
3 Beds
2.5 Baths
2,175 sqft
(on 0.33 acres)

Home Value

Trulia Estimate
$489K
Since last month
Decreased$5K (-1.1%)
Since last year
Increased$13K (+2.7%)
Since last sale
Increased$25K (+5.2%)
Learn more about this home's value by checking out its Trulia Estimate, the value of nearby homes, and how much similar homes have sold for.

Trulia Estimate

The of this home's value increased by +603% in the last 10 years
MonthEstimated value
2026
August 2026$493K
July 2026$498K
June 2026$499K
May 2026$499K
April 2026$497K
March 2026$495K
February 2026$487K
January 2026$487K
2025
2024
2019
2018
2017
2016

Comparable sales

These are recently sold homes that have a similar location or other similar features to this home, like bedrooms, bathrooms, and square footage. Get a sense of the expected prices in the area by viewing these homes.
Address
Distance
Property Type
Sold Price
Sold Date
Bed
Bath
Sqft
0.15
Single-Family Home
$482,199
10/14/25
3
2.5
2,175
0.06
Single-Family Home
$462,927
11/14/25
4
2.5
2,487
0.05
Single-Family Home
$499,000
11/25/25
4
2.5
2,580
0.09
Single-Family Home
$474,000
02/20/26
4
2.5
2,487
0.08
Single-Family Home
$474,900
02/13/26
4
2.5
2,548
0.12
Single-Family Home
$525,000
05/21/26
4
2.5
2,548
0.13
Single-Family Home
$505,000
01/05/26
4
2.5
2,575
0.16
Single-Family Home
$440,000
07/20/26
4
2.5
3,077
0.17
Single-Family Home
$525,000
08/05/26
4
2.5
2,900
0.35
Single-Family Home
$420,000
12/01/25
3
2.5
2,235

Nearby home prices

Get a sense of expected prices in the area by checking the value of nearby homes.
Address
Distance
Price
Bed
Bath
Sqft
Status
0.02
$481,300
4
2.5
2,487
Off Market
0.05
$499,000
4
2.5
2,580
Recently Sold
0.06
$462,927
4
2.5
2,487
Recently Sold
0.08
$474,900
4
2.5
2,548
Recently Sold
0.09
$474,000
4
2.5
2,487
Recently Sold
0.09
$482,100
4
2.5
2,548
Off Market
0.12
$482,400
4
2.5
2,487
Off Market
0.10
$539,400
4
2.5
3,341
Off Market
0.09
$518,600
3
2.5
2,299
Off Market
0.12
$525,000
4
2.5
2,548
Recently Sold
0.15
$481,000
3
2.5
2,175
Off Market

Local Information

  • Map ViewExplore the area around 26787 Celtic Dr.
  • Schools1 Preschool School2 Elementary Schools1 Middle School1 High School
  • Shop & Eat
-- mins to
Commute Destination

Home Highlights

Property Type
Single-Family Home
Year Built
2024
Lot Size
0.33 acres
Living Area
2,175 sqft
Price/Sqft
$225
Parking
2 Car Garage

About this House

Welcome to this stunning 3-bedroom, 2.5-bath ranch home in the desirable Celtic Farms neighborhood, under construction with estimated occupancy in October 2024. Step into a beautifully designed space featuring a modern kitchen with white cabinetry and sleek quartz countertops. The interior features beautiful hardwood flooring in the foyer, powder room, kitchen, nook, and laundry room, adding warmth and elegance to the space. The bedrooms feature Woodland-resistant carpet with plush 6 lb padding for added comfort, while the bathrooms include granite countertops and ceramic tile floors. All walls are finished with Sherwin Williams interior paint, offering a fresh and stylish look throughout the home. In the Great Room, you'll find a gas fireplace with a marble surround and mantle. The basement is prepped for a bathroom, has an egress window, and comes with a 10-year waterproof warranty, giving you peace of mind and the flexibility to expand and customize the space to suit your needs. Top-of-the-line standard features include a Bryant high-efficiency Furnace (with ECM Motor programmable thermostat), Bryant Central Air, Bryant Humidifier, and high-efficiency 50-gallon Water Heater. Enjoy Pella vinyl windows' durability and energy efficiency and IKO 30-year dimensional shingles. This home seamlessly combines modern amenities with thoughtful design. PHOTOS SHOWN ARE FROM SIMILAR HOMES AND MAY SHOW OPTIONAL OR UPGRADED FEATURES. OCCUPANCY- Est. October 2024.
26787 Celtic Dr, Flat Rock, MI 48134 is a 3 bedroom, 3 bathroom, 2,175 sqft single-family home built in 2024. It last sold for the $468,000 asking price on Nov 27, 2024. It is currently off market. The Trulia Estimate is $489,400, with a rent estimate of $3,082/month.
Last check for updates: about 10 hours ago
Listed by Stacey A Pardikes, (734) 564-5154
EXP Realty
Bought with: Susan Paolucci, (734) 787-0512, Berkshire Hathaway HomeServices Kee Realty Browns
Source: Realcomp II, MLS#20240061200

Home Details for 26787 Celtic Dr

Interior Features

Interior Details
Basement: Full,UnfinishedNumber of Rooms: 8
Beds & Baths
Number of Bedrooms: 3Number of Bathrooms: 3Number of Bathrooms (full): 2Number of Bathrooms (half): 1
Dimensions and Layout
Living Area: 2175 Square Feet
Appliances & Utilities
Appliances: DisposalDisposal
Heating & Cooling
Heating: Forced Air,Natural GasHas CoolingAir Conditioning: Central AirHas HeatingHeating Fuel: Forced Air
Fireplace & Spa
Fireplace: Gas, Great RoomHas a Fireplace
Windows, Doors, Floors & Walls
Window: Egress Windows
Levels, Entrance, & Accessibility
Stories: 1Levels: OneEntry Location: GroundLevelwSteps

Exterior Features

Exterior Home Features
Roof: AsphaltFoundation: Basement, Poured, Sump Pump
Parking & Garage
Number of Garage Spaces: 2No CarportHas a GarageHas an Attached GarageParking Spaces: 2Parking: Two Car Garage,Attached
Pool
Pool: None
Frontage
Road Frontage: PavedNot on Waterfront
Water & Sewer
Sewer: Public Sewer
Finished Area
Finished Area (above surface): 2175 Square Feet

Days on Market

Cumulative Days on Market: 78

Property Information

Year Built
Year Built: 2024
Property Type / Style
Property Type: ResidentialProperty Subtype: Single Family ResidenceArchitecture: Ranch
Building
Construction Materials: Brick, Vinyl SidingIs a New ConstructionIncludes Home Warranty
Property Information
Condition: New ConstructionParcel Number: 58089020015000

Price & Status

Price
List Price: $468,000
Status Change & Dates
Off Market Date: Thu Nov 07 2024Possession Timing: At Close

Active Status

MLS Status: Sold

Location

Direction & Address
City: Flat RockCommunity: CELTIC FARMS SUB
School Information
High School District: Flat Rock

Community

Not Senior Community

HOA

No HOA

Lot Information

Lot Area: 0.33 acres

Listing Info

Special Conditions: Short Sale No, Standard

Offer

Listing Agreement Type: Exclusive Right To SellListing Terms: Cash, Conventional, FHA, Va Loan

Miscellaneous

BasementMls Number: 20240061200Above Grade Unfinished Area: 2175Activation Date: Wed Aug 21 2024Showing Requirements: AppointmentLockBox

Price and Tax history

DateEventPrice
Nov 27, 2024
Source: Realcomp II #20240061200
Sold
$468,000
Nov 7, 2024
Source: Realcomp II #20240061200
Pending
$468,000
Nov 1, 2024
Source: Realcomp II #20240061200
PriceChange
$468,000
Price decreased by 1%
Aug 21, 2024
Source: Realcomp II #20240061200
Listed For Sale
$471,638

Market trends in Flat Rock

Last updated July 2026
Buyer'sMarketSeller'sMarket
Avg. sale price
—
Sale-to-List Price
—
Price per sq ft
—
Available listings
12
1
MoM

Around this home

What Locals Say about Flat Rock

At least 59 Trulia users voted on each feature.
  • 92 % Say yards are well-kept

  • 91 % Say car is needed

  • 86 % Say parking is easy

  • 86 % Say there are sidewalks

  • 84 % Say it's dog friendly

  • 84 % Say kids play outside

  • 82 % Say there's holiday spirit

  • 80 % Say people would walk alone at night

  • 75 % Say streets are well-lit

  • 73 % Say there's wildlife

  • 65 % Say it's quiet

  • 58 % Say neighbors are friendly

  • 55 % Say it's walkable to restaurants

  • 54 % Say they plan to stay for at least 5 years

  • 49 % Say it's walkable to grocery stores

  • 29 % Say there are community events

Sourced by Trulia users. Learn more about our methodology.
  • 8c4y5dnmqn
    "I drive and commuting by car. There’s no public transport available but there are other ways to travel!"
  • Mtbigi
    "Neighbors are great and the neighborhood is beautiful. The Huroc and the metro parks are connected by the bike trail that runs through the reared of our backyard! "
  • Trulia User
    "Flat Rock is home. My family and I feel safe. Parks, splash pad, library and the recreation center are all great places to enjoy."
  • P.season2323
    "Flat rock has decent school or so I heard. I don’t know too much about the city as much as I would like. "
  • Thomas M.
    "There are many families in our neighborhood and they all watch out for each other and their children. Very quiet neighborhood with a friendly atmosphere."
  • Amalia G.
    "My commute is only 20 minutes to work. Flat rock is great because it’s close to 75 and 275. Very convenient!"
  • Eenyar1945
    "Great place to live small town feel but close to shopping and great restaurants. Also metro parks an kayaking."
  • Esterk23
    "Quiet, lovely, and great place to raise kids. Police are friendly and very responsive. Summer festival every year is a must visit."
  • Jme7502
    "old small town, lots of history.great middle class neighborhood with all ages of people. School of choice available."
  • Buyboxgurus
    "they would love the friendliness, peace and quiet the neighborhood brings. It is the perfect neighborhood with Huroc Park."
  • Joel G.
    "you can walk to what you need. everything is contained in this small town. sidewalks aren't the best or anundant."
  • Pattersonlawn
    "really friendly, good neighbors, nice houses. a close knit community. I love all my neighbors. great place to live I would recommend for sure to live here. close to parks and recreation "
  • Nikita R.
    "It's safe and affordable. It's kid friendly and welcoming. I like how quiet the neighborhood is. There is little to no crime."
  • Jgrabarkie
    "Mostly good hard working people. But the ones that don’t keep their properties up are never cited by the city so that’s enough to make one, like me, wish to move. "

LGBTQ Local Legal Protections

IDX provided courtesy of Realcomp II Ltd. via Zillow, Inc and MLS Copyright 2026 Realcomp II Ltd. Shareholders IDX information is provided exclusively for consumers' personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified. Any use of search facilities of data on the site, other than by a consumer looking to purchase real estate, is prohibited. The data relating to real estate properties on this website was last updated as recently as 2026-08-24 09:11:51 PDT Listing Information presented by local MLS brokerage: Zillow, Inc., REALTOR®- Lauren Buttazzoni - (313) 479-2702

Frequently asked questions about 26787 Celtic Dr

  • What is 26787 Celtic Dr estimated to be worth?
    Trulia's estimated value for 26787 Celtic Dr in Flat Rock, MI is $489,400.
  • What is the price history for 26787 Celtic Dr?
    26787 Celtic Dr in Flat Rock, MI last sold for $468,000 in November 2024.
  • Is Flat Rock a buyer's or seller's market?
    Flat Rock is currently a balanced market, based on recent for-sale activity.
  • What do residents say about Flat Rock?
    Residents describe Flat Rock, MI as well-kept, easy to park in, and pedestrian-friendly. See recently sold homes in Flat Rock, MI.
  • Does 26787 Celtic Dr have air conditioning?
    Yes, 26787 Celtic Dr in Flat Rock, MI has air conditioning.
  • How big is the lot at 26787 Celtic Dr?
    The lot at 26787 Celtic Dr in Flat Rock, MI is about 0.33 acres (14,375 sq ft).

Explore by feature - Air Conditioning

Off Market Homes Near 26787 Celtic Dr

Skip to last item
Skip to first item

Homes for sale near 26787 Celtic Dr

Skip to last item
Skip to first item
Skip to last item
  • Results are loading
Skip to first item