Save
Ask
Tour
Hide
$529,900
19 Days On Site
38206 Brook DriveSterling Heights City, MI 48312
For Sale|Single Family Residence|Active
4
Beds
3
Total Baths
2
Full Baths
1
Partial Bath
3,041
SqFt
$174
/SqFt
2004
Built
Subdivision:
PLUMCREEK ESTATES
County:
Macomb
Call Now: 810-360-3488
Is this the listing for you? We can help make it yours.
810-360-3488
Save
Ask
Tour
Hide
Mortgage Calculator
Monthly Payment (Est.)
$2,418Calculator powered by Showcase IDX, a Constellation1 Company. Copyright ©2026 Information is deemed reliable but not guaranteed.
This is the house you want to see and explore. This remodeled colonial is in a desirable area. Two car attached garage, four bedrooms, two and a half bathrooms, updated Kitchen and Bathrooms, Recess lights are in most parts of the house, 2025 Roof, New premium laminate floors. Stainless steel appliances, New kitchen cabinets with Quartz countertops, finished basement, fenced yard with a beautiful patio for your summer entertainment, this house combines the charm, functionality and the location. Utica community schools, close to Sterling Heights Library and Park. Ready in a Move in condition with zero days occupancy.
Save
Ask
Tour
Hide
Listing Snapshot
Price
$529,900
Days On Site
19 Days
Bedrooms
4
Inside Area (SqFt)
3,041 sqft
Total Baths
3
Full Baths
2
Partial Baths
1
Lot Size
0.15 Acres
Year Built
2004
MLS® Number
20261054174
Status
Active
Property Tax
$5,466
HOA/Condo/Coop Fees
$75 monthly
Sq Ft Source
Public Records
Friends & Family
Recent Activity
| 3 weeks ago | Status changed to Active | |
| 3 weeks ago | Listing updated with changes from the MLS® | |
| 3 weeks ago | Listing first seen on site |
General Features
Acres
0.15
Attached Garage
Yes
Cross Street
East of Dodge Park Rd, South of Plum Brook Rd
Disclosures
Taxes Homestead Exempt
Garage
Yes
Garage Spaces
2
Levels
Two
Parking
Attached
Property Sub Type
Single Family Residence
Sewer
Public Sewer
Special Circumstances
Standard
SqFt Above
2041
SqFt Below
1000
Style
Colonial
Water Source
Public
Interior Features
Basement
Finished
Cooling
Central Air
Heating
Forced AirNatural Gas
BathFull
BathLav
Bedroom
Dimensions - 12 X 10Level - Second
Family Room
Dimensions - 16 X 16
Kitchen
Dimensions - 16 X 13
Living Room
Dimensions - 13 X 10
Master Bathroom
Level - Second
Master Bedroom
Dimensions - 19 X 13Level - Second
Save
Ask
Tour
Hide
Exterior Features
Construction Details
Brick
Pool Features
None
Community Features
Association Dues
75
Building Access
GroundLevel
Financing Terms Available
CashConventionalFHAVA Loan
HOA Fee Frequency
Monthly
MLS Area
Area03101SterlingHeights
Roads
Paved
School District
Utica
Schools
School District
Utica
Elementary School
Unknown
Middle School
Unknown
High School
Unknown
Listing courtesy of Realty Executives Home Towne: [email protected]
IDX provided courtesy of Realcomp II Ltd. via RealcompIILtd. Copyright © 2026 Realcomp II Ltd. Shareholders.
IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing and that the data is deemed reliable but not guaranteed accurate by the MLS.
IDX provided courtesy of Realcomp II Ltd. via RealcompIILtd. Copyright © 2026 Realcomp II Ltd. Shareholders.
IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing and that the data is deemed reliable but not guaranteed accurate by the MLS.
Neighborhood & Commute
Source: Walkscore
Save
Ask
Tour
Hide
Did you know? You can invite friends and family to your search. They can join your search, rate and discuss listings with you.