Skip main navigation
For sale
    • Price cut: $2.5K (8/12)
    $128,500

    23742 Stewart Ave, Warren, MI 48089

    2beds
    1,277sqft
    : 
    $1,037/mo
    Get pre-qualified
    Single Family Residence
    Built in 1954
    4,356 Square Feet Lot
    $125,800 Zestimate®
    $101/sqft
    $-- HOA

    What's special

    New electric fireplaceNew vanityRecessed lightsUpdated bungalow layoutNew kitchen cabinetsNew flooring
    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!
    42 days
    |
    262
    |
    27
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    John Rayes 586-215-4100,

    Community Choice Realty Inc. 248-729-0011

    Source: MiRealSource,MLS#: 50215039MLS LogoOriginating MLS: MiRealSource

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 2
      • Bathrooms: 2
      • Full bathrooms: 2
      Bedroom 1
      • Level: Upper
      • Area: 264
      • Dimensions: 22 x 12
      Bedroom 2
      • Level: Upper
      • Area: 132
      • Dimensions: 12 x 11
      Bathroom 1
      • Level: Entry
      Bathroom 2
      • Level: Upper
      Dining room
      • Area: 99
      • Dimensions: 11 x 9
      Kitchen
      • Area: 144
      • Dimensions: 12 x 12
      Living room
      • Area: 198
      • Dimensions: 18 x 11
      Heating
      • Forced Air, Natural Gas
      Cooling
      • Central Air
      Appliances
      • Included: Range/Oven, Refrigerator, Washer, Gas Water Heater
      Features
      • Has basement: Yes
      • Number of fireplaces: 1
      • Fireplace features: Electric
      Interior area
      • Total structure area: 2,077
      • Total interior livable area: 1,277 sqft
      • Finished area above ground: 1,277
      • Finished area below ground: 0

      Property

      Parking
      • Total spaces: 1
      • Parking features: Detached, Electric in Garage
      • Garage spaces: 1
      Features
      • Levels: One and One Half
      • Stories: 1.5
      • Patio & porch: Porch
      • Frontage type: See Remarks
      • Frontage length: 40
      Lot
      • Size: 4,356 Square Feet
      • Dimensions: 40 x 105
      Details
      • Parcel number: 1325426013
      • Special conditions: Private

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Bungalow
      • Property subtype: Single Family Residence
      Materials
      • Vinyl Siding
      • Foundation: Basement
      Condition
      • Year built: 1954

      Utilities & green energy

      • Sewer: Public Sanitary
      • Water: Public

      Community & HOA

      Community
      • Subdivision: Supervisors Chesterfield Park Sub 2
      HOA
      • Has HOA: No
      Location
      • Region: Warren

      Financial & listing details

      • Price per square foot: $101/sqft
      • Tax assessed value: $147,060
      • Annual tax amount: $2,297
      • Date on market: 7/15/2026
      • Cumulative days on market: 110 days
      • Listing agreement: Exclusive Right To Sell
      • Listing terms: Cash,Conventional,FHA,VA Loan

        Estimated market value

        $125,800

        $120,000 - $132,000

        $1,552/mo

        Price history

        DateEventPrice
        8/12/2026Price change$128,500-1.9%$101/sqft
        Source: MiRealSource #50215039 Report a problem
        7/29/2026Price change$131,000-3%$103/sqft
        Source: MiRealSource #50215039 Report a problem
        7/23/2026Price change$135,000-1.5%$106/sqft
        Source: MiRealSource #50215039 Report a problem
        7/15/2026Listed for sale$137,000$107/sqft
        Source: MiRealSource #50215039 Report a problem
        7/9/2026Listing removed$137,000$107/sqft
        Source: MiRealSource #50207022 Report a problem
        6/8/2026Price change$137,000-3.5%$107/sqft
        Source: MiRealSource #50207022 Report a problem
        6/3/2026Price change$142,000-2.1%$111/sqft
        Source: MiRealSource #50207022 Report a problem
        5/21/2026Price change$145,000-0.7%$114/sqft
        Source: MiRealSource #50207022 Report a problem
        5/18/2026Pending sale$146,000$114/sqft
        Source: MiRealSource #50207022 Report a problem
        5/10/2026Listed for sale$146,000-3.9%$114/sqft
        Source: MiRealSource #50207022 Report a problem
        4/27/2026Listing removed$152,000$119/sqft
        Source: MiRealSource #50204682 Report a problem
        4/17/2026Listed for sale$152,000+90%$119/sqft
        Source: MiRealSource #50204682 Report a problem
        8/29/2025Sold$80,000+60%$63/sqft
        Source: Public Record Report a problem
        6/15/2018Sold$50,000+117.4%$39/sqft
        Source: Public Record Report a problem
        9/17/2012Sold$23,000-7.3%$18/sqft
        Source: MiRealSource #31116049 Report a problem
        8/25/2012Listed for sale$24,800$19/sqft
        Source: The Real Estate Book #31116049 Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025$1,902 +5.5%$73,530 +9.4%
        2024$1,803 +5.1%$67,200 +54.3%
        2023$1,715 +2.7%$43,550 +15.2%
        2022$1,670 +0.8%$37,800 +6.1%
        2021$1,656 $35,610 +11.6%
        2020$1,656 +7.1%$31,910 +2.3%
        2019$1,546 +7.6%$31,190 +23.4%
        2018$1,437 $25,270 +1.5%
        2017-- $24,890
        2016-- $24,890 +8%
        2015-- $23,040 +4.3%
        2012-- $22,100
        2010-- --
        2009-- $37,490 -15.4%
        2008-- $44,310 -6.1%
        2007-- $47,200 +2.6%
        2006-- $46,000 +7.5%
        2005-- $42,800 +5.4%
        2004-- $40,590 +56.7%
        2001$916 +3.4%$25,900 +3.2%
        2000$886 $25,100
        Find assessor info on the county website

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        See how much you could borrow to make a competitive offer.
        Get pre-qualified

        Climate risks

        Neighborhood: 48089

        Getting around

        56 / 100
        Somewhat Walkable
        45 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • District: Eastpointe Community Schl

        Source: MiRealSource. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts

        Similar homes

              Nearby cities

              Nearby zip codes

              Other Warren Topics

                Search
                Updates
                Favorites
                Plan
                Inbox