$275,000
SOLD MAR 28, 2016

23377 Streamview St Macomb, MI 48042

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

Recently Sold

$162 Per Sq Ft

6 Days on Market

Highlights

  • Outdoor Pool
  • Ranch Style House
  • 2 Car Direct Access Garage
  • Clubhouse
  • Covered patio or porch
  • Forced Air Heating and Cooling System

About This Home

As of November 2019

GORGEOUS MACOMB CONDO IN THE HIGHLY SOUGHT AFTER SANDSTONE AT THE RETREAT COMMUNITY. ENJOY MAINTENANCE FREE LIVING ON THIS PREMIUM CORNER LOT BACKING UP TO QUIET WOODED SETTING. NEIGHBORHOOD FEATURES CLUB HOUSE AND COMMUNITY POOL! INSIDE THE HOME, FIND A LARGE KITCHEN WITH BEAUTIFUL HARDWOOD FLOORS, GRANITE COUNTER TOPS & GLASS TILE BACKSPLASH. THE BREAKFAST NOOK HAS DOORWALL ACCESS TO PATIO, AND LEADS THROUGH TO THE GREATROOM BOASTING HIGH CEILINGS, FIREPLACE, AND FORMAL DINING AREA. THE MASTER SUITE FEATURES WALK IN CLOSET AND ATTACHED BATH WITH DUAL SINKS AND SEPARATE TUB & SHOWER. ADDITIONALLY ON THE ENTRY LEVEL, A LARGE SECOND BEDROOM, ADDITIONAL FULL BATH, LAUNDRY ROOM AND A DEN/OFFICE SPACE WITH FRENCH DOORS. THE BASEMENT IS FULLY FINISHED, WITH PLENTY OF ADDITIONAL LIVING SPACE AND A HALF BATH. PLUS A BONUS - SALE TO INCLUDE LEATHER COUCH AND ELLIPTICAL MACHINE! DO NOT MISS OUT ON THIS GREAT CONDO!

Last Agent to Sell the Property

Alex Nugent

Real Estate One-Troy License #6501278515 Listed on: 01/19/2016

Real Estate One-Troy

Last Buyer's Agent

Susan Parker

Century 21 Professionals Utica License #6501344379

Century 21 Professionals Utica

Property Details

Home Type

  • Condominium

Est. Annual Taxes

Year Built

  • Built in 2011

Lot Details

  • Property fronts a private road

HOA Fees

  • $200 Monthly HOA Fees

Parking

  • 2 Car Direct Access Garage

Home Design

  • Ranch Style House
  • Brick Exterior Construction
  • Poured Concrete
  • Asphalt Roof
  • Vinyl Construction Material

Interior Spaces

  • 1,702 Sq Ft Home
  • Ceiling Fan
  • Gas Fireplace
  • Great Room with Fireplace
  • Finished Basement
  • Sump Pump

Kitchen

  • Microwave
  • Dishwasher

Bedrooms and Bathrooms

  • 2 Bedrooms

Laundry

  • Dryer
  • Washer

Outdoor Features

  • Outdoor Pool
  • Covered patio or porch

Utilities

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

Listing and Financial Details

  • Assessor Parcel Number 0824325051

Community Details

Overview

  • The Sandstone At The Retreat Condo #956 Subdivision
  • On-Site Maintenance

Amenities

  • Clubhouse

Recreation

  • Community Pool

Property Details

Home Type

Condominium

Est. Annual Taxes

$3,061

Year Built

Built in 2011

Lot Details

0

HOA Fees

$200 per month

Listing Details

  • Property Type: Condominium
  • Architecture Style: Ranch
  • Architecture Level: 1 Story
  • Year Built: 2011
  • Foundation Features: Sump Pump
  • Special Features: None
  • Property Sub Type: Condos
  • Stories: 1

Interior Features

  • Interior Amenities: Humidifier
  • Fireplace: Yes
  • Fireplace Fuel: Gas
  • Fireplace Locations: Great Room
  • Room Count: 9
  • Total Bedrooms: 2
  • Total Bathrooms: 2.10
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Basement: Yes
  • Basement Type: Finished
  • Kitchen Appliances: Dishwasher, Dryer, Microwave, Refrigerator, Range/Stove, Washer
  • Sq Ft Combined: 3102
  • Sq Ft Lower Floor: 1400
  • Total Sq Ft: 1702
  • Sq Ft Total Bsmt: 1500

Exterior Features

  • Roof Material: Asphalt
  • Pool: Yes
  • Foundation Details: Basement
  • Construction Materials: Brick, Vinyl
  • Exterior Features: Club House, Grounds Maintenance, Pool – Community
  • Foundation Materials: Poured
  • Porch Type: Patio, Porch - Covered
  • Road Frontage Type: Private

Garage/Parking

  • Garage Size: 2 Car
  • Garage Features: Attached, Direct Access, Electricity
  • Garage: Yes

Utilities

  • Heating Fuel: Natural Gas
  • Cooling: Ceiling Fan(s), Central Air
  • Heating: Forced Air
  • Sewer: Public Sewer (Sewer-Sanitary)
  • Water Heater Fuel: Natural Gas
  • Water Source: Public (Municipal)
  • Laundry Facilities: No

Condo/Co-op/Association

  • Association Fee Frequency: Monthly
  • Association Fee: 200
  • Association Fee: No

Schools

  • School District: New Haven

Lot Info

  • Homestead: Yes
  • Parcel Number: 0824325051

Tax Info

  • Tax Amount Summer: 1984.0000
  • Tax Amount Winter: 1077.0000
  • Total Tax: 3061.0000

MLS Schools

  • School District: New Haven

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
6
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 Macomb, MI

  • 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

    **OPEN HOUSE SUN June 8th 1:00-3:00** 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

    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
  • 52140 Naugatuck Dr Unit 94, Macomb, MI 48042

    $220,000

    • 2 Beds
    • 2 Baths
    • 1,364 Sq Ft
    • 52140 Naugatuck Dr
    • Unit 94
    • Macomb, MI

    Welcome to the Hartford Condo Community! This move-in ready, lower-level ranch-style condo features 2 bedrooms and 2 full baths, offering a well-maintained and thoughtfully cared-for living space.Inside, you'll find an inviting open-concept layout with a cozy gas fireplace in the living room and two doorwalls (from both the living room and primary suite) that open to a covered outdoor patio —

    Giovanna Special Real Broker LLC

    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
  • 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: 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 $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: Realcomp

MLS Number: 216005820

Realcomp

APN: 20-08-24-325-051