Skip main navigation
For sale
  • Price cut: $5K (7/1)
    $359,900

    40135 Streamwood Ct, Sterling Heights, MI 48310

    2beds
    1,519sqft
    : 
    Loading
    Get pre-qualified
    Condominium, Stock Cooperative
    Built in 2003
    -- sqft lot
    $355,500 Zestimate®
    $237/sqft
    $300/mo HOA

    What's special

    Full basementSoaring architectural ceilingsUpstairs laundryPeaceful views
    Stylish and low-maintenance condo living in the heart of Sterling Heights! This beautifully designed 2 bedroom, 2 bathroom condo features soaring architectural ceilings, upstairs laundry, a full basement, and an attached 2-car garage. Enjoy peaceful views from the gorgeous private deck surrounded by mature trees. Conveniently located near 17½ Mile and Dequindre, offering easy access to shopping, dining, and everyday conveniences. Easy living with high style!
    9 days
    |
    486
    |
    19
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Francesca Krause 810-217-1202,

    RE/MAX Advisors 586-725-1900

    Source: MiRealSource,MLS#: 50212258MLS LogoOriginating MLS: MiRealSource

    Loading...

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 2
      • Bathrooms: 2
      • Full bathrooms: 2
      Rooms
      • Room types: Breakfast Nook/Room, Entry, Bedroom, Bathroom, First Flr Lavatory, Living Room, Master Bathroom, Master Bedroom, Shared Bathroom
      Bedroom 1
      • Features: Carpet
      • Level: First
      • Area: 168
      • Dimensions: 14 x 12
      Bedroom 2
      • Features: Carpet
      • Level: First
      • Area: 132
      • Dimensions: 12 x 11
      Bathroom 1
      • Features: Ceramic
      • Level: First
      • Area: 55
      • Dimensions: 11 x 5
      Bathroom 2
      • Features: Ceramic
      • Level: First
      • Area: 55
      • Dimensions: 11 x 5
      Dining room
      • Features: Carpet
      • Level: First
      • Area: 132
      • Dimensions: 12 x 11
      Kitchen
      • Features: Wood
      • Level: First
      • Area: 144
      • Dimensions: 12 x 12
      Living room
      • Features: Carpet
      • Level: First
      • Area: 375
      • Dimensions: 25 x 15
      Heating
      • Forced Air, Natural Gas
      Cooling
      • Central Air
      Appliances
      • Included: Dishwasher, Humidifier, Range/Oven, Refrigerator, Gas Water Heater
      • Laundry: First Floor Laundry
      Features
      • Walk-In Closet(s), Eat-in Kitchen
      • Flooring: Ceramic Tile, Carpet, Wood
      • Windows: Window Treatments
      • Basement: Full,Concrete,Unfinished
      • Number of fireplaces: 1
      • Fireplace features: Living Room
      Interior area
      • Total structure area: 3,038
      • Total interior livable area: 1,519 sqft
      • Finished area above ground: 1,519
      • Finished area below ground: 0

      Property

      Parking
      • Total spaces: 2
      • Parking features: Garage, Attached, Electric in Garage, Off Street
      • Attached garage spaces: 2
      Features
      • Levels: One
      • Stories: 1
      • Patio & porch: Patio, Porch
      • Exterior features: Street Lights
      • Frontage type: Road
      Details
      • Parcel number: 101018151085
      • Zoning description: Residential
      • Special conditions: Private

      Construction

      Type & style
      • Home type: Condo
      • Architectural style: Ranch
      • Property subtype: Condominium, Stock Cooperative
      Materials
      • Brick
      • Foundation: Basement, Concrete Perimeter
      Condition
      • New construction: No
      • Year built: 2003

      Utilities & green energy

      • Sewer: Public At Street
      • Water: Public Water at Street
      • Utilities for property: Cable/Internet Avail.

      Community & HOA

      Community
      • Subdivision: Avalon Wood #631
      HOA
      • Has HOA: Yes
      • Amenities included: Maintenance Grounds, Sidewalks, Street Lights
      • Services included: Maintenance Grounds, Maintenance Structure, Snow Removal
      • HOA fee: $300 monthly
      • HOA name: Avalon Woods
      • HOA phone: 586-566-8100
      Location
      • Region: Sterling Heights

      Financial & listing details

      • Price per square foot: $237/sqft
      • Tax assessed value: $331,200
      • Annual tax amount: $6,227
      • Date on market: 6/22/2026
      • Cumulative days on market: 48 days
      • Listing agreement: Exclusive Right To Sell
      • Listing terms: Cash,Conventional,FHA,VA Loan
      • Road surface type: Paved

        Estimated market value

        $355,500

        $338,000 - $373,000

        $2,395/mo

        Price history

        DateEventPrice
        7/1/2026Price change$359,900-1.4%$237/sqft
        Source: MiRealSource #50212258 Report a problem
        6/17/2026Price change$364,900-1.1%$240/sqft
        Source: MiRealSource #50207725 Report a problem
        5/15/2026Listed for sale$369,000+21%$243/sqft
        Source: MiRealSource #50207725 Report a problem
        6/6/2022Sold$305,000-3.1%$201/sqft
        Source: Realcomp II #2220034779 Report a problem
        5/14/2022Pending sale$314,900$207/sqft
        Source: Realcomp II #2220034779 Report a problem
        5/11/2022Listed for sale$314,900+53.6%$207/sqft
        Source: Realcomp II #2220034779 Report a problem
        6/2/2016Sold$205,000-6.8%$135/sqft
        Source: Public Record Report a problem
        10/31/2015Listing removed$219,900$145/sqft
        Source: Jack Christenson-Troy #215106913 Report a problem
        10/2/2015Listed for sale$219,900+5.7%$145/sqft
        Source: Jack Christenson-Troy #215106913 Report a problem
        9/2/2014Sold$208,000-10.1%$137/sqft
        Source: MiRealSource #31202391 Report a problem
        9/16/2004Sold$231,465$152/sqft
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025$5,903 +5.6%$165,600 +6.4%
        2024$5,590 +24.3%$155,600 +6.4%
        2023$4,497 +2.1%$146,300 +7.8%
        2022$4,404 $135,700 +3.3%
        2021-- $131,400 +5%
        2020-- $125,100 +13.2%
        2019-- $110,500 +1.7%
        2018$3,995 $108,600 -3%
        2017-- $112,000
        2016-- $112,000 +6.5%
        2015-- $105,200 +37.3%
        2014-- $76,600

        Find assessor info on the county website

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: 48310

        Getting around

        44 / 100
        Car-Dependent
        40 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • District: Utica Community Schools

        Source: MiRealSource. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts

        Similar homes

        Skip to the end of the carouselSkip to the beginning of the carousel