NOT LISTED FOR SALE

23377 Streamview St Macomb, MI 48042

Estimated Value: $314,000 - $420,000

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

Last Sold November 04, 2019

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

Est. 24% increase in value since last sale

Current estimated payment $2,616/month

18 Days on Market

Highlights

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

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

Outdoor Features

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

0

HOA Fees

$254 per month

Listing Details

  • Originating MLS: MiRealSource
  • Class: RESIDENTIAL
  • Type Of Property: Condominium
  • Architecture Style: Ranch
  • Structure Style: 1 Story
  • 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
  • Taxable Value: 136660
  • Total Tax: Year: 2018, Amount: $4,116.00
  • SEV Year: 2018

MLS Schools

  • School District: New Haven Community Schools

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Sep 23, 2019
Closed on
Nov 4, 2019
Sold by
Ouellette William and Ouellette Pamela
Bought by
Kelley Julia A
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%
Total Days on Market
18
Current Estimated Value
$387,937

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$75,937
Avg. Annual Appreciation
5.55%
Original Mortgage
$234,000
Outstanding Balance
$208,263
Interest Rate
3.65%
Mortgage Type
New Conventional
Estimated Equity
$214,026

Purchase Details

Listed on
Jan 19, 2016
Closed on
Mar 28, 2016
Sold by
Fulcher Raymond L and Fulcher Michelle M
Bought by
Ouellette William and Ouellette Pamela
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
Pulte Land Company Llc
Bought by
Fulcher Raymond L and Fulcher Michelle M

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$162,512
Interest Rate
3.97%
Mortgage Type
New Conventional

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
  • 20480 Banbury Ct, Macomb, MI 48044

    $498,990

    • 2 Beds
    • 2.5 Baths
    • 1,766 Sq Ft
    • 20480 Banbury Ct
    • Macomb, MI

    To be built and estimated move in August-October. Welcome to this beautifully designed new ranch floorplan, The Alcott. This home offers the perfect blend of comfort and style. This spacious two bedroom, 2 bathroom home also features a versatile den, ideal for home office, guest space or hobby room. Step inside to an inviting open floor plan, where the bright and airy living area flows

    Heather Shaffer PH Relocation Services LLC

    Section Image
  • 20505 W Kilburn Dr, Macomb, MI 48044

    $474,990

    • 2 Beds
    • 2 Baths
    • 1,766 Sq Ft
    • 20505 W Kilburn Dr
    • Macomb, MI

    December 2025-February 2026 Ready. Welcome to this beautifully designed new ranch floorplan, The Alcott. This home offers the perfect blend of comfort and style. This spacious two bedroom, 2 bathroom home also features a versatile den, ideal for home office, guest space or hobby room. Step inside to an inviting open floor plan, where the bright and airy living area flows seamlessly into the

    Heather Shaffer PH Relocation Services LLC

    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

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
Kelley Julia A $312,000 Title One Inc
Ouellette William $275,000 Liberty Title
Fulcher Raymond L $203,140 Pgp Title
Pulte Land Company Llc -- None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Kelley Julia A $87,389
Open Kelly Julia A $234,000
Previous Owner Ouellette William $250,400
Previous Owner Ouellette William $165,000
Previous Owner Fulcher Raymond L $162,512
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
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
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 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 $3,632 $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

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Michigan Multiple Listing Service

MLS Number: 31395224

Michigan Multiple Listing Service

APN: 20-08-24-325-051