$505,000

27070 Celtic Dr Flat Rock, MI 48134

Estimated payment $3,700/month

Total Views 579
4 Beds
2.5 Baths
2,548 Sq Ft
$198 Price per Sq Ft

Highlights

  • Very Popular Property
  • Garage
  • Fenced

About This Home

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 remote-controlled blinds, bringing in incredible natural light and leading to a gorgeous concrete patio with extensive landscaping. This home truly has no projects waiting for you. The yard is fully enclosed with a wrought iron fence and sits on a generous 0.33-acre lot. Upstairs includes three additional bedrooms plus a loft area currently used as a game room. The full basement includes an egress window, is plumbed for a third bathroom, and has a large open footprint ready for finishing.
Located in a newer community of just ~65 homes with a park in the center of the community, and no HOA, which is rare for newer construction.
Don't miss your chance to tour this move-in ready home with a clean, modern aesthetic and many upgrades throughout.

Listing Agent

Jasmine Sheffield

Century 21 Curran & Oberski License #6501406773 Listed on: 04/27/2026

Century 21 Curran & Oberski

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 2023

Lot Details

  • 14,375 Sq Ft Lot
  • Lot Dimensions are 98.08x146.22
  • Fenced

Parking

  • Garage

Home Design

  • 2,548 Sq Ft Home
  • Brick Exterior Construction
  • Poured Concrete

Bedrooms and Bathrooms

  • 4 Bedrooms

Location

  • Ground Level

Additional Features

  • Basement

Community Details

  • Celtic Farms Sub Subdivision

Listing and Financial Details

  • Assessor Parcel Number 58089020052000

Home Details

Home Type

Single Family

Est. Annual Taxes

$12,495

Year Built

Built in 2023

Lot Details

0.33 Acres

Parking

2

Listing Details

  • Property Type: Residential
  • Year Built: 2023
  • State Equalized Value: 229900.00
  • Entry Location: Ground Level w/Steps
  • Pets Allowed: Yes
  • Property Sub Type: SingleFamilyResidence
  • Co List Office Mls Id: 05467102
  • Above Grade Finished Sq Ft: 2548.00
  • Special Features: None

Interior Features

  • Interior Amenities: EntranceFoyer
  • Fireplace: No
  • Basement: Yes
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bedrooms: 4
  • Window Features: EgressWindows

Exterior Features

  • Waterfront: No
  • Foundation Details: Basement, Poured, SumpPump
  • Construction Materials: Brick, VinylSiding
  • Road Frontage Type: Paved
  • Fencing: Fenced, FencingAllowed
  • Disclosures: ExclusionsDoNotExist, NoRestrictions, TaxesHomesteadExempt
  • Home Warranty: No
  • Other Structures: Sheds, ShedsAllowed
  • Roof: Asphalt

Garage/Parking

  • Garage: Yes

Utilities

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

Schools

  • Junior High Dist: FlatRock

Lot Info

  • Lot Dimensions: 98.08X146.22
  • Parcel Number: 58089020052000

Tax Info

  • Tax Amount Summer: 9830.00
  • Tax Amount Winter: 2665.26
  • Tax Annual Amount: 12495.26

3D Interior and Exterior Tours

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

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,830 $229,900 $0 $0
2024 $9,777 $228,400 $0 $0
2023 $568 $36,800 $0 $0
2022 $764 $28,000 $0 $0
2021 $746 $25,500 $0 $0
2020 $737 $25,500 $0 $0
2019 $716 $23,000 $0 $0
2018 $501 $17,200 $0 $0
2017 $440 $18,000 $0 $0
2016 $684 $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

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
04/28/2026 04/28/26 For Sale $505,000 +13.3% $198 / Sq Ft
09/22/2023 09/22/23 Sold $445,683 0.0% $175 / Sq Ft View Prior Sale
07/25/2023 07/25/23 Pending -- -- --
07/20/2023 07/20/23 For Sale $445,683 -- $175 / Sq Ft
Source: Realcomp

Purchase History

Date Type Sale Price Title Company
Quit Claim Deed -- None Listed On Document
Warranty Deed $445,683 Vanguard Title
Warranty Deed $445,683 Vanguard Title
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $351,600 New Conventional
Closed $351,600 New Conventional
Source: Public Records

About the Listing Agent

Jasmine Sheffield

