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.
For sale
Price cut: $15K (8/20)
$275,000
17511 Indiana St, Detroit, MI 48221
4beds
2,140sqft
Multi Family
Built in 1937
-- sqft lot
$274,300 Zestimate®
$129/sqft
$-- HOA
What's special
- 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#: 20261064008
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
| Date | Event | Price |
|---|---|---|
| 9/8/2026 | Listed for sale | $275,000$129/sqft |
Source: | ||
| 8/28/2026 | Pending sale | $275,000$129/sqft |
Source: | ||
| 8/20/2026 | Price change | $275,000-5.2%$129/sqft |
Source: | ||
| 8/15/2026 | Listed for sale | $290,000+82.4%$136/sqft |
Source: | ||
| 2/1/2022 | Sold | $159,000$74/sqft |
Source: Public Record Report a problem | ||
| 1/2/2022 | Pending sale | $159,000$74/sqft |
Source: | ||
| 12/11/2021 | Price change | $159,000-3.6%$74/sqft |
Source: | ||
| 10/19/2021 | Price change | $165,000-5.7%$77/sqft |
Source: | ||
| 10/4/2021 | Listed for sale | $175,000$82/sqft |
Source: | ||
| 3/24/2021 | Listing removed | -- |
Source: Owner Report a problem | ||
| 7/31/2019 | Listing removed | $750 |
Source: Owner Report a problem | ||
| 6/30/2019 | Listed for rent | $750+3.4% |
Source: Owner Report a problem | ||
| 7/8/2018 | Listing removed | $725 |
Source: Owner Report a problem | ||
| 4/2/2018 | Listed for rent | $725+11.5% |
Source: Owner Report a problem | ||
| 12/1/2015 | Listing removed | $650 |
Source: Thelma Smith Report a problem | ||
| 9/2/2015 | Listed for rent | $650 |
Source: Thelma Smith Report a problem | ||
| 7/8/2015 | Listing removed | $650 |
Source: Zillow Rental Network Report a problem | ||
| 2/5/2015 | Listed for rent | $650 |
Source: Owner Report a problem | ||
Public tax history
| Year | Property taxes | Tax 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





