NOT LISTED FOR SALE

15658 Retreat Dr Macomb, MI 48042

Estimated Value: $554,750 - $587,000

4 Beds
2 Baths
4,013 Sq Ft
$142/Sq Ft Est. Value

Last Sold August 18, 2021

Last sale price $485,000 $121 Per Sq Ft

Est. 18% increase in value since last sale

Current estimated payment $3,534/month

Highlights

  • Above Ground Pool
  • Colonial Architecture
  • Wood Flooring
  • Richard J. Duncan Elementary Rated A-
  • Cathedral Ceiling
  • Great Room with Fireplace

About This Home

As of August 2021

BACK ON THE MARKET.. DUE TO BUYER NOT ABLE TO OBTAIN FINANCING. Welcome Home ! This 4 Bedroom, 2 .5 baths & 1/2 bath in basement. Colonial on an oversized lot in sought after Utica School District, Duncan , Shelby Jr. High & Eisenhower High School. Home features den w/ double doors. Dining room w/ hardwood floors, bay window & built in cabinet. Open concept great room w/vaulted ceiling, gas fireplace w/mantle. Kitchen with newer cabinets, granite, ceramic flooring, island and black stainless-steel appliances. Primary en-suite with oversized tub, separate shower, double vanity, walk in closet. Laundry was relocated to second floor has the option to be 1st floor, if needed. Fully finished basement features bar, kitchen area, tons of storage. Oversized fenced in backyard yard. The yard extends past the fence line in the back. Brick paver patio with walkway to the front of the home. Service door off the attached 2.5 car garage.

Last Agent to Sell the Property

Yvonne Zielinski

Epique Inc. License #MISPE-6501374158 Listed on: 06/24/2021

Epique Inc.

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 2000

Lot Details

  • 0.26 Acre Lot
  • Lot Dimensions are 65x189x105x157
  • Sprinkler System

HOA Fees

  • $10 Monthly HOA Fees

Parking

  • 2 Car Attached Garage

Home Design

  • Colonial Architecture
  • Brick Exterior Construction
  • Cedar

Interior Spaces

  • 2-Story Property
  • Cathedral Ceiling
  • Ceiling Fan
  • Window Treatments
  • Great Room with Fireplace
  • Formal Dining Room
  • Home Office
  • Finished Basement
  • Sump Pump

Kitchen

  • Eat-In Kitchen
  • Oven or Range
  • Microwave
  • Dishwasher
  • Disposal

Flooring

  • Wood
  • Carpet
  • Laminate
  • Ceramic Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet
  • 2 Full Bathrooms

Laundry

  • Laundry on upper level
  • Dryer
  • Washer

Outdoor Features

  • Above Ground Pool
  • Patio

Utilities

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

Community Details

  • 586 000 0000 HOA
  • Pine Pointe Sub Subdivision

Listing and Financial Details

  • Assessor Parcel Number 20-08-06-329-002

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,382

Year Built

Built in 2000

Lot Details

0

HOA Fees

$10 per month

Listing Details

  • Originating MLS: MiRealSource
  • Class: RESIDENTIAL
  • Type Of Property: Single Family
  • Architecture Style: Colonial
  • Structure Style: 2 Story
  • Total Tax Amount: 5382
  • Year Built: 2000
  • Mail City: Macomb
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2

