Macomb County property record for 23278 Streamview St, Macomb, MI 48042
| Property Type | Condominium |
|---|---|
| Details | 2 bd · 3 ba · 1,753 sqft · built 2013 |
| Lot Size | 1 acres (43,560 sqft) |
| Owner | 2 Individual Names on File |
| Last Sale | $412,000 (Jun 2023) |
| Tax Bill | $6,674 (2025) |
| Deeds & Mortgages | Jun 2023 Sale Nov 2017 Line of Credit |
| Flood Zone | Zone X (minimal risk) |
| APN | 20-08-24-325-078 |
| Primary APN | 20-08-24-325-078 |
|---|---|
| Alternative APN |
|
| Bedrooms | 2 Beds |
|---|---|
| Full Baths | 3 Baths |
| Stories | 1 Story |
| Building Area | 1,753 sqft Living Area |
| 1st Floor Area | 1,739 sqft |
| Basement Area | 1,739 sqft |
| Unfinished Basement | 1,739 sqft |
| Year Built | Built 2013 |
|---|---|
| Effective Year Built | Effective 2014 |
| Architectural Style | Condo/Apartment |
| Lot Area | 43,560 sqft (1 acres) |
| Garage Area | 488 sqft |
| Parking Spaces | 2 Parking Spaces |
| Cooling System | HVAC |
|---|---|
| Heating System | Forced Air with A/C |
| Street Address | 23278 STREAMVIEW ST |
|---|---|
| City | MACOMB |
| State | MI |
| Zip | 48042-4858 |
| Property Category | Residential |
| Property Type | Residential > Condominium / Townhouse > Condominium |
| Local Zoning Code | R2L |
| Legal Description | THE SANDSTONE AT THE RETREAT MCCP #956 UNIT 78 BLDG 112 |
| Legal Subdivision | THE SANDSTONE AT THE RETREAT |
| Legal Unit | 78 |
| Jurisdiction | MACOMB MI |
| Township / Civil Division | MACOMB |
| Census Block Group | 1 |
| Census Block | 1004 |
| Census Tract | 223401 |
Source: Macomb County records · APN 20-08-24-325-078
Assessment roll updated July 6, 2026 · Last verified July 2026
Owner names and exact recorded amounts shown locked on this page are available instantly with a free trial.
| Owner of Record | 2 Individual Names on File |
|---|---|
| Mailing Address | 23278 STREAMVIEW ST, MACOMB, MI 48042-4858 |
| Occupancy | Owner Occupied |
| Owner Type | Individual |
| Date | Document |
|---|---|
| Jun 28, 2023 | Warranty Deed, Transfer |
| Nov 30, 2017 | Deed of Trust, Mortgage · Line of Credit CITIZENS BANK NA |
| Deed Names | 2 Verified Names on Deed |
|---|---|
| Last Sale | Jun 28, 2023 · Amount on Record |
| Deed Sale | Jun 28, 2023 · Amount on Record |
| Prior Sale | Aug 21, 2013 · Amount on Record |
| Deed Document Number | 202355662 |
| Deed Book / Page | 29187 / 149 |
| Record Updated | Sep 20, 2026 |
| Document Type | Warranty Deed |
|---|---|
| Jurisdiction | MACOMB MI |
| Recording Date | Jun 28, 2023 |
| Property Address | 23278 STREAMVIEW ST, MACOMB, MI 48042-4858 |
| Document Number | 2300055662 |
| Book / Page | 29187 / 149 |
| Map Reference | LB 17377 PG 193 |
| Instrument Date | Jun 19, 2023 |
| Instrument | 202300055662 |
| Transaction Type | Transfer |
| Record Updated | Jul 13, 2023 |
| Amount | Amount Recorded |
|---|---|
| Tax | $3,090.00 |
| Amount Accuracy | Full Amount Stated |
| Additional |
|
| Name | Verified Name |
|---|---|
| Address | 23278 STREAMVIEW ST, MACOMB, MI 48042-4858 |
| Name | Verified Name |
|---|---|
| Address | 23278 STREAMVIEW ST, MACOMB, MI 48042-4858 |
| Document Type | Deed of Trust |
|---|---|
| Jurisdiction | MACOMB MI |
| Property Address | 23278 STREAMVIEW ST, MACOMB, MI 48042-4858 |
| Transaction Type | Mortgage |
| Record Updated | Aug 12, 2022 |
| Name | Verified Name |
|---|
| Document Number | 0000141455 |
|---|---|
| Date | Nov 30, 2017 |
| Book Page | 25088/255 |
| Instrument | 7141455 |
| Name | CITIZENS BANK NA |
|---|---|
| Type | Bank |
| Address | PROVIDENCE, RI 02903 |
| Type | Line of Credit |
|---|---|
| Amount | Amount Recorded |
| Term | 299 Months |
| Due | Oct 12, 2042 |
| Rate Type | Adjustable Rate |
|---|---|
| Change Frequency | Monthly |
Source: Macomb County records · Assessment roll updated July 6, 2026 · Last verified July 2026
| Type | Name |
|---|---|
| State | Michigan |
| County | Macomb County |
| County Subdivision | Macomb Township |
| Unified School District | New Haven Community Schools (PK - 12) |
Assessed value and assessed market value are set for property tax purposes, not market price estimates; both are a fraction of this property's market value.
| Year | Tax Bill | Assessed Value | Assessed Market Value |
|---|---|---|---|
| 2026 | $218,700 (+21.03%) | $437,400 (+21.03%) | |
| 2025 | $6,674.00 (+70.56%) | ||
| 2023 | $180,700 | $361,400 | |
| 2022 | $3,913.00 |
Source: FEMA National Flood Hazard Layer as of October 4, 2026 · FEMA NFIP claims and policies as of September 2026 · USDA Forest Service Wildfire Risk to Communities as of 2024 · Last verified October 2026
| FEMA Flood Zone | Zone X minimal risk |
|---|---|
| Nearest Special Flood Hazard Area | Zone A, within 100 ft |
| Flood Insurance Requirement | Not required lenders may require it |
| Flood Insurance Cost | Premium on Record median of 13 policies |
| Nearby Flood Policies | 13 in force |
| Nearby Flood Claims | 1 (2024) |
| Most Recent Claim | Aug 2024 · rainfall accumulation |
| Wildfire Risk | Low lower than 99.1% of the US · lower than 98.4% of Michigan |
|---|---|
| Wildfire Likelihood | Under 0.01% annual chance |
| Exposure | None beyond ember reach |
Values are read at the parcel center point; flood claims are located to the census block group, not this parcel; lenders make the official flood determination.
Source: FCC Broadband Data Collection as of December 31, 2025 · Last verified October 2026
| Provider | Max Down / Up (Mbps) |
|---|---|
| Xfinity Cable · Fiber in parts of the area | 2,000 / 250 |
| T-Mobile USA Fixed Wireless | 100 / 20 |
| AT&T Fixed Wireless · Fiber, DSL in parts of the area | 100 / 20 |
May also be available: Verizon.
Based on FCC filings for 302 locations within half a mile of this property.
Source: EPA Safe Drinking Water Information System as of 2026 Q3 · EPA water system boundaries as of March 2026 · Last verified October 2026
| Water System | MACOMB TOWNSHIP serves 90,000 people |
|---|---|
| Water Source | Purchased surface water from GREAT LAKES WATER AUTHORITY |
| Last State Inspection | Jan 2025 |
| Lead | Under 1 ppb (2025) action level 15 ppb |
| Water Quality | None last 10 years |
|---|---|
| Treatment and Procedure | None last 10 years |
| Monitoring and Reporting | 2 last 3 years |
Results are for the whole water system as reported to EPA, not water tested at this address; lead at the tap also depends on the building's own pipes. The full violation and enforcement history is in the system's EPA record.
Search by:
By searching, you agree to: Terms • Privacy • Disclosures