NOT LISTED FOR SALE

23377 Streamview St Macomb, MI 48042

Estimated Value: $412,000 - $479,000

2 Beds
2 Baths
1,702 Sq Ft
1 Acres Lot

Sale Details

Date Sold: November 4, 2019

Last sale price $312,000 $183 Per Sq Ft

Est. 39% increase in value since last sale

Current estimated payment $2,903 / mo

18 Days on Market

Highlights

  • Pool
  • Clubhouse
  • Wood Flooring
  • Gated Community
  • Ranch Style House
  • Corner Lot

About This Home

As of November 2019

OPEN HOUSE SAT 10/5 12-2 PM Gorgeous Split Ranch Condo 2 Bedroom -2 Bath with a Den! Meticulously Clean just move right in! Cathedral ceilings in Great Room w/ Gas Fireplace & formal Dining Room- Beautiful kitchen with tons of Maple Cabinets- Appliances stay, Granite island w/ more cabinets & a Pantry- Master suite w/soaking tub, Double Granite sink , nice Large Shower & Walk-In Closet - 2nd bedroom also nice size w/ large closet. Den w/ french doors, 1st floor laundry w more cabinets! Finished Basement w/ 1/2 Bath - 2 car garage - nice landscaping & sidewalks 2 pets allowed ! Immediate Occupancy ! GORGEOUS 5000 SQUARE FOOT CLUBHOUSE INCLUDING POOL, WORKOUT FACILITIES, COMPUTER ROOM, GAME ROOM & A GREAT ROOM FOR SOCIALIZING ! come see today !

Last Agent to Sell the Property

Susan Parker

Century 21 Professionals License #MISPE-6501344379 Listed on: 09/23/2019

Century 21 Professionals

Last Buyer's Agent

Auday Putrus

Top Agent Realty License #MISPE-6506049238

Property Details

Home Type

  • Condominium

Est. Annual Taxes

Year Built

  • Built in 2011

Lot Details

  • Sprinkler System

HOA Fees

  • $254 Monthly HOA Fees

Home Design

  • Ranch Style House
  • Brick Exterior Construction
  • Vinyl Trim

Interior Spaces

  • 1,702 Sq Ft Home
  • Gas Fireplace
  • Bay Window
  • Great Room with Fireplace
  • Den
  • Finished Basement
  • Sump Pump

Kitchen

  • Oven or Range
  • Microwave
  • Dishwasher

Flooring

  • Wood
  • Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

  • 2 Bedrooms
  • 2 Full Bathrooms

Parking

  • 2 Car Attached Garage
  • Garage Door Opener

Pool

Outdoor Features

  • Patio
  • Porch

Utilities

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

Listing and Financial Details

  • Assessor Parcel Number 2008-24-325-051

Community Details

Overview

  • Sandstone @ The Retreat HOA
  • The Sandstone At The Retreat Subdivision
  • Maintained Community

Recreation

  • Exercise Course
  • Community Spa

Pet Policy

  • Dogs and Cats Allowed

Additional Features

  • Clubhouse
  • Gated Community

Property Details

Home Type

Condominium

Est. Annual Taxes

$4,116

Year Built

Built in 2011

Lot Details

1 Acres

HOA Fees

$254 per month

Listing Details

  • Originating MLS: MiRealSource
  • Class: RESIDENTIAL
  • Type Of Property: Condominium
  • Architecture Style: Ranch
  • Structure Style: 1 Story
  • Total Tax Amount: 4116
  • Total Tax Year: 2018
  • Year Built: 2011
  • Mail City: Macomb Twp
  • Special Features: None
  • Property Sub Type: Condos
  • Stories: 1

Interior Features

  • Interior Amenities: Bay Window, Ceramic Floors, Hardwood Floors
  • Appliances: Dishwasher, Microwave, Range/Oven, Refrigerator
  • Fireplace: Yes
  • Fireplaces: Gas Fireplace, Grt Rm Fireplace
  • Basement: Yes
  • Basement: Finished, Sump Pump
  • Bedrooms: 2
  • Bedroom 1: On 1st Floor, Dimensions: 15 x 12
  • Bedroom 1 Floor Covering: Carpet
  • Bedroom 2: On 1st Floor, Dimensions: 13 x 12
  • Bedroom 2 Floor Covering: Carpet
  • Full Bathrooms: 2
  • Total Bathrooms: 3
  • Below Grade Bedrooms: 1
  • Bathroom 1: On Level: First
  • Bathroom 2: On Level: First
  • Room Types: Den/Study/Lib, First Floor Bedroom, First Floor Laundry, First Flr Primary Bedroom, Great Room, Primary Bathroom
  • Dining Room: On 1st Floor, Dimensions: 15 x 10
  • Great Room: On 1st Floor, Dimensions: 17 x 15
  • Kitchen: On 1st Floor, Dimensions: 21 x 12
  • Library Den: On 1st Floor, Dimensions: 12 x 10
  • Below Grade Sq Ft: 1700
  • Half Bathrooms: 1
  • Above Grade Finished Sq Ft: 1702
  • Total Finished Sq Ft: 1702

