23278 Streamview St
Macomb, MI 48042
- 2 Beds
- 3 Baths
- 3,253 sqft
2 Beds
3 Baths
3,253 sqft
Local Information
© Google
-- mins to
Description
WELCOME TO THIS IMPECCABLY MAINTAINED DUPLEX CONDO OVERLOOKING THE POND AT THE POPULAR SANDSTONE RETREAT. FIRST FLOOR DEN, LAUNDRY RM WITH MATCHING CABINETS TO KITCHEN. INCLUDES HIGH END LG WASHER/DRYER WITH LAUNDRY TUB. KITCHEN BOASTS ISLAND SEATING WITH ALL GRANITE COUNTER TOPS, BACKSPLASH WITH UNDER CABINET LIGHTING. GENEROUS STORAGE IN CHERRY WOOD 42 HIGH CABINETS. ALL STAINLESS STEEL APPL INCLUDED. GLASS TOP ELECTRIC STOVE WITH DOUBLE OVEN. COUNTER DEPTH REFRID. MICROWAVE, BOSCH DISHW BOTH 2019. GREAT ROOM HAS SWITCH ON GAS FIRE PLACE SURROUNDED BY GRANITE. HUNTER DOUGLAS BLINDS IN GR ROOM, KITCHEN, BEDROOMS AND DEN. NEWER CARPETING THROUGHOUT THE MAIN FLOOR. ATTACH 2 CAR GARAGE WITH ENERGY EFFICIENT UPDATES, EXTRA DEEP AND WIDE FOR STORAGE. ADDITIONAL 1500 SF FINISHED BASEMENT WITH A 3RD FULL BATH AND 8FT HIGH CEILINGS. LOADS OF STORAGE. ADDITIONAL RECENT UPGRADES: POURED AGGREGATE CONCRETE PATIO ADJ TO ENCLOSED PORCH, LARGE GAS GRILL, NEW SUMP PUMP WTH 2 BACKUPS, 50 GAL HW HEATER, CEILING FAN IN ENCLOSED PORCH, AND 2 ELECTRICAL OUTLETS (2022). PRIMARY BATH AND KITCHEN FAUCETS REPLACED. 2 HOSE BIBS ONE IN THE BACK OF CONDO AND ONE ON SIDE NEAR THE FRONT. COMMUNITY CLUB HOUSE, POOL, FITNESS CENTER, NEARBY POPULAR GOLF COURSES. YOU WON'T BE DISAPPOINTED.
This property is off market, which means it's not currently listed for sale or rent on Trulia. This may be different from what's available on other websites or public sources. This description is from December 11, 2023
Home Highlights
Parking
2 Car Garage
Outdoor
Porch, Patio
A/C
Heating & Cooling
HOA
$280/Monthly
Price/Sqft
No Info
Listed
180+ days ago
Home Details for 23278 Streamview St
|
|---|
Interior Details Basement: FinishedNumber of Rooms: 9 |
Beds & Baths Number of Bedrooms: 2Number of Bathrooms: 3Number of Bathrooms (full): 3 |
Dimensions and Layout Living Area: 3253 Square Feet |
Appliances & Utilities Appliances: Dishwasher, Disposal, Dryer, Exhaust Fan, Free Standing Electric Oven, Free Standing Refrigerator, Microwave, Stainless Steel Appliances, WasherDishwasherDisposalDryerMicrowaveWasher |
Heating & Cooling Heating: Forced Air,Natural GasHas CoolingAir Conditioning: Ceiling Fans,Central AirHas HeatingHeating Fuel: Forced Air |
Fireplace & Spa Fireplace: Gas, Great RoomHas a Fireplace |
Gas & Electric Electric: Circuit Breakers |
Windows, Doors, Floors & Walls Window: Egress Windows |
Levels, Entrance, & Accessibility Stories: 1Levels: One Story GroundEntry Location: GroundLevel |
|
|---|
Exterior Home Features Patio / Porch: Enclosed, Patio, PorchExterior: Private EntranceFoundation: Basement, Poured |
Parking & Garage Number of Garage Spaces: 2No CarportHas a GarageHas an Attached GarageParking Spaces: 2Parking: Two Car Garage,Attached |
Pool Pool: Community, In Ground |
Frontage Waterfront: PondRoad Frontage: PavedNot on Waterfront |
Water & Sewer Sewer: Public Sewer |
Finished Area Finished Area (above surface): 1753 Square FeetFinished Area (below surface): 1500 Square Feet |
|
|---|
Cumulative Days on Market: 6 |
|
|---|
Year Built Year Built: 2013 |
Property Type / Style Property Type: ResidentialProperty Subtype: CondominiumArchitecture: Ranch |
Building Construction Materials: BrickNot a New ConstructionDoes Not Include Home Warranty |
Property Information Parcel Number: 0824325078 |
|
|---|
Price List Price: $420,000 |
Status Change & Dates Off Market Date: Tue Jun 06 2023Possession Timing: Close Plus 31 to 60 Days |
|
|---|
MLS Status: Sold |
|
|---|
Direction & Address City: MacombCommunity: THE SANDSTONE AT THE RETREAT CONDO #956 |
School Information High School District: New Haven |
|
|---|
Community rooms Fitness Center |
|
|---|
Community Features: Clubhouse, Fitness Center, SidewalksNot Senior Community |
|
|---|
HOA Fee Includes: Insurance, Maintenance Grounds, Snow RemovalHOA Phone: 586-254-3000Has an HOAHOA Fee: $280/Monthly |
|
|---|
Special Conditions: Short Sale No, Standard |
|
|---|
Listing Agreement Type: Exclusive Right To SellListing Terms: Cash, Conventional |
|
|---|
BasementMls Number: 20230042709Above Grade Unfinished Area: 1753Activation Date: Thu Jun 01 2023Showing Requirements: AppointmentOnly |
|
|---|
ClubhouseSidewalks |
Last check for updates: about 18 hours ago
Listed by Laila Abud, (313) 886-4200
Coldwell Banker Professionals-GPF
Kay Rinke, (313) 886-4200
Coldwell Banker Professionals-GPF
Bought with: Sandra Matti, (248) 590-0800, Anthony Djon Luxury Real Estate
Source: Realcomp II, MLS#20230042709

