UPDATED COLONIAL located on the North Rosedale Park border. This stunner has a NEW TEAR OFF ROOF (2026), new mechanicals and a ton of upgrades. Home has new flooring and paint throughout. Tons of natural light adorn the spacious living room, replete with panoramic windows, wood plank flooring, natural fireplace and recessed lighting. Entry level also has a dedicated dining room, and convenient half bathroom. Open floorplan flows to a gourmet kitchen flush with high end finishes, porcelain flooring, plenty of cabinets, QUARTZ counters, custom backsplash and gold designer fixtures. Upstairs find 3 spacious bedrooms and an updated full bath with tub/shower, new porcelain floor and wall tile. Full basement has a large laundry area and is ready for your finishing touches. Outside find an oversized garage and fenced yard. Priced well under the value of comparable homes in the area. Home with be delivered with CENTRAL AIR conditioning. This one is truly turn key and charming.
Active
$219,000
17217 Plainview Ave, Detroit, MI 48219
3beds
1,361sqft
Single Family Residence
Built in 1948
4,356 Square Feet Lot
$217,600 Zestimate®
$161/sqft
$-- HOA
What's special
Natural fireplaceFenced yardHigh end finishesOversized garageOpen floorplanTons of natural lightQuartz counters
- 26 days
- 262
- 22
Zillow last checked:
Listing updated:
Listed by:
Ali Baydoun 313-673-2655,
U.S. Investor Group 313-644-0034,
Sam Berri 248-255-9114,
U.S. Investor Group
Source: MichRIC,MLS#: 26040238
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 2
- Full bathrooms: 1
- 1/2 bathrooms: 1
Heating
- Forced Air
Appliances
- Laundry: In Basement
Features
- Basement: Full
- Number of fireplaces: 1
Interior area
- Total structure area: 1,361
- Total interior livable area: 1,361 sqft
- Finished area below ground: 675
Property
Parking
- Total spaces: 1
- Parking features: Detached
- Garage spaces: 1
Features
- Stories: 2
Lot
- Size: 4,356 Square Feet
- Dimensions: 41 x 110
Details
- Parcel number: 22094374.
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial
- Property subtype: Single Family Residence
Materials
- Brick
Condition
- New construction: No
- Year built: 1948
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
Community & HOA
Location
- Region: Detroit
Financial & listing details
- Price per square foot: $161/sqft
- Tax assessed value: $55,467
- Annual tax amount: $4,846
- Date on market: 8/3/2026
- Listing terms: Cash,FHA,VA Loan,Conventional
Estimated market value
$217,600
$207,000 - $228,000
$1,535/mo
Price history
| Date | Event | Price |
|---|---|---|
| 7/29/2026 | Listed for rent | $1,500+25%$1/sqft |
Source: Zillow Rentals Report a problem | ||
| 5/15/2026 | Listed for sale | $219,000+4.8%$161/sqft |
Source: | ||
| 4/16/2026 | Listing removed | $209,000$154/sqft |
Source: | ||
| 3/21/2026 | Listed for sale | $209,000$154/sqft |
Source: | ||
| 2/28/2026 | Listing removed | $209,000$154/sqft |
Source: | ||
| 1/24/2026 | Listed for sale | $209,000$154/sqft |
Source: | ||
| 1/23/2026 | Listing removed | $209,000$154/sqft |
Source: | ||
| 10/20/2025 | Listed for sale | $209,000-4.6%$154/sqft |
Source: | ||
| 10/20/2025 | Listing removed | $219,000$161/sqft |
Source: | ||
| 8/25/2025 | Listed for sale | $219,000$161/sqft |
Source: | ||
| 8/13/2025 | Listing removed | $219,000$161/sqft |
Source: | ||
| 5/29/2025 | Listed for sale | $219,000+1.9%$161/sqft |
Source: | ||
| 5/13/2025 | Listing removed | $215,000$158/sqft |
Source: | ||
| 1/8/2025 | Listed for sale | $215,000+87%$158/sqft |
Source: | ||
| 8/25/2023 | Listing removed | -- |
Source: Zillow Rentals Report a problem | ||
| 8/18/2023 | Listed for rent | $1,200$1/sqft |
Source: Zillow Rentals Report a problem | ||
| 6/30/2023 | Sold | $115,000+130%$84/sqft |
Source: Public Record Report a problem | ||
| 5/17/2023 | Listing removed | -- |
Source: Zillow Rentals Report a problem | ||
| 5/13/2023 | Listed for rent | $1,200+33.3%$1/sqft |
Source: Zillow Rentals Report a problem | ||
| 8/3/2015 | Listing removed | $900$1/sqft |
Source: DB Real estate Service. Report a problem | ||
| 7/31/2015 | Listed for rent | $900$1/sqft |
Source: DB Real estate Service. Report a problem | ||
| 2/23/2015 | Listing removed | $900$1/sqft |
Source: Ready Tenant USA INC. Report a problem | ||
| 2/6/2015 | Listed for rent | $900$1/sqft |
Source: Ready Tenant USA INC. Report a problem | ||
| 4/29/2014 | Listing removed | $900$1/sqft |
Source: re8l rental agency Report a problem | ||
| 2/5/2014 | Listed for rent | $900$1/sqft |
Source: re8l rental agency Report a problem | ||
| 1/17/2014 | Sold | $50,000+203%$37/sqft |
Source: Public Record Report a problem | ||
| 12/10/2013 | Sold | $16,500+18.9%$12/sqft |
Source: Public Record Report a problem | ||
| 11/15/2012 | Sold | $13,875-87.9%$10/sqft |
Source: Public Record Report a problem | ||
| 3/28/2008 | Sold | $115,000+400%$84/sqft |
Source: Public Record Report a problem | ||
| 1/25/2008 | Sold | $23,000$17/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | -- | $53,800 +27.2% |
| 2024 | -- | $42,300 +22.6% |
| 2023 | -- | $34,500 +26.4% |
| 2022 | -- | $27,300 +9.2% |
| 2021 | -- | $25,000 |
| 2020 | $1,009 -42.1% | $25,000 +29.5% |
| 2019 | $1,745 | $19,300 +10.9% |
| 2018 | $1,745 | $17,400 -2.2% |
| 2017 | -- | $17,800 -24.6% |
| 2016 | $2,739 | $23,600 +11.3% |
| 2015 | $2,739 -17.5% | $21,200 -36.2% |
| 2013 | $3,322 +21.3% | $33,216 -31.8% |
| 2010 | $2,739 | $48,699 -18% |
| 2009 | -- | $59,389 -14% |
| 2008 | -- | $69,057 |
| 2007 | -- | $69,057 +5.5% |
| 2005 | $800 | $65,457 +3% |
| 2004 | -- | $63,550 +110.4% |
| 2001 | $1,966 +12.2% | $30,207 +3.2% |
| 2000 | $1,752 | $29,270 |
Find assessor info on the county website
Monthly payment
Est. payment








