NOT LISTED FOR SALE

48725 Celeste St Chesterfield, MI 48051

Estimated Value: $260,431 - $306,000

3 Beds
1.5 Baths
1,466 Sq Ft
$198/Sq Ft Est. Value

Last Sold October 26, 2018

Last sale price $185,000 $126 Per Sq Ft

Est. 57% increase in value since last sale

Current estimated payment $1,676/month

3 Days on Market

Highlights

  • Above Ground Pool
  • No HOA
  • Patio
  • L'Anse Creuse High School - North Rated 9+
  • 2 Car Attached Garage
  • Fireplace in Basement

About This Home

As of October 2018

GORGEOUS TRI-LEVEL WITH GREAT CURB APPEAL. PRIDE OF OWNERSHIP SHINES, HOME HAS BEEN WELL MAINTAINED AND IS VERY CLEAN! LIVING ROOM WITH HUGE PICTURE WINDOW OFFERING LOTS OF NATURAL LIGHT. KITCHEN WITH APPLIANCES INCLUDED, BREAKFAST NOOK, AND DOOR WALL TO BEAUTIFUL BACKYARD. THREE SPACIOUS BEDROOMS AND FULL BATHROOM ON UPPER LEVEL. LOWER LEVEL FEATURES GORGEOUS LIVING ROOM WITH STONE NATURAL FIREPLACE, HALF BATHROOM AND LAUNDRY/UTILITY ROOM. BACKYARD IS YOUR OWN PRIVATE OASIS WITH PRIVACY FENCE, COVERED PATIO, AND ABOVE GROUND POOL. 2 CAR ATTACHED GARAGE. NOTHING TO DO BUT MOVE RIGHT IN. THIS HOME WILL NOT LAST!

Last Agent to Sell the Property

Eric Jurmo

KW Platinum License #6501347983 Listed on: 09/25/2018

KW Platinum

Co-Listed By

Ryan Maceri

KW Platinum License #6501393054

Last Buyer's Agent

Michael Capers

Keller Williams Realty Central License #RCO-6501404073

Keller Williams Realty Central

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 1981

Lot Details

  • 9,148 Sq Ft Lot
  • Lot Dimensions are 130x78x130x69

Parking

  • 2 Car Attached Garage

Home Design

  • Tri-Level Property
  • Brick Exterior Construction
  • Poured Concrete
  • Vinyl Construction Material

Interior Spaces

  • 1,466 Sq Ft Home
  • Ceiling Fan

Kitchen

  • Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 3 Bedrooms

Basement

  • Fireplace in Basement
  • Crawl Space

Outdoor Features

  • Above Ground Pool
  • Patio

Utilities

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

Community Details

  • No Home Owners Association
  • Chesterfield Meadows Subdivision

Listing and Financial Details

  • Assessor Parcel Number 0929105003

Home Details

Home Type

Single Family

Est. Annual Taxes

$1,631

Year Built

Built in 1981

Lot Details

9,148 Sq Ft Lot

Listing Details

  • Property Type: Residential
  • Architecture Level: Tri-Level
  • Year Built: 1981
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 3

Interior Features

  • Fireplace: Yes
  • Fireplace Fuel: Natural
  • Fireplace Locations: Basement
  • Total Bedrooms: 3
  • Total Bathrooms: 1.10
  • Full Bathrooms: 1
  • Half Bathrooms: 1
  • Kitchen Appliances: Dishwasher, Disposal, Microwave, Refrigerator, Range/Stove
  • Total Sq Ft: 1466

Exterior Features

  • Pool: Yes
  • Foundation Details: Crawl
  • Construction Materials: Brick, Vinyl
  • Exterior Features: Pool - Above Ground
  • Foundation Materials: Poured
  • Porch Type: Patio
  • Road Frontage Type: Paved

Garage/Parking

  • Garage Size: 2 Car
  • Garage Features: Attached
  • Garage: Yes

Utilities

  • Heating Fuel: Natural Gas
  • Cooling: Ceiling Fan(s), Central Air
  • Heating: Forced Air
  • Sewer: Public Sewer (Sewer-Sanitary)
  • Water Heater Fuel: Natural Gas
  • Water Source: Public (Municipal)
  • Laundry Facilities: No

