Seller's Agent in 2024
Stacey Pardikes
Harmony Home Real Estate Group
(734) 437-4826
17 in this area
125 Total Sales
26787 Celtic Dr Flat Rock, MI 48134
Estimated Value: $466,000 - $501,000
3
Beds
2.5
Baths
2,175
Sq Ft
$222/Sq Ft
Est. Value
Highlights
- New Construction
- No HOA
- Forced Air Heating and Cooling System
- Ranch Style House
- 2 Car Attached Garage
- Gas Fireplace
About This Home
As of November 2024Welcome 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.
Last Agent to Sell the Property
Harmony Home Real Estate Group License #6502433276 Listed on: 08/21/2024
Last Buyer's Agent
Berkshire Hathaway HomeServices Kee Realty Browns License #6501413663
Home Details
Home Type
- Single Family
Est. Annual Taxes
Year Built
- Built in 2024 | New Construction
Lot Details
- 0.33 Acre Lot
- Lot Dimensions are 91.60 x 156.10
Parking
- 2 Car Attached Garage
Home Design
- Ranch Style House
- Brick Exterior Construction
- Poured Concrete
- Asphalt Roof
- Vinyl Construction Material
Interior Spaces
- 2,175 Sq Ft Home
- Gas Fireplace
- Great Room with Fireplace
- Disposal
Bedrooms and Bathrooms
- 3 Bedrooms
Unfinished Basement
- Sump Pump
- Basement Window Egress
Location
- Ground Level
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Natural Gas
- Natural Gas Water Heater
Community Details
- No Home Owners Association
- Celtic Farms Sub Subdivision
Listing and Financial Details
- Home warranty included in the sale of the property
- Assessor Parcel Number 58089020015000
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Aug 21, 2024
Closed on
Nov 27, 2024
Sold by
Celtic Farms Development Llc
Bought by
Pischke Andrea and Tyrer Ryan
Seller's Agent
Stacey Pardikes
Harmony Home Real Estate Group
Buyer's Agent
Susan Paolucci
Berkshire Hathaway HomeServices Kee Realty Browns
List Price
$471,638
Sold Price
$468,000
Premium/Discount to List
-$3,638
-0.77%
Views
58
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$14,372
Avg. Annual Appreciation
2.64%
Original Mortgage
$421,200
Outstanding Balance
$417,698
Interest Rate
6.5%
Mortgage Type
New Conventional
Estimated Equity
$64,674
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
Average Home Value in this Area
Purchase History
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Pischke Andrea | $468,000 | Vanguard Title | |
| Pischke Andrea | $468,000 | Vanguard Title |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Pischke Andrea | $421,200 | |
| Closed | Pischke Andrea | $421,200 |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 11/27/2024 11/27/24 | Sold | $468,000 | 0.0% | $215 / Sq Ft |
| 11/07/2024 11/07/24 | Pending | -- | -- | -- |
| 11/01/2024 11/01/24 | Price Changed | $468,000 | -0.8% | $215 / Sq Ft |
| 08/21/2024 08/21/24 | For Sale | $471,638 | -- | $217 / Sq Ft |
Source: Realcomp
Tax History Compared to Growth
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,142 | $213,800 | $0 | $0 |
| 2024 | $596 | $34,300 | $0 | $0 |
| 2023 | $568 | $34,300 | $0 | $0 |
| 2022 | $764 | $26,100 | $0 | $0 |
| 2021 | $746 | $23,800 | $0 | $0 |
| 2020 | $737 | $23,800 | $0 | $0 |
| 2019 | $716 | $21,500 | $0 | $0 |
| 2018 | $501 | $16,000 | $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
-
Stacey Pardikes
-
Susan Paolucci
S
Buyer's Agent in 2024
Susan Paolucci
Berkshire Hathaway HomeServices Kee Realty Browns
(734) 787-0512
8 in this area
110 Total Sales
Map
Source: Realcomp
MLS Number: 20240061200
APN: 58-089-02-0015-000
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
IDX provided courtesy of Realcomp II Ltd. via Ten-X and MLS
Copyright 2025 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.
Listing Information presented by local MLS brokerage: Ten-X, local REALTOR®- Arlene Richardson - (888)-952-6393
Nearby Homes
- 26926 Celtic Dr
- 26998 Celtic Dr
- 27196 Hawthorne Blvd
- 27299 Jessica Ln
- 24611 Rock Lake Ct
- 27145 James Ave
- 27110 Wager St
- 24161 Senate Dr
- 26980 James Ave
- 27200 Telegraph Rd
- 25352 Canyon Cir
- 25712 Telegraph Rd
- 26609 Laramie Ln
- 25182 Frontier Cir
- Argonne Ave 8.8 Acre Argonne Ave
- Argonne Ave 5 Acres Argonne Ave
- 24946 Peters Rd
- 24608 Woodland Dr
- 28401 Seneca St
- 25860 Brighton Ln
- 26763 Celtic Dr
- 26811 Celtic Dr
- 26739 Celtic Dr
- 26835 Celtic Dr
- 27125 Lancaster Dr
- 27129 Lancaster Dr
- 26715 Celtic Dr
- 26859 Celtic Dr
- 27121 Lancaster Dr
- 26710 Celtic Dr
- 25940 Coyote Dr
- 26691 Celtic Dr
- 26883 Celtic Dr
- 27117 Lancaster Dr
- 26667 Celtic Dr
- 26686 Celtic Dr
- 26686 Celtic Dr Unit 43 Drv
- 26686 Celtic Dr
- 25906 Coyote Dr