NOT LISTED FOR SALE

Estimated Value: $502,740

4 Beds
2.5 Baths
2,580 Sq Ft
$195/Sq Ft Est. Value

Sale Details

Date Sold: November 25, 2025

Last sale price $499,000 $193 Per Sq Ft

Est. 1% increase in value since last sale

Current estimated payment $2,820 / mo

41 Days on Market

Highlights

  • Cathedral Ceiling
  • Forced Air Heating and Cooling System
  • Gas Fireplace
  • Laundry Room
  • Garage

About This Home

As of November 2025

Now available in the sought-after Celtic Farms community in Flat Rock – stunning 4-bedroom, 2.5-bath new construction home with anticipated occupancy November/December 2025! Step inside to a bright, open floor plan featuring 9’ first-floor ceilings and beautiful hardwood floors. The spacious kitchen boasts 42” upper cabinets, quartz countertops, a generous appliance allowance, and hardwood flooring throughout the kitchen and dining nook. The sunroom with a cathedral ceiling opens to the great room, creating the perfect space for entertaining and everyday living. The first floor also includes a private study with French doors and a stylish powder room with hardwood flooring and quartz countertops. Upstairs, you'll find two secondary bedrooms with ample closet space, a versatile loft area, and a full main bath featuring ceramic tile flooring, a tub/shower combo, and dual-sink quartz vanity. The expansive primary suite offers a large walk-in closet, dual sinks with quartz countertops, and a walk-in shower. Enjoy the convenience of a second-floor laundry room. Don’t miss this opportunity to call Celtic Farms home!

Last Agent to Sell the Property

Stacey Pardikes

Harmony Home Real Estate Group License #6502433276 Listed on: 09/09/2025

Last Buyer's Agent

Kim Jarvis

RE/MAX Innovation License #6501337674

RE/MAX Innovation
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 Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 2025

Lot Details

  • 14,810 Sq Ft Lot
  • Lot Dimensions are 100.16x149.14

Parking

  • Garage

Home Design

  • Brick Exterior Construction
  • Poured Concrete
  • Asphalt Roof
  • Vinyl Siding

Interior Spaces

  • 2,580 Sq Ft Home
  • Cathedral Ceiling
  • Gas Fireplace
  • Great Room with Fireplace
  • Basement
  • Basement Window Egress
  • Laundry Room

Bedrooms and Bathrooms

  • 4 Bedrooms

Location

  • Ground Level

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas

Community Details

  • Celtic Farms Sub Subdivision

Listing and Financial Details

  • Home warranty included in the sale of the property
  • Assessor Parcel Number 58089020046000

Home Details

Home Type

Single Family

Est. Annual Taxes

$847

Year Built

Built in 2025

Lot Details

0.34 Acres

Parking

3

Listing Details

  • Property Type: Residential
  • Year Built: 2025
  • State Equalized Value: 37700.00
  • Entry Location: GroundLevelwSteps
  • Property Sub Type: SingleFamilyResidence
  • LotSizeAcres: 0.34
  • Co List Office Mls Id: 433276
  • Above Grade Finished Sq Ft: 2580.00
  • Living Area: 2580.00
  • ClassName: Residential
  • ThirdPartyApprovalRequiredYN: No
  • Special Features: NewHome

Interior Features

  • Fireplace: Yes
  • Basement: Yes
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bedrooms: 4
  • Fireplace Features: Gas, GreatRoom
  • Window Features: EgressWindows

Exterior Features

  • Waterfront: No
  • Foundation Details: Basement, Poured
  • Construction Materials: Brick, VinylSiding
  • Road Frontage Type: Paved
  • Disclosures: Restrictions, TaxesNotHomesteadExempt
  • Home Warranty: Yes
  • Roof: Asphalt

Garage/Parking

  • Garage: Yes

Utilities

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

Schools

  • Junior High Dist: FlatRock

Lot Info

  • Lot Dimensions: 100.16X149.14
  • Parcel Number: 58089020046000
  • Land Lease Expiration Date: 2026-02-28

Tax Info

  • Tax Amount Summer: 596.00
  • Tax Amount Winter: 251.00
  • Tax Annual Amount: 847.00

Multi Family

  • Above Grade Finished Area Units: SquareFeet

Ownership 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 Name Owned For Owner Type

Purchase Details

Listed on
Sep 9, 2025
Closed on
Nov 25, 2025
Sold by
Bought by
Seller's Agent
Stacey Pardikes
Harmony Home Real Estate Group
Buyer's Agent
Kim Jarvis
RE/MAX Innovation
List Price
$507,558
Sold Price
$499,000
Premium/Discount to List
-$8,558
-1.69%
Views
30
Current Estimated Value
$502,740

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$3,740
Avg. Annual Appreciation
1.09%
Original Mortgage
$334,000
Outstanding Balance
$331,721
Interest Rate
6.19%
Mortgage Type
New Conventional
Estimated Equity
$171,019
Source: Public Records

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Agents Specializing in Flat Rock, MI

See All Agents

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 Buyer Sale Price Title Company
$499,000 Vanguard Title
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 Borrower Loan Amount
Open $334,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
11/25/2025 11/25/25 Sold $499,000 -1.7% $193 / Sq Ft
10/20/2025 10/20/25 Pending -- -- --
09/09/2025 09/09/25 For Sale $507,558 -- $197 / Sq Ft
Source: Realcomp

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 $614 $37,700 $0 $0
2024 $596 $37,600 $0 $0
2023 $568 $37,600 $0 $0
2022 $764 $28,500 $0 $0
2021 $746 $26,000 $0 $0
2020 $738 $26,000 $0 $0
2019 $716 $23,500 $0 $0
2018 $501 $17,500 $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

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Realcomp

MLS Number: 20251033832

Realcomp

APN: 58-089-02-0046-000

Your Personal Tour Guide

Ask me questions while you tour the home.