Skip main navigation
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

    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.

    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#: 20230042709MLS Logo

    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