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.
Sold for $412,000
$412,000
23278 Streamview St, Macomb, MI 48042
2beds
3,253sqft
Condominium
Built in 2013
-- sqft lot
$436,300 Zestimate®
$127/sqft
$3,038 Estimated rent
Home value
$436,300
$414,000 - $458,000
$3,038/mo
Zestimate® history
Loading...
Owner options
List your home for rent
$3,038/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
Learn more$3,038/mo
Rent Zestimate®
Refinance and save
$2,938/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
See today's rates$2,938/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Zillow last checked: 7 hours ago
Listing updated: December 11, 2023 at 09:28am
Listed by:
Laila Abud 313-886-4200,
Coldwell Banker Professionals-GPF,
Kay Rinke 313-886-4200,
Coldwell Banker Professionals-GPF
Bought with:
Sandra Matti, 6501440019
Anthony Djon Luxury Real Estate
Source: Realcomp II,MLS#: 20230042709
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 2
- Bathrooms: 3
- Full bathrooms: 3
Heating
- Forced Air, Natural Gas
Cooling
- Ceiling Fans, Central Air
Appliances
- Included: Dishwasher, Disposal, Dryer, Exhaust Fan, Free Standing Electric Oven, Free Standing Refrigerator, Microwave, Stainless Steel Appliances, Washer
Features
- Entrance Foyer
- Windows: Egress Windows
- Basement: Finished
- Has fireplace: Yes
- Fireplace features: Gas, Great Room
Interior area
- Total interior livable area: 3,253 sqft
- Finished area above ground: 1,753
- Finished area below ground: 1,500
Property
Parking
- Total spaces: 2
- Parking features: Two Car Garage, Attached
- Attached garage spaces: 2
Features
- Levels: One Story Ground
- Stories: 1
- Entry location: GroundLevel
- Patio & porch: Enclosed, Patio, Porch
- Exterior features: Private Entrance
- Pool features: Community, In Ground
- Waterfront features: Pond
Details
- Parcel number: 0824325078
- Special conditions: Short Sale No,Standard
Construction
Type & style
- Home type: Condo
- Architectural style: Ranch
- Property subtype: Condominium
Materials
- Brick
- Foundation: Basement, Poured
Condition
- New construction: No
- Year built: 2013
Utilities & green energy
- Electric: Circuit Breakers
- Sewer: Public Sewer
- Water: Public
Community & neighborhood
Community
- Community features: Clubhouse, Fitness Center, Sidewalks
Location
- Region: Macomb
- Subdivision: THE SANDSTONE AT THE RETREAT CONDO #956
HOA & financial
HOA
- Has HOA: Yes
- HOA fee: $280 monthly
- Services included: Insurance, Maintenance Grounds, Snow Removal
- Association phone: 586-254-3000
Other
Other facts
- Listing agreement: Exclusive Right To Sell
- Listing terms: Cash,Conventional
Price history
| Date | Event | Price |
|---|---|---|
| 6/19/2023 | Sold | $412,000-1.9%$127/sqft |
Source:  Realcomp II #20230042709 Report a problem | ||
| 6/6/2023 | Pending sale | $420,000$129/sqft |
Source: Realcomp II #20230042709 Report a problem | ||
| 6/1/2023 | Listed for sale | $420,000+57.2%$129/sqft |
Source: Realcomp II #20230042709 Report a problem | ||
| 8/21/2013 | Sold | $267,100$82/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $6,504 +58% | $208,400 +3.2% |
| 2024 | $4,116 +5.2% | $201,900 +11.7% |
| 2023 | $3,914 +2.8% | $180,700 +11.7% |
Find assessor info on the county website
Neighborhood: 48042
Nearby schools
GreatSchools rating
- 4/10New Haven Elementary SchoolGrades: K-5Distance: 6.2 mi
- 5/10Endeavour Elementary and Middle SchoolGrades: K-8Distance: 4 mi
- 7/10New Haven High SchoolGrades: 9-12Distance: 6 mi
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$436,300
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$436,300
- Michigan
- Macomb County
- Macomb
- 48042
- 23278 Streamview St