$420,000
PENDING

27099 Celtic Dr Flat Rock, MI 48134

Estimated payment $3,018/month

Total Views 8,176
4 Beds
2.5 Baths
3,077 Sq Ft
$136 Price per Sq Ft

Highlights

  • Vaulted Ceiling
  • Forced Air Heating and Cooling System
  • Garage
  • Entrance Foyer
  • Ceiling Fan
  • Power Generator

About This Home

MULTIPLE OFFERS RECEIVED: All offers due Monday 6/29/26 @ 5PM
Welcome home to this spacious 4-bedroom ranch offering nearly 2,000 square feet of living space and an incredible backyard oasis. Vaulted ceilings and two doorwalls fill the home with natural light while creating a seamless connection to the outdoor living spaces. The kitchen features granite countertops, stainless steel appliances, an island with additional storage, and an abundance of cabinets. Other features include first-floor laundry, an owned water softener system, whole-house generator, and extra-deep garage. The finished basement expands your living space with a fourth bedroom complete with an egress window and is already plumbed for an additional bathroom. Outside, enjoy your own private oasis with a saltwater inground pool surrounded by a large concrete patio. The wooded backdrop and neighboring retention pond provide added privacy, leaving you with only one direct neighbor. Located in a quiet neighborhood of fewer than 70 homes, this property offers a peaceful setting while still being close to everyday conveniences. This is the perfect combination of ranch-style living, functional space, and outdoor enjoyment, all in a desirable, low-traffic community.

Listing Agent

Jasmine Sheffield

Century 21 Curran & Oberski License #6501406773 Listed on: 06/24/2026

Century 21 Curran & Oberski

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 2009

Lot Details

  • 14,375 Sq Ft Lot
  • Lot Dimensions are 75.86x192.05
  • Fenced

Parking

  • Garage

Home Design

  • Brick Exterior Construction
  • Poured Concrete

Interior Spaces

  • Vaulted Ceiling
  • Ceiling Fan
  • Gas Fireplace
  • Entrance Foyer
  • Living Room with Fireplace
  • Basement

Bedrooms and Bathrooms

  • 4 Bedrooms

Utilities

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

Community Details

  • Celtic Farms Sub Subdivision

Listing and Financial Details

  • Assessor Parcel Number 58089020024000

Home Details

Home Type

Single Family

Est. Annual Taxes

$9,473

Year Built

Built in 2009

Lot Details

0.33 Acres

Parking

2

Listing Details

  • Property Type: Residential
  • Year Built: 2009
  • State Equalized Value: 190600.00
  • Entry Location: GroundLevelwSteps
  • Property Sub Type: SingleFamilyResidence
  • LotSizeAcres: 0.33
  • Co List Office Mls Id: 05467102
  • Above Grade Finished Sq Ft: 1948.00
  • Living Area: 3077.00
  • ClassName: Residential
  • Special Features: None

Interior Features

  • Interior Amenities: EntranceFoyer
  • Fireplace: Yes
  • Basement: Yes
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bedrooms: 4
  • Below Grade Sq Ft: 1129.00
  • Fireplace Features: Gas, LivingRoom

Exterior Features

  • Waterfront: No
  • Foundation Details: Basement, Poured
  • Construction Materials: Brick
  • Road Frontage Type: Paved
  • Fencing: Fenced
  • Disclosures: ExclusionsDoNotExist, TaxesHomesteadExempt
  • Exclusions: Exclusion(s) Do Not Exist
  • Home Warranty: No

Garage/Parking

  • Garage: Yes

Utilities

  • Cooling: CeilingFans, CentralAir
  • Heating: ForcedAir, NaturalGas
  • Sewer: PublicSewer
  • Water Heater Fuel: NaturalGas
  • Water Source: Public
  • Electric: Generator

Schools

  • Junior High Dist: FlatRock

Lot Info

  • Lot Dimensions: 75.86X192.05
  • Parcel Number: 58089020024000
  • Land Lease Expiration Date: 2026-09-15

Tax Info

  • Tax Amount Summer: 7451.00
  • Tax Amount Winter: 2022.00
  • Tax Annual Amount: 9473.00

Multi Family

  • Above Grade Finished Area Units: SquareFeet

Matterport 3D Tour

Floorplans