Exterior Features

  • Pool: Yes
  • Exterior: Brick, Vinyl Trim
  • Exterior Features: Lawn Sprinkler, Patio, Porch, Sidewalks, Street Lights
  • Foundation: Basement
  • Road: Curbed, Paved Street, City/County

Garage/Parking

  • Garage: Gar Door Opener, Attached Garage, Electric in Garage
  • Garage Spaces: 2
  • Parking: Garage
  • Garage: Yes

Utilities

  • Heating: Forced Air
  • Heating Fuel: Natural Gas
  • Sewer: Public Sanitary
  • Water: Public Water
  • Water Heater: Gas
  • Cooling: Central A/C

Condo/Co-op/Association

  • HOA Fees: 254
  • HOA Fee Frequency: Monthly
  • Community Features: Club House, Exercise/Facility Room, Gate House, Grounds Maintenance, Pool/Hot Tub, Pets-Allowed, Dogs Allowed, Cats Allowed
  • Association Contact: Sandstone @ the Retreat
  • Pets: Yes
  • Association Fee: Yes

Lot Info

  • Assessor Parcel Number: 2008-24-325-051
  • Zoning: Residential
  • Geo Subdivision: MI
  • Site/Lot Features: Corner Lot, Subdivision

Rental Info

  • Pets Allowed: Yes
  • Pet Restriction: Dogs Allowed, Cats Allowed

Tax Info

  • Summer Tax: Year: 2018, Amount: $2,532.00
  • Winter Tax: Year: 2018, Amount: $1,583.00
  • Total Tax: Year: 2018, Amount: $4,116.00

MLS Schools

  • School District: New Haven Community Schools

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
Sep 23, 2019
Closed on
Nov 4, 2019
Sold by
Bought by
Seller's Agent
Susan Parker
Century 21 Professionals
Buyer's Agent
Auday Putrus
Top Agent Realty
List Price
$319,000
Sold Price
$312,000
Premium/Discount to List
-$7,000
-2.19%
Current Estimated Value
$433,594

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$121,594
Avg. Annual Appreciation
5.09%

Purchase Details

Listed on
Jan 19, 2016
Closed on
Mar 28, 2016
Sold by
Bought by
Seller's Agent
Alex Nugent
Real Estate One-Troy
Buyer's Agent
Susan Parker
Century 21 Professionals Utica
List Price
$275,000
Sold Price
$275,000

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
3.56%
Original Mortgage
$165,000
Interest Rate
3.12%
Mortgage Type
New Conventional

Purchase Details

Closed on
Dec 29, 2011
Sold by
Bought by

Purchase Details

Closed on
May 21, 2009
Sold by
Bought by
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

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
$312,000 Title One Inc
$275,000 Liberty Title
$203,140 Pgp Title
-- None Available
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 $165,000
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
11/04/2019 11/04/19 Sold $312,000 -2.2% $183 / Sq Ft
10/11/2019 10/11/19 Pending -- -- --
09/23/2019 09/23/19 For Sale $319,000 +16.0% $187 / Sq Ft
03/28/2016 03/28/16 Sold $275,000 0.0% $162 / Sq Ft View Prior Sale
01/25/2016 01/25/16 Pending -- -- --
01/19/2016 01/19/16 For Sale $275,000 -- $162 / Sq Ft
Source: Michigan Multiple Listing Service

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
2025 $3,734 $205,700 $0 $0
2024 $36 $199,500 $0 $0
2023 $3,442 $178,700 $0 $0
2022 $5,156 $160,100 $0 $0
2021 $4,992 $156,400 $0 $0
2020 $3,148 $152,000 $0 $0
2019 $4,330 $142,500 $0 $0
2018 $4,116 $138,700 $0 $0
2017 $4,032 $123,940 $19,500 $104,440
2016 $3,022 $123,980 $0 $0
2015 $3,030 $112,240 $0 $0
2014 $3,030 $102,970 $12,500 $90,470
2013 $1,881 $102,970 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Susan Parker

    Seller's Agent in 2019

    Susan Parker

    Century 21 Professionals

    (586) 322-3641

    2 in this area

    41 Total Sales

    Susan Parker
    Section Image

  • A

    Buyer's Agent in 2019

    Auday Putrus

    Top Agent Realty

    Section Image
  • Alex Nugent

    Seller's Agent in 2016

    Alex Nugent

    Real Estate One

    (248) 840-3111

    5 in this area

    169 Total Sales

    Alex Nugent
    Section Image
See All Agents

Map

Source: Michigan Multiple Listing Service

MLS Number: 31395224

Michigan Multiple Listing Service

APN: 20-08-24-325-051

Michigan Macomb County Macomb 48042

23377 Streamview St, Macomb, MI

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 2026 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
Your Personal Tour Guide

Ask me questions while you tour the home.