Welcome to this stunning modern concept situated on a nice lot! This home is the closest thing to new construction. Be taken back when entering your new home - featuring custom craftsmanship with premium wood trims, a new kitchen and living spaces with award winning color choices, stella quartz countertops in kitchen and bath, with recessed lighting throughout, plus more. The stylish exterior boasts custom barn features with wood accents and custom landscaping for a bonfire. New windows, new siding, new roof, new HVAC, new electric, plus more. It doesn't end, there's a brand new driveway! Brand new appliance package! This property is nestled on a quiet street and makes for a quiet living with primarily homeowners on the street. Come on by so you can enjoy the backyard both morning and night, so bring your coffee and wine, and make this house your home - it won't last! Home is certified for occupancy by City of Warren. Agents are owners.
Top-Rated School District
Open House
$149,900

23611 Stewart Avenue, Warren, MI, 48089

23611 Stewart Avenue, Warren, MI, 48089
BEDS
3
BATHS
1
SQUARE FT.
1,094
BUILT IN
1944
Time Advantage
Due to day on market:
15 DAYS

Property Details

Description

Welcome to this stunning modern concept situated on a nice lot! This home is the closest thing to new construction. Be taken back when entering your new home - featuring custom craftsmanship with premium wood trims, a new kitchen and living spaces with award winning color choices, stella quartz countertops in kitchen and bath, with recessed lighting throughout, plus more. The stylish exterior boasts custom barn features with wood accents and custom landscaping for a bonfire. New windows, new siding, new roof, new HVAC, new electric, plus more. It doesn't end, there's a brand new driveway! Brand new appliance package! This property is nestled on a quiet street and makes for a quiet living with primarily homeowners on the street. Come on by so you can enjoy the backyard both morning and night, so bring your coffee and wine, and make this house your home - it won't last! Home is certified for occupancy by City of Warren. Agents are owners.

Find out more about this home

Tour Request

Ready to Make This Home Yours?

Calculate Your Monthly Payment

Use our free mortgage calculator to estimate your monthly payment for this property.

Calculate Payment

Get Pre-Approved

Secure your financing with our trusted lending partners in just minutes.

Start Pre-Approval

Looking for more options in Warren?

View All Homes in Warren

Key Details

Price per Sqft137.02010968921388
MLS Listing ID70501525
Square Footage1,094 Sqft
Lot Size0.1
Originating BoardRealcomp MLS
HOA FeeN/A

Location

StateMI
CountyMacomb
AreaWarren
Zoning48089

Interior

Heating["Forced Air", "Natural Gas"]
Heat SourceNatural Gas

Exterior

PoolNo
Waterfrontno
Roof TypeN/A

Building

Lot DimensionsN/A
SewerSewer (Sewer-Sanitary)
WaterPublic (Municipal)
Structure Type

Others

Tax ID0824210132
Ownership
Acceptable FinancingCash, Conventional, VA

Schools / Nearby Schools

Top-Rated School DistrictTop-Rated
Source: GreatSchool.org © 2025. All rights reserved.
Walkability Score
8 / 10
Alameda High School
High School
Walkability Score
7 / 10
Lincoln Middle School
Middle School
Walkability Score
8 / 10
Frank Otis Elementary School
Elementary School
Loading nearby places...
Loading scores...
Loading calculator...

Similar Homes for Sale

Loading similar properties...
IDX Logo

IDX provided courtesy of Realcomp II Ltd. via GoodHome Realty and MLS. Copyright 2025 Realcomp II Ltd. Shareholders. IDX information is provided exclusively for consumers' personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.

The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified.

The data relating to real estate properties on this website was last updated as recently as 12/26/2025 11:00:00 PM EST.

Listing Information presented by local MLS brokerage: GoodHome Realty and MLS, Inc., REALTOR® - Quinton Lemond - (248) 928-4992.