Seller's Agent in 2025
Haig Istamboulian
Arterra Realty Michigan LLC
(248) 379-6547
2 in this area
247 Total Sales
EXTREMELY RARE OPPORTUNITY IN HIGHLY DESIRABLE “THE ORCHARDS ASHBURY CONDOS”. Extremely Clean Detached Condo in a Cul-De-Sac w/Incredible View of Wide Open Commons Area. Large Primary Bedroom w/Walk-In Closet & Sizeable Ensuite w/Jetted Tub & Shower. Vastly Sized Natural Light Filled Great Room w/Soaring Cathedral Ceiling, Gas Fireplace w/Ceramic Surround, Wood Mantle & Skylights, Attached to Dining Room. Open Kitchen w/Built-In Double Ovens, Cooktop, Corian Counters, Undermount Sink, Ceramic Backsplash, Hardwood Floor, Dining Nook & Door Wall to Substantially Sized Back Deck. Private Den/Office w/French Doors, Hardwood Floor & Cathedral Ceiling. First Floor Laundry & Half Bath. Upstairs Features 2 Spacious Bedrooms & Full Bath. Huge Fully Finished Extended Height Walk-Out Basement PERFECT for Entertaining. Custom-Built Wet Bar w/Refrigerator, Dishwasher & Disposal, Family Room, Dining Area, Full Bathroom, Plenty of Storage Space & Door Wall to Immaculate Brick Paver Patio Overlooking an Open & Massive Commons Area. 2 Car Attached Garage. Across the Street from The Orchards Golf Club, Macomb Orchard Trail, Stoney Creek Metro Park & M-53. HOA includes Trash, Snow Removal & Lawn Maintenance. Other Features/Updates Include: New Roof (2021), Hot Water Heater (2024), Furnace/AC (2016), Low Maintenance Composite Decking (Foundation Repairs & Beams Reset (2023), New Insulated Garage Door (2022), Separate Water Meter for Irrigation. HOA Includes Trash, Snow Removal & Lawn Maintenance.
Last Agent to Sell the Property
Arterra Realty Michigan LLC License #6501304368 Listed on: 10/25/2024
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 02/05/2025 02/05/25 | Sold | $524,000 | -0.2% | $229 / Sq Ft |
| 01/20/2025 01/20/25 | Pending | -- | -- | -- |
| 11/04/2024 11/04/24 | Price Changed | $524,900 | -3.7% | $229 / Sq Ft |
| 10/25/2024 10/25/24 | For Sale | $544,900 | -- | $238 / Sq Ft |
| 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 | $3,178 | $238,100 | $0 | $0 |
| 2024 | $30 | $226,500 | $0 | $0 |
| 2023 | $2,926 | $184,900 | $0 | $0 |
| 2022 | $4,065 | $179,200 | $0 | $0 |
| 2021 | $3,977 | $160,900 | $0 | $0 |
| 2020 | $2,709 | $174,400 | $0 | $0 |
| 2019 | $3,649 | $180,500 | $0 | $0 |
| 2018 | $3,576 | $170,700 | $0 | $0 |
| 2017 | $3,449 | $166,200 | $47,500 | $118,700 |
| 2016 | $3,455 | $166,200 | $0 | $0 |
| 2015 | -- | $134,300 | $0 | $0 |
| 2013 | $3,187 | $119,500 | $13,100 | $106,400 |
| 2012 | $3,187 | $109,000 | $0 | $0 |
Seller's Agent in 2025
Haig Istamboulian
Arterra Realty Michigan LLC
(248) 379-6547
2 in this area
247 Total Sales
Buyer's Agent in 2025
Teri Weems
Berkshire Hathaway HomeServices Kee Realty Wash
(248) 701-7114
8 in this area
52 Total Sales
Source: Realcomp
MLS Number: 20240079711
APN: 24-04-15-351-011