NOT LISTED FOR SALE

23359 Streamview St Macomb, MI 48042

Estimated Value: $411,000 - $521,000

2 Beds
3 Baths
3,353 Sq Ft
$242/mo HOA Fee

Last Sold October 15, 2018

Last sale price $320,000 $95 Per Sq Ft

Est. 40% increase in value since last sale

Current estimated payment $2,889/month

3 Days on Market

Highlights

  • Outdoor Pool
  • Deck
  • Wood Flooring
  • Clubhouse
  • Ranch Style House
  • Walk-In Closet

About This Home

As of October 2018

Rare find! Beautiful ranch condo on a serene lot with private, wooded area behind that you can enjoy from your large, new maintenance free deck. Newer build with updates galore. Kitchen includes dark granite, stainless appliances, cherry wood cabinets, under cabinet lighting, large island and hardwood floors. Beautiful fireplace with decorative trim. Entry has upgraded molding package. Nicely finished basement with full bathroom, bedroom, storage and more! Three full baths with Corian counters. Master bedroom with master bath and WIC. Community has pool, clubhouse, walking trails and events. Move right in to this turnkey condo.

Last Agent to Sell the Property

Karyn Gaidos

Fresh Coast Collective Realty, PLLC License #MISPE-6502433736 Listed on: 09/05/2018

Fresh Coast Collective Realty, PLLC

Last Buyer's Agent

Eric Wilhelm

Real Estate One Inc-Shelby License #MISPE-6501363897

Real Estate One Inc-Shelby

Property Details

Home Type

  • Condominium

Est. Annual Taxes

Year Built

  • Built in 2011

Lot Details

  • 1

HOA Fees

  • $242 Monthly HOA Fees

Parking

  • 2 Car Garage

Home Design

  • Ranch Style House
  • Brick Exterior Construction
  • Poured Concrete

Interior Spaces

  • Ceiling height of 9 feet or more
  • Ceiling Fan
  • Gas Fireplace

Kitchen

  • Oven or Range
  • Microwave
  • Dishwasher
  • Disposal

Flooring

  • Wood
  • Ceramic Tile

Bedrooms and Bathrooms

  • 2 Bedrooms
  • Walk-In Closet
  • 3 Full Bathrooms

Laundry

  • Dryer
  • Washer

Finished Basement

  • Sump Pump
  • Basement Window Egress

Outdoor Features

  • Outdoor Pool
  • Deck

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas

Listing and Financial Details

  • Assessor Parcel Number 20-08-24-325-050

Community Details

Overview

  • The Sandstone At The Retreat Condo #956 Subdivision
  • Maintained Community

Amenities

  • Clubhouse

Recreation

  • Community Spa

Property Details

Home Type

Condominium

Est. Annual Taxes

$4,109

Year Built

Built in 2011

Lot Details

0

HOA Fees

$242 per month

Listing Details

  • Originating MLS: MiRealSource
  • Class: RESIDENTIAL
  • Type Of Property: Condominium
  • Architecture Style: Ranch
  • Structure Style: 1 Story
  • Total Tax Amount: 4109.13
  • Year Built: 2011
  • Mail City: Macomb Twp
  • Special Features: None
  • Property Sub Type: Condos
  • Stories: 1

Interior Features

  • Interior Amenities: 9 ft + Ceilings, Ceramic Floors, Hardwood Floors, Sump Pump, Walk-In Closet
  • Appliances: Dishwasher, Disposal, Dryer, Microwave, Range/Oven, Refrigerator, Washer
  • Fireplace: Yes
  • Fireplaces: Gas Fireplace
  • Basement: Yes
  • Basement: Egress/Daylight Windows, Finished, Poured
  • Bedrooms: 2
  • Full Bathrooms: 3
  • Total Bathrooms: 3
  • Dining Room: On Entry Level, Dimensions: 10 x 15
  • Great Room: On Entry Level, Dimensions: 17 x 15
  • Kitchen: On Entry Level, Dimensions: 19 x 11
  • Library Den: On Entry Level, Dimensions: 12 x 10
  • Below Grade Sq Ft: 1753
  • Finished Below Grade Sq Ft: 1600
  • Above Grade Finished Sq Ft: 1753
  • Total Finished Sq Ft: 3353

