Spacious upper-level ranch condo featuring 2 bedrooms, 2 full baths, and an attached 1-car garage! As you enter, there's a spacious mud room leading to the staircase. Relax by the fireplace in the living room, featuring vaulted ceilings and plenty of natural light. Expansive kitchen offers ample cabinet and counter space. Adjacent to the kitchen, the dining area features a doorwall leading to a private balcony—perfect for enjoying your morning coffee or evening breeze.
The primary suite includes a walk-in closet and en-suite full bath featuring dual sinks and a seperate tub AND shower. A second large sized bedroom also offers a walk-in closet, private balcony access, and is conveniently located near the second full bath.
This desirable end-unit condo is ideally situated just minutes from shopping, dining, entertainment, and easy freeway access, providing both comfort and convenience.
Sold for $217,000
Zestimate®
$217,000
28712 Sheffield Ct, Chesterfield, MI 48047
2beds
1,750sqft
Condominium
Built in 2004
-- sqft lot
$217,000 Zestimate®
$124/sqft
$1,849 Estimated rent
Home value
$217,000
$206,000 - $228,000
$1,849/mo
Zestimate® history
Owner options
List your home for rent
$1,849/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$1,849/mo
Rent Zestimate®
Refinance and save
$1,756/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$1,756/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
Zillow last checked:
Listing updated:
Listed by:
Garrett M Hayden 586-541-4000,
Keller Williams Realty-Great Lakes,
Erick Monzo 586-210-3350,
Keller Williams Realty-Great Lakes
Bought with:
Kristi Robins, 6501420234
Real Estate One Great Lakes Bay
Source: Realcomp II,MLS#: 20261039677
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 2
- Bathrooms: 2
- Full bathrooms: 2
Primary bedroom
- Level: Second
- Area: 143
- Dimensions: 11 X 13
Bedroom
- Level: Second
- Area: 143
- Dimensions: 11 X 13
Other
- Level: Second
- Area: 50
- Dimensions: 5 X 10
Other
- Level: Second
- Area: 204
- Dimensions: 12 X 17
Kitchen
- Level: Second
- Area: 210
- Dimensions: 15 X 14
Living room
- Level: Second
- Area: 240
- Dimensions: 12 X 20
Heating
- Forced Air, Natural Gas
Cooling
- Ceiling Fans, Central Air
Appliances
- Included: Dryer, Free Standing Gas Range, Free Standing Refrigerator, Washer
Features
- Entrance Foyer
- Has basement: No
- Has fireplace: Yes
- Fireplace features: Living Room
Interior area
- Total interior livable area: 1,750 sqft
- Finished area above ground: 1,750
Property
Parking
- Total spaces: 1
- Parking features: One Car Garage, Attached
- Attached garage spaces: 1
Features
- Levels: One Story Up
- Stories: 1
- Entry location: UpperLevelwSteps
- Patio & porch: Porch
Details
- Parcel number: 0920477030
- Special conditions: Short Sale No,Standard
Construction
Type & style
- Home type: Condo
- Architectural style: Ranch
- Property subtype: Condominium
Materials
- Brick, Other
- Foundation: Slab
Condition
- New construction: No
- Year built: 2004
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
Community & HOA
Community
- Subdivision: STONEHENGE CONDO
HOA
- Has HOA: Yes
- HOA fee: $275 monthly
- HOA phone: 586-737-7641
Location
- Region: Chesterfield
Financial & listing details
- Price per square foot: $124/sqft
- Tax assessed value: $104,357
- Annual tax amount: $5,825
- Date on market: 6/5/2026
- Cumulative days on market: 36 days
- Listing agreement: Exclusive Agency
- Listing terms: Cash,Conventional
Price history
| Date | Event | Price |
|---|---|---|
| 8/11/2026 | Sold | $217,000-3.6%$124/sqft |
Source:  Realcomp II #20261039677 Report a problem | ||
| 6/10/2026 | Price change | $225,000-2.2%$129/sqft |
Source: Realcomp II #20261039677 Report a problem | ||
| 6/5/2026 | Listed for sale | $230,000+21.1%$131/sqft |
Source: Realcomp II #20261039677 Report a problem | ||
| 5/23/2026 | Listing removed | $1,700$1/sqft |
Source: Zillow Rentals Report a problem | ||
| 4/2/2026 | Listed for rent | $1,700+3%$1/sqft |
Source: Zillow Rentals Report a problem | ||
| 11/19/2022 | Listing removed | -- |
Source: Zillow Rental Manager Report a problem | ||
| 11/17/2022 | Listed for rent | $1,650$1/sqft |
Source: Zillow Rental Manager Report a problem | ||
| 11/16/2022 | Sold | $190,000-5%$109/sqft |
Source: Realcomp II #20221044582 Report a problem | ||
| 10/10/2022 | Pending sale | $200,000$114/sqft |
Source: Realcomp II #20221044582 Report a problem | ||
| 9/23/2022 | Listed for sale | $200,000+63.4%$114/sqft |
Source: Realcomp II #20221044582 Report a problem | ||
| 2/7/2019 | Listing removed | $122,408-19.9%$70/sqft |
Source: Auction.com Report a problem | ||
| 1/18/2019 | Listed for sale | -- |
Source: Auction.com Report a problem | ||
| 10/7/2004 | Sold | $152,900$87/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $5,647 +5.4% | $108,800 +3.5% |
| 2024 | $5,355 +195.5% | $105,100 +9% |
| 2023 | $1,812 +2.8% | $96,400 +25.5% |
| 2022 | $1,762 | $76,800 +5.3% |
| 2021 | -- | $72,900 +4.1% |
| 2020 | -- | $70,000 +6.4% |
| 2019 | -- | $65,800 +3% |
| 2018 | $1,587 +117.9% | $63,900 +14.3% |
| 2017 | $728 | $55,900 |
| 2016 | $728 | $55,900 +17.3% |
| 2015 | $728 | $47,650 +10.6% |
| 2014 | -- | $43,100 |
| 2012 | -- | -- |
Find assessor info on the county website
Neighborhood: 48047
Nearby homes
- $187,5002 bd2 ba1.1k sqft28715 Portsmouth Ct, Chesterfield, MI 48047Sold
- $245,0002 bd3 ba2.4k sqft28746 Yarmouth Ct, Chesterfield, MI 48047Sold
- $256,6002 bd2 ba1.6k sqft28724 Sheffield Ct, Chesterfield, MI 48047Off Market
- $259,3002 bd2 ba1.5k sqft28720 Sheffield Ct, Chesterfield, MI 48047Off Market
- $224,9002 bd2 ba1.1k sqft28728 Sheffield Ct, Chesterfield, MI 48047Off Market
- $216,1002 bd2 ba1.1k sqft28716 Sheffield Ct, Chesterfield, MI 48047Off Market
- $256,2002 bd2 ba-- sqft28745 Sheffield Ct, Chesterfield, MI 48047Off Market
- $---- bd-- ba-- sqft28732 Sheffield Ct, New Baltimore, MI 48047Off Market
Nearby schools
GreatSchools rating
- 6/10Dean A. Naldrett SchoolGrades: PK-5Distance: 0.6 mi
- 6/10Anchor Bay Middle School SouthGrades: 6-8Distance: 1.5 mi
- 7/10Anchor Bay High SchoolGrades: 9-12Distance: 5.9 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
$217,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
$217,000
- Michigan
- Macomb County
- Chesterfield
- 48047
- 28712 Sheffield Ct
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Chesterfield Topics
