For sale

Price cut: $5K (8/14)

$145,000

23743 Columbus Ave, Warren, MI 48089

3beds

888sqft

$1,170/mo

Get pre-qualified

Single Family Residence

Built in 2000

4,356 Square Feet Lot

$142,900 Zestimate^®

$163/sqft

$-- HOA

What's special

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

27 days

194

6

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: $163/sqft
Tax assessed value: $39,502
Annual tax amount: $4,564
Date on market: 7/31/2026
Cumulative days on market: 27 days
Listing agreement: Exclusive Right To Sell
Listing terms: Cash,Warranty Deed
Exclusions: Exclusion(s) Do Not Exist

Estimated market value

$142,900

$136,000 - $150,000

$1,430/mo

Price history

Date	Event	Price
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
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