A lot has changed since the 90s, and so should the way your Realtor does business. With more than 15 years of experience in marketing and public relations, multiple awards for his work in the field, as well as a degree in Communications with a minor in Applied Statistics from the University of Michigan, Brian Stone has the unparalleled data-driven knowledge and expertise needed to market and sell your home today. As a listing agent, Brian uses his unique background in marketing and communications to drive demand, forcing buyers to compete against each other for the opportunity to buy your home. No other local agent has the ability to act as the complete marketing team for you, from professional photography, graphics design, video production & editing, to owning an in-house marketing firm. As an award-winning professional photographer whose works have been featured on MSNBC, CNN and the Washington Post, and as a marketing and public relations professional whose ground-breaking outreach has been featured in a wide variety of local, regional, national and international publications - Brian Stone knows what it takes to generate interest and buzz around your property in order to get you top dollar. When acting as a buyer's agent, Brian uses his knowledge of the marketplace and top-notch negotiating skills to carve out as much for his clients as they can possibly get. Brian routinely negotiates concessions, repairs and more from the other side while giving expert advice to his clients. Brian embraces digital technology that makes every part of the real estate process easy and convenient for his buyers. Brian Stone is a native of Dearborn, Mich., a decorated Navy veteran. Excellence is what you deserve - so what are you waiting for? Give Brian a call or text and start achieving your dreams today.
Listed By:
Max Broock, REALTORS®-Birmingham - 2486446700
Address
23060 Columbus Avenue, Warren, MI
Price
$ 155,000
Property Attributes
  • ID#20261067721
  • TypeSingle Family
  • Listing Status Active
  • CountyMACOMB
  • CityWarren
  • AreaWarren
  • NeighborhoodSUPERVISORS CHESTERFIELD PARK SUB 2
  • Zip48089
  • StyleBungalow
  • Year Built1938
  • Taxes$ 1667
  • Price$ 155,000
  • Bedrooms4
  • Full Bathrooms1
  • Half Bathrooms0
  • Sqr Footage1014
  • Lot Size0.19 Acres
Data Source:
RealComp
Property Description

Welcome to this newly renovated 4-bedroom 1-bathroom two story single-family investment home in Warren on a large, fenced double-lot! Centrally located in Warren, north of 9 Mile road, the ease of access to local highways makes this home a great value. Approaching the home from the road, you'll notice the natural field stone front facade detail work, a relic of yesteryear craftsmanship. Enter in to the home and be greeted by brand new, durable and expansive luxury vinyl plank flooring throughout the common areas and bedrooms, beautiful large format marble-like ceramic tile in the bathroom, freshly painted walls, bathroom featuring brand new vanity and fixtures, brand new kitchen appliances, shaker style white kitchen cabinets, and updated light fixtures throughout. The double lot offers abundant space and privacy for that up-north staycation feeling. Currently the home is long-term tenant occupied with a Section 8 tenant, positioning it as a strong, turn-key, cash-flowing investment property to add to your portfolio. Currently rented for $1,387 / month. Tenant is responsible for all utilities including landscaping and snow removal. Existing lease runs through July 31st, 2028.

Price History
8/27/2026 Listed $155,000

General Features

Sewer PublicSewer
Heating ForcedAir, NaturalGas
Possession AtClose
Roof Asphalt
Garage Spaces 0.0
Patio/Porch Features Porch
Architectural Style Bungalow
Pool Features None
Construction Materials Stone, VinylSiding
Year Built 1938
Levels Two
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 8
Full Baths 1
Status Active
Directions Take Van Dyke South to 9 Mile Road. Head East on 9 Mile Road, and turn Left onto Columbus Avenue. Home is on the right side.
City WarrenCity_Macomb
Disclosures 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 1667.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 24654
Expected Active Date 2026-08-27
MobileHomeRemainsYN No
PostalCity Warren_Macomb
Legal Description SUPERVISORS CHESTERFIELD PARK SUB NO 2 LOT123 INCL 1/2 VAC ALLEY L.17 P.38

Interior Features

Basement (Y/N) No
Air Conditioning Y/N No
Heating Y/N Yes
Fireplace Y/N No
Above Grade Finished Area 1014.0
Laundry Features ElectricDryerHookup, LaundryRoom, WasherHookup
Total Bedrooms 4
LivingAreaSource Assessor
Above Grade Finished Area Unit Type SquareFeet
Total Baths 1

Exterior Features

Parking Features NoGarage
Water Source Public
Foundation Details CrawlSpace
Spa No
Lot Dimensions 78X104
Lot Size Acres 0.19
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 REMAX Leading Edge 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:50 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
AVG $140K
$160K
Taxes
AVG $2,786
$1,667
Year Built
AVG 1953
1938
Visits
AVG 108
35
Data Provided by Inside Real Estate®

Areas We Cover