For Sale190d on market
38128 Lakeshore Dr
Harrison Township, MI, 48045 • 48045 • Macomb County
$1,299,000
$331/sqft
-$76,000 since Dec 18, 2025
Down payment assistance available
4Beds
4Baths
3,928Sqft
0.23 acLot
2002Built
Property DNA
Waterfront Property
Lake Front
Colonial Style
Built 2002 · 24 years of history
St Clair Haven
48045
3.5-Car Garage
Attached
Ceramic Tile & Wood Floors
Quality flooring throughout
This home is getting attention
Listed 190 days ago · 1,047 views · 33 saves
Market activity
Demand and pricing signals for this listing
1,047 views
People checking out this listing
33 saves
Buyers have saved this home
190 days on market
Established listing
$331/sqft
Price per square foot
About this home
Single Family · Built 2002
Welcome to your dream home! Nearly 4,000 square feet of elegance and comfort are set directly on the shores of Lake St. Clair. This 4-bedroom, 3.5-bath residence offers unparalleled lake views and custom features throughout.On the main level, enjoy sun-filled living spaces with hardwood floors, a dedicated office, a cozy den, and a spacious living room with expansive windows showcasing breathtaking lakefront views. The chef’s kitchen is complete with custom cabinetry, premium finishes, and a seamless flow to the patio and Trex deck, perfect for entertaining.The second level is anchored by a serene primary suite featuring panoramic water views, a spa-inspired full bath, and a generous walk-in closet. The additional bedrooms are equally spacious, including a large second bedroom with its own walk-in closet. The finished third level provides a versatile bonus retreat with a full bath — ideal for guests, a home gym, or creative studio. Outside, enjoy a fenced backyard, Trex decking, and a 3-car heated garage with abundant space for storage, hobbies, or toys. Every detail has been thoughtfully designed to maximize comfort, style, and function, all just steps from the lake.
Standout features identified
Our analysis highlights fenced backyard, premium finishes, and hardwood floors as key attractions of this home.
Estimated monthly payment
Based on current rates
$8,472/month
Principal & Interest$6,740
Property Tax$1,299
Insurance$433
Down payment20% ($259,800)
3%50%
Est. 6.75% rate · 30yr fixed · $1,039,200 loan
Full calculator →At a glance
Key facts and listing details
TypeSingle Family Residence
Year Built2002
HeatingForced Air, Natural Gas
CoolingCeiling Fan(s), Central Air
Parking3 Attached Garage spaces
Lot10,018 sqft
Days on Zillow190 Days
Price/sqft$331
Property
Home typeSingle Family
Sub-typeSingle Family Residence
StyleColonial
Year built2002
Stories2
Systems
HeatingForced Air, Natural Gas
CoolingCeiling Fan(s), Central Air
ConstructionBrick
Water / SewerPublic / Public Sanitary
Parking & Outdoor
ParkingAttached
Garage3.5 spaces
BasementCrawl Space
Lot10,018 sqft
Location & Tax
Neighborhood48045
Annual tax$12,137
Parcel171222331011
Bathrooms & Fees
Full baths3
Features & details
7 categories of property features
Interior Features
Appliances
Bar Fridge
Dishwasher
Dryer
Refrigerator
Washer
Flooring
Ceramic Tile
Carpet
Wood
Heating
Forced Air
Natural Gas
Cooling
Ceiling Fan(s)
Central Air
Laundry
Main Level
Exterior Features
Parking
Attached
Construction
Brick
Room details
11 rooms detailed
Bedroom1
Second25×14 ft350 sqft
Carpet
Bedroom2
Second30×15 ft450 sqft
Carpet
Bedroom3
Second18×15 ft270 sqft
Carpet
Bedroom4
Third23×14 ft322 sqft
Carpet
Bathroom1
Second17×8 ft136 sqft
Ceramic
Bathroom2
Second8×6 ft48 sqft
Ceramic
Listing insights
Market data and value estimates
StatusFor Sale
Days on market190
Est. value$1,229,200
Est. rent$4,918/mo
Tax rate1.32%
Price/sqft$331
On marketSep 29, 2025
PostedSep 29, 2025
Last sold$960,000
MLS updatedDec 18, 2025
Tour days9
Views1,047
Favorites33
How are the schools in Harrison Township?
3 schools rated nearby
Location
Harrison Township, MI, 48045
Price history
3 events
DateEventPrice$/sqftSource
Dec 18, 2025Price Change$1,299,000$331MiRealSource
Sep 29, 2025Listed For Sale$1,375,000$350MiRealSource
Aug 6, 2004Sold$960,000$244MiRealSource
Price Change$1,299,000
Dec 18, 2025•$331/sqft•MiRealSource
Listed For Sale$1,375,000
Sep 29, 2025•$350/sqft•MiRealSource
Sold$960,000
Aug 6, 2004•$244/sqft•MiRealSource
Tax history
20 years of records
YearTax paidAssessed value
Apr 7, 2025$12,137$520,000
Apr 7, 2024$11,564$500,000
Apr 7, 2023$10,993$466,500
Apr 7, 2022$10,571$429,600
Apr 7, 2021—$422,800
Apr 7, 2020—$397,400
Apr 7, 2019—$377,300
Apr 7, 2018$9,570$338,500
Apr 7, 2017—$332,690
Apr 7, 2016—$332,690
Apr 7, 2015—$304,700
Apr 7, 2012$7,873$262,940
Apr 7, 2010—$265,410
Apr 7, 2009—$267,010
Apr 7, 2008—$354,610
Apr 7, 2007—$404,150
Apr 7, 2006—$300,210
Apr 7, 2004$14,153$297,200
Apr 7, 2003$6,762$279,240
Apr 7, 2000$5,751—
Nearby homes
Neighborhood details
Local context around this listing
Harrison Township, MI • Macomb County
Nearby cities
ChesterfieldClinton TownshipEastpointeMacombRosevilleSaint Clair ShoresShelby TownshipSterling Heights
Nearby zip codes
48045
Similar homes
Source MLS: MiRealSource Provided through IDX via MiRealSource. Courtesy of MiRealSource Shareholder. Copyright MiRealSource. The information published and disseminated by MiRealSource is communicated verbatim, without change by MiRealSource, as filed with MiRealSource by its members. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified. Copyright 2026 MiRealSource. All rights reserved. The information provided hereby constitutes proprietary information of MiRealSource, Inc. and its shareholders, affiliates and licensees and may not be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopy, recording, scanning or any information storage and retrieval system, without written permission from MiRealSource, Inc. [Click here for more information](/mls-disclaimers/#261)
No obligation · Same-day response