TD GameChangerLoading details
Loading rows
Roseville, Michigan, 48066
Opening bid
$2,487
Assessed value
$36,200
Market / AVM
$96,000
Taxes owed
—
Legal description
CASTLE GARDENS CONDOMINIUM; MCCP NO. 57; UNIT 26
Property facts enriched via realestateapi · 9/29/2026
RealEstateAPI PropertyDetail · Every populated field, as returned · 229 values
| Id | 172,170,237 |
|---|---|
| Beds | 2 |
| Baths | 1 |
| Mls sold | Yes |
| Mls type | ForSale |
| Cash buyer | Yes |
| Flood zone | Yes |
| Free clear | Yes |
| Mls status | Closed |
| Quit claim | Yes |
Official appraiser / assessor — free, always available. Copy the parcel number if the link opens a search page.
17156 recorded outcomes in MI|Tax Deed (17156 with winning bid).
This record was compiled from the published sale list. Parcels are pulled, redeemed, and re-priced up to the moment of sale. Confirm the lot is still in the sale, and confirm the opening bid, directly with the county.
Macomb County Treasurer — Tax Foreclosure Auctions ↗| High equity |
|---|
| Yes |
| Last sale date | 2024-05-28 |
|---|
| Mls has photos | Yes |
|---|
| Mls sold price | $24,899 |
|---|
| Property type | CONDO |
|---|
| Equity percent | 100 |
|---|
| Flood zone type | X |
|---|
| Last sale price | $3,000 |
|---|
| Owner occupied | Yes |
|---|
| Estimated value | $96,000 |
|---|
| Last update date | 2026-09-23 00:00:00 UTC |
|---|
| Mls listing date | 2016-11-07 |
|---|
| Estimated equity | $96,000 |
|---|
| Mls days on market | 1 |
|---|
| Mls last sale date | 2026-06-30 |
|---|
| Mls listing price | $24,899 |
|---|
| Mls total updates | 1 |
|---|
| Mls last status date | 2026-06-30 |
|---|
| Flood zone description | AREA OF MINIMAL FLOOD HAZARD |
|---|
| Mls listing price per square foot | 28.04 |
|---|
| Apn | 08-14-08-177-047 |
|---|---|
| Land use | Residential |
| Lot acres | 4.74 |
| Census block | 3003 |
| Census tract | 255200 |
| Property use | Condominium Unit (Residential) |
| Subdivision | Garden |
| Lot depth feet | 683.2 |
| Lot width feet | 340.3 |
| Lot square feet | 206,340 |
| Property class | The general use for the property is for residential purposes |
| Apn unformatted | 081408177047 |
| Census block group | 3 |
| Legal description | CASTLE GARDENS CONDOMINIUM, MACOMB COUNTY CONDOMINIUM SUBDIVISION PLAN NO. 57 BLDG B, APT 26 MASTER DEED L2372 P 613 TO 649 |
| Year | 2,025 |
|---|---|
| Tax amount | $2,024 |
| Property id | 172,170,237 |
| Market value | $72,400 |
| Assessed value | $36,200 |
| Assessment year | 2,026 |
| Ltv | 100 |
|---|---|
| Book | 29614 |
| Page | 214 |
| Seq no | 1 |
| Sale date | 2024-05-28 |
| Buyer names | Christopher Elliott |
| Sale amount | $3,000 |
| Down payment | $3,000 |
| Seller names | Jerry Ford |
| Document type | Quit Claim Deed |
| Recording date | 2024-06-03 |
| Document number | 202400046093 |
| Purchase method | Cash Purchase |
| Owner individual | Yes |
| Transaction type | Non-Arm's Length Transactions |
| Document type code | DTQC |
| Prior owner months owned | 89 |
| Owner1 type | Individual |
|---|---|
| Owner2 type | Other |
| Mail address · zip | 48066 |
| Mail address · city | Roseville |
| Mail address · fips | 26099 |
| Mail address · unit | 209B |
| Mail address · zip4 | 1596 |
| Mail address · house | 30205 |
| Mail address · label | 30205 Utica Rd Apt 209B, Roseville, MI 48066 |
| Mail address · state | MI |
| Mail address · street | Utica |
| Mail address · address | 30205 Utica Rd Apt 209b |
| Mail address · unit type | Apt |
| Owner occupied | Yes |
| Owner1 full name | Christopher Elliott |
| Owner1 last name | Elliott |
| Owner1 first name | Christopher |
| Ownership length | 27 |
| Beds | Type | Baths | Price | Seq no | Status | Agent name | Agent email | Agent phone | Property id | Status date | Agent office | Days on market | Last status date |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | condo | 1 | $24,899 | 1 | Closed | Lisa Rush | lisarush@kwlakeside.com | 5869098686 | 172,170,237 | 2026-06-30 | Keller Williams Realty Lakeside | 1 | 2026-06-30 |
| Ltv | Book | Page | Seq no | Sale date | Buyer names | Sale amount | Down payment | Seller names | Document type | Recording date | Document number | Purchase method | Owner individual | Transaction type | Document type code | Arms length |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 100 | 29614 | 214 | 1 | 2024-05-28 | Christopher Elliott | $3,000 | $3,000 | Jerry Ford | Quit Claim Deed | 2024-06-03 | 202400046093 | Cash Purchase | Yes | Non-Arm's Length Transactions | DTQC | |
| 25172 | 812 | 2 | 2017-12-27 | Jerry Ford | Early Ventures Llc | Intrafamily Transfer | 2018-01-19 | 8006883 | Cash Purchase | Yes | Non-Arm's Length Transactions | DTIT | ||||
| 24657 | 977 | 3 | 2017-04-12 | Early Ventures Llc | Early Ventures Llc | Quit Claim Deed | 2017-04-12 | 7048520 | Cash Purchase | Non-Arm's Length Transactions | DTQC | |||||
| 100 | 24497 | 331 | 4 | 2016-12-19 | Early Ventures Llc, Jerry Ford | $20,000 | $20,000 | Ronny Irlacher | Warranty Deed | 2017-01-11 | 7004543 | Cash Purchase | Arms Length Residential Transactions (Purchase/Resales) | DTWD | Yes | |
| 19956 | 459 | 5 | 2009-09-18 | Ronny Irlacher | Brian C Lee, Estate Of John Irlacher | Quit Claim Deed | 2009-09-22 | 9103330 | Cash Purchase | Yes | Non-Arm's Length Transactions | DTQC |
| Fmr year | 2023 |
|---|---|
| Hud area code | METRO19820M19820 |
| Hud area name | Detroit-Warren-Livonia, MI HUD Metro FMR Area |
| Median income | $51,861 |
| Fmr efficiency | $880 |
| Fmr one bedroom | $1,000 |
| Fmr two bedroom | $1,270 |
| Suggested rent | $1,270 |
| Fmr four bedroom | $1,710 |
| Fmr three bedroom | $1,580 |
| Id | 299449 |
|---|---|
| Name | Castle Gardens |
| Type | subdivision |
| Center | POINT(-82.942480279762 42.518682553435) |
| Hoa | Yes |
|---|---|
| Pool | Yes |
| Address · zip | 48066 |
| Address · city | Roseville |
| Address · fips | 26099 |
| Address · unit | 209b |
| Address · zip4 | 1596 |
| Address · house | 30205 |
| Address · label | 30205 Utica Rd Apt 209b, Roseville, MI 48066 |
| Address · state | MI |
| Address · county | Macomb County |
| Address · street | Utica |
| Address · address | 30205 Utica Rd Apt 209b |
| Address · unit type | Apt |
| Address · street type | Rd |
| Address · carrier route | C020 |
| Address · jurisdiction | Macomb County |
| Address · congressional district | 10 |
| Stories | 1 |
| Bedrooms | 2 |
| Deck area | 0 |
| Latitude | 42.518602143093474 |
| Pool area | 0 |
| Bathrooms | 1 |
| Longitude | -82.9422653559229 |
| Patio area | 0 |
| Year built | 1,972 |
| Rooms count | 0 |
| Units count | 0 |
| Heating type | Hot Water |
| Property use | Condominium Unit (Residential) |
| Basement type | NO BASEMENT |
| Lot square feet | 232,492 |
| Parking spaces | 0 |
| Buildings count | 0 |
| Property use code | 1,004 |
| Garage square feet | 0 |
| Living square feet | 888 |
| Partial bathrooms | 0 |
| Basement square feet | 0 |
| Building square feet | 888 |
| Price per square foot | 3 |
| Plumbing fixtures count | 0 |
| Tax exemption homeowner flag | Yes |
| Basement square feet finished | 0 |
| Basement square feet unfinished | 0 |
Index 2026-08-01 · 87,879 total recorded outcomes
Reads this parcel against MacombCounty's rules and flags what could go wrong — surviving liens, redemption exposure, title cost, and the facts we don't have. Takes about 35 seconds; the result is saved, so opening this lot again is instant.