NOT LISTED FOR SALE

23404 Streamview St Unit 71 Macomb, MI 48042

Estimated Value: $318,000 - $406,000

2 Beds
2 Baths
1,702 Sq Ft
$175/mo HOA Fee

Last Sold December 07, 2012

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

Est. 72% increase in value since last sale

Current estimated payment $2,405/month

5 Days on Market

Highlights

  • Water Views
  • Outdoor Pool
  • 2 Car Attached Garage
  • 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

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

  • Outdoor 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

0

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

  • Room Count: 10
  • Total Bedrooms: 2
  • Total Bathrooms: 2.00
  • Full Bathrooms: 2
  • Basement: Yes
  • Sq Ft Combined: 1702
  • 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

Schools

  • School District: New Haven

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

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
Zoulas Faye
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%
Total Days on Market
5
Current Estimated Value
$377,728

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$158,648
Avg. Annual Appreciation
5.26%

Purchase Details

Closed on
May 21, 2009
Sold by
Lombardo North Avenue Properties Llc
Bought by
Pulte Land Company Llc
Source: Public Records

Similar Homes in the area

  • 49234 Jacob Ct, Macomb, MI 48042

    $419,500

    • 2 Beds
    • 2.5 Baths
    • 2,001 Sq Ft
    • 49234 Jacob Ct
    • Macomb, MI

    This beautiful Condo was completed in 2019 a custom-built end unit is your retirement dream! situated in a quiet court this all Brick 2 bed 2 bath unit has everything you need. Move in ready this home features a gourmet kitchen, built in oven and cook top. A spacious island for gatherings and entertaining! premium flooring and lighting, A bright open floor plan and massive door wall that opens

    Shayla Haboosh ICON Realty Experts, LLC

    Section Image
  • 22093 Andover Dr, Macomb, MI 48042

    $319,000

    • 2 Beds
    • 2 Baths
    • 1,596 Sq Ft
    • 22093 Andover Dr
    • Macomb, MI

    Sprawling upper level 2 bedroom 2 bath ranch style condo with a 2 car attached garage built in 2022! Open concept split ranch floor plan featuring a massive great room w/cathedral ceiling, corner gas fireplace & glass panel door to the covered deck/balcony! Spacious dining rm! Large kitchen w/plenty of cabinetry, granite counter tops, a break fast bar, stainless appliances & recessed lighting!

    Jason Minnick Market Elite Inc

    Section Image
  • 21925 Andover Dr, Macomb, MI 48042

    $295,000

    • 2 Beds
    • 2 Baths
    • 1,445 Sq Ft
    • 21925 Andover Dr
    • Macomb, MI

    Welcome home to Hartford Village Condominiums. Enjoy your large Community Center with private key-fob entrance to the clubhouse, pool, hot tub and fitness center. Your 2 Bedroom condo features a First Floor End Unit with 9' ceilings, granite throughout, large walk-in closets, private full sized washer and dryer - included and a Primary Suite with its own full bathroom and large walk-in closet.

    Kimberly Crosby Epique Inc.

    Section Image
  • 45693 Beaufort Dr, Macomb, MI 48044

    $379,711

    • 3 Beds
    • 2.5 Baths
    • 1,610 Sq Ft
    • 45693 Beaufort Dr
    • Macomb, MI

    This home is to be built with an estimated move-in of May/June 2025. New duet condominiums in sought-after Macomb Twp & within the Chippewa Valley district! Lombardo Homes proudly present the GLENBURY in Windemere Farms II! 1,610 sq. ft., 3 beds, 2.5 baths, & 2-car front-entry garage. Beautiful kitchen with 42'' upper cabinets, hardwood flooring, and stainless steel appliances: gas range,

    Anthony Lombardo Lombardo Realty

    Section Image
  • 45675 Beaufort Dr, Macomb, MI 48044

    $400,250

    • 3 Beds
    • 3 Baths
    • 1,777 Sq Ft
    • 45675 Beaufort Dr
    • Macomb, MI

    This home is to-be-built with an estimated move-in May/June 2025 . New duet condominiums in sought-after Macomb Twp and within the Chippewa Valley school district! Lombardo Homes proudly presents the BRADBURY in Windemere Farms II! 1,777 sq. ft., 3 beds, 3 baths, 2-car front-entry garage, and full basement. This home features a beautiful kitchen with 42? upper cabinets, an island, hardwood

    Anthony Lombardo Lombardo Realty

    Section Image
  • 20787 Burn Dr, Macomb, MI 48044

    $338,990

    • 2 Beds
    • 2 Baths
    • 1,345 Sq Ft
    • 20787 Burn Dr
    • Macomb, MI

    TO BE BUILT! Build time is approx. 8-10 months. New Condos in sought after Macomb Township with Chippewa Valley School District. Lombardo Homes proudly presents the BRADBURY II in Windemere Farms! We offer ranch and colonial style condos ranging from 1,345 - 1,780 sq. ft. This condo offers an open concept that is perfect for entertaining and spending time with loved ones. Unwind in your Master

    Anthony Lombardo Lombardo Realty

    Section Image
  • 20840 Burn Dr, Macomb Township, MI 48044

    $359,990

    • 2 Beds
    • 2.5 Baths
    • 1,610 Sq Ft
    • 20840 Burn Dr
    • Macomb Township, MI

    This home is to be built with an estimated move-in of Feb/Mar. New duet condominiums in sought-after Macomb Twp & within the Chippewa Valley district! Lombardo Homes proudly presents the GLENBURY in Windemere Farms II! 1,610 sq. ft., 2 beds, 2.5 baths, loft, & 2-car front-entry garage. The full basement is prepped for a future bath. Beautiful kitchen with 42'' upper cabinets, hardwood flooring,

    Anthony Lombardo Lombardo Realty

    Section Image
  • 20779 Burn Dr, Macomb, MI 48044

    $338,990

    • 2 Beds
    • 2 Baths
    • 1,345 Sq Ft
    • 20779 Burn Dr
    • Macomb, MI

    TO BE BUILT! Build time is approx. 8-10 months. New Condos in sought after Macomb Township with Chippewa Valley School District. Lombardo Homes proudly presents the BRADBURY in Windemere Farms! We offer ranch and colonial style condos ranging from 1,345 - 1,780 sq. ft. This condo offers an open concept that is perfect for entertaining and spending time with loved ones. Unwind in your Master

    Anthony Lombardo Lombardo Realty

    Section Image
  • 20800 Burn Dr, Macomb, MI 48044

    $365,275

    • 2 Beds
    • 2 Baths
    • 1,345 Sq Ft
    • 20800 Burn Dr
    • Macomb, MI

    This home is to be built with an estimated move-in of 8-10 months. New duet condominiums in sought-after Macomb Twp & within the Chippewa Valley district! Lombardo Homes proudly presents the BRADBURY in Windemere Farms II! We offer ranch, ranch with 2nd floor, & split level condominiums ranging from 1,345-1771 sq. ft. This home offers an open concept that is perfect for entertaining and spending

    Anthony Lombardo Lombardo Realty

    Section Image
See All Homes in Macomb

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
Zoulas Faye $219,080 None Available
Pulte Land Company Llc -- None Available
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
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 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
2024 $2,706 $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

  • J

    Seller's Agent in 2012

    John Fabirkiewicz

    Marketplace Homes

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

This home is located at 23404 Streamview St Unit 71, Macomb, MI 48042 since 18 September 2012 and is currently estimated at $377,728, approximately $221 per square foot. This property was built in 2012. 23404 Streamview St Unit 71 is a home located in Macomb County with nearby schools including New Haven High School and Austin Catholic Academy.

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 2025 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