Exterior Features

  • Pool: Yes
  • Exterior: Brick
  • Exterior Features: Deck
  • Foundation: Basement

Garage/Parking

  • Garage Spaces: 2
  • Garage: Yes

Utilities

  • Heating: Forced Air
  • Heating Fuel: Natural Gas
  • Sewer: Public Sanitary
  • Water: Public Water
  • Cooling: Ceiling Fan(s), Central A/C

Condo/Co-op/Association

  • HOA Fees: 242
  • HOA Fee Frequency: Monthly
  • Community Features: Club House, Grounds Maintenance, Pool/Hot Tub, Pets-Allowed
  • Association Fee: Yes

Lot Info

  • Assessor Parcel Number: 20-08-24-325-050
  • Geo Subdivision: MI

Tax Info

  • Summer Tax: Year: 2018, Amount: $2,556.37
  • Winter Tax: Year: 2017, Amount: $1,552.76
  • Total Tax: Amount: $4,109.13

MLS Schools

  • School District: New Haven Community Schools

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Oct 30, 2019
Sold by
Arthurs James D and Arthurs Judy
Bought by
Arthurs James D and Arthurs Judy
Current Estimated Value
$448,177

Purchase Details

Listed on
Sep 5, 2018
Closed on
Oct 15, 2018
Sold by
Bennett Joseph F and Bennett Ronna G
Bought by
Arthurs James Douglas and Arthurs Judy
Seller's Agent
Karyn Gaidos
Fresh Coast Collective Realty, PLLC
Buyer's Agent
Eric Wilhelm
Real Estate One Inc-Shelby
List Price
$300,000
Sold Price
$320,000
Premium/Discount to List
$20,000
6.67%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
4.78%

Purchase Details

Listed on
Nov 17, 2015
Closed on
Feb 29, 2016
Sold by
Descoteaux Roland and Descoteaux Pokyo
Bought by
Bennett Joseph F and Bennett Rounn G
Seller's Agent
Mary Locricchio
Keller Williams Realty Lakeside
Buyer's Agent
Karyn Gaidos
Fresh Coast Collective Realty, PLLC
List Price
$274,900
Sold Price
$270,000
Premium/Discount to List
-$4,900
-1.78%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
6.70%
Original Mortgage
$251,750
Interest Rate
4.25%
Mortgage Type
Adjustable Rate Mortgage/ARM

Purchase Details

Closed on
Dec 29, 2011
Sold by
Pulte Land Company Llc
Bought by
Descoteaux Roland and Descoteaux Pokyo

Purchase Details

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

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

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
Arthurs James D -- None Available
Arthurs James Douglas $320,000 First Priority Title
Bennett Joseph F $270,000 None Available
Descoteaux Roland $211,965 Pgp Title
Pulte Land Company Llc -- None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Bennett Joseph F $251,750
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
10/15/2018 10/15/18 Sold $320,000 +6.7% $95 / Sq Ft
09/08/2018 09/08/18 Pending -- -- --
09/05/2018 09/05/18 For Sale $300,000 +11.1% $89 / Sq Ft
03/02/2016 03/02/16 Sold $270,000 -1.8% $154 / Sq Ft View Prior Sale
12/30/2015 12/30/15 Pending -- -- --
11/17/2015 11/17/15 For Sale $274,900 -- $157 / 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
2025 $3,583 $197,400 $0 $0
2024 $3,486 $191,400 $0 $0
2023 $3,303 $171,500 $0 $0
2022 $4,948 $153,600 $0 $0
2021 $4,815 $150,700 $0 $0
2020 $3,037 $146,600 $0 $0
2019 $4,458 $144,100 $0 $0
2018 $4,154 $140,000 $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 $3,762 $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: 31359011

Michigan Multiple Listing Service

APN: 20-08-24-325-050