Price History for 23278 Streamview St
| Date | Price | Event | Source |
|---|---|---|---|
| 06/19/2023 | $412,000 | Sold | Realcomp II #20230042709 |
| 06/06/2023 | $420,000 | Pending | Realcomp II #20230042709 |
| 06/01/2023 | $420,000 | Listed For Sale | Realcomp II #20230042709 |
| 08/21/2013 | $267,100 | Sold | N/A |
Property Tax and Assessment
| Year | 2025 |
|---|---|
| Tax | $6,504 |
| Assessment | $416,800 |
Home facts updated by county records
Comparable Sales for 23278 Streamview St
Address | Distance | Property Type | Sold Price | Sold Date | Bed | Bath | Sqft |
|---|---|---|---|---|---|---|---|
0.10 | Condo | $440,000 | 10/20/25 | 2 | 3 | 3,453 | |
0.02 | Condo | $440,900 | 03/06/26 | 3 | 3 | 3,453 | |
0.07 | Condo | $405,000 | 07/08/25 | 2 | 2.5 | 2,001 | |
0.02 | Condo | $418,000 | 12/11/25 | 2 | 2 | 1,753 | |
0.17 | Condo | $373,000 | 09/05/25 | 2 | 2.5 | 2,001 | |
0.22 | Condo | $385,000 | 01/05/26 | 2 | 3 | 3,501 | |
0.19 | Condo | $440,000 | 05/11/26 | 2 | 3.5 | 4,002 | |
0.25 | Condo | $410,000 | 03/06/26 | 2 | 2 | 3,496 | |
0.23 | Condo | $360,000 | 05/12/26 | 2 | 2.5 | 2,100 | |
0.12 | Condo | $421,000 | 07/25/25 | 2 | 2 | 1,753 |
Nearby homes
Get a sense of prices in the area by checking nearby homes.Assigned Schools
These are the assigned schools for 23278 Streamview St.
What Locals Say about Macomb
At least 404 Trulia users voted on each feature.
91 % Say car is needed
89 % Say it's dog friendly
88 % Say yards are well-kept
88 % Say parking is easy
83 % Say there are sidewalks
80 % Say there's holiday spirit
77 % Say people would walk alone at night
74 % Say kids play outside
73 % Say it's quiet
59 % Say neighbors are friendly
56 % Say they plan to stay for at least 5 years
49 % Say streets are well-lit
48 % Say there's wildlife
40 % Say it's walkable to restaurants
34 % Say it's walkable to grocery stores
31 % Say there are community events
Sourced by Trulia users. Learn more about our methodology.
LGBTQ Local Legal Protections
LGBTQ Local Legal Protections
Apartments for Rent
Explore by feature
Homes for sale near 23278 Streamview St
Off Market Homes Near 23278 Streamview St

IDX provided courtesy of Realcomp II Ltd. via Zillow, Inc and MLS
Copyright 2026 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. Any use of search facilities of data on the site, other than by a consumer looking to purchase real estate, is prohibited.
The data relating to real estate properties on this website was last updated as recently as 2026-02-06 15:35:30 PST
Listing Information presented by local MLS brokerage: Zillow, Inc., REALTOR®- Lauren Buttazzoni - (313) 479-2702
Homes for rent near 23278 Streamview St
23278 Streamview St, Macomb, MI 48042 is a 2 bedroom, 3 bathroom, 3,253 sqft condo built in 2013. This property is not currently available for sale. 23278 Streamview St was last sold on Jun 19, 2023 for $412,000 (2% lower than the asking price of $420,000). The current Trulia Estimate for 23278 Streamview St is $437,800.