For Sale
Price CutPrice Drop: $5K (09/28)
Single family home for sale at 23742 Stewart Ave, Warren, MI 48089 | MLS# 58050223185 | Listing updated on 2026-10-18
Photo 1 of Single family home for sale at 23742 Stewart Ave, Warren, MI 48089 | MLS# 58050223185 | Listing updated on 2026-10-18
Photo 2 of Single family home for sale at 23742 Stewart Ave, Warren, MI 48089 | MLS# 58050223185 | Listing updated on 2026-10-18
Photo 3 of Single family home for sale at 23742 Stewart Ave, Warren, MI 48089 | MLS# 58050223185 | Listing updated on 2026-10-18
Photo 4 of Single family home for sale at 23742 Stewart Ave, Warren, MI 48089 | MLS# 58050223185 | Listing updated on 2026-10-18
14+
Beds Icon

Street View

$122,000

Monthly Est:$607

  • Beds Icon2 Beds
  • Beds Icon
    2 Baths
  • Beds Icon1,277sqft

23742 Stewart Ave, Warren, MI 48089

$607/moEst:

Get Pre-Approved

  • Single Family Residence

  • Built in 1954

  • $-- HOA

  • 4,356 sqft lot

  • $96/sq.ft

Description

Charming updated bungalow layout perfect for first-time homebuyers or investors. This home includes lots of updates, Fresh paint through out the house, New electric fire place, recessed lights, New flooring, New kitchen cabinets, SS New appliances, New vanity, New hot water tank. This home is ready to move in and enjoy!

  • Houzeo last checked: 14 minutes ago
  • Listing updated: October 18, 2026 at 4:43 pm
  • Listing Provided by: John Rayes | Community Choice Realty Inc. (248) 729-0011
  • Source: Realcomp MLS-MI | MLS#: 58050223185 Realcomp MLS-MI
  • Originating MLS: MiRealSource

Property Details

  • Status

    Active

  • Type

    Single Family Residence

  • No. of Stories

    -

  • County

    Macomb County

  • City

    Warren

  • Neighborhood

    --

  • Year Built

    1954

  • HOA Fees

    -

  • Finished Area

    1,277 sqft

  • Lot Size

    4,356 sqft lot

  • Basement Area

    - sqft

  • MLS Name

    Realcomp MLS

  • MLS Number

    58050223185

  • MLS Status

    Active

  • Days on Market

    23

  • Cumulative Days on Market

    20

Continue Your Journey in App

Find your dream home, receive real-time updates, and many more!

Location

Facts & Features

Rooms

  • Bedrooms & bathrooms

    Bedrooms: 2

    Bathrooms: 2

Interior

  • Appliances

    Oven, Refrigerator, Range, Washer

  • Sewer

    Public Sewer

  • Cooling

    Central Air

  • Heating

    Forced Air, Natural Gas

Construction

  • Year Built

    Year Built: 1954

  • Home type

    Single Family Residence

  • Construction Materials

    Vinyl Siding

  • Architectural Style

    Bungalow

  • Foundation Details

    Basement

Utilities & Energy

  • Water Source

    Public

  • Fireplace Features

    Electric

  • Parking Features

    One Car Garage, Detached, Electricityin Garage

  • Pool Features

    None

Other Features

  • Disclosures

    Taxes Not Homestead Exempt

  • Patio And Porch Features

    Porch

  • Subdivision Name

    Supervisors Chesterfield Park Sub 2

Price History

DateEventPrice

10/18/2026

Source: mls_logoMiRealSource MLS-MI #50223185

Price Decreased

$122,000 -3.94%

$96/sqft

09/28/2026

Source: mls_logoMiRealSource MLS-MI #50223185

Listed for Sale

$127,000

$99/sqft

09/28/2026

Source: mls_logoRealcomp MLS-MI #58050223185

Price Decreased

$127,000 -1.17%

$99/sqft

08/27/2026

Source: mls_logoMiRealSource MLS-MI #50215039

Listing Removed

$128,500

$101/sqft

08/12/2026

Source: mls_logoMiRealSource MLS-MI #50215039

Price Decreased

$128,500 -1.91%

$101/sqft

Show more

Getting Around 23742 Stewart Ave

Walk Score®

Walk Score

Somewhat Walkable

56/100

Data provided by Redfin

Nearby Homes

Based on information from the Board/Association of REALTORS® (alternatively, from the Realcomp II Ltd. MLS) through Oct 22, 2026, 02:30AM. 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