$312,000
SOLD NOV 4, 2019

23377 Streamview St Macomb, MI 48042

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

Recently Sold

$183 Per Sq Ft

2% Below List Price

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.54%
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

  • 45535 Heather Ridge Dr Unit 102, Macomb, MI 48044

    $250,000

    • 2 Beds
    • 2 Baths
    • 1,375 Sq Ft
    • 45535 Heather Ridge Dr
    • Unit 102
    • Macomb, MI

    2nd Floor, 2 Bedroom Great Room Ranch Condo with 1 car garage, 2 full bathrooms, large balcony. New quartz counters in updated kitchen with stainless steel appliances. Nice open floor plan. Beautiful solid surface floors thru ought. Fireplace in great room with cathedral ceilings. Extra storage space in garage. Immediate possession. Community pool.

    Thomas Zibkowski Real Estate One Inc-Shelby

    Section Image
  • 46777 Scotch Pine Ln, Macomb, MI 48042

    $279,000

    • 2 Beds
    • 2.5 Baths
    • 2,395 Sq Ft
    • 46777 Scotch Pine Ln
    • Macomb, MI

    Absolutely Immaculate! Fall in love with this stunning 2-bedroom, 2.5-bath condo featuring a full-size FINISHED WALK-OUT BASEMENT overlooking a serene and scenic setting. The main level offers a spacious great room with soaring vaulted ceilings & skylights that flood the space with natural light. Enjoy meals in the large dining area with a doorwall leading to a private balcony/deck—perfect for

    Janice Plaskon Berkshire Hathaway HomeServices Kee Realty

    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
  • 21083 Cooper Dr Unit 26, Macomb, MI 48044

    $229,900

    • 2 Beds
    • 2 Baths
    • 1,540 Sq Ft
    • 21083 Cooper Dr
    • Unit 26
    • Macomb, MI

    Very spacious open-concept upper-unit condo with attached garage and private balcony. The entire unit features updated flooring, light fixtures, and a cathedral ceiling with neutral color wall paint throughout. Living room and kitchen with newer recessed lights. Electric Fireplace in the living room adds elegance and a sleek look. Large master suite with full bath and custom-made walk-in closet.

    Malgorzata Sepko Select Real Estate Professionals

    Section Image
  • 45700 Gable Dr Unit 8, Macomb, MI 48044

    $274,900

    • 2 Beds
    • 2 Baths
    • 1,653 Sq Ft
    • 45700 Gable Dr
    • Unit 8
    • Macomb, MI

    Uptown Luxury Meets Everyday Affordability! Welcome to this stunning condo that delivers high-rise sophistication with the warmth of home. Designed for those who crave modern elegance, this residence has been thoughtfully updated with no expense spared. From the moment you enter, you’ll appreciate the upscale touches—granite countertops, a deluxe front-loading washer and dryer, and a dishwasher

    Andrea DeGasperis Berkshire Hathaway HomeServices Kee Realty Oxford

    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 Type Sale Price Title Company
Warranty Deed $312,000 Title One Inc
Warranty Deed $275,000 Liberty Title
Warranty Deed $203,140 Pgp Title
Warranty Deed -- None Available
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $87,389 Unknown
Open $234,000 New Conventional
Previous Owner $250,400 Credit Line Revolving
Previous Owner $165,000 New Conventional
Previous Owner $162,512 New Conventional
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