OFF MARKET
Google street view image for 37400 Union Lake Rd, Harrison Twp, MI 48045
Off market nov 1992 for $180K
$587,427
Est. refi paymentEst. refi $1,276/mo
2
bd
•
2.5 ba
•
2,959
sq ft

37400 Union Lake Rd, Harrison Twp, MI 48045

map-entry

About this home

37400 Union Lake Rd is a 2,959 square foot house on a 2.65 acre lot with 2 bedrooms and 2.5 bathrooms. - it last sold on November 20, 1992 for $180,000. Based on Redfin's Harrison Twp data, we estimate the home's value is $587,427.
Single-familyProperty Type
1954Year Built
2.65 acresLot Size
$199Est. Price/Sq.Ft.
Source:Public Records

Redfin Estimate

$587,427
$407K since sold in November 1992$3,000 since September

This home's estimate is 63.6% higher than the average sale price ($359K) of 6 comparable homes.

Claim this home to receive a free report every month with insights on the changing estimate.

Earn from this home

Sell
$551,624
Est. take-home

List your home with Redfin and save $5,874

Refinance
$0
Est. cash available

Get cash now or lower your monthly rate

Rent
$2,938/mo
Redfin rental estimate

List your home for rent

Market trends in 48045, MI

Last updated September 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price
98.5%

0.4% MoM

Median sale price
$274K

$16K MoM

Avg. days on market
29d

3 days MoM

Recently sold homes
99

6 MoM

New listings for sale

Provided by Redfin

Sale history for 37400 Union Lake Rd

Tax history for 37400 Union Lake Rd

*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.

Permits

Sep 6, 2017 • Final
Building

Roofing

Dec 2, 2003 • Final
Plumbing

Plumbing

Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.

Property details

Around this home

Schools

Marie C. Graham Elementary School

Public PreK-5 • Assigned • 0.5mi

8/10
L'anse Creuse Middle School - Central

Public 6-8 • Assigned • 0.6mi

5/10
High School

Public 9-12 • Assigned • 0.8mi

8/10
Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Climate risks

1/10 Flood Factor

Minimal risk of a flood reaching the building in the next 30 years

1/10 Fire Factor

Unlikely to be in a wildfire in next 30 years

3/10 Heat Factor

7 days above 96° expected this year, 14 days in 30 years

1/10 Wind Factor

Minimal risk of severe winds over next 30 years

4/10 Air Factor

4 unhealthy days expected this year, 6 days in 30 years

Provided by First Street

Historical weather

Harrison Twp, MI • 48045
Average low and high temperatures (°F)
28
17
33
20
49
32
58
42
65
49
79
62
83
68
78
63
74
57
65
48
49
39
36
26
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec

Sun exposure

In this area, properties receive around 9.1 hours in June and 2.4 hours in December, placing it below the U.S. average for solar exposure.

9.1 hrs
2.4 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$559,000 – $676,000

Reach more buyers when you sell with Redfin. Save up to $5,874 in fees. 3 minutes to get started.

Need the cash from your home fast? Sell to .

Nearby similar homes

$239,900
3 beds1.5 baths2,000 sq ft
10 Shiawassee Cir, Mount Clemens, MI 48043
(586) 932-2660
$214,900
4 beds2 baths1,725 sq ft
280 Clinton River Dr, Mount Clemens, MI 48043
$1,495,000
Land— sq ft
35190 Jeffers Ct, Harrison Twp, MI 48045
(810) 329-9001
$265,000
4 beds1.5 baths2,756 sq ft
22405 E Schafer St, Clinton Twp, MI 48035
(586) 783-7888
$279,999
3 beds2.5 baths1,536 sq ft
26560 Acacia St, Harrison Twp, MI 48045 2501
(248) 264-1700
$230,000
3 beds1.5 baths3,129 sq ft
23880 Shook Rd, Clinton Twp, MI 48035 3230
(248) 609-8000

New listings for sale in 48045 1536

NEW 6 HRS AGO
25800 N North River Rd, Harrison Township, MI 48045 1536
$299,900
3 beds1.5 baths1,619 sq ft
25800 N North River Rd, Harrison Township, MI 48045 1536
(586) 536-6000
OPEN SAT, 12PM TO 2PMVIDEO TOUR
$415,000
3 beds2.5 baths3,415 sq ft
39265 Canterbury Dr, Harrison Twp, MI 48045
(586) 315-5700
NEW 21 HRS AGO
$489,000
4 beds2.5 baths2,577 sq ft
39283 Willowmere St, Harrison Twp, MI 48045
NEW 21 HRS AGO
25800 N North River Rd, Harrison Twp, MI 48045
$299,900
3 beds1.5 baths1,619 sq ft
25800 N North River Rd, Harrison Twp, MI 48045
OPEN SAT, 11AM TO 1PM
$574,977
2 beds1 bath1,182 sq ft
41260 Conger Bay Dr, Harrison Twp, MI 48045 1424
(248) 786-1777
NEW 22 HRS AGO3D WALKTHROUGH
$499,000
3 beds2.5 baths2,180 sq ft
34432 Jefferson Unit 6 Ave #6, Harrison Twp, MI 48045
(313) 884-7000
NEW 25 HRS AGO3D & VIDEO TOUR
$235,000
3 beds2 baths1,530 sq ft
39639 Chart St, Harrison Twp, MI 48045
(586) 580-8092
$229,000
2 beds2.5 baths1,350 sq ft
25592 Sun Sail #155, Harrison Twp, MI 48045
(313) 663-1308
$398,000
3 beds1.5 baths2,612 sq ft
38165 Circolo St, Harrison Twp, MI 48045
(586) 465-6296

Home values near 37400 Union Lake Rd

Data from public records.

More real estate resources

Oakland County homes for sale
Wayne County homes for sale
Lapeer County homes for sale
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

Download the Redfin App on the Apple App Store
Download the Redfin App from the Google Play Store

About us

Why Redfin?
Community Impact
Inclusion
Culture
Press
Investors
Blog
Real Estate News

Find us

Contact Us
Help Center
Advertise

Subsidiaries

Rent.
ApartmentGuide

Affiliated Business

Rocket Close
Rocket Mortgage

Countries

US flagUnited States

Canadian flagCanada

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.

GreatSchools Ratings provided by GreatSchools.org.