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!
For sale
Price cut: $5K (7/1)
$359,900
40135 Streamwood Ct, Sterling Heights, MI 48310
2beds
1,519sqft
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
- 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#: 50212258
Originating 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
| Date | Event | Price |
|---|---|---|
| 7/1/2026 | Price change | $359,900-1.4%$237/sqft |
Source: | ||
| 6/17/2026 | Price change | $364,900-1.1%$240/sqft |
Source: | ||
| 5/15/2026 | Listed for sale | $369,000+21%$243/sqft |
Source: | ||
| 6/6/2022 | Sold | $305,000-3.1%$201/sqft |
Source: | ||
| 5/14/2022 | Pending sale | $314,900$207/sqft |
Source: | ||
| 5/11/2022 | Listed for sale | $314,900+53.6%$207/sqft |
Source: | ||
| 6/2/2016 | Sold | $205,000-6.8%$135/sqft |
Source: Public Record Report a problem | ||
| 10/31/2015 | Listing removed | $219,900$145/sqft |
Source: Jack Christenson-Troy #215106913 Report a problem | ||
| 10/2/2015 | Listed for sale | $219,900+5.7%$145/sqft |
Source: Jack Christenson-Troy #215106913 Report a problem | ||
| 9/2/2014 | Sold | $208,000-10.1%$137/sqft |
Source: | ||
| 9/16/2004 | Sold | $231,465$152/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax 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$--/mo
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
Nearby schools
GreatSchools rating
- 7/10Schuchard Elementary SchoolGrades: PK-6Distance: 0.5 mi
- 6/10Frank Jeannette Jr. High SchoolGrades: 7-9Distance: 0.6 mi
- 8/10Adlai Stevenson High SchoolGrades: 9-12Distance: 3.9 mi
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.
- Michigan
- Macomb County
- Sterling Heights
- 48310
- 40135 Streamwood Ct
Nearby cities
Nearby zip codes
Other Sterling Heights Topics
- Apartments for Rent in 48310
- Houses for Sale in 48310
- Houses for Rent in 48310
- 48310 Real Estate
- Sterling Heights Condos
- Houses for Sale in Sterling Heights
- Newest Listings in Sterling Heights
- Sterling Heights Home Values
- Sterling Heights Real Estate Agents
- Sterling Heights Refinance
- Sterling Heights Mortgage Rates






