NOT LISTED FOR SALE

22597 Brantingham Rd Macomb, MI 48044

Macomb Area

Estimated Value: $484,000 - $547,000

3 Beds
2.5 Baths
2,400 Sq Ft
$214/Sq Ft Est. Value

Sale Details

Date Sold: July 20, 2022

Last sale price $418,000 $174 Per Sq Ft

Est. 23% increase in value since last sale

Current estimated payment $3,395 / mo

Highlights

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

About This Home

As of May 2025

Welcome to This **Absolutely gorgeous !! ** Beautiful Brick Ranch, This lovely home offers plenty of nicely added upgrades ** will have you fall in love at first sight, w/ the gleaming premium quality Laminate floors throughout & entrance that opens into a bright Great room w/Sky Lights, Gas Fireplace and gourmet/modern Kitchen w/ Design Cabinets, Granite Countertop, w/all Kitchen Stainless Steel Appliances included and lots of space. New custom Modern curtains all over included. 3 Bedrooms w/great views from every window. Master Bedroom w/ master Bath and walking closed. Specious Full bathrooms w/Ceramic Titles, New Vanities and Fixtures. First floor laundry w/ newer appliances included. Partial finished Basement w/ high ceiling, egress window and finished office room w/ new Electric Fireplace and vinyl flooring. Fresh paint throughout. New Dimensional Roof (2024). Beautiful & large Stamped Concrete Patio with newer Gazebo included. Fenced Backyard. Driveway extended w/ stamped concrete on both sides w/ 2 cars attached, This home is located in a very convenient location, Desirable Lanse Creuse School district. Must see **this home has easy access to fishing ponds, bike trails, and a community park!Requirements; First month plus security deposit and $300 none refundable cleaning fees. Employment verification, Credit Score and previous Landlord verification.

Last Agent to Rent the Property

Diana Mamo

Community Choice Realty Inc License #6501371742 Listed on: 05/15/2025

Community Choice Realty Inc

Last Renter's Agent

William Parr

REALTEAM Real Estate License #6501446416

REALTEAM Real Estate

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 Details

Home Type

  • Single Family

Year Built

  • Built in 2005 | Remodeled in 2024

Lot Details

  • 9,583 Sq Ft Lot
  • Lot Dimensions are 75.00 x 125.00
  • Back Yard Fenced

HOA Fees

  • $21 per month

Parking

  • Garage

Home Design

  • Brick Exterior Construction
  • Poured Concrete
  • Asphalt Roof

Interior Spaces

  • Gas Fireplace
  • Great Room with Fireplace
  • Laundry Room
  • Basement

Bedrooms and Bathrooms

  • 3 Bedrooms

Location

  • Ground Level

Utilities

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

Community Details

  • Michigan Condominium Management Co. Association, Phone Number (586) 775-5757
  • The Bluffs Of Beaufait Farms Sub Subdivision

Listing and Financial Details

  • Security Deposit $5,250
  • Assessor Parcel Number 0835402007

Home Details

Home Type

Single Family

Year Built

Built in 2005 | Remodeled in 2024

Lot Details

9,583 Sq Ft Lot

HOA Fees

$21 per month

Parking

2

Rental Info

  • Lease Type: SingleFamilyHouse
  • Rent Includes: AssociationFee
  • Security Deposit: 5250.00

Listing Details

  • Property Type: ResidentialLease
  • Year Built: 2005
  • Year Renovated: 2024
  • Entry Location: GroundLevelwSteps
  • Pets Allowed: No
  • Property Sub Type: SingleFamilyResidence
  • LotSizeAcres: 0.22
  • Co List Office Mls Id: 338645
  • Above Grade Finished Sq Ft: 2100.00
  • Living Area: 2400.00
  • ClassName: ResidentialLease
  • LeaseTermsAvailable: Months12, Months13to24, Months25to36
  • ThirdPartyApprovalRequiredYN: No
  • Special Features: NewHome

Interior Features

  • Fireplace: Yes
  • Basement: Yes
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bedrooms: 3
  • Below Grade Sq Ft: 300.00
  • Fireplace Features: Gas, GreatRoom

Exterior Features

  • Waterfront: No
  • Foundation Details: Basement, Poured
  • Construction Materials: Brick
  • Road Frontage Type: Paved
  • Fencing: BackYard
  • Roof: Asphalt

Garage/Parking

  • Garage: Yes

Utilities

  • Cooling: CentralAir
  • Heating: ForcedAir, NaturalGas
  • Sewer: PublicSewer
  • Water Heater Fuel: NaturalGas
  • Water Source: Public
  • Laundry Features: LaundryRoom

Condo/Co-op/Association

  • Association Fee Frequency: Annually
  • Phone: (586) 775-5757
  • Association Contact: Michigan Condominium Management Co.

Fee Information

  • Additional Fee: 300.00

Schools

  • Junior High Dist: LanseCreuse

Lot Info

  • Lot Size Area: 0.22
  • Lot Dimensions: 75.00 x 125.00
  • Parcel Number: 0835402007

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

Closed on
Mar 28, 2025
Sold by
Shamasha Allen and Dawood Rita
Bought by
Current Estimated Value
$514,286

Purchase Details

Listed on
Jun 16, 2022
Closed on
Jul 20, 2022
Sold by
Kay Ryan D and Kay Jessica B
Bought by
Shamasha Allen
Buyer's Agent
Diana Mamo
Community Choice Realty Inc
List Price
$400,000
Sold Price
$418,000
Premium/Discount to List
$18,000
4.5%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
5.16%
Original Mortgage
$397,100
Interest Rate
5.81%
Mortgage Type
New Conventional

Purchase Details

Closed on
Dec 16, 2005
Sold by
Harvest Homes Llc
Bought by
Kay Ryan D and Kay Jessica B

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$38,585
Interest Rate
6.48%
Mortgage Type
Stand Alone Second
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
-- None Listed On Document
Shamasha Allen $418,000 Luxury Title Services
Kay Ryan D $73,000 Greco
Harvest Homes Llc -- 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
Previous Owner $397,100
Previous Owner Kay Ryan D $215,200
Previous Owner Kay Ryan D $198,000
Previous Owner Kay Ryan D $211,100
Previous Owner Kay Ryan D $38,585
Previous Owner Kay Ryan D $205,650
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
05/30/2025 05/30/25 Rented $3,500 0.0% --
05/27/2025 05/27/25 Under Contract -- -- --
05/15/2025 05/15/25 For Rent $3,500 0.0% --
07/20/2022 07/20/22 Sold $418,000 +4.5% $199 / Sq Ft View Prior Sale
07/20/2022 07/20/22 Pending -- -- --
06/16/2022 06/16/22 For Sale $400,000 -- $190 / 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 $6,611 $238,700 $0 $0
2025 $4,975 $232,600 $0 $0
2024 $48 $226,800 $0 $0
2023 $4,587 $196,400 $0 $0
2022 $3,976 $160,900 $0 $0
2021 $4,341 $157,000 $0 $0
2020 $2,853 $144,300 $0 $0
2019 $4,363 $143,300 $0 $0
2018 $3,581 $139,800 $0 $0
2017 $3,528 $128,640 $34,500 $94,140
2016 $3,584 $128,630 $0 $0
2015 $3,207 $119,510 $0 $0
2014 $3,207 $109,270 $23,500 $85,770
2011 $699 $113,140 $20,500 $92,640
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Realcomp

MLS Number: 20250035896

Realcomp

APN: 20-08-35-402-007

Your Personal Tour Guide

Ask me questions while you tour the home.