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
For sale
Price cut: $3K (9/3)
$142,000
23743 Columbus Ave, Warren, MI 48089
3beds
888sqft
Single Family Residence
Built in 2000
4,356 Square Feet Lot
$140,900 Zestimate®
$160/sqft
$-- HOA
What's special
- 72 days
- 80
- 2
Zillow last checked:
Listing updated:
Listed by:
Michael J Allen 248-914-0847,
National Realty Centers, Inc 248-724-1234
Source: Realcomp II,MLS#: 20261060058
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 1
- Full bathrooms: 1
Bedroom
- Level: Entry
- Area: 90
- Dimensions: 10 X 9
Bedroom
- Level: Entry
- Area: 120
- Dimensions: 12 X 10
Bedroom
- Level: Entry
- Area: 100
- Dimensions: 10 X 10
Other
- Level: Entry
- Area: 35
- Dimensions: 7 X 5
Kitchen
- Level: Entry
- Area: 126
- Dimensions: 14 X 9
Living room
- Level: Entry
- Area: 169
- Dimensions: 13 X 13
Heating
- Forced Air, Natural Gas
Cooling
- Ceiling Fans, Central Air
Appliances
- Laundry: Washer Hookup
Features
- Basement: Full,Unfinished
- Has fireplace: No
Interior area
- Total interior livable area: 888 sqft
- Finished area above ground: 888
Property
Parking
- Parking features: No Garage
Features
- Levels: One
- Stories: 1
- Entry location: GroundLevelwSteps
- Pool features: None
Lot
- Size: 4,356 Square Feet
- Dimensions: 40 x 104
Details
- Parcel number: 1325404060
- Special conditions: Short Sale No,Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Ranch
- Property subtype: Single Family Residence
Materials
- Brick, Vinyl Siding
- Foundation: Basement, Poured
- Roof: Asphalt
Condition
- New construction: No
- Year built: 2000
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Above Ground Utilities, Cable Available
Community & HOA
Community
- Subdivision: SUPERVISORS CHESTERFIELD PARK SUB 2
HOA
- Has HOA: No
Location
- Region: Warren
Financial & listing details
- Price per square foot: $160/sqft
- Tax assessed value: $39,502
- Annual tax amount: $4,564
- Date on market: 7/31/2026
- Cumulative days on market: 73 days
- Listing agreement: Exclusive Right To Sell
- Listing terms: Cash,Warranty Deed
- Exclusions: Exclusion(s) Do Not Exist
Estimated market value
$140,900
$134,000 - $148,000
$1,349/mo
Price history
| Date | Event | Price |
|---|---|---|
| 9/3/2026 | Price change | $142,000-2.1%$160/sqft |
Source:  Realcomp II #20261060058 Report a problem | ||
| 8/14/2026 | Price change | $145,000-3.3%$163/sqft |
Source: Realcomp II #20261060058 Report a problem | ||
| 8/1/2026 | Listed for sale | $150,000+38.9%$169/sqft |
Source: Realcomp II #20261060058 Report a problem | ||
| 11/4/2025 | Sold | $108,000+35%$122/sqft |
Source: Public Record Report a problem | ||
| 2/19/2019 | Sold | $80,000$90/sqft |
Source:  MiRealSource #31367955 Report a problem | ||
| 1/18/2019 | Pending sale | $80,000$90/sqft |
Source: Keller Williams Realty Central #31367955 Report a problem | ||
| 1/16/2019 | Price change | $80,000-5.9%$90/sqft |
Source: Keller Williams Realty Central #31367955 Report a problem | ||
| 1/2/2019 | Listed for sale | $85,000$96/sqft |
Source: Keller Williams Realty Central #31367955 Report a problem | ||
| 11/3/2018 | Listing removed | $85,000$96/sqft |
Source: Real Living Kee Realty-Clinton Twp #218077044 Report a problem | ||
| 10/20/2018 | Price change | $85,000-2.3%$96/sqft |
Source: Real Living Kee Realty-Clinton Twp #218077044 Report a problem | ||
| 10/2/2018 | Price change | $87,000-3.3%$98/sqft |
Source: Real Living Kee Realty-Clinton Twp #218077044 Report a problem | ||
| 9/10/2018 | Price change | $90,000-3.2%$101/sqft |
Source: Real Living Kee Realty-Clinton Twp #218077044 Report a problem | ||
| 9/6/2018 | Price change | $93,000-2.1%$105/sqft |
Source: Real Living Kee Realty-Clinton Twp #218077044 Report a problem | ||
| 8/10/2018 | Listed for sale | $95,000$107/sqft |
Source: Real Living Kee Realty #218077044 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2026 | $2,671 +1.9% | $66,350 +6.8% |
| 2025 | $2,621 +39.2% | $62,150 +0.1% |
| 2024 | $1,883 +5.1% | $62,080 +34.2% |
| 2023 | $1,791 +2.7% | $46,260 +23.7% |
| 2022 | $1,744 +0.8% | $37,400 +4.9% |
| 2021 | $1,729 | $35,640 +7.4% |
| 2020 | $1,729 +33.4% | $33,180 +9.9% |
| 2019 | $1,296 -25.2% | $30,200 +7.7% |
| 2018 | $1,733 | $28,030 +1.2% |
| 2017 | -- | $27,690 |
| 2016 | -- | $27,690 +5.8% |
| 2015 | $3,305 | $26,170 +8.2% |
| 2013 | $3,305 | $24,190 |
| 2010 | -- | -- |
| 2009 | -- | $49,800 -14.9% |
| 2008 | -- | $58,530 -5.3% |
| 2007 | -- | $61,810 +3.6% |
| 2006 | -- | $59,640 +8.6% |
| 2005 | -- | $54,920 +6.5% |
| 2004 | -- | $51,580 +18% |
| 2001 | $1,546 +979.7% | $43,720 +1531.3% |
| 2000 | $143 | $2,680 |
Find assessor info on the county website
Monthly payment
Est. payment
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Climate risks
Neighborhood: 48089
Similar homes
- $--3 bd2 ba875 sqft24265 Prairie Ln, Warren, MI 48089Auction
Auction.com 2 - $--3 bd2 ba910 sqft11324 Timken Ave, Warren, MI 48089Auction
Auction.com 1 - $144,9003 bd1 ba910 sqft14921 Myola Ave, Warren, MI 48089For Sale
MLS ID #20261061467, Samuel M Kaplunov, @properties Christie's Int'l R.E. Birmingham. Realcomp II - $150,0003 bd1 ba975 sqft13723 Hendricks Ave, Warren, MI 48089For Sale
MLS ID #20261059006, Joseph Hammel, Keller Williams Somerset. Realcomp II - $145,0003 bd2 ba1.1k sqft11520 Young Ave, Warren, MI 48089For SaleMLS ID #20261007247, Joseph Hammel, Keller Williams Somerset. Realcomp II
- $145,0003 bd2 ba960 sqft13920 Hobart Ave, Warren, MI 48089For SaleMLS ID #20261007254, Joseph Hammel, Keller Williams Somerset. Realcomp II
- $129,9003 bd1 ba960 sqft11299 Chalmers Ave, Warren, MI 48089For SaleMLS ID #20261060091, Michael J Allen, National Realty Centers, Inc. Realcomp II
- $140,0003 bd1 ba1.1k sqft8468 Timken Ave, Warren, MI 48089For SaleMLS ID #20261060082, Michael J Allen, National Realty Centers, Inc. Realcomp II
- $148,9003 bd1 ba1k sqft22145 Gascony Ave, Eastpointe, MI 48021For SaleMLS ID #20261080962, Mary E Henry, Max Broock, REALTORS®-Bloomfield Hills. Realcomp II
- $125,0003 bd1 ba1k sqft8419 N Lozier Ave, Warren, MI 48089For SaleMLS ID #20261067822, Dorothy M Robinson, Community Choice Realty Inc. Realcomp II
- $127,9003 bd1 ba1k sqft8059 Ford Ave, Warren, MI 48089For SaleMLS ID #20261040788, Marina LaRocca, Expert Realty Solutions Inc. Realcomp II
- $160,0003 bd2 ba1k sqft11004 Cadillac Ave, Warren, MI 48089For SaleMLS ID #20261007269, Joseph Hammel, Keller Williams Somerset. Realcomp II
- $144,9003 bd1 ba1.1k sqft25620 Hudson St, Roseville, MI 48066For SaleMLS ID #20261070507, Vladislav Sheyngauz, Brookstone, Realtors LLC. Realcomp II
- $154,0003 bd1 ba1.1k sqft15834 Stephens Dr, Eastpointe, MI 48021For SaleMLS ID #20261024974, Adam Willibey, Keller Williams Realty-Great Lakes. Realcomp II
- $140,0003 bd1 ba994 sqft19775 Kingsville St, Harper Woods, MI 48225For SaleMLS ID #20261007257, Joseph Hammel, Keller Williams Somerset. Realcomp II
- $128,0003 bd1 ba1.2k sqft21828 Rausch Ave, Eastpointe, MI 48021For SaleMLS ID #20261074425, Matthew M Blitchok, Trademark Realty & Management Service. Realcomp II
- $145,0003 bd1 ba950 sqft20924 Ridgemont Rd, Harper Woods, MI 48225For SaleMLS ID #20261007241, Joseph Hammel, Keller Williams Somerset. Realcomp II
- $159,9003 bd1 ba1.1k sqft26210 Clancy St, Roseville, MI 48066For SaleMLS ID #20261064664, Anthony Djon, Anthony Djon Luxury Real Estate. Realcomp II
