Seller's Agent in 2025
John DiPiazza
EXP Realty Rochester
(586) 634-2246
105 in this area
152 Total Sales
55810 Stewart Dr Macomb, MI 48042
3
Beds
2
Baths
2,165
Sq Ft
9,583
Sq Ft Lot
Highlights
- New Construction
- 2-Story Property
- Mud Room
- Beacon Tree Elementary School Rated A-
- Ground Level Unit
- 3 Car Attached Garage
About This Home
As of September 2025This home has been completed and is ready for a new family!
Welcome to this stunning 2165 sq. ft. split-style ranch, thoughtfully designed with the primary suite on one side and guest accommodations on the other for maximum privacy.
The spacious kitchen boasts a big island, perfect for cooking and entertaining. The nook features a door-wall that opens to a covered patio, creating a seamless indoor-outdoor living experience.
Enjoy the elegance of 9-foot ceilings throughout, with a soaring 11-foot ceiling in the great room, enhanced by a floor-to-ceiling stone fireplace that serves as a striking focal point. Recessed lighting brightens the space, while the primary bedroom also has a door-wall for easy access to the patio.
A flexible room on the second floor can serve as a 4th bedroom or a versatile space to suit your needs. Additional highlights include tray ceilings, stylish wood beams, and practical mudroom lockers for everyday organization.
Built by Acadia Home Builders, Macomb County's premier home builder, this ranch combines comfort and style in every detail. Don't miss your chance to make this exceptional home yours!
This home is in the Utica School District!!!
Last Agent to Sell the Property
EXP Realty Rochester License #6502119029 Listed on: 04/09/2025
Home Details
Home Type
- Single Family
Est. Annual Taxes
Year Built
- Built in 2025 | New Construction
Lot Details
- 9,583 Sq Ft Lot
- Lot Dimensions are 74.00 x 130.00
HOA Fees
- $42 Monthly HOA Fees
Parking
- 3 Car Attached Garage
Home Design
- 2-Story Property
- Brick Exterior Construction
- Poured Concrete
Interior Spaces
- 2,165 Sq Ft Home
- Recessed Lighting
- Mud Room
- Great Room with Fireplace
- Unfinished Basement
- Sump Pump
Bedrooms and Bathrooms
- 3 Bedrooms
- 2 Full Bathrooms
Location
- Ground Level Unit
Utilities
- Forced Air Heating System
- Heating System Uses Natural Gas
Community Details
- The Jolicor Association, Phone Number (586) 323-5090
Listing and Financial Details
- Home warranty included in the sale of the property
- Assessor Parcel Number 0805431002
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Apr 9, 2025
Closed on
Sep 26, 2025
Sold by
Acadia Home Builders Llc
Bought by
Lehman Andrew James
Seller's Agent
John DiPiazza
EXP Realty Rochester
Buyer's Agent
John DiPiazza
EXP Realty Rochester
List Price
$594,900
Sold Price
$595,000
Premium/Discount to List
$100
0.02%
Views
57
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$6,094
Avg. Annual Appreciation
-4.03%
Original Mortgage
$476,000
Outstanding Balance
$476,000
Interest Rate
6.58%
Mortgage Type
New Conventional
Estimated Equity
$112,906
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Values in the Area
Average Home Value in this Area
Purchase History
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Warranty Deed | $595,000 | First American Title | |
| Quit Claim Deed | -- | First American Title |
Source: Public Records
Mortgage History
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $476,000 | New Conventional |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 09/26/2025 09/26/25 | Sold | $595,000 | 0.0% | $275 / Sq Ft |
| 09/08/2025 09/08/25 | Pending | -- | -- | -- |
| 04/09/2025 04/09/25 | For Sale | $594,900 | -- | $275 / Sq Ft |
Source: Realcomp
Tax History Compared to Growth
Tax History
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2025 | $1,117 | $97,100 | $0 | $0 |
| 2024 | $236 | $39,000 | $0 | $0 |
| 2023 | $224 | $39,000 | $0 | $0 |
| 2022 | $406 | $37,500 | $0 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
John DiPiazza
Map
Source: Realcomp
MLS Number: 20250024618
APN: 20-08-05-431-002
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
IDX provided courtesy of Realcomp II Ltd. via Ten-X and MLS
Copyright 2025 Realcomp II Ltd. Shareholders
IDX information is provided exclusively for consumers' personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified.
Listing Information presented by local MLS brokerage: Ten-X, local REALTOR®- Arlene Richardson - (888)-952-6393
Nearby Homes
- 18620 Stallmann Dr
- 18430 Stallman Dr
- 18883 Brighton Dr
- 55649 Faldo Dr Unit 141
- 18582 Stallmann Dr
- 18064 Stallman Dr
- 18037 Player Dr
- 18005 Player Dr
- 18727 Saint Matthew Dr
- 55203 Saint Paul Dr
- 56508 Topaz Dr
- 18213 Stallman Dr Unit 137
- 17829 Stallman Dr
- 17836 Country Club Dr
- 17835 Player Dr
- 55802 Jones Dr
- 56452 Scotland
- 55777 Jones Dr
- 55809 Jones Dr
- 55809 Jones Dr Unit 113