NOT LISTED FOR SALE

23404 Streamview St Unit 71 Macomb, MI 48042

Macomb Area

Estimated Value: $426,149

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

Sale Details

Date Sold: December 7, 2012

Last sale price $219,080 $129 Per Sq Ft

Est. 95% increase in value since last sale

Current estimated payment $2,943 / mo

5 Days on Market

Highlights

  • Water Views
  • Pool
  • 2 Car Attached Garage
  • Built in 2012 | Newly Remodeled
  • Clubhouse
  • 1-Story Property

About This Home

As of December 2012

Beautiful 2 bedroom ranch with study located on private pond! Amazing community with clubhouse and community pool. Condo living at its finest with great location.

Last Agent to Sell the Property

John Fabirkiewicz

Marketplace Homes License #6501365676 Listed on: 09/18/2012

Last Buyer's Agent

John Fabirkiewicz

Marketplace Homes License #RCO-6501365676

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

Property Details

Home Type

  • Condominium

Est. Annual Taxes

Year Built

  • Built in 2012 | Newly Remodeled

Lot Details

  • 1

HOA Fees

  • $175 Monthly HOA Fees

Parking

  • 2 Car Attached Garage

Home Design

  • Brick Exterior Construction
  • Vinyl Construction Material

Interior Spaces

  • 1,702 Sq Ft Home
  • 1-Story Property
  • Water Views
  • Basement

Bedrooms and Bathrooms

  • 2 Bedrooms
  • 2 Full Bathrooms

Pool

Utilities

  • Forced Air Heating System
  • Heating System Uses Natural Gas

Listing and Financial Details

  • Assessor Parcel Number 0824325071

Community Details

Overview

  • The Sandstone At The Retreat Condo #956 Subdivision

Amenities

  • Clubhouse

Recreation

  • Community Pool

Property Details

Home Type

Condominium

Est. Annual Taxes

$501

Year Built

Built in 2012 | Newly Remodeled

Lot Details

1 Acres

HOA Fees

$175 per month

Listing Details

  • Property Type: Condominium
  • Architecture Level: 1 Story
  • Year Built: 2012
  • Special Features: NewHome
  • Property Sub Type: Condos
  • Stories: 1

Interior Features

  • Total Bedrooms: 2
  • Total Bathrooms: 2.00
  • Full Bathrooms: 2
  • Basement: Yes
  • Total Sq Ft: 1702

Exterior Features

  • Pool: Yes
  • Foundation Details: Basement
  • Construction Materials: Brick, Vinyl
  • Construction Features: New Construction
  • Exterior Features: Club House, Pool – Community
  • Road Frontage Type: Paved

Garage/Parking

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

Utilities

  • Heating Fuel: Natural Gas
  • Heating: Forced Air
  • Water Source: Public (Municipal)
  • Laundry Facilities: No

Condo/Co-op/Association

  • Association Fee Frequency: Monthly
  • Association Fee: 175
  • Association Fee: No

Lot Info

  • Lot Features: Water View
  • Parcel Number: 0824325071

Tax Info

  • Tax Amount Summer: 303.0000
  • Tax Amount Winter: 198.0000
  • Total Tax: 501.0000

MLS Schools

  • School District: New Haven

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 18, 2012
Closed on
Dec 7, 2012
Sold by
Pulte Land Co Llc
Bought by
Seller's Agent
John Fabirkiewicz
Marketplace Homes
Buyer's Agent
John Fabirkiewicz
Marketplace Homes
List Price
$219,835
Sold Price
$219,080
Premium/Discount to List
-$755
-0.34%
Current Estimated Value
$426,149

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$207,069
Avg. Annual Appreciation
4.94%

Purchase Details

Closed on
May 21, 2009
Sold by
Lombardo North Avenue Properties Llc
Bought by
Pulte Land Company Llc
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

  • Louis Bitto Real Estate Agent - USA #1 Realty LLC

    Louis Bitto

    USA #1 Realty LLC

    (586) 571-8032

    123 Total Sales

    5 in Macomb

    $75K - $660K Price Range

    Louis Bitto
     Section Image
  • Eric Jurmo Real Estate Agent - KW Platinum

    Eric Jurmo

    KW Platinum

    (586) 666-6303

    247 Total Sales

    22 in Macomb

    $140K - $630K Price Range

    Eric Jurmo
     Section Image
  • Laura Pazdzierz Real Estate Agent - Brookstone, Realtors LLC

    Laura Pazdzierz

    Brookstone, Realtors LLC

    (947) 219-0617

    43 Total Sales

    3 in Macomb

    $275K - $565K Price Range

    Laura Pazdzierz
     Section Image
  • Jamison Agnello Real Estate Agent - J Michael Realty LLC

    Jamison Agnello

    J Michael Realty LLC

    (517) 701-3594

    123 Total Sales

    7 in Macomb

    $272K - $630K Price Range

    Jamison Agnello
     Section Image
  • Josh Taylor Real Estate Agent - Good Company

    Josh Taylor

    Good Company

    (947) 941-2791

    19 Total Sales

    1 in Macomb

    $327,000 Price

    Josh Taylor
     Section Image
  • Claudia Abel Passalacqua Real Estate Agent - Keller Williams Realty Great Lakes

    Claudia Abel Passalacqua

    Responds Quickly

    Keller Williams Realty Great Lakes

    (313) 710-1612

    102 Total Sales

    3 in Macomb

    $315K - $425K Price Range

    Claudia Abel Passalacqua
     Section Image
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
$219,080 None Available
Pulte Land Company Llc -- None Available
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
12/07/2012 12/07/12 Sold $219,080 -0.3% $129 / Sq Ft
09/23/2012 09/23/12 Pending -- -- --
09/18/2012 09/18/12 For Sale $219,835 -- $129 / 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 $4,346 $207,000 $0 $0
2025 $2,782 $197,000 $0 $0
2024 $27 $191,000 $0 $0
2023 $2,565 $171,100 $0 $0
2022 $3,842 $153,200 $0 $0
2021 $3,739 $150,300 $0 $0
2020 $2,358 $146,200 $0 $0
2019 $3,456 $143,700 $0 $0
2018 $3,261 $139,500 $0 $0
2017 $3,219 $124,950 $19,500 $105,450
2016 $3,047 $124,990 $0 $0
2015 $3,055 $113,160 $0 $0
2014 $3,055 $103,810 $12,500 $91,310
2011 $225 $11,000 $11,000 $0
Source: Public Records

Agents Affiliated with this Home

  • JF

    Seller's Agent in 2012

    John Fabirkiewicz

    Marketplace Homes

    Section Image
See All Agents

Map

Source: Realcomp

MLS Number: 212097491

Realcomp

APN: 20-08-24-325-071

Michigan Macomb County Macomb 48042

23404 Streamview St Unit 71, 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.

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.