Seller's Agent in 2025
Susan Vogel
RE/MAX
(586) 799-3090
8 in this area
118 Total Sales
23260 Streamview St Unit 79 Macomb, MI 48042
2
Beds
3
Baths
1,753
Sq Ft
$315/mo
HOA Fee
Highlights
- Outdoor Pool
- Deck
- End Unit
- Clubhouse
- Ranch Style House
- Bar Fridge
About This Home
As of May 2025Beautiful Spacious Ranch Condo!
This 2 Bedroom, 3 Bath, 2013 built Ranch condo boasts an open floor plan with a Library/Office, large kitchen with island seating. Stunning Great Room with adjacent formal Dining, generous size Bedrooms, 1st floor Laundry and a beautifully finished Basement with Full Bathroom.
The large Kitchen with premium 42” upper cabinetry features a white subway tile backsplash, newer appliances and an island with bar seating. The Kitchen opens to the beautiful high-ceilinged Great Room with the spotlighted gas fireplace, allowing for ease of entertaining.
The beautiful Primary Ensuite offers double sinks with white Corian counters, an oversized soaking tub, separate stand-up shower and generous size walk-in closet. Additional entertaining space can be enjoyed in the huge finished basement offering a large recreation area, a third full bathroom, ample storage space and an egress window. A 2-car attached garage with an epoxy floor also adds additional storage. Enjoy the outdoors on your maintenance-free composite deck with a retractable awning overlooking the gorgeous pond with a fountain!
Property Details
Home Type
- Condominium
Est. Annual Taxes
Year Built
- Built in 2013
Lot Details
- Property fronts a private road
- End Unit
- Private Entrance
- Sprinkler System
HOA Fees
- $315 Monthly HOA Fees
Home Design
- Ranch Style House
- Brick Exterior Construction
- Poured Concrete
- Asphalt Roof
- Stone Siding
- Cedar
- Vinyl Construction Material
Interior Spaces
- 1,753 Sq Ft Home
- Bar Fridge
- Ceiling Fan
- Gas Fireplace
- Awning
- Entrance Foyer
- Great Room with Fireplace
- Finished Basement
- Basement Window Egress
- Security System Owned
Kitchen
- Free-Standing Gas Range
- Microwave
- Dishwasher
- Disposal
Bedrooms and Bathrooms
- 2 Bedrooms
- 3 Full Bathrooms
Laundry
- Dryer
- Washer
Parking
- 2 Car Attached Garage
- Front Facing Garage
- Garage Door Opener
- Driveway
Outdoor Features
- Outdoor Pool
- Deck
Location
- Ground Level
- Property is near golf course
Utilities
- Forced Air Heating and Cooling System
- Humidifier
- Heating System Uses Natural Gas
- Programmable Thermostat
- Natural Gas Water Heater
Listing and Financial Details
- Assessor Parcel Number 0824325079
Community Details
Overview
- Jbc Property Management Association, Phone Number (586) 254-3000
- On-Site Maintenance
Amenities
- Clubhouse
- Laundry Facilities
Recreation
- Community Pool
- Tennis Courts
Pet Policy
- Limit on the number of pets
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Closed on
Oct 10, 2025
Sold by
Hudson Richard F and Hudson Claudia L
Bought by
Richard F Hudson And Claudia L Hudson Living and Hudson
Current Estimated Value
Purchase Details
Listed on
Apr 24, 2025
Closed on
May 20, 2025
Sold by
Lozzi Frank A and Lozzi Nancy P
Bought by
Hudson Richard
Seller's Agent
Susan Vogel
RE/MAX First
Buyer's Agent
Mark Charbonneau
List Price
$425,000
Sold Price
$430,000
Premium/Discount to List
$5,000
1.18%
Views
66
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
-0.39%
Purchase Details
Closed on
May 31, 2016
Sold by
Lozzi Frank A and Lozzi Nancy P
Bought by
Frank A Lozzi & Nancy P Lozzi Trust
Purchase Details
Closed on
Jan 23, 2014
Sold by
Pulte Land Company Llc
Bought by
Lozzi Frank and Lozzi Nancy
Purchase Details
Closed on
May 21, 2009
Sold by
Lombardo North Avenue Properties Llc
Bought by
Pulte Land Company Llc
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
Average Home Value in this Area
Purchase History
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Quit Claim Deed | -- | None Listed On Document | |
| Quit Claim Deed | -- | None Listed On Document | |
| Warranty Deed | $430,000 | None Listed On Document | |
| Warranty Deed | $430,000 | None Listed On Document | |
| Interfamily Deed Transfer | -- | Attorney | |
| Warranty Deed | $230,845 | None Available | |
| Warranty Deed | -- | None Available |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 05/20/2025 05/20/25 | Sold | $430,000 | +1.2% | $245 / Sq Ft |
| 04/28/2025 04/28/25 | Pending | -- | -- | -- |
| 04/24/2025 04/24/25 | For Sale | $425,000 | -- | $242 / Sq Ft |
Source: Realcomp
Tax History Compared to Growth
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 | $2,991 | $197,500 | $0 | $0 |
| 2024 | $2,910 | $191,400 | $0 | $0 |
| 2023 | $2,758 | $171,500 | $0 | $0 |
| 2022 | $4,131 | $153,500 | $0 | $0 |
| 2021 | $4,020 | $150,600 | $0 | $0 |
| 2020 | $2,535 | $146,500 | $0 | $0 |
| 2019 | $3,716 | $144,000 | $0 | $0 |
| 2018 | $3,506 | $140,000 | $0 | $0 |
| 2017 | $3,461 | $125,350 | $19,500 | $105,850 |
| 2016 | $3,276 | $125,390 | $0 | $0 |
| 2015 | $1,209 | $113,520 | $0 | $0 |
| 2014 | $1,209 | $12,500 | $12,500 | $0 |
| 2011 | $225 | $11,000 | $11,000 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
Susan Vogel
-
Mark Charbonneau
Buyer's Agent in 2025
Mark Charbonneau
(586) 260-4400
2 in this area
24 Total Sales
Map
Source: Realcomp
MLS Number: 20250028611
APN: 20-08-24-325-079
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.
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
- 49257 Brodie Ct
- 22968 Rainbow Dr
- 50279 North Ave
- 49525 North Ave
- 50281 Arcadia Dr
- 50246 Arcadia Dr
- 50315 Arcadia Dr
- 24244 Tullymore Dr
- 24165 Tullymore Dr
- 23873 Sawgrass Dr
- 24166 Sawgrass Dr
- 23947 Sawgrass Dr
- 24021 Sawgrass Dr
- 48284 Stapleton Ave
- 50860 Timberstone Dr
- 50486 Timberstone Dr
- 24537 Tribute Dr
- 24388 Sawgrass Dr
- 24722 Tribute Dr
- 24778 Kabarda Dr