Andover RE
Powered by 
- 8
- Overview
- Description
- Property Details
- Location
- Facts & Features
- Getting Around
- Nearby Homes
Street View
$149,900
Monthly Est:$746
5 Beds
2 Baths2 full baths
1,434sqft
17196 Shields St, Hamtramck, MI 48212
$149,900
$746/moEst:
Get Pre-Approved
Single Family Residence
Built in 1925
$-- HOA
0.07 acre lot
$105/sq.ft
Description
A great opportunity to own a dream house at 48212 zip code, ideal for first-time buyers or anyone looking for investment as it can be turned to Multifamily. This amazing house has been fully remodeled in 2026 including new roof, doors and windows. This house has 4 bedrooms with a potential 5th bed and 2 full baths with spacious layout with separate entrance for upper unit, and a perfect basement for storage. Close to shopping, dining, schools, and major roadways. Schedule today to turn this house to your home.
- Houzeo last checked: 1 hour ago
- Listing updated: September 9, 2026 at 1:21 am
- Listing Provided by: Abusaleh Tarek (313) 739-8291 | NPG Real Estate (248) 819-3637
- Source: Realcomp MLS-MI | MLS#: 20261051898
- Originating MLS: Realcomp II Ltd
Property Details
Status
Pending
Type
Single Family Residence
No. of Stories
-
County
City
Neighborhood
--
Year Built
1925
HOA Fees
-
Finished Area
1,434 sqft
Lot Size
0.07 acre lot
Basement Area
- sqft
MLS Name
Realcomp MLS
MLS Number
20261051898
MLS Status
Pending
Days on Market
121
Cumulative Days on Market
86
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Location
Facts & Features
Rooms
Bedrooms & bathrooms
Bedrooms: 5
Bathrooms: 2
Interior
Sewer
Sewer At Street
Heating
Forced Air, Natural Gas
Appliances
Free Standing Refrigerator, Gas Cooktop
Construction
Year Built
Year Built: 1925
Home type
Single Family Residence
Construction Materials
Brick, Vinyl Siding
Architectural Style
Bungalow
Foundation Details
Basement, Block
Utilities & Energy
Parking Features
Driveway, No Garage
Water Source
Waterat Street
Pool Features
None
Basement
Unfinished
Other Features
Disclosures
No Restrictions, Taxes Not Homestead Exempt
Patio And Porch Features
Porch
Subdivision Name
Downies Aladdin
Price History
| Date | Event | Price |
|---|---|---|
09/08/2026 Source: | Pending | $149,900 $105/sqft |
07/10/2026 Source: | Listed for Sale | $149,900 -21.11% $105/sqft |
07/05/2026 Source: | Listing Removed | $190,000 +15733.33% $132/sqft |
06/12/2026 Source: | Coming Soon | $1,200 $1/sqft |
06/12/2026 Source: | Listed for Sale | $1,200 -99.37% $1/sqft |
Show more
Nearby Homes
Find Homes by Property Features in Hamtramck, MI
Based on information from the Board/Association of REALTORS® (alternatively, from the Realcomp II Ltd. MLS) through Nov 06, 2026, 07:00AM. 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
