Address
23743 Columbus Avenue, Warren, MI
Price
$ 142,000
Property Attributes
- ID#20261060058
- TypeSingle Family
- Listing Status Active
- CountyMACOMB
- CityWarren
- AreaWarren
- NeighborhoodSUPERVISORS CHESTERFIELD PARK SUB 2
- Zip48089
- StyleRanch
- Year Built2000
- Taxes$ 4564
- Price$ 142,000
- Bedrooms3
- Full Bathrooms1
- Half Bathrooms0
- Sqr Footage888
- Lot Size0.1 Acres
Data Source:
RealComp
Property Description
Investment opportunity in Warren. This solid brick ranch built in 2000 offers 3 bedrooms, 1 bath, a full basement with poured foundation, and central air, newer construction that means less maintenance and stronger tenant appeal than the typical rental stock in the area. Currently tenant-occupied and producing income from day one, this is a true buy and hold play. Inside you'll find new vinyl plank flooring, and the full basement adds valuable storage or future finished living space. Only available as part of a 10-home portfolio package across Warren, Roseville, and Detroit for investors looking to scale. Priced to perform for buy and hold investors seeking immediate cash flow. Do not disturb tenants. Interior showings with accepted offer only. Gross Rent: $1,547/month
| Price History | |
|---|---|
| 8/1/2026 | Listed $150,000 |
| 8/14/2026 | 4$145,000 |
| 9/3/2026 | 3$142,000 |
General Features
| Sewer | PublicSewer |
|---|---|
| Heating | ForcedAir, NaturalGas |
| Cooling | CeilingFans, CentralAir |
| Utilities | AboveGroundUtilities, CableAvailable |
| Possession | AtClose |
| Roof | Asphalt |
| Garage Spaces | 0.0 |
| Architectural Style | Ranch |
| Pool Features | None |
| Construction Materials | Brick, VinylSiding |
| Exclusions | Exclusion(s) Do Not Exist |
| Year Built | 2000 |
| Levels | One |
| Property Subtype | SingleFamilyResidence |
| County | Macomb |
| New Construction | No |
| Property Type | Residential |
| HOA | No |
| Attached Garage | No |
| Subdivision Name | SUPERVISORS CHESTERFIELD PARK SUB 2 |
| Garage Y/N | No |
| Total Rooms | 5 |
| Full Baths | 1 |
| Status | Active |
| Directions | North on Columbus Avenue from 9 Mile Road |
| City | WarrenCity_Macomb |
| Disclosures | ExclusionsDoNotExist, NoRestrictions, TaxesNotHomesteadExempt |
| Entry Location | GroundLevelwSteps |
| Senior Community Y/N | No |
| High School District | EastDetroit |
| MLS Area | Area03131Warren |
| Lot Size Units | Acres |
| Carport Y/N | No |
| Land Lease Y/N | No |
| Tax Annual Amount | 4564.0 |
| 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 |
| Occupancy Type | Tenant |
| Tax Assessed Value | 39502 |
| Expected Active Date | 2026-07-31 |
| MobileHomeRemainsYN | No |
| PostalCity | Warren_Macomb |
| Legal Description | SUPERVISORS CHESTERFIELD PARK SUB NO 2 LOT 51 L.17 P.38 |
Interior Features
| Basement | Full, Unfinished |
|---|---|
| Basement (Y/N) | Yes |
| Air Conditioning Y/N | Yes |
| Heating Y/N | Yes |
| Fireplace Y/N | No |
| Above Grade Finished Area | 888.0 |
| Laundry Features | WasherHookup |
| Total Bedrooms | 3 |
| LivingAreaSource | PublicRecords |
| Above Grade Finished Area Unit Type | SquareFeet |
| Total Baths | 1 |
Exterior Features
| Parking Features | NoGarage |
|---|---|
| Water Source | Public |
| Foundation Details | Basement, Poured |
| Spa | No |
| Lot Dimensions | 40X104 |
| Lot Size Acres | 0.1 |
| Waterfront Y/N | No |
| Road Frontage Type | Paved |
| 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 Jim Shaffer and Associates 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 12, 2026 12:30 PM 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
Visits
Listing information is provided by Participants of the MichRIC MLS. IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information deemed reliable but not guaranteed. ©: MichRIC MLS. Last Update September 12, 2026 2:19 PM UTC