Map

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

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 $7,451 $190,600 $0 $0
2024 $7,235 $196,700 $0 $0
2023 $6,899 $171,700 $0 $0
2022 $8,753 $153,300 $0 $0
2021 $5,837 $149,500 $0 $0
2020 $5,948 $144,100 $0 $0
2019 $5,648 $138,200 $0 $0
2018 $4,385 $129,200 $0 $0
2017 $2,356 $141,200 $0 $0
2016 $5,315 $133,200 $0 $0
2015 $9,767 $128,200 $0 $0
2013 $9,462 $104,000 $0 $0
2012 $3,367 $92,400 $12,400 $80,000
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
06/30/2026 06/30/26 Pending -- -- --
06/26/2026 06/26/26 For Sale $420,000 +10.7% $136 / Sq Ft
09/28/2021 09/28/21 Sold $379,500 0.0% $195 / Sq Ft View Prior Sale
09/14/2021 09/14/21 Pending -- -- --
08/28/2021 08/28/21 Price Changed $379,500 -2.4% $195 / Sq Ft
08/24/2021 08/24/21 Price Changed $389,000 -2.5% $200 / Sq Ft
08/22/2021 08/22/21 Price Changed $399,000 -5.0% $205 / Sq Ft
08/13/2021 08/13/21 For Sale $419,900 -- $216 / Sq Ft
Source: Realcomp

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 Type Sale Price Title Company
Warranty Deed $379,500 First American Title Ins Co
Warranty Deed -- Multiple
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 Loan Amount Loan Type
Closed $360,525 New Conventional
Closed $143,050 New Conventional
Closed $139,000 New Conventional
Source: Public Records

About the Listing Agent

Jasmine Sheffield

Century 21 Curran & Oberski

(734) 294-6627

Section Image

I’m a top-producing Realtor® with CENTURY 21 Curran & Oberski and proud co-leader of the Select Team, serving buyers, sellers, and investors across Greater Metro Detroit. With a background in marketing and education, I approach real estate with equal parts strategy and heart—pairing data-driven expertise with the kind of creative problem-solving that turns challenges into closings and home shopping FUN!

Before real estate, I spent years as a Marketing Director and an elementary school

