Seller's Agent in 2025
Joe Hammel
Keller Williams Somerset
(248) 422-1685
237 in this area
1,086 Total Sales
Welcome to 8047 Hupp—a well-maintained, tenant-occupied ranch in one of Michigan’s most dynamic real estate markets. This 2-bedroom, 1-bath home is already generating $1,050/month in rental income, with a lease set to renew in August 2025. The tenant covers all utilities, offering immediate cash flow and minimal overhead for the new owner. The property boasts an updated kitchen and bathroom (2020), hardwood floors, a dedicated laundry room, and an enclosed patio with new windows. Additional features include a garage with a new roof, providing ample storage space. All city rental certifications are current, ensuring compliance and peace of mind. Warren continues to draw investor interest with its strong rental demand, ongoing revitalization efforts, and strategic location near Detroit. This thriving market has become a go-to for both new and seasoned investors seeking dependable, income-producing properties.
Last Agent to Sell the Property
Keller Williams Somerset License #6501422602 Listed on: 05/15/2025
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Warranty Deed | $90,000 | None Listed On Document | |
| Warranty Deed | -- | None Listed On Document | |
| Warranty Deed | -- | None Listed On Document | |
| Warranty Deed | $57,500 | Interstate Title | |
| Quit Claim Deed | -- | None Available | |
| Warranty Deed | $14,000 | None Available | |
| Quit Claim Deed | -- | None Available | |
| Warranty Deed | $64,000 | Lawyers Title Insurance Corp |
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $72,000 | New Conventional | |
| Previous Owner | $541,100 | New Conventional |
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 07/07/2025 07/07/25 | Sold | $90,000 | -5.3% | $113 / Sq Ft | |
| 05/28/2025 05/28/25 | Price Changed | $95,000 | -5.0% | $119 / Sq Ft | |
| 05/15/2025 05/15/25 | For Sale | $100,000 | +73.9% | $126 / Sq Ft | |
| 01/12/2023 01/12/23 | Sold | $57,500 | -16.7% | $68 / Sq Ft | View Prior Sale |
| 12/24/2022 12/24/22 | Pending | -- | -- | -- | |
| 12/02/2022 12/02/22 | For Sale | $69,000 | 0.0% | $81 / Sq Ft | |
| 06/26/2020 06/26/20 | Rented | $850 | +6.3% | -- | |
| 06/06/2020 06/06/20 | Under Contract | -- | -- | -- | |
| 05/07/2020 05/07/20 | For Rent | $800 | +3.2% | -- | |
| 04/26/2018 04/26/18 | Rented | $775 | +3.3% | -- | |
| 04/23/2018 04/23/18 | Under Contract | -- | -- | -- | |
| 04/17/2018 04/17/18 | Price Changed | $750 | -3.2% | $1 / Sq Ft | |
| 04/06/2018 04/06/18 | For Rent | $775 | +19.2% | -- | |
| 01/14/2015 01/14/15 | Rented | $650 | -10.3% | -- | |
| 01/11/2015 01/11/15 | Under Contract | -- | -- | -- | |
| 09/29/2014 09/29/14 | For Rent | $725 | +11.5% | -- | |
| 01/26/2013 01/26/13 | Rented | $650 | 0.0% | -- | |
| 01/15/2013 01/15/13 | Under Contract | -- | -- | -- | |
| 11/30/2012 11/30/12 | For Rent | $650 | -- | -- |
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2025 | $2,603 | $41,490 | $0 | $0 |
| 2024 | $25 | $36,110 | $0 | $0 |
| 2023 | $954 | $27,490 | $0 | $0 |
| 2022 | $934 | $22,510 | $0 | $0 |
| 2021 | $913 | $20,580 | $0 | $0 |
| 2020 | $892 | $19,810 | $0 | $0 |
| 2019 | $869 | $17,580 | $0 | $0 |
| 2018 | $858 | $13,020 | $0 | $0 |
| 2017 | $844 | $12,740 | $1,910 | $10,830 |
| 2016 | $837 | $12,740 | $0 | $0 |
| 2015 | -- | $12,830 | $0 | $0 |
| 2012 | -- | $12,800 | $0 | $0 |
Seller's Agent in 2025
Joe Hammel
Keller Williams Somerset
(248) 422-1685
237 in this area
1,086 Total Sales
Seller Co-Listing Agent in 2025
Jess Caldwell
Keller Williams Somerset
(734) 231-5235
19 in this area
69 Total Sales
Buyer's Agent in 2025
Salma Mumu
ZS Realty LLC
(586) 565-4655
26 in this area
80 Total Sales
M
Seller's Agent in 2023
Martin Jeakle
Signature Sotheby's International Realty Bham
(248) 895-5002
2 in this area
24 Total Sales
D
Seller's Agent in 2020
David Meesseman
Berkshire Hathaway HomeServices Kee Realty
A
Buyer's Agent in 2018
Alice Peabody
Real Estate One Clinton
Source: Realcomp
MLS Number: 20250032901
APN: 12-13-34-105-017