This home's estimate is 103.9% higher than the average sale price ($203K) of 6 comparable homes.
Search- Overview
- Sale & tax history
- Property details
- Neighborhood
17138 QUARRY St, Riverview, MI 48193 4735
About this home
Do not approach tenants! Turnkey 3-Unit Apartment Complex – Fully Renovated & Fully Occupied! Discover this beautifully renovated, income-generating property featuring three units and prime amenities. Featuring almost 3,500 sq feet. The expansive 1,700 sqft first-floor unit offers a spacious 2-bedroom layout with a luxurious master suite, walk-in closet, custom kitchen with quartz countertops, vinyl flooring, and a bright, open-concept living room. Rear storage space adds extra convenience. The second floor includes two additional units, one of which has been tastefully updated. A brand new tankless water heater, efficiently heating the whole building (installed in 2024) ensures energy-efficient comfort for all tenants. This well-maintained complex is fully occupied, delivering immediate cash flow. Enjoy private rear parking, ample street parking, and an additional parking agreement with a nearby liquor store just two buildings down, ensuring plenty of tenant parking. Whether you're expanding your portfolio or looking for a stable investment, this property offers long-term value and strong returns. All measurements are approximate agent to verify.

Redfin Estimate
Earn from this home
List your home with Redfin and save $4,142
Market trends in 48193, MI
Last updated August 2026
Buyer's Market
Seller's Market
Balanced market
0 days MoM
0 MoM
- COMING SOON
- NEW 22 HRS AGO
See all
Provided by Redfin
Sale history for 17138 QUARRY St
$0/sq ft
$0/sq ft
$0/sq ft
$123/sq ft
$126/sq ft
$126/sq ft
$126/sq ft
$0/sq ft
$0/sq ft
$64/sq ft
$80/sq ft
As the MLS and public records start to fill up, we'll list the details here.
Public record
Property details
Exterior
- Property Information
- Year Built: 19
- Lot Information
- Lot Size: 70,115
- Land Information
- Acreage: 0.06
- Frontage: 40
Financial
- Tax/Assessments Information
- Taxable Value: $41,055
- Total Tax Amount: $3,690
- Has Assessments
- Assessments Amount: $795
- Lease/Rent Information
- Has Lease
Location
- Address Information
- Street Designation: Street
- Location Details
- Directions: Property is one block South of Pennsylvania Road on the West Side of Quarry Road
- Municipality Type: City
- Municipality: Riverview
- Area (Municipality): Riverview (82181)
Public facts
- Beds: —
- Baths: —
- Sq. Ft.: —
- Stories: —
- Lot Size: —
- Style: Multi-Family (2-4 Unit)
- Year Built: —
- Year Renovated: —
- County: Wayne County
- APN: 51011010248002
Around this home
Schools
Public PreK-5 • Assigned • 0.5mi
Public 6-8 • Assigned • 1.3mi
Public 9-12 • Assigned • 0.4mi
Lifestyle
Provided by Walk Score and Local Logic
Sun exposure
In this area, properties receive around 9.6 hours in June and 2.7 hours in December, placing it below the U.S. average for solar exposure.
Nearby similar homes
New listings for sale in 48193 7503
Home values near 17138 QUARRY St
| Address | Redfin Estimate |
|---|---|
7 Beds | 4 Baths | 2439 Sq. Ft. | $293,413 |
- Beds | 1.5 Baths | 1128 Sq. Ft. | $199,334 |
| Address | Redfin Estimate |
|---|---|
4 Beds | 2.5 Baths | 2054 Sq. Ft. | $366,132 |
- Beds | 1 Baths | 1308 Sq. Ft. | $187,823 |
| Address | Redfin Estimate |
|---|---|
- Beds | 1.5 Baths | 2054 Sq. Ft. | $312,029 |
- Beds | - Baths | 1400 Sq. Ft. | — |
More real estate resources
- Neighborhoods
- Zip Codes
- Cities
- Popular Searches
| Grosse Ile homes for sale | |||
| Riverview Gardens homes for sale | |||
| Bretton Park homes for sale |
| 48193 homes for sale | |||
| 48195 homes for sale | |||
| 48138 homes for sale | |||
| 48183 homes for sale |
| Detroit homes for sale | |||
| Livonia homes for sale | |||
| Plymouth homes for sale |
Find us
Subsidiaries
Affiliated Business
Copyright: © 2026 Redfin. All rights reserved.
Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.
Do not sell or share my personal information.
REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.
California DRE #01521930
Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures
New Mexico Real Estate Licenses
TREC: Info About Brokerage Services, Consumer Protection Notice
All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.
Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.
If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.
REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.





























United States
Canada