- 0
- 7
- Overview
- Description
- Property Details
- Location
- Facts & Features
- Getting Around
- Nearby Homes
$159,900
Monthly Est:$796
4 Beds
2 Baths2 full baths
1,072sqft
23027 Stewart Ave, Warren, MI 48089
$159,900
$796/moEst:
Get Pre-Approved
Single Family Residence
Built in 1938
$-- HOA
0.17 acre lot
$149/sq.ft
Description
Welcome to this stunning modern concept situated on a nice lot! This home is absolutely spectacular. Be taken back when entering your new home - featuring custom craftsmanship with premium wood trims, a newer 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. Newer 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...
Continue Reading- Houzeo last checked: 50 minutes ago
- Listing updated: September 15, 2026 at 8:41 pm
- Listing Provided by: Paul Gjelaj (586) 697-0510 | Community Choice Realty Inc (248) 729-0011
- Source: Realcomp MLS-MI | MLS#: 20261069954
- Originating MLS: Realcomp II Ltd
Property Details
Status
Pending
Type
Single Family Residence
No. of Stories
-
County
City
Neighborhood
--
Year Built
1938
HOA Fees
-
Finished Area
1,072 sqft
Lot Size
0.17 acre lot
Basement Area
- sqft
MLS Name
Realcomp MLS
MLS Number
20261069954
MLS Status
Pending
Days on Market
17
Cumulative Days on Market
9
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Download App
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Location
Facts & Features
Rooms
Bedrooms & bathrooms
Bedrooms: 4
Bathrooms: 2
Interior
Cooling
Central Air
Sewer
Public Sewer
Heating
Forced Air, Natural Gas
Construction
Year Built
Year Built: 1938
Home type
Single Family Residence
Construction Materials
Aluminum Siding
Architectural Style
Bungalow
Foundation Details
Crawl Space
Roof
Asphalt
Utilities & Energy
Pool Features
None
Parking Features
Two Car Garage, Detached
Water Source
Public
Other Features
Subdivision Name
Supervisors Chesterfield Park Sub 2
Disclosures
Taxes Homestead Exempt
Price History
| Date | Event | Price |
|---|---|---|
09/15/2026 Source: | Pending | $159,900 $149/sqft |
09/06/2026 Source: | Listed for Sale | $159,900 $149/sqft |
Nearby Homes
Find Homes by Property Features in Warren, MI
Based on information from the Board/Association of REALTORS® (alternatively, from the Realcomp II Ltd. MLS) through Sep 18, 2026, 05:45PM. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified. IDX provided courtesy of Realcomp II Ltd. via Andover Real Estate & Houzeo, Copyright 2026 Realcomp II Ltd. Shareholders Any use of search facilities of data on the site, other than by a consumer looking to purchase real estate, is prohibited. 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. Listing Information presented by local MLS brokerage: Andover Real Estate, local REALTOR®- Scott Rubin - (248)206-3666 . Any use of search facilities of data on the site, other than by a consumer looking to purchase real estate, is prohibited. © 2024 Realcomp II Ltd. MLS. All Rights Reserved.
Advertising Broker: Andover Real Estate | Andover Real Estate
Love this home?
Here's 4 things you can do
Your local real estate expert. Speak directly with agent about the home & pricing.
Book your private tour
as early as Today at 05:00 PM
Rates starting from 6.3%. Secure financing early to move quickly when you're ready.
Fastest way to get your offer in. Speak directly with agent to negotiate the offer.
Houzeo Corp. holds real estate brokerage licenses in Alabama (License No. 000157023 - 0) and Texas (License No. 9013396)
TREC: Info About Brokerage Services, Consumer Protection Notice.
§ 442‑H New York Standard Operating Procedure.
New York State Fair Housing Notice.
