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 on 06/19/23
$412,000
23278 Streamview St, Macomb, MI 48042
2beds
3,253sqft
Condominium
Built in 2013
-- sqft lot
$436,600 Zestimate®
$127/sqft
$3,563 Estimated rent
What'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
Services availability
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,600