Interior Features

  • Interior Amenities: Cable/Internet Avail., Cathedral/Vaulted Ceiling, Ceramic Floors, Sump Pump, Walk-In Closet, Window Treatment(s)
  • Appliances: Dishwasher, Disposal, Dryer, Microwave, Range/Oven, Refrigerator, Washer
  • Fireplace: Yes
  • Fireplaces: Grt Rm Fireplace
  • Basement: Yes
  • Basement: Finished, Sump Pump
  • Bedrooms: 4
  • Bedroom 1: On 2nd Floor, Dimensions: 15 x 14
  • Bedroom 1 Floor Covering: Carpet
  • Bedroom 2: On 2nd Floor, Dimensions: 13 x 12
  • Bedroom 2 Floor Covering: Carpet
  • Bedroom 3: On 2nd Floor, Dimensions: 13 x 10
  • Bedroom 3 Floor Covering: Carpet
  • Bedroom 4: On 2nd Floor, Dimensions: 11 x 11
  • Bedroom 4 Floor Covering: Laminate
  • Bathrooms Description: Basement Lavatory, PrimaryBdrm Full Bathroom, Second Flr Full Bathroom
  • Full Bathrooms: 2
  • Total Bathrooms: 4
  • Bathroom 1: Dimensions: 13 x 12, On Level: Second, Flooring: Ceramic
  • Bathroom 2: Dimensions: 9 x 5, On Level: Second, Flooring: Ceramic
  • Room Types: First Floor Laundry, Great Room, Second Floor Laundry, Primary Bedroom, Home Office, Basement Lavatory, First Flr Lavatory, Primarybdrm Full Bathroom, Second Flr Full Bathroom, Eat-In Kitchen, Formal Dining Room
  • Breakfast Nook: On 1st Floor, Dimensions: 13 x 12
  • Breakfast Nook Floor Covering: Ceramic
  • Dining Room: On Entry Level, Dimensions: 13 x 10
  • Dining Room Floor Covering: Wood
  • Great Room: On 1st Floor, Dimensions: 23 x 16
  • Great Room Floor Covering: Carpet
  • Kitchen: On 1st Floor, Dimensions: 13 x 12
  • Kitchen Features: Eat-In Kitchen
  • Kitchen Floor Covering: Ceramic
  • Laundry: On 1st Floor, Dimensions: 9 x 6
  • Laundry Room Floor Covering: Ceramic
  • Library Den: On 1st Floor, Dimensions: 14 x 10
  • Below Grade Sq Ft: 1486
  • Finished Below Grade Sq Ft: 1203
  • Half Bathrooms: 2
  • Above Grade Finished Sq Ft: 2810
  • Total Finished Sq Ft: 4013

Exterior Features

  • Pool: Yes
  • Exterior: Brick, Cedar
  • Exterior Features: Above Ground Pool, Lawn Sprinkler, Patio, Sidewalks
  • Foundation: Basement
  • Frontage: 65
  • Road: Paved Street

Garage/Parking

  • Garage: Attached Garage, Electric in Garage
  • Garage Spaces: 2
  • Garage: Yes

Utilities

  • Heating: Forced Air
  • Heating Fuel: Natural Gas
  • Sewer: Public Sanitary
  • Water: Public Water
  • Water Heater: Electric
  • Cooling: Ceiling Fan(s), Central A/C

Condo/Co-op/Association

  • HOA Fees: 125
  • HOA Fee Frequency: Yearly
  • HOA Fee Includes: Snow Removal
  • Association Contact: 586-000-0000
  • Association Phone: 000
  • Association Fee: Yes

Lot Info

  • Assessor Parcel Number: 20-08-06-329-002
  • Location: Subdivision
  • Lot Description: Large Lot - 65+ Ft.
  • Lot Dimensions: 65x189x105x157
  • Acreage: 0.26
  • Geo Subdivision: MI

Rental Info

  • Pets Allowed: Yes

Tax Info

  • Summer Tax: Year: 2020, Amount: $3,313.00
  • Winter Tax: Year: 2020, Amount: $2,069.00
  • Total Tax: Amount: $5,382.00

MLS Schools

  • School District: Utica Community Schools

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 24, 2021
Closed on
Aug 17, 2021
Sold by
Braxton Julia and Braxton Aaron Stephen
Bought by
Adhikari Ann Marie and Adhikari Suman
Seller's Agent
Yvonne Zielinski
Epique Inc.
List Price
$429,900
Sold Price
$485,000
Premium/Discount to List
$55,100
12.82%
Current Estimated Value
$571,688

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$86,688
Avg. Annual Appreciation
4.01%
Original Mortgage
$470,000
Outstanding Balance
$426,081
Interest Rate
2.7%
Mortgage Type
VA
Estimated Equity
$145,607

Purchase Details