Condo/Co-op/Association

  • Association Fee: No

Lot Info

  • Homestead: Yes
  • List Price per Acre: 857142.8571
  • Lot Size Area: 0.21
  • Lot Dimensions: 130x78x130x69
  • Parcel Number: 0929105003

Tax Info

  • Tax Amount Summer: 1085.0000
  • Tax Amount Winter: 546.0000
  • Total Tax: 1631.0000

MLS Schools

  • School District: Lanse Creuse

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Sep 25, 2018
Closed on
Oct 26, 2018
Sold by
Mccartney Mike
Bought by
Schwendenman Corey
Seller's Agent
Eric Jurmo
KW Platinum
Buyer's Agent
Michael Capers
Keller Williams Realty Central
List Price
$180,000
Sold Price
$185,000
Premium/Discount to List
$5,000
2.78%
Current Estimated Value
$290,608

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$105,608
Avg. Annual Appreciation
6.29%
Original Mortgage
$179,450
Outstanding Balance
$157,142
Interest Rate
4.6%
Mortgage Type
New Conventional
Estimated Equity
$133,466

Purchase Details

Closed on
Nov 9, 2011
Sold by
The Bank Of New York Mellon
Bought by
Mccartney Mike

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$56,967
Interest Rate
4.4%
Mortgage Type
FHA

Purchase Details

Closed on
Dec 10, 2010
Sold by
Marsee Daniel J and Marsee Christina
Bought by
The Bank Of New York Mellon and The Bank Of New York

Purchase Details

Closed on
Jul 16, 1996
Sold by
Cyma T and Cyma D
Bought by
Marsee D and Marsee K
Source: Public Records

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

Purchase History

Date Buyer Sale Price Title Company
Schwendenman Corey $185,000 Cislo Title Co
Mccartney Mike $58,449 None Available
The Bank Of New York Mellon $204,401 None Available
Marsee D $119,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Schwendenman Corey $179,450
Previous Owner Mccartney Mike $56,967
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
10/26/2018 10/26/18 Sold $185,000 +2.8% $126 / Sq Ft
09/28/2018 09/28/18 Pending -- -- --
09/25/2018 09/25/18 For Sale $180,000 -- $123 / Sq Ft
Source: Realcomp

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 $1,970 $100,700 $0 $0
2024 $19 $98,600 $0 $0
2023 $1,817 $90,400 $0 $0
2022 $2,532 $81,100 $0 $0
2021 $2,462 $78,200 $0 $0
2020 $1,668 $74,500 $0 $0
2019 $1,628 $69,400 $0 $0
2018 $1,665 $68,800 $13,800 $55,000
2017 $1,630 $61,750 $13,800 $47,950
2016 $1,628 $61,750 $0 $0
2015 $549 $55,450 $0 $0
2014 $549 $49,750 $11,250 $38,500
2012 -- $0 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Eric Jurmo

    Seller's Agent in 2018

    Eric Jurmo

    KW Platinum

    (586) 524-1829

    23 in this area

    292 Total Sales

    Eric Jurmo
    Section Image
  • Ryan Maceri

    Seller Co-Listing Agent in 2018

    Ryan Maceri

    KW Platinum

    (586) 519-6259

    22 in this area

    241 Total Sales

    Ryan Maceri
    Section Image
  • Michael Capers

    Buyer's Agent in 2018

    Michael Capers

    Keller Williams Realty Central

    (586) 265-8261

    2 in this area

    9 Total Sales

    Michael Capers
    Section Image
See All Agents

Map

Source: Realcomp

MLS Number: 218088269

Realcomp

APN: 15-09-29-105-003

Michigan Macomb County Chesterfield 48051

48725 Celeste St, Chesterfield, MI

Not Listed for Sale

Detached

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.

Realcomp IDX provided courtesy of Realcomp II Ltd. via Ten-X 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.
Listing Information presented by local MLS brokerage: Ten-X, local REALTOR®- Arlene Richardson - (888)-952-6393

Nearby Homes
Your Personal Tour Guide

Ask me questions while you tour the home.