Better than new! This stunning 4-bed, 2.5-bath Colonial (built 2023) offers nearly 2,900 sq ft of refined living space with premium upgrades throughout. The backyard is transformed into a private oasis featuring a stamped concrete patio, pergola, and spa-quality Jacuzzi — perfect for year-round entertaining. Inside, designer lighting fixtures elevate every room, while custom tile inlays in the hardwood floors of the kitchen and dining areas add unique elegance. The open floor plan flows seamlessly, complemented by a spacious 3-car garage and modern finishes. Unlike typical new builds, all upgrades are complete, professionally installed, and move-in ready — delivering the warranty and efficiency of new construction with the style and sophistication of a custom home. Located in a desirable Macomb neighborhood, this home blends everyday comfort with luxury touches, creating a truly one-of-a-kind property. Offered at $599,900.
Sold for $615,000
$615,000
24538 Brookshire Dr, Macomb, MI 48042
4beds
2,972sqft
Single Family Residence
Built in 2023
0.25 Acres Lot
$638,400 Zestimate®
$207/sqft
$3,787 Estimated rent
Home value
$638,400
$600,000 - $683,000
$3,787/mo
Zestimate® history
Owner options
List your home for rent
$3,787/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$3,787/mo
Rent Zestimate®
Refinance and save
$4,332/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$4,332/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Modern finishesOpen floor planSpa-quality jacuzziLuxury touchesDesigner lighting fixtures
Zillow last checked:
Listing updated:
Listed by:
Samuel Johnny 248-230-8767,
Urban Ridge Realty LLC
Bought with:
Tameka Littleton, 6501426051
Elite Realty
Source: Realcomp II,MLS#: 20251056928
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
Bedroom
- Level: Second
- Area: 132
- Dimensions: 12 X 11
Bedroom
- Level: Second
- Area: 154
- Dimensions: 11 X 14
Bedroom
- Level: Second
- Area: 154
- Dimensions: 11 X 14
Bedroom
- Level: Second
- Area: 154
- Dimensions: 11 X 14
Primary bathroom
- Level: Second
- Area: 238
- Dimensions: 14 X 17
Other
- Level: Second
Other
- Level: Entry
- Area: 32
- Dimensions: 4 X 8
Other
- Level: Entry
- Area: 165
- Dimensions: 11 X 15
Dining room
- Level: Entry
- Area: 154
- Dimensions: 11 X 14
Great room
- Level: Entry
- Area: 240
- Dimensions: 15 X 16
Kitchen
- Level: Entry
- Area: 165
- Dimensions: 11 X 15
Laundry
- Level: Second
- Area: 80
- Dimensions: 10 X 8
Library
- Level: Entry
- Area: 154
- Dimensions: 11 X 14
Heating
- ENERGYSTAR Qualified Furnace Equipment, Forced Air, Natural Gas
Features
- Basement: Unfinished
- Has fireplace: No
Interior area
- Total interior livable area: 2,972 sqft
- Finished area above ground: 2,972
Property
Parking
- Total spaces: 3
- Parking features: Three Car Garage, Attached
- Garage spaces: 3
Features
- Levels: Two
- Stories: 2
- Entry location: GroundLevelwSteps
- Pool features: Above Ground
- Fencing: Back Yard
Lot
- Size: 0.25 Acres
- Dimensions: 75 x 147
Details
- Parcel number: 0824280053
- Special conditions: Short Sale No,Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial
- Property subtype: Single Family Residence
Materials
- Brick
- Foundation: Basement, Poured
- Roof: Asphalt
Condition
- New construction: No
- Year built: 2023
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
Green energy
- Energy efficient items: Appliances
Community & HOA
Community
- Subdivision: PINNACLE FARMS
HOA
- Has HOA: Yes
- HOA fee: $325 annually
Location
- Region: Macomb
Financial & listing details
- Price per square foot: $207/sqft
- Tax assessed value: $303,100
- Annual tax amount: $8,524
- Date on market: 11/28/2025
- Cumulative days on market: 92 days
- Listing agreement: Exclusive Agency
- Listing terms: Cash,Conventional,FHA,Va Loan
Price history
| Date | Event | Price |
|---|---|---|
| 1/9/2026 | Sold | $615,000+2.5%$207/sqft |
Source:  Realcomp II #20251056928 Report a problem | ||
| 1/5/2026 | Pending sale | $599,900$202/sqft |
Source: Realcomp II #20251056928 Report a problem | ||
| 11/28/2025 | Listed for sale | $599,900-4.8%$202/sqft |
Source: Realcomp II #20251056928 Report a problem | ||
| 11/20/2025 | Listing removed | $630,000$212/sqft |
Source: Realcomp II #20251042361 Report a problem | ||
| 11/17/2025 | Price change | $630,000-3.1%$212/sqft |
Source: Realcomp II #20251042361 Report a problem | ||
| 11/5/2025 | Price change | $649,900-3%$219/sqft |
Source: Realcomp II #20251042361 Report a problem | ||
| 10/28/2025 | Price change | $669,900-1.5%$225/sqft |
Source: Realcomp II #20251042361 Report a problem | ||
| 10/3/2025 | Listed for sale | $679,900$229/sqft |
Source: Realcomp II #20251042361 Report a problem | ||
| 9/25/2025 | Listing removed | $679,900$229/sqft |
Source: Realcomp II #20251036188 Report a problem | ||
| 9/23/2025 | Contingent | $679,900$229/sqft |
Source: Realcomp II #20251036188 Report a problem | ||
| 9/12/2025 | Listed for sale | $679,900+13.3%$229/sqft |
Source: Realcomp II #20251036188 Report a problem | ||
| 4/25/2024 | Sold | $600,000+1.7%$202/sqft |
Source: Realcomp II #20230057277 Report a problem | ||
| 3/18/2024 | Pending sale | $589,900$198/sqft |
Source: Realcomp II #20230057277 Report a problem | ||
| 7/13/2023 | Listed for sale | $589,900$198/sqft |
Source: Realcomp II #20230057277 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $5,765 +2807.6% | $303,100 +36.5% |
| 2024 | $198 -27% | $222,100 +422.6% |
| 2023 | $271 +12.9% | $42,500 +3.7% |
| 2022 | $240 | $41,000 +6.5% |
| 2021 | -- | $38,500 |
Find assessor info on the county website
Neighborhood: 48042
Nearby homes
- $675,0004 bd4 ba4.3k sqft50142 Kapalua Dr, Macomb, MI 48042Sold
- $619,8904 bd4 ba2.7k sqft50170 Kapalua Dr, Macomb, MI 48042Pending
- $650,0004 bd3 ba2.9k sqft24487 Brookshire Dr, Macomb, MI 48042Sold
- $364,7003 bd2 ba1.4k sqft50075 Fairchild Rd, Chesterfield, MI 48051Off Market
- $592,0003 bd3 ba3.7k sqft49991 Fairchild Rd, Chesterfield, MI 48051Off Market
- $409,2003 bd2 ba1.6k sqft50105 Fairchild Rd, Chesterfield, MI 48051Off Market
- $457,3003 bd3 ba2.3k sqft50165 Fairchild Rd, Chesterfield, MI 48051Off Market
- $625,4754 bd3 ba3k sqft24738 Callaway Dr, Macomb, MI 48042Sold
Nearby schools
GreatSchools rating
- 6/10Joseph M. Carkenord Elementary SchoolGrades: K-5Distance: 1.8 mi
- 7/10L'anse Creuse Middle School - EastGrades: 6-8Distance: 3.2 mi
- 8/10L'anse Creuse High School - NorthGrades: 9-12Distance: 2.1 mi
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
$638,400
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
$638,400
- Michigan
- Macomb County
- Macomb
- 48042
- 24538 Brookshire Dr
Nearby cities
Nearby zip codes
Other Macomb Topics