Century 21 Curran & Oberski

(734) 999-3063

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

  • 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

  • 21150 Bryce Ct, Brownstown Township, MI 48174

    $475,000 Sold Aug 29, 2025

    • 4 Beds
    • 2.5 Baths
    • 2,093 Sq Ft
    • 21150 Bryce Ct
    • Brownstown Township, MI

    Welcome to 21150 Bryce Court in Brownstown Township, a stunning 2022-built brick ranch in the Bryce Commons Subdivision at Inkster and King Rd. This impeccably maintained home features three spacious bedrooms and two and a half bathrooms, with a versatile loft above the garage, offering the potential for a fourth bedroom or additional living space. The loft comes complete with its own mini-split

    Jasmine Sheffield Century 21 Curran & Oberski

  • 25048 Filmore St, Taylor, MI 48180

    $175,000 Sold Dec 08, 2025

    • 3 Beds
    • 1.5 Baths
    • 1,026 Sq Ft
    • 25048 Filmore St
    • Taylor, MI

    This solid brick ranch offers great potential with a layout that includes three bedrooms, a full basement, and a two-car garage. Inside, you’ll find newer windows, updated bathroom, and newer furnace and water heater, offering peace of mind on big-ticket items. The roof on both the house and garage has also been replaced in recent years. While the home could use some cosmetic updates, the bones

    Jasmine Sheffield Century 21 Curran & Oberski

  • 19124 Harman St, Melvindale, MI 48122

    $162,000 Sold Jul 16, 2025

    • 3 Beds
    • 1 Bath
    • 877 Sq Ft
    • 19124 Harman St
    • Melvindale, MI

    Fully remodeled + move-in ready in Melvindale for just $165K?! This 3-bed, 1-bath bungalow has the upgrades you actually care about—like a brand new kitchen with stainless steel appliances (yes, even a dishwasher), fresh carpet and paint, and a tiled bathroom that looks sharp. New ceiling fans and light fixtures? Yep. Central air? Yep. Plus, there’s a basement and a garage. The roof is newer, and

    Jasmine Sheffield Century 21 Curran & Oberski

  • 63 Kessler St, Monroe, MI 48162

    $69,500 Sold Apr 10, 2026

    • 3 Beds
    • 1 Bath
    • 820 Sq Ft
    • 63 Kessler St
    • Monroe, MI

    **MULTIPLE OFFERS RECEIVED: OFFER DEADLINE SATURDAY 3/28 AT 8PM. Three-bedroom, one-bath home in a great area of Monroe with strong potential for an investment property or renovation project. Features include good-sized bedrooms, a large door wall in the third bedroom leading directly to a covered back deck, and a front porch deck. The backyard is fully fenced (in need of repair) and includes

    Jasmine Sheffield Century 21 Curran & Oberski

  • 661 Lavender St, Monroe, MI 48162

    $232,500 Sold Sep 15, 2025

    • 3 Beds
    • 1.5 Baths
    • 1,209 Sq Ft
    • 661 Lavender St
    • Monroe, MI

    Welcome to this well-loved 3-bedroom, 1.5-bath brick ranch in Monroe’s desirable St. Mary’s Gardens subdivision. Built in 1965 by its original owners, this home has been cared for with pride and attention to detail ever since. Inside, you’ll find hardwood floors in two bedrooms, a one-of-a-kind tiled hallway and bath, and parquet flooring in the formal dining room. The kitchen and separate eat-in

    Jasmine Sheffield Century 21 Curran & Oberski

  • 59 E Pleasant St, River Rouge, MI 48218

    $85,000 Sold Jul 15, 2025

    • 3 Beds
    • 1 Bath
    • 1,128 Sq Ft
    • 59 E Pleasant St
    • River Rouge, MI

    Super clean 3-bedroom bungalow in the heart of River Rouge featuring a huge tiled dining room, spacious kitchen, and brand-new carpet throughout the bedrooms and living room. Enjoy a fully fenced backyard with a beautifully manicured yard and a covered front porch for relaxing. Convenient layout with a full bath, bright interior, and lots of charm throughout. River Rouge is a city on the rise

    Jasmine Sheffield Century 21 Curran & Oberski

Source: Realcomp

MLS Number: 20261028730

Realcomp

APN: 58-089-02-0052-000

Your Personal Tour Guide

Ask me questions while you tour the home.