Just Listed
Address
23742 Stewart Avenue, Warren, MI
Price
$ 127,000
Property Attributes
- ID#50223185
- 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:
MiRealSource (MIRS)
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
| Heating | Forced Air |
|---|---|
| Cooling | Central A/C |
| Possession | At Close |
| Fireplaces | Electric Fireplace |
| Garage | Detached Garage,Electric in Garage |
| Water | Public Water |
| Appliances | Range/Oven,Refrigerator,Washer |
| Status | Active |
| Full Baths | 2 |
| Bathrooms | 2 |
| Year Built | 1954 |
| Subdivision | Supervisors Chesterfield Park Sub 2 |
| Water Heater | Gas |
| Style | Bungalow |
| County | Macomb |
| Class | RESIDENTIAL |
| Type | Single Family |
| Ownership | Private |
| Status | Active |
| Subdivision | MI |
| Sale/Rent | For Sale |
| Manufactured Y/N | No |
| Structure Style | 1 1/2 Story |
| Subj to Short Sale Apprvl | No |
| Area | Warren (50023) |
| Primary City | Warren |
| City | Warren |
| School District | Eastpointe Community Schl |
| Lease Y/N | No |
| Originating MLS | MiRealSource |
| Source MLS | MI Real Source |
| Financial Terms | Cash,Conventional,FHA,VA |
| Legal Description | SUPERVISORS CHESTERFIELD PARK SUB NO 2 LOT204 L.17 P.38 |
| Postal Code | 48089 |
| Price Per Sq Ft Total AG | 99.45 |
| Internet Remarks | Listing Agent: John Rayes Broker: Community Choice Realty Inc.: Charming updated bungalow layout perfect for first-time homebuyers or investors. This home includes lots of updates |
| Public Remarks | 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 |
Interior Features
| Bedroom 1 Level | Upper |
|---|---|
| Bedroom 2 Level | Upper |
| Kitchen Length | 12 |
| Living Room Length | 18 |
| Bedroom 2 Width | 11 |
| Dining Room Width | 9 |
| Bedroom 2 Length | 12 |
| Living Room Width | 11 |
| Dining Room Length | 11 |
| Kitchen Width | 12 |
| Beds | 2 |
| Fireplace? | Yes |
| Bedroom 1 Length | 22 |
| Bedroom 1 Width | 12 |
| Below Grade SqFt | 800 |
| Above Grade SqFt | 1277 |
| Basement Y/N | Yes |
| Fireplaces Total | 1 |
| Total SqFt Finished | 1277 |
Exterior Features
| Exterior | Vinyl Siding |
|---|---|
| Exterior Amenities | Porch |
| Frontage | 40 |
| Lot Size Area | 0.1 |
| Pool (Y/N) | No |
| Lot Dimensions | 40 X 105 |
| Garage # of Car | 1 |
| FOUNDATION TYPE | Basement |
| SEWER/SEPTIC | Public Sanitary |
| Waterfront Y/N | No |
| Garage Y/N | Yes |
| Frontage Type | See Remarks (FrontageType) |
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
Property vs Single Family Average in 48089
Price
Taxes
Year Built
IDX provided courtesy of Realcomp II Ltd., via REMAX First and The Originating MLS(found above), © 2026 Realcomp II Ltd. 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.
Provided through IDX via MiRealSource. Courtesy of MiRealSource Shareholder. Copyright MiRealSource.
The information published and disseminated by MiRealSource is communicated verbatim, without change by MiRealSource, as filed with MiRealSource by its members. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified.
Copyright 2026 MiRealSource. All rights reserved. The information provided hereby constitutes proprietary
