Skip main navigation
For sale
  • Price cut: $15K (8/20)
    $275,000

    17511 Indiana St, Detroit, MI 48221

    4beds
    2,140sqft
    : 
    $2,528/mo
    Get pre-qualified
    Multi Family
    Built in 1937
    -- sqft lot
    $274,300 Zestimate®
    $129/sqft
    $-- HOA

    What's special

    17511 Indiana St. is a fully operational, income-producing duplex with a verified short-term rental track record and an existing business infrastructure that transfers with the sale. Since 2022, this property has generated $182,474 in gross short-term rental revenue running as an active Airbnb Superhost listing. Built in 1937 and fully rehabbed in 2022, this 2,140 sq ft brick two-story features modern kitchens, updated bathrooms, new flooring, and quality fixtures throughout. Forced-air gas heat, full basement, garage, and covered porch. Solid construction with low deferred maintenance. What makes this listing exceptional is not just the property. The entire operation conveys. Both units transfer fully furnished and guest-ready, with all turnover supplies, and inventory in place. An established cleaning team is already active and familiar with the property. Home security is installed and operational. The buyer is not inheriting a project. They are stepping into a running business. The current owner, a five-year Airbnb Superhost, is also open to remaining as co-host during the transition period to ensure a seamless handoff, continuity of bookings, and full knowledge transfer on operations, pricing strategy, and guest communication. This property is priced to reflect its income-producing performance and the operational value built into it. Verified Airbnb earnings documentation is available for serious buyers upon request. Turnkey. Furnished. Staffed. Secured. Co-host supported transition available. Contact listing agent for revenue breakdown and showing access.
    39 days
    420
    42

    Zillow last checked:

    Listing updated:

    Listed by:

    Kaitlyn Pangrazzi 248-727-7262,

    @properties Christie's Int'l R.E. Birmingham 248-850-8632,

    Amy Presnell 248-850-8632,

    @properties Christie's Int'l R.E. Birmingham

    Source: Realcomp II,MLS#: 20261064008MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 4
      • Bathrooms: 4
      • Full bathrooms: 2
      • 1/2 bathrooms: 2
      Heating
      • Forced Air, Natural Gas
      Features
      • Basement: Unfinished
      • Has fireplace: No
      Interior area
      • Total interior livable area: 2,140 sqft
      • Finished area above ground: 2,140

      Property

      Features
      • Levels: Two
      • Stories: 2
      • Pool features: None
      Lot
      • Size: 4,791 Square Feet
      • Dimensions: 40 x 114.03
      Details
      • Parcel number: W16I035987S
      • Zoning description: MultiFamily
      • Special conditions: Short Sale No,Standard

      Construction

      Type & style
      • Home type: MultiFamily
      • Architectural style: Colonial
      • Property subtype: Multi Family
      Materials
      • Brick
      • Foundation: Basement, Poured
      Condition
      • New construction: No
      • Year built: 1937

      Utilities & green energy

      • Sewer: Public Sewer
      • Water: Public

      Community & HOA

      Community
      • Subdivision: SANTA MARIA PARK SUB
      Location
      • Region: Detroit

      Financial & listing details

      • Price per square foot: $129/sqft
      • Tax assessed value: $51,500
      • Annual tax amount: $8,155
      • Date on market: 8/15/2026
      • Cumulative days on market: 39 days
      • Listing agreement: Exclusive Right To Sell
      • Listing terms: Cash,Conventional,FHA,Va Loan

        Estimated market value

        $274,300

        $261,000 - $288,000

        $1,183/mo

        Price history

        DateEventPrice
        9/8/2026Listed for sale$275,000$129/sqft
        Source: Realcomp II #20261064008 Report a problem
        8/28/2026Pending sale$275,000$129/sqft
        Source: Realcomp II #20261064008 Report a problem
        8/20/2026Price change$275,000-5.2%$129/sqft
        Source: Realcomp II #20261064008 Report a problem
        8/15/2026Listed for sale$290,000+82.4%$136/sqft
        Source: Realcomp II #20261064008 Report a problem
        2/1/2022Sold$159,000$74/sqft
        Source: Public Record Report a problem
        1/2/2022Pending sale$159,000$74/sqft
        Source: Realcomp II #2210083090 Report a problem
        12/11/2021Price change$159,000-3.6%$74/sqft
        Source: Realcomp II #2210083090 Report a problem
        10/19/2021Price change$165,000-5.7%$77/sqft
        Source: Realcomp II #2210083090 Report a problem
        10/4/2021Listed for sale$175,000$82/sqft
        Source: Realcomp II #2210083090 Report a problem
        3/24/2021Listing removed--
        Source: Owner Report a problem
        7/31/2019Listing removed$750
        Source: Owner Report a problem
        6/30/2019Listed for rent$750+3.4%
        Source: Owner Report a problem
        7/8/2018Listing removed$725
        Source: Owner Report a problem
        4/2/2018Listed for rent$725+11.5%
        Source: Owner Report a problem
        12/1/2015Listing removed$650
        Source: Thelma Smith Report a problem
        9/2/2015Listed for rent$650
        Source: Thelma Smith Report a problem
        7/8/2015Listing removed$650
        Source: Zillow Rental Network Report a problem
        2/5/2015Listed for rent$650
        Source: Owner Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025-- $89,700 -2%
        2024-- $91,500 +27.3%
        2023-- $71,900 +35.2%
        2022-- $53,200 +21.5%
        2021-- $43,800
        2020$2,385 +5.8%$43,800 +27.7%
        2019$2,255 $34,300 +24.3%
        2018$2,255 $27,600 +9.5%
        2017-- $25,200 -43.9%
        2016$2,659 $44,900 +98.7%
        2015$2,659 -12.3%$22,600 -25.5%
        2013$3,032 +14%$30,316 -28%
        2010$2,659 $42,079 -18%
        2009-- $51,316 -14.5%
        2008-- $60,019
        2007-- $60,019 +5.5%
        2005$314 $56,890 +3%
        2004-- $55,233
        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.

        Climate risks

        Neighborhood: Bagley

        Getting around

        51 / 100
        Somewhat Walkable
        46 / 100
        Some Transit
        44 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating

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

        Browse local experts