Move-in ready, 4 bedr-2bath colonial w/finished basement in the heart of Sterling Heights in subdivision off Van Dyke, renowned Utica School district, 3 min away from Dodge park, community center, shopping and restaurants. Updated in 2022, with New furnace, New HWT, Beautiful hardwood floors. All 4 bedrooms are on the 2nd floor. Updated full bath features newer flooring and bathtub. Additional half-bath is on the main level. Your friends will comment on spacious living room with hardwood floors and bay window, XL family room 21x12 with a beautiful fireplace and doorwall overlooking the patio. Large fenced yard is a great place for kids, pets and entertainment. Lots of storage space in the finished basement and attached 2 car garage. Make strong offer today!
Sold for $284,000 on 10/23/25
Zestimate®
$284,000
38252 Tottenham Rd, Sterling Heights, MI 48312
4beds
2,459sqft
Single Family Residence
Built in 1968
7,405.2 Square Feet Lot
$284,000 Zestimate®
$115/sqft
$2,571 Estimated rent
Home value
$284,000
$270,000 - $298,000
$2,571/mo
Zestimate® history
Loading...
Owner options
Explore your selling options
What's special
Zillow last checked: 8 hours ago
Listing updated: October 24, 2025 at 01:21pm
Listed by:
Natallia Tsarkouskaya 248-955-5888,
Sky High Agency LLC
Bought with:
Faik Yaldo, 6501331086
Century 21 Professionals Sterling Heights
Source: MiRealSource,MLS#: 50188412
Originating MLS: MiRealSource
Originating MLS: MiRealSourceFacts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 2
- Full bathrooms: 1
- 1/2 bathrooms: 1
Bedroom 1
- Level: Upper
- Area: 144
- Dimensions: 12 x 12
Bedroom 2
- Level: Upper
- Area: 132
- Dimensions: 11 x 12
Bedroom 3
- Level: Upper
- Area: 110
- Dimensions: 11 x 10
Bedroom 4
- Level: Upper
- Area: 90
- Dimensions: 10 x 9
Bathroom 1
- Level: Upper
Family room
- Features: Wood
- Level: Main
- Area: 252
- Dimensions: 21 x 12
Living room
- Features: Wood
- Level: Main
- Area: 216
- Dimensions: 18 x 12
Heating
- Forced Air, Natural Gas
Cooling
- Central Air
Appliances
- Included: Dishwasher, Dryer, Range/Oven, Refrigerator, Washer, Gas Water Heater
Features
- Sump Pump
- Flooring: Hardwood, Wood
- Windows: Bay Window(s)
- Basement: Finished
- Number of fireplaces: 1
- Fireplace features: Family Room
Interior area
- Total structure area: 2,859
- Total interior livable area: 2,459 sqft
- Finished area above ground: 1,459
- Finished area below ground: 1,000
Property
Parking
- Total spaces: 3
- Parking features: 3 or More Spaces, Garage, Attached
- Attached garage spaces: 2
Features
- Levels: Two
- Stories: 2
- Frontage type: See Remarks
- Frontage length: 61
Lot
- Size: 7,405 sqft
- Dimensions: 61 x 120
- Features: Wooded, Subdivision, Walk to School, Sidewalks
Details
- Parcel number: 101022153034
- Zoning description: Residential
- Special conditions: Private
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial
- Property subtype: Single Family Residence
Materials
- Brick
- Foundation: Basement
Condition
- New construction: No
- Year built: 1968
Utilities & green energy
- Sewer: Public Sanitary
- Water: Public
Community & neighborhood
Location
- Region: Sterling Heights
- Subdivision: New Bradford Manor Sub
Other
Other facts
- Listing agreement: Exclusive Right To Sell
- Listing terms: Cash,Conventional
- Road surface type: Paved
Price history
| Date | Event | Price |
|---|---|---|
| 10/23/2025 | Sold | $284,000-2.1%$115/sqft |
Source:  MiRealSource #50188412 | ||
| 9/29/2025 | Pending sale | $290,000$118/sqft |
Source: MiRealSource #50188412 | ||
| 9/14/2025 | Listed for sale | $290,000+8.2%$118/sqft |
Source: MiRealSource #50188412 | ||
| 7/12/2022 | Sold | $268,000+1.5%$109/sqft |
Source: Public Record | ||
| 6/1/2022 | Pending sale | $264,000$107/sqft |
Source: MiRealSource #50075890 | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $4,858 +5.6% | $140,600 +5% |
| 2024 | $4,601 +79.2% | $133,900 +11.2% |
| 2023 | $2,568 +2.1% | $120,400 +12.3% |
Find assessor info on the county website
Neighborhood: 48312
Nearby schools
GreatSchools rating
- 7/10Plumbrook Elementary SchoolGrades: PK-6Distance: 0.7 mi
- 4/10Davis Junior High SchoolGrades: 7-9Distance: 0.6 mi
- 9/10Adlai Stevenson High SchoolGrades: 9-12Distance: 1 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.
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
$284,000
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
$284,000