17138 QUARRY St, Riverview, MI 48193 4735

Off market jul 2025 for $385K

—

•

— ba

•

3,125

sq ft

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.

2,613 sq ftLot Size

$123Price/Sq.Ft.

Listed by Nick Jaafar • Keller Williams Legacy

•313-752-0000 (broker)

Bought with Nick Jaafar • Keller Williams Legacy

•313-752-0000 (broker)

Redfin checked: a minute ago

•Source:MiRealSource-MiMLS #60393793

Redfin Estimate

Unfortunately, we don't have enough data to generate an accurate Estimate at this time.

Market trends in 48193, MI

Last updated September 2026

Buyer's Market

Seller's Market

Balanced market

Sale-to-list price

99.7%

1.4% MoM

Median sale price

$245K

$30K MoM

Avg. days on market

12d

3 days MoM

Recently sold homes

5 MoM

New listings for sale

NEW 10 HRS AGO
$194,900
3 beds1 bath1,036 sq ft
18571 Hamann St, Riverview, MI 48193
OPEN SUN, 2PM TO 4PM
$595,000
4 beds2.5 baths4,000 sq ft
18731 Country Club Cir, Riverview, MI 48193
OPEN SUN, 12PM TO 3PM
$258,900
3 beds1.5 baths1,792 sq ft
18340 Alvaro Ave, Brownstown, MI 48193
$154,900
3 beds1 bath980 sq ft
18563 Hamann St, Riverview, MI 48193
$349,000
4 beds1.5 baths1,648 sq ft
19339 Hampton St, Riverview, MI 48193
$179,900
3 beds1 bath1,036 sq ft
18062 Hinton St, Riverview, MI 48193
$232,000
2 beds2.5 baths1,396 sq ft
18628 Hilltop Dr, Riverview, MI 48193
$1,050,000
4 beds6 baths11,172 sq ft
22535 Pennsylvania Rd, Brownstown, MI 48193
FOR SALE BY OWNER
$389,500
3 beds3 baths2,418 sq ft
18015 Mulberry St, Riverview, MI 48193
OPEN SAT, 11AM TO 1PM
$230,000
2 beds2.5 baths1,395 sq ft
15764 Golfview Dr N #185, Riverview, MI 48193
See all

Provided by Redfin

Sale history for 17138 QUARRY St

Date

Event

Price

REALSOURCE #60980690

May 11, 2026

Rental Removed

$1,400

$0/sq ft

Apr 16, 2026

Price Changed

$1,400

$0/sq ft

Apr 2, 2026

Listed for Rent

$1,495

$0/sq ft

MiRealSource-MiMLS #60393793

Jul 1, 2025

Pending

—

Jul 1, 2025

Sold

$385,000

$123/sq ft

May 24, 2025

Listing Removed

—

May 24, 2025

Pending

—

May 14, 2025

Listing Removed

—

May 13, 2025

Listed

$395,000

$126/sq ft

REALCOMP #20250035008

May 23, 2025

Listing Removed

—

May 13, 2025

Listed

$395,000

$126/sq ft

MiRealSource-MiMLS #60393818

May 23, 2025

Listing Removed

—

May 13, 2025

Listed

$395,000

$126/sq ft

RENT. #1

Aug 24, 2023

Rental Removed

$1,500

$0/sq ft

Jul 26, 2023

Listed for Rent

$1,500

$0/sq ft

MiRealSource-MiMLS #60147310

Nov 10, 2022

Listing Removed

—

Nov 10, 2022

Pending

—

Nov 10, 2022

Sold

$200,000

$64/sq ft

Oct 1, 2022

Listing Removed

—

Oct 1, 2022

Relisted

—

Sep 30, 2022

Listing Removed

—

Sep 30, 2022

Relisted

—

Sep 29, 2022

Listing Removed

—

Sep 29, 2022

Relisted

—

Sep 28, 2022

Listing Removed

—

Sep 26, 2022

Listed

$249,900

$80/sq ft

Public record

Public record
Permits

Beds

—

Baths

—

Stories

—

Lot width

—

Lot depth

—

Lot size

—

Year renovated

—

Sq. Ft.

—

Year built

—

Style

Multi-Family (2-4 Unit)

County

Wayne County

APN

51011010248002

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Jul 20, 2025.

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

Home facts updated by county records on Jul 20, 2025

Around this home

Schools

Memorial Elementary School

Public PreK-5 • Assigned • 0.5mi

4/10

Seitz Middle School

Public 6-8 • Assigned • 1.3mi

7/10

Riverview Community High School

Public 9-12 • Assigned • 0.4mi

10/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Historical weather

Riverview, MI • 48193 4735

Average low and high temperatures (°F)

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

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.

9.6 hrs

2.7 hrs