Listed on
Jun 12, 2019
Closed on
Jul 22, 2019
Sold by
Braxton Julia
Bought by
Braxton Julia and Braxton Aaron Stephen
Seller's Agent
Tony Haddad
Keller Williams Realty Lakeside
Buyer's Agent
Bryan Washington
EXP Realty LLC
List Price
$359,950
Sold Price
$363,000
Premium/Discount to List
$3,050
0.85%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
14.95%
Original Mortgage
$344,850
Interest Rate
4.11%
Mortgage Type
Adjustable Rate Mortgage/ARM

Purchase Details

Listed on
Jun 12, 2019
Closed on
Jun 22, 2019
Sold by
Holman James R and Holman Nicolette
Bought by
Braxton Julia
Seller's Agent
Tony Haddad
Keller Williams Realty Lakeside
Buyer's Agent
Bryan Washington
EXP Realty LLC
List Price
$359,950
Sold Price
$363,000
Premium/Discount to List
$3,050
0.85%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$344,850
Interest Rate
4.11%
Mortgage Type
Adjustable Rate Mortgage/ARM
Source: Public Records

Range of Values:

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
Adhikari Ann Marie $485,000 Visionary Title Agency Llc
Braxton Julia -- Liberty Title
Braxton Julia $363,000 Fpt
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Adhikari Ann Marie $470,000
Previous Owner Braxton Julia $344,850
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
08/18/2021 08/18/21 Sold $485,000 +12.8% $121 / Sq Ft
07/13/2021 07/13/21 Pending -- -- --
06/26/2021 06/26/21 For Sale $429,900 +18.4% $107 / Sq Ft
07/22/2019 07/22/19 Sold $363,000 +0.8% $90 / Sq Ft View Prior Sale
06/16/2019 06/16/19 Pending -- -- --
06/12/2019 06/12/19 For Sale $359,950 -- $90 / Sq Ft
Source: Michigan Multiple Listing Service

Tax History Compared to Growth

Source: Public Records

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 $6,019 $248,300 $0 $0
2024 $3,917 $238,500 $0 $0
2023 $3,709 $221,900 $0 $0
2022 $5,456 $195,100 $0 $0
2021 $5,159 $184,700 $0 $0
2020 $3,313 $180,700 $0 $0
2019 $3,707 $159,800 $0 $0
2018 $3,654 $155,000 $0 $0
2017 $3,607 $150,000 $34,500 $115,500
2016 $3,399 $150,000 $0 $0
2015 $3,358 $139,880 $0 $0
2014 $3,358 $126,270 $23,500 $102,770
2013 $2,142 $126,270 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Yvonne Zielinski

    Seller's Agent in 2021

    Yvonne Zielinski

    Epique Inc.

    (586) 738-5543

    10 in this area

    118 Total Sales

    Yvonne Zielinski
    Section Image
  • Tony Haddad

    Seller's Agent in 2019

    Tony Haddad

    Keller Williams Realty Lakeside

    (586) 854-7720

    6 in this area

    81 Total Sales

    Tony Haddad
    Section Image
  • Bryan Washington

    Buyer's Agent in 2019

    Bryan Washington

    EXP Realty LLC

    (989) 429-4663

    18 Total Sales

    Bryan Washington
    Section Image
See All Agents

Map

Source: Michigan Multiple Listing Service

MLS Number: 50046258

Michigan Multiple Listing Service

APN: 20-08-06-329-002

Michigan Macomb County Macomb 48042

15658 Retreat Dr, Macomb, MI

This home is located at 15658 Retreat Dr, Macomb, MI 48042 since 24 June 2021 and is currently estimated at $571,688, approximately $142 per square foot. This property was built in 2000. 15658 Retreat Dr is a home located in Macomb County with nearby schools including Richard J. Duncan Elementary, Shelby Junior High School, and Eisenhower High School.

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.

Michigan Multiple Listing Service Source MLS: MiRealSource
Provided through IDX via MiRealSource. Courtesy of MiRealSource Shareholder. Copyright MiRealSource.

The information published and disseminated by MiRealSource is communicated verbatim, without change by MiRealSource, as filed with MiRealSource by its members. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified.

Copyright 2025 MiRealSource. All rights reserved. The information provided hereby constitutes proprietary information of MiRealSource, Inc. and its shareholders, affiliates and licensees and may not be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopy, recording, scanning or any information storage and retrieval system, without written permission from MiRealSource, Inc.

Nearby Homes