Jasmine's Other Listings

  • 1620 Tony Ct, Monroe, MI 48162

    $244,900 Pending

    • 2 Beds
    • 2 Baths
    • 1,450 Sq Ft
    • 1620 Tony Ct
    • Monroe, MI

    Rare opportunity in highly sought-after Rose Park Estates! Tucked away on a quiet one-way cul-de-sac with fewer than 20 homes, this small, private community is one of Monroe's hidden gems and condos here don't last long. This move-in ready 2-bedroom, 2-bath condo offers a spacious and functional layout with first-floor laundry, a 2-car attached garage, and a full basement with an additional

    Jasmine Sheffield Century 21 Curran & Oberski

    Section Image
  • 517 John Anderson Ct Unit 71, Monroe, MI 48162

    $55,000 $5K PRICE DROP

    • 1 Bed
    • 1 Bath
    • 641 Sq Ft
    • 517 John Anderson Ct
    • Unit 71
    • Monroe, MI

    Why rent when you can own? This super clean 1-bedroom condo in a centrally located Monroe community offers immediate occupancy and low-maintenance living at an affordable price point! Featuring brand new vinyl plank flooring throughout, fresh paint, and a bright, move-in ready interior, this condo is perfect for a first-time buyer, downsizer, or investor. Low HOA dues of only $250/month make

    Jasmine Sheffield Century 21 Curran & Oberski

    Section Image
  • 6300 Minock St, Detroit, MI 48228

    $60,000 Pending

    • 3 Beds
    • 1 Bath
    • 972 Sq Ft
    • 6300 Minock St
    • Detroit, MI

    Attention investors! This tenant-occupied Warrendale property offers immediate rental income with a long-term tenant of nearly 10 years already in place. The home is Section 8 certified, making it a great addition to your investment portfolio. Major updates have already been completed, including a house roof (2018), brand-new garage roof, updated electrical panel, and a hot water heater that's

    Jasmine Sheffield Century 21 Curran & Oberski

    Section Image
  • 20123 Lauder St, Detroit, MI 48235

    $185,000 Pending

    • 3 Beds
    • 1.5 Baths
    • 2,280 Sq Ft
    • 20123 Lauder St
    • Detroit, MI

    **MULTIPLE OFFERS RECEIVED: HIGHEST AND BEST DUE MONDAY 6/15 at 5PM. Some homes just have a feeling, and this is one of them. Built in 1952, this home is full of character, from the beautiful hardwood floors to the spacious living areas and formal dining room that simply aren't common in newer homes. One of the home's most unique features is the incredible office (or bedroom) with custom built-in

    Jasmine Sheffield Century 21 Curran & Oberski

    Section Image
  • 4630 Commerce Woods Dr, Commerce Township, MI 48382

    $460,000 Pending

    • 4 Beds
    • 2.5 Baths
    • 2,706 Sq Ft
    • 4630 Commerce Woods Dr
    • Commerce Township, MI

    Welcome to 4630 Commerce Woods, a beautifully maintained 4-bedroom, 2.5-bath home offering nearly 2,000 square feet of comfortable living space in one of Commerce Township’s most desirable locations. From the moment you step inside, you’ll appreciate the pride of ownership and attention to detail throughout. Located just minutes from lakes, parks, walking trails, and outdoor recreation, you’ll

    Jasmine Sheffield Century 21 Curran & Oberski

    Section Image
  • 27070 Celtic Dr, Flat Rock, MI 48134

    $525,000 Sold May 21, 2026

    • 4 Beds
    • 2.5 Baths
    • 2,548 Sq Ft
    • 27070 Celtic Dr
    • Flat Rock, MI

    OPEN HOUSE IS CANCELED TODAY, 5/01/2026. Built in 2023, this Harper model in Celtic Farms offers a modern open floor plan layout with over 2,500 sq ft, 4 bedrooms, and 2.5 baths. The main level features hardwood flooring throughout, a first-floor primary suite, first-floor laundry, and a dedicated office space.The kitchen and living area open to a wall of windows with a doorwall featuring

    Jasmine Sheffield Century 21 Curran & Oberski

  • 23264 Oakleigh Ave, Woodhaven, MI 48183

    $370,000 Sold Feb 19, 2026

    • 4 Beds
    • 4.5 Baths
    • 2,059 Sq Ft
    • 23264 Oakleigh Ave
    • Woodhaven, MI

    Welcome to this solid two-story colonial in Woodhaven, offering just over 2,000 square feet, four bedrooms, and four full baths plus a half bath! Fresh paint throughout the first floor and gorgeous laminate wood flooring give the home an updated, move-in ready feel. The layout is perfect and functional, you can see the dining room and family room from your large kitchen, first-floor laundry for

    Jasmine Sheffield Century 21 Curran & Oberski

  • 0 Gildersleeve St Unit 20261000486, Charter Township of Berlin, MI 48179

    $46,500 Sold Apr 10, 2026

    • Land
    • 0.60 Acre Lot
    • 0 Gildersleeve St
    • Unit 20261000486
    • Charter Township of Berlin, MI

    0.60 Acres – Two-Parcel Residential Lot in South RockwoodRare opportunity to build in a well-established residential neighborhood just off S Huron River Drive in the Village of South Rockwood. This listing includes two adjacent parcels (4804010710 & 4804010720) totaling 0.60 acres. The seller is only offering both parcels together and will not split.Enjoy the lower Monroe County taxes

    Jasmine Sheffield Century 21 Curran & Oberski

  • 23505 Baker St, Taylor, MI 48180

    $58,500 Sold Aug 06, 2025

    • 2 Beds
    • 1.5 Baths
    • 744 Sq Ft
    • 23505 Baker St
    • Taylor, MI

    This sweet little brick townhouse co-op in Taylor is the perfect mix of cozy and low-maintenance! With two roomy bedrooms, a bath and a half (with an updated tub!), and even a basement. You’ll love having your own fenced-in yard—ideal for pets, plants, or just a little peace and quiet. The best part? The $605/month HOA covers just about everything: gas, water, taxes, insurance, lawn care, snow

    Jasmine Sheffield Century 21 Curran & Oberski

Source: Realcomp

MLS Number: 20261046974

Realcomp

APN: 58-089-02-0024-000

Your Personal Tour Guide

Ask me questions while you tour the home.