Welcome to this Beautiful Two-Bedroom, Two-Full-Bath Ranch Located in Northern Macomb County near Romeo Plank and 23 Mile Road. Featuring an Open-Concept Living Space, this Home Offers Comfort, Convenience, and Easy One-Level Living.
The Updated Kitchen Boasts Rich Custom-Made Cabinet by La Fata and Granite Countertops, While Hardwood Floors Throughout Add Warmth and Timeless Appeal. Enjoy the Convenience of a First-Floor Laundry Room, a Full Basement Offering Plenty of Storage or Additional Living Space Potential, and an Attached Two-Car Garage.
Perfect for Empty Nester's or Anyone Looking to Downsize, with Comfort and Functionality, this Lovely Ranch Offers the Ideal Blend of Style and Practicality in a Desirable Location!
For sale
$289,900
17230 Mayfield Dr, Macomb, MI 48042
2beds
2,204sqft
Condominium
Built in 1997
-- sqft lot
$287,100 Zestimate®
$132/sqft
$177/mo HOA
What's special
- 8 days
- 1,190
- 133
Likely to sell faster than
Zillow last checked:
Listing updated:
Listed by:
John Selby 586-216-6354,
AMC Realty Corporation 586-797-0300
Source: Realcomp II,MLS#: 20261083103
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 2
- Bathrooms: 2
- Full bathrooms: 2
Bedroom
- Level: Entry
- Area: 156
- Dimensions: 13 X 12
Bedroom
- Level: Entry
- Area: 110
- Dimensions: 11 X 10
Other
- Level: Entry
- Area: 70
- Dimensions: 10 X 7
Other
- Level: Entry
- Area: 70
- Dimensions: 10 X 7
Dining room
- Level: Entry
- Area: 100
- Dimensions: 10 X 10
Kitchen
- Level: Entry
- Area: 99
- Dimensions: 11 X 9
Laundry
- Level: Entry
- Area: 40
- Dimensions: 8 X 5
Living room
- Level: Entry
- Area: 180
- Dimensions: 15 X 12
Heating
- Forced Air, Natural Gas
Cooling
- Central Air
Appliances
- Included: Dishwasher, Disposal, Free Standing Electric Range, Range Hood, Stainless Steel Appliances
- Laundry: Laundry Room
Features
- Basement: Unfinished
- Has fireplace: No
Interior area
- Total interior livable area: 2,204 sqft
- Finished area above ground: 1,110
- Finished area below ground: 1,094
Property
Parking
- Total spaces: 2
- Parking features: Two Car Garage, Attached
- Attached garage spaces: 2
Features
- Levels: One
- Stories: 1
- Entry location: GroundLevel
- Patio & porch: Patio, Porch
- Pool features: None
Details
- Parcel number: 0817253065
- Special conditions: Short Sale No,Standard
Construction
Type & style
- Home type: Condo
- Architectural style: Ranch
- Property subtype: Condominium
Materials
- Brick
- Foundation: Basement, Poured
- Roof: Asphalt
Condition
- New construction: No
- Year built: 1997
Utilities & green energy
- Electric: Circuit Breakers
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Underground Utilities
Community & HOA
Community
- Subdivision: WESTGROVE ESTATES
HOA
- Has HOA: Yes
- Services included: Maintenance Grounds
- HOA fee: $177 monthly
Location
- Region: Macomb
Financial & listing details
- Price per square foot: $132/sqft
- Tax assessed value: $109,389
- Annual tax amount: $3,781
- Date on market: 10/15/2026
- Cumulative days on market: 8 days
- Listing agreement: Exclusive Right To Sell
- Listing terms: Cash,Conventional
Estimated market value
$287,100
$273,000 - $301,000
$2,189/mo
Price history
| Date | Event | Price |
|---|---|---|
| 10/15/2026 | Listed for sale | $289,900+40.4%$132/sqft |
Source:  Realcomp II #20261083103 Report a problem | ||
| 8/5/2025 | Sold | $206,533-16.6%$94/sqft |
Source: Public Record Report a problem | ||
| 3/22/2023 | Sold | $247,500-1%$112/sqft |
Source: Public Record Report a problem | ||
| 2/7/2023 | Pending sale | $249,999$113/sqft |
Source: Owner Report a problem | ||
| 1/9/2023 | Listed for sale | $249,999+31.6%$113/sqft |
Source: Owner Report a problem | ||
| 6/25/2020 | Sold | $190,000-1.8%$86/sqft |
Source:  MiRealSource #50009818 Report a problem | ||
| 5/14/2020 | Pending sale | $193,500$88/sqft |
Source: RE/MAX Advisors #50009818 Report a problem | ||
| 4/23/2020 | Price change | $193,500-0.7%$88/sqft |
Source: Keller Williams Realty #219086634 Report a problem | ||
| 3/23/2020 | Listed for sale | $194,900$88/sqft |
Source: Keller Williams Realty-Great Lakes #219086634 Report a problem | ||
| 2/24/2020 | Pending sale | $194,900$88/sqft |
Source: Keller Williams Realty #219086634 Report a problem | ||
| 1/30/2020 | Price change | $194,900-0.1%$88/sqft |
Source: Keller Williams Realty-Great Lakes #219086634 Report a problem | ||
| 1/13/2020 | Price change | $195,000-0.5%$88/sqft |
Source: Keller Williams Realty-Great Lakes #219086634 Report a problem | ||
| 12/30/2019 | Price change | $196,000-0.5%$89/sqft |
Source: Keller Williams Realty-Great Lakes #219086634 Report a problem | ||
| 12/2/2019 | Price change | $196,900-1.1%$89/sqft |
Source: Keller Williams Realty-Great Lakes #219086634 Report a problem | ||
| 11/20/2019 | Price change | $199,000-0.5%$90/sqft |
Source: Keller Williams Realty-Great Lakes #219086634 Report a problem | ||
| 11/4/2019 | Listed for sale | $199,900$91/sqft |
Source: Keller Williams Realty-Great Lakes #219086634 Report a problem | ||
| 10/1/2019 | Pending sale | $199,900$91/sqft |
Source: Keller Williams Realty #219086634 Report a problem | ||
| 8/24/2019 | Price change | $199,900+1.5%$91/sqft |
Source: Keller Williams Realty #219086634 Report a problem | ||
| 7/30/2019 | Price change | $197,000-1.5%$89/sqft |
Source: Owner Report a problem | ||
| 7/14/2019 | Price change | $199,900+0.7%$91/sqft |
Source: Owner Report a problem | ||
| 6/30/2019 | Price change | $198,500-0.7%$90/sqft |
Source: Owner Report a problem | ||
| 6/25/2019 | Listed for sale | $199,900$91/sqft |
Source: Owner Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2026 | $3,781 +9.3% | $129,100 +7.1% |
| 2025 | $3,458 +9.9% | $120,500 +13.6% |
| 2024 | $3,148 +4.4% | $106,100 +10.1% |
| 2023 | $3,016 +0% | $96,400 +4.2% |
| 2022 | $3,015 +8.4% | $92,500 +0.5% |
| 2021 | $2,782 | $92,000 +3.8% |
| 2020 | $2,782 +5.7% | $88,600 +10.6% |
| 2019 | $2,631 +4.4% | $80,100 +4.4% |
| 2018 | $2,521 +5.3% | $76,700 +13.2% |
| 2017 | $2,393 | $67,740 +0% |
| 2016 | $2,393 | $67,720 +15.9% |
| 2015 | $2,393 +660.9% | $58,410 +19.4% |
| 2011 | $315 | $48,930 -36.7% |
| 2009 | -- | $77,250 +26.1% |
| 2001 | $1,644 | $61,260 |
Find assessor info on the county website
Monthly payment
Est. payment
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Climate risks
Neighborhood: 48042
Similar homes
- $239,0002 bd2 ba1.5k sqft16714 Gemstone Dr, Macomb, MI 48042For Sale By Owner
- $249,9002 bd2 ba1.5k sqft52355 Stoneridge Dr, Macomb, MI 48042For Sale
MLS ID #26055900, Jad I Ramadan, EXP Realty LLC. MichRIC - $319,9002 bd2 ba1.4k sqft52689 Wildwood Dr, Macomb, MI 48042For Sale
MLS ID #26045762, Scott Wilcox, eXp Realty, LLC. MichRIC - $329,9002 bd3 ba1.6k sqft52843 Sable Dr, Macomb, MI 48042For Sale
MLS ID #50220722, Joseph A. Iacona, Keller Williams Realty Lakeside. MiRealSource - $359,9003 bd3 ba2.1k sqft16827 Sandstone Cir, Macomb, MI 48042For Sale
MLS ID #20261085404, Philis Carlier, REALTEAM Real Estate. Realcomp II - $289,9002 bd3 ba2.6k sqft16306 E Hill Dr, Macomb, MI 48044For SaleMLS ID #50224000, Jacob Thompson, RE/MAX First. MiRealSource
- $374,9003 bd4 ba3.1k sqft16727 Cobblestone West Blvd, Macomb, MI 48042For SaleMLS ID #26055282, Jeffrey Glover, Keller Williams Professionals. MichRIC
- $365,0002 bd2 ba1.4k sqft52440 Westfield Dr, Macomb, MI 48042For SaleMLS ID #20261081313, Gwen Daubenmeyer, Keller Williams Paint Creek. Realcomp II
- $320,0002 bd3 ba2.4k sqft50307 Brockton Ct, Macomb, MI 48044For SaleMLS ID #50224322, Becky Post, KW Platinum. MiRealSource
- $244,9002 bd2 ba1.5k sqft52280 Heatherstone Ave, Macomb, MI 48042For SaleMLS ID #20261068869, Andre Audo, Realty Executives Home Towne. Realcomp II
- $290,0002 bd2 ba1.6k sqft22113 Aberdeen Dr, Macomb, MI 48042For SaleMLS ID #20261077052, Mark Kattula, @properties Christie's Int'l R.E. Birmingham. Realcomp II
- $295,0004 bd2 ba1.7k sqft21181 24 Mile Rd, Macomb, MI 48042For SaleMLS ID #50219640, Lisa Nolff, Keller Williams Realty Lakeside. MiRealSource
- $309,9002 bd2 ba1.4k sqft50261 Pepper Tree Dr Unit 306, Macomb, MI 48044For SaleMLS ID #20261082236, Daniel DeYonker, EXP Realty Rochester. Realcomp II
- $282,5002 bd2 ba1.5k sqft21950 Aberdeen Dr #44, Macomb, MI 48042For SaleMLS ID #20261076801, Beta Camaj, Powell Real Estate. Realcomp II
- $295,0003 bd2 ba1.4k sqft21912 Aberdeen Dr, Macomb, MI 48042For SaleMLS ID #50220611, Julie Ann Brown, Realty Executives Home Towne Romeo. MiRealSource
- $284,0002 bd2 ba1.6k sqft21930 Andover Dr Unit 77, Macomb, MI 48042For SaleMLS ID #20261044008, Penny Potocki, Red Carpet Lakeside Real Estate Inc. Realcomp II
- $239,9002 bd2 ba2.2k sqft14955 Hartford Ct, Shelby Township, MI 48315For SaleMLS ID #50225619, Jonnie Lewandowski, Good Company Realty LLC. MiRealSource
- $245,9002 bd2 ba1.5k sqft52268 Naugatuck Dr, Macomb, MI 48042For SaleMLS ID #50221996, Elaine M. Viccars, Century 21 Professionals Sterling Heights. MiRealSource
