Welcome home to this stunning 3-bedroom, 2.5-bath Craftsman-style beauty, perfectly located just minutes from Metro Parkway and I-75 for ultimate convenience. Step inside and be greeted by soaring two-story ceilings and 9-foot ceilings throughout the main floor, creating a light-filled, open atmosphere.
The luxury bathrooms showcase a European flair, blending sleek design with timeless comfort. Your spacious primary suite offers a spa-like retreat, while the additional bedrooms provide flexibility for family, guests, or a home office.
Enjoy evenings on the large covered front porch, perfect for relaxing, entertaining, or simply watching the world go by. The Craftsman details and thoughtful finishes make this home truly stand out.
?? 3 Bedrooms, 2.5 Baths
?? Soaring Two-Story & 9-Foot Ceilings
?? Spa-Inspired Bathrooms with European Design
?? Covered Front Porch for Outdoor Living
?? Ideal Location Near Metro Parkway & I-75
Custom-built by original owners! This home offers the perfect blend of style, comfort, and convenience—ready for you to move in and enjoy!
?? Schedule your private showing today before it’s gone!
For sale
$569,900
37147 Dundee St, Sterling Heights, MI 48310
3beds
2,030sqft
Est.:
Single Family Residence
Built in 2022
0.27 Acres Lot
$564,300 Zestimate®
$281/sqft
$-- HOA
What's special
- 203 days |
- 1,876 |
- 77 |
Zillow last checked: 8 hours ago
Listing updated: October 02, 2025 at 05:15am
Listed by:
Paul Mychalowych 248-686-0024,
EXP Realty Birmingham 248-686-0024
Source: Realcomp II,MLS#: 20251027271
Tour with a local agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
Heating
- Forced Air, Natural Gas
Cooling
- Central Air
Appliances
- Included: Dishwasher, Disposal, Dryer, Washer
Features
- High Speed Internet, Programmable Thermostat
- Basement: Full,Unfinished
- Has fireplace: Yes
- Fireplace features: Gas, Great Room
Interior area
- Total interior livable area: 2,030 sqft
- Finished area above ground: 2,030
Property
Parking
- Total spaces: 2
- Parking features: Two Car Garage, Attached, Direct Access
- Attached garage spaces: 2
Features
- Levels: Two
- Stories: 2
- Entry location: GroundLevel
- Patio & porch: Covered, Porch
- Pool features: None
Lot
- Size: 0.27 Acres
- Dimensions: 68 x 170
Details
- Parcel number: 1019351051
- Special conditions: Short Sale No,Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial,Craftsman
- Property subtype: Single Family Residence
Materials
- Brick, Stone, Vinyl Siding
- Foundation: Basement, Poured, Sump Pump
- Roof: Asphalt
Condition
- New construction: No
- Year built: 2022
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
Community & HOA
Community
- Subdivision: S/P CURTIS ACRES
HOA
- Has HOA: No
Location
- Region: Sterling Heights
Financial & listing details
- Price per square foot: $281/sqft
- Tax assessed value: $222,904
- Annual tax amount: $9,593
- Date on market: 8/16/2025
- Cumulative days on market: 203 days
- Listing agreement: Exclusive Right To Sell
- Listing terms: Cash,Conventional
Estimated market value
$564,300
$536,000 - $593,000
$3,025/mo
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 8/25/2025 | Price change | $569,900-1.7%$281/sqft |
Source: | ||
| 8/16/2025 | Listed for sale | $579,900+544.3%$286/sqft |
Source: | ||
| 3/7/2016 | Sold | $90,000-1.7%$44/sqft |
Source: | ||
| 12/9/2015 | Price change | $91,600-1.5%$45/sqft |
Source: Weir Manuel #31263866 Report a problem | ||
| 10/21/2015 | Price change | $93,000-3.1%$46/sqft |
Source: Coldwell Banker Weir Manuel #31263866 Report a problem | ||
| 9/23/2015 | Listed for sale | $96,000-26.2%$47/sqft |
Source: Coldwell Banker Weir Manuel-Mc #215103559 Report a problem | ||
| 8/16/2004 | Sold | $130,000+26.2%$64/sqft |
Source: Public Record Report a problem | ||
| 8/22/2000 | Sold | $103,050$51/sqft |
Source: | ||
Public tax history
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $9,593 +3.2% | $248,600 -0.2% |
| 2024 | $9,294 +1135.1% | $249,000 +10.2% |
| 2023 | $752 +2.1% | $226,000 +874.1% |
| 2022 | $737 | $23,200 |
| 2021 | -- | $23,200 +11% |
| 2020 | -- | $20,900 |
| 2019 | -- | $20,900 -58.2% |
| 2018 | $2,215 | $50,000 +7.1% |
| 2017 | -- | $46,700 |
| 2016 | -- | $46,700 +2.6% |
| 2015 | -- | $45,500 +10.4% |
| 2014 | -- | $41,200 |
| 2012 | -- | -- |
| 2009 | -- | -- |
Find assessor info on the county website
BuyAbility℠ payment
Est. payment
$3,283/mo
Principal & interest
$2656
Property taxes
$627
Climate risks
Neighborhood: 48310
Nearby schools
GreatSchools rating
- 6/10Holden Elementary SchoolGrades: PK-6Distance: 0.3 mi
- 4/10Grissom Middle SchoolGrades: 6-8Distance: 1 mi
- 7/10Sterling Heights Senior High SchoolGrades: 9-12Distance: 4.6 mi
Local experts in 48310
- Michigan
- Macomb County
- Sterling Heights
- 48310
- 37147 Dundee St
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