JuneDecember

Provided by Shadowmap

Work with an experienced agent and save on fees. 3 minutes to get started.

Need the cash from your home fast? Sell to .

Nearby similar homes

FOR SALE BY OWNER

$10,000

1 bed1 bath— sq ft

4470 9th St, Ecorse, MI 48229

Listed 3 days

$59,000

Land— sq ft

000 king Rd, Riverview, MI 48192

Listed 288 days

(734) 782-3200

$310,000

3 beds1.5 baths2,154 sq ft

10845 Melbourne Ave, Allen Park, MI 48101

Attached garage • Natural fireplace • Well manicured yard

$299,995

Land— sq ft

722 Southfield Rd, Lincoln Park, MI 48146

Paved parking lot • Listed 296 days

$350,000

7 beds6 baths2,692 sq ft

162 Burke St, River Rouge, MI 48218

Remodeled kitchens • Remodeled bathrooms • Stable occupancy

$980,000

Land— sq ft

22900 Superior, Taylor, MI 48180

Listed 360 days

New listings for sale in 48193

NEW 10 HRS AGO

$194,900

3 beds1 bath1,036 sq ft

18571 Hamann St, Riverview, MI 48193

Covered patio • Remodeled kitchen • Tile backsplash

OPEN SUN, 2PM TO 4PM

$595,000

4 beds2.5 baths4,000 sq ft

18731 Country Club Cir, Riverview, MI 48193

Two story great room • Remodeled kitchen • Dedicated wine bar

OPEN SUN, 12PM TO 3PM

$258,900

3 beds1.5 baths1,792 sq ft

18340 Alvaro Ave, Brownstown, MI 48193

0.25 acre lot • 2 garage spots • Built 1973

$154,900

3 beds1 bath980 sq ft

18563 Hamann St, Riverview, MI 48193

Fenced-in yard • 6,098 sq ft lot • 2 garage spots

$349,000

4 beds1.5 baths1,648 sq ft

19339 Hampton St, Riverview, MI 48193

Private backyard • Finished basement • Updated cabinets

$179,900

3 beds1 bath1,036 sq ft

18062 Hinton St, Riverview, MI 48193

New roof • Newer gutters • Newer garage door

$232,000

2 beds2.5 baths1,396 sq ft

18628 Hilltop Dr, Riverview, MI 48193

Main-floor laundry • Generous green space • Vaulted ceilings

$1,050,000

4 beds6 baths11,172 sq ft

22535 Pennsylvania Rd, Brownstown, MI 48193

Custom built estate • Chef kitchen • Private guest home

FOR SALE BY OWNER

$389,500

3 beds3 baths2,418 sq ft

18015 Mulberry St, Riverview, MI 48193

Hardwood floors • Granite countertops • Gourmet kitchen

Home values near 17138 QUARRY St

Data from public records.

Address	Redfin Estimate
17146 Quarry Road, Riverview, MI 7 Beds \| 4 Baths \| 2439 Sq. Ft.	—
17109 Quarry Street, Riverview, MI - Beds \| 1.5 Baths \| 1128 Sq. Ft.	$201,544

Address	Redfin Estimate
17153 Quarry Street, Riverview, MI 4 Beds \| 2.5 Baths \| 3194 Sq. Ft.	$334,645
17123 Quarry Street, Riverview, MI - Beds \| 1 Baths \| 1308 Sq. Ft.	$188,663

Address	Redfin Estimate
17171 Quarry Street, Riverview, MI - Beds \| 1.5 Baths \| 2054 Sq. Ft.	$310,281
17076 Quarry, Riverview, MI - Beds \| - Baths \| 1400 Sq. Ft.	—

Property information provided by undefined .

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

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.

GreatSchools Ratings provided by GreatSchools.org.

48193 homes for sale
48195 homes for sale
48138 homes for sale
48183 homes for sale

Houses for rent in Riverview	Agents near me	Livonia, MI homes for sale	Riverview Housing Market
Houses for sale near me	Detroit, MI homes for sale	Royal Oak, MI homes for sale
Land for sale near me	Ann Arbor, MI homes for sale	Novi, MI homes for sale
Open Houses near me	Grand Rapids, MI homes for sale	Riverview Property Records
Condos for sale near me	Troy, MI homes for sale	MI New Listings

Grosse Ile homes for sale
Riverview Gardens homes for sale
Bretton Park homes for sale

Detroit homes for sale
Livonia homes for sale
Southfield homes for sale

About this home

Redfin Estimate

Market trends in 48193, MI

Sale history for 17138 QUARRY St

Public record

Property details

Around this home

Schools

Lifestyle

Historical weather

Sun exposure

Nearby similar homes

New listings for sale in 48193

Home values near 17138 QUARRY St

More real estate resources