NOT LISTED FOR SALE

47540 Kelston Dr Macomb, MI 48044

Macomb Area

Estimated Value: $543,126

4 Beds
5 Baths
4,879 Sq Ft
$111/Sq Ft Est. Value

Sale Details

Date Sold: August 14, 2025

Last sale price $493,000 $101 Per Sq Ft

Est. 10% increase in value since last sale

Current estimated payment $3,607 / mo

15 Days on Market

Highlights

  • Forced Air Heating and Cooling System
  • Ceiling Fan
  • Garage

About This Home

As of August 2025

Welcome to this beautifully designed 4-bedroom, 3 full and 2 half-bath split-level home nestled on a quiet cul-de-sac in Macomb. With an open and inviting layout, this home offers both comfort and functionality for everyday living and entertaining. Step inside to find a formal dining room perfect for gatherings, and a versatile library/den that shares a cozy double-sided fireplace with the expansive great room. The kitchen features abundant cabinet space, a walk-in pantry, and a dining nook for casual meals. The entry-level primary suite provides convenience and privacy, complete with a spacious bathroom. Upstairs, you’ll find three generously sized bedrooms and two full baths. The finished basement adds even more living space with an additional bedroom, a large rec area, a half bathroom that is plumbed for a shower, and a bar area—ideal for entertaining or relaxing. Outside, enjoy the peaceful backyard with a deck that backs up to a wide-open field, offering exceptional privacy and a natural view. Refrigerator is excluded. the house has a "220 volt 90 amp service panel in the garage ready to support up to 2 EV chargers"

Last Agent to Sell the Property

Scott Gehres

REALTEAM Real Estate License #6501391543 Listed on: 06/03/2025

REALTEAM Real Estate

Last Buyer's Agent

Karl Qonja

Utica Realty LLC License #6501449608

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 2003

Lot Details

  • 13,504 Sq Ft Lot
  • Lot Dimensions are 87x155

HOA Fees

  • $19 per month

Parking

  • Garage

Home Design

  • Brick Exterior Construction
  • Poured Concrete

Interior Spaces

  • Ceiling Fan
  • Basement

Bedrooms and Bathrooms

  • 4 Bedrooms

Location

  • Ground Level

Utilities

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

Community Details

  • Carleton Place Home Owner Association, Phone Number (586) 248-1351
  • Carleton Place Sub Subdivision

Listing and Financial Details

  • Assessor Parcel Number 0827425006

Home Details

Home Type

Single Family

Est. Annual Taxes

$6,994

Year Built

Built in 2003

Lot Details

0.31 Acres

HOA Fees

$19 per month

Listing Details

  • Property Type: Residential
  • Year Built: 2003
  • State Equalized Value: 251000.00
  • Entry Location: GroundLevelwSteps
  • Property Sub Type: SingleFamilyResidence
  • LotSizeAcres: 0.31
  • Co List Office Mls Id: 403050
  • Above Grade Finished Sq Ft: 2960.00
  • Living Area: 4879.00
  • ClassName: Residential
  • ThirdPartyApprovalRequiredYN: No
  • Special Features: None

Interior Features

  • Fireplace: No
  • Basement: Yes
  • Full Bathrooms: 3
  • Half Bathrooms: 2
  • Total Bedrooms: 4
  • Below Grade Sq Ft: 1919.00

Exterior Features

  • Waterfront: No
  • Foundation Details: Basement, Poured
  • Construction Materials: Brick
  • Road Frontage Type: Paved
  • Disclosures: TaxesHomesteadExempt
  • Home Warranty: No

Garage/Parking

  • Garage: Yes

Utilities

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

Condo/Co-op/Association

  • Association Fee Frequency: Annually
  • Phone: 586-248-1351
  • Association Contact: CARLETON PLACE HOME OWNER ASSOCIATION

Schools

  • Junior High Dist: ChippewaValley

Lot Info

  • Lot Dimensions: 87X155
  • Parcel Number: 0827425006
  • Land Lease Expiration Date: 2025-12-31

Tax Info

  • Tax Amount Summer: 5313.00
  • Tax Amount Winter: 1681.00
  • Tax Annual Amount: 6994.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
Jun 3, 2025
Closed on
Aug 14, 2025
Sold by
Bought by
Seller's Agent
Scott Gehres
REALTEAM Real Estate
Buyer's Agent
Karl Qonja
Utica Realty LLC
List Price
$495,000
Sold Price
$493,000
Premium/Discount to List
-$2,000
-0.4%
Views
83
Current Estimated Value
$543,126

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$50,126
Avg. Annual Appreciation
10.50%
Original Mortgage
$443,700
Outstanding Balance
$439,721
Interest Rate
6.67%
Mortgage Type
New Conventional
Estimated Equity
$103,405

Purchase Details

Listed on
Aug 15, 2019
Closed on
Nov 8, 2019
Sold by
Bought by
Seller's Agent
Dave Budny
RE/MAX First
Buyer's Agent
Scott Gehres
REALTEAM Real Estate
List Price
$389,000
Sold Price
$350,000
Premium/Discount to List
-$39,000
-10.03%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
6.12%
Original Mortgage
$332,500
Interest Rate
3.5%
Mortgage Type
New Conventional

Purchase Details

Closed on
Aug 11, 2003
Sold by
Bought by

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$272,736
Interest Rate
6.99%
Mortgage Type
Unknown
Source: Public Records

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Agents Specializing in Macomb, 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
$493,000 None Listed On Document
$350,000 Partners Title Agency Llc
$287,000 Greco
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 $443,700
Previous Owner $39,500
Previous Owner $332,500
Previous Owner $315,000
Previous Owner $309,500
Previous Owner $287,850
Previous Owner $272,736
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
08/14/2025 08/14/25 Sold $493,000 -0.4% $101 / Sq Ft
06/18/2025 06/18/25 Pending -- -- --
06/13/2025 06/13/25 For Sale $495,000 0.0% $101 / Sq Ft
06/09/2025 06/09/25 Pending -- -- --
06/03/2025 06/03/25 For Sale $495,000 +41.4% $101 / Sq Ft
11/08/2019 11/08/19 Sold $350,000 -2.8% $74 / Sq Ft View Prior Sale
09/23/2019 09/23/19 Pending -- -- --
09/10/2019 09/10/19 Price Changed $359,900 -7.5% $76 / Sq Ft
08/15/2019 08/15/19 For Sale $389,000 -- $82 / 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
2026 $7,175 $271,800 $0 $0
2025 $5,464 $258,800 $0 $0
2024 $53 $251,000 $0 $0
2023 $5,039 $225,800 $0 $0
2022 $6,341 $200,700 $0 $0
2021 $6,166 $187,200 $0 $0
2020 $4,623 $183,300 $0 $0
2019 $5,589 $168,900 $0 $0
2018 $5,785 $166,500 $0 $0
2017 $4,818 $159,670 $35,000 $124,670
2016 $5,027 $159,670 $0 $0
2015 $5,108 $150,420 $0 $0
2014 $5,108 $136,760 $24,000 $112,760
2013 $6,207 $136,760 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Realcomp

MLS Number: 20251004189

Realcomp

APN: 20-08-27-425-006

Your Personal Tour Guide

Ask me questions while you tour the home.