Just Listed
Address
23742 Stewart Avenue, Warren, MI
Price
$ 127,000
Property Attributes
- ID#58050223185
- TypeSingle Family
- Listing Status Active
- CountyMACOMB
- CityWarren
- AreaWarren
- NeighborhoodSUPERVISORS CHESTERFIELD PARK SUB 2
- Zip48089
- StyleBungalow
- Year Built1954
- Taxes$ 2297
- Price$ 127,000
- Bedrooms2
- Full Bathrooms2
- Half Bathrooms0
- Sqr Footage1277
- Lot Size0.1 Acres
Data Source:
RealComp
Property Description
Charming updated bungalow layout perfect for first-time homebuyers or investors. This home includes lots of updates, Fresh paint through out the house, New electric fire place, recessed lights, New flooring, New kitchen cabinets, SS New appliances, New vanity, New hot water tank. This home is ready to move in and enjoy!
| Price History | |
|---|---|
| 9/28/2026 | Listed $127,000 |
General Features
| Sewer | PublicSewer |
|---|---|
| Heating | ForcedAir, NaturalGas |
| Cooling | CentralAir |
| Possession | AtClose |
| Appliances | Oven, Refrigerator, Range, Washer |
| Garage Spaces | 1.0 |
| Patio/Porch Features | Porch |
| Architectural Style | Bungalow |
| Pool Features | None |
| Construction Materials | VinylSiding |
| Year Built | 1954 |
| Levels | OneAndOneHalf |
| Property Subtype | SingleFamilyResidence |
| County | Macomb |
| New Construction | No |
| Property Type | Residential |
| HOA | Yes |
| Attached Garage | No |
| Subdivision Name | SUPERVISORS CHESTERFIELD PARK SUB 2 |
| Garage Y/N | Yes |
| Total Rooms | 5 |
| Full Baths | 2 |
| Status | Active |
| City | WarrenCity_Macomb |
| Disclosures | TaxesNotHomesteadExempt |
| Senior Community Y/N | No |
| High School District | EastDetroit |
| MLS Area | Area03131Warren |
| Carport Y/N | No |
| Land Lease Y/N | No |
| Tax Annual Amount | 2297.82 |
| Home Warranty Y/N | No |
| Lease Renewal Y/N | No |
| Additional Parcels Y/N | No |
| Lease Considered Y/N | No |
| Rent Control Y/N | No |
| Standard Status | Active |
| MobileHomeRemainsYN | No |
| PostalCity | Warren_Macomb |
| Legal Description | SUPERVISORS CHESTERFIELD PARK SUB NO 2 LOT204 L.17 P.38 |
Interior Features
| Fireplace Features | Electric |
|---|---|
| Basement (Y/N) | Yes |
| Air Conditioning Y/N | Yes |
| Heating Y/N | Yes |
| Fireplace Y/N | Yes |
| Above Grade Finished Area | 1277.0 |
| Total Bedrooms | 2 |
| Below Grade Finished Area | 0.0 |
| WaterHeaterFuel | NaturalGas |
| Above Grade Finished Area Source | PublicRecords |
| Above Grade Finished Area Unit Type | SquareFeet |
| Total Baths | 2 |
Exterior Features
| Parking Features | OneCarGarage, Detached, ElectricityinGarage |
|---|---|
| Water Source | Public |
| Foundation Details | Basement |
| Spa | No |
| Lot Dimensions | 40 X 105 |
| Lot Size Acres | 0.1 |
| Waterfront Y/N | No |
| Crops Included Y/N | No |
| Horse Y/N | No |
| Irrigation Water Rights Y/N | No |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No HOA Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool
IDX provided courtesy of Realcomp II Ltd., via REMAX City Centre and The Originating MLS(found above), © 2026 Realcomp II Ltd. Shareholders. Shareholders. The information being provided is for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Data is updated as of September 28, 2026 5:07 AM UTC Information deemed reliable but not guaranteed.
The data relating to real estate on this web site comes in part from the Internet Data Exchange (IDX) Program of Realcomp Ltd
Property vs Single Family Average in 48089
Price
Taxes
Year Built
