Sold707d on market
37841 Lakeshore Dr
Harrison Township, MI, 48045 • 48045 • Macomb County
$754,000
$198/sqft
4Beds
2Baths
3,809Sqft
0.18 acLot
2017Built
Property DNA
On the Lake St Clair
Canal Front, Direct Water Frontage
Colonial,Contemporary,Traditional Style
Built 2017 · 9 years of history
ST CLAIR HAVEN
48045
Enhanced Security
Carbon Monoxide Detectors · Closed Circuit Cameras · Exterior Video Surveillance
Outdoor Living
Deck · Porch
Gazebo
Gazebo
3-Car Garage
Three Car Garage · Attached · Electricityin Garage · Garage Door Opener
Market activity
Demand and pricing signals for this listing
12 views
People checking out this listing
707 days on market
Established listing
$198/sqft
Price per square foot
About this home
Single Family · Built 2017
Indulge in waterfront luxury living at its finest with this impeccably crafted newer home over 3800 sq ft, boasting a blend of timeless brick & high-end composite siding. Nestled on the serene canal, moments from open waters, this home offers a haven for boating enthusiasts with even the grandest of vessels. Accessibility thoughtfully prepped for w/ handicap elevator shaft connecting the pantry to the 2nd floor. Step inside to discover upgraded electrical systems transform the dwelling into a sophisticated smart home, full surround sound, complete with seamless Wi-Fi connectivity and comprehensive built-in surveillance and alarm systems for ultimate peace of mind. The heart of this home beats with culinary delight, showcasing real cherry hardwood cabinets with exquisite quartz countertops, kitchen worthy of both gourmet creations & everyday gatherings. Revel in the efficiency of this architectural gem with top-of-the-line windows and doors that not only bathe the interiors in natural light but also contribute to remarkably low monthly bills. With two primary bedrooms gracing different levels, each offering its own unique charm, indulge in the luxury of choice as you retire to your sanctuary. The third-level primary bedroom treats you to breathtaking water vistas, while the 2nd-level boasts a private bath adorned with lavish his & her sinks, a standup decorative shower enveloped in custom tile, & a Kohler self-cleaning jetted soaker tub complete with a digital screen for added indulgence. Designed for comfort and control home features 2 furnaces and AC units for zoned H&C, A large hot water tank & instant hot water add convenience, while a thoughtfully positioned mother-in-law suite on the main level, adjacent to a full bath. Spacious 3-car garage and a sprawling trex deck W/ Gazebo perfect for outdoor entertaining or simply soaking in the picturesque views. Enclosed by a newer aluminum fence, waterfront living at its finest! Appliances Included. PRE-APPROVAL/POF REQUIRED FOR ALL SHOWINGS. BATVAI
Standout features identified
Our analysis highlights waterfront living, serene canal, and boating enthusiasts as key attractions of this home.
Estimated monthly payment
Based on current rates
$4,644/month
Principal & Interest$3,639
Property Tax$754
Insurance$251
Down payment20% ($150,800)
3%50%
Est. 6.06% rate · 30yr fixed · $603,200 loan
Full calculator →At a glance
Key facts and listing details
TypeSingle Family Residence
Year Built2017
HeatingENERGYSTAR Qualified Furnace Equipment, Natural Gas, Zoned
CoolingCeiling Fans, ENERGYSTAR Qualified AC Equipment
Parking3 Attached Garage spaces
Lot7,840 sqft
Property
Home typeSingle Family
Sub-typeSingle Family Residence
StyleColonial,Contemporary,Traditional
Year built2017
Stories3
Systems
HeatingENERGYSTAR Qualified Furnace Equipment, Natural Gas, Zoned
CoolingCeiling Fans, ENERGYSTAR Qualified AC Equipment
RoofAsphalt
ConstructionBrick, Other
Water / SewerPublic / Public Sewer
Parking & Outdoor
ParkingThree Car Garage, Attached, Electricityin Garage, Garage Door Opener
Garage3 spaces
FencingBack Yard,Fenced
Lot7,840 sqft
Location & Tax
Neighborhood48045
Annual tax$9,466
Parcel171222381021
Bathrooms & Fees
Full baths2
Features & details
14 categories of property features
Interior Features
Interior
Entrance Foyer
High Speed Internet
Jetted Tub
Programmable Thermostat
Sound System
Spa Hottub
Appliances
Dishwasher
Disposal
Double Oven
Dryer
Free Standing Gas Range
Free Standing Refrigerator
Humidifier
Microwave
Washer
Heating
ENERGYSTAR Qualified Furnace Equipment
Natural Gas
Zoned
Cooling
Ceiling Fans
ENERGYSTAR Qualified AC Equipment
Laundry
Gas Dryer Hookup
Laundry Room
Windows
Energy Star Qualified Windows
Exterior Features
Exterior
Lighting
Parking
Three Car Garage
Attached
Electricityin Garage
Garage Door Opener
Construction
Brick
Other
Patio & Porch
Deck
Porch
Security
Carbon Monoxide Detectors
Closed Circuit Cameras
Exterior Video Surveillance
Security System Owned
Smoke Detectors
Pool Features
None
Utilities
Cable Available
Underground Utilities
Other Structures
Gazebo
Room details
11 rooms detailed
Primary Bedroom
Second12×13 ft
Bedroom
Second12×12 ft
Bedroom
Entry12×16 ft
Bedroom
Third13×18 ft
Primary Bathroom
SecondOther
EntryListing insights
Market data and value estimates
StatusSold
Days on market707
Est. value$821,300
Est. rent$3,707/mo
Tax rate1.32%
Price/sqft$198
On marketFeb 29, 2024
PostedJul 3, 2025
Last sold$754,000
MLS updatedAug 29, 2025
Tour days6
Views12
How are the schools in Harrison Township?
3 schools rated nearby
Location
Harrison Township, MI, 48045
Price history
12 events
DateEventPrice$/sqftSource
May 1, 2024Sold$754,000$198Realcomp II
Apr 22, 2024Pending Sale$765,000$201Realcomp II
Mar 23, 2024Price Change$765,000$201Realcomp II
Feb 29, 2024Listed For Sale$799,000$210Realcomp II
Oct 11, 2021Sold$500,000$131MiRealSource
Sep 17, 2021Pending Sale$615,000$161MiRealSource
Sep 7, 2021Price Change$615,000$161MiRealSource
Aug 12, 2021Listed For Sale$625,000$164Realcomp II
Aug 1, 2021Contingent$625,000$164Realcomp II
Jul 24, 2021Price Change$625,000$164MiRealSource
Jul 17, 2021Listed For Sale$899,000$236MiRealSource
Jun 20, 2013Sold$80,000$21Public Record
Sold$754,000
May 1, 2024•$198/sqft•Realcomp II
Pending Sale$765,000
Apr 22, 2024•$201/sqft•Realcomp II
Price Change$765,000
Mar 23, 2024•$201/sqft•Realcomp II
Listed For Sale$799,000
Feb 29, 2024•$210/sqft•Realcomp II
Sold$500,000
Oct 11, 2021•$131/sqft•MiRealSource
Pending Sale$615,000
Sep 17, 2021•$161/sqft•MiRealSource
Price Change$615,000
Sep 7, 2021•$161/sqft•MiRealSource
Listed For Sale$625,000
Aug 12, 2021•$164/sqft•Realcomp II
Contingent$625,000
Aug 1, 2021•$164/sqft•Realcomp II
Price Change$625,000
Jul 24, 2021•$164/sqft•MiRealSource
Listed For Sale$899,000
Jul 17, 2021•$236/sqft•MiRealSource
Sold$80,000
Jun 20, 2013•$21/sqft•Public Record
Tax history
13 years of records
YearTax paidAssessed value
Apr 9, 2025$11,555$382,500
Apr 9, 2024$9,617$381,000
Apr 9, 2023$9,207$277,500
Apr 9, 2022$8,527$266,400
Apr 9, 2021—$283,000
Apr 9, 2020—$270,200
Apr 9, 2019—$259,000
Apr 9, 2018$8,954$270,200
Apr 9, 2017—$89,020
Apr 9, 2016—$89,020
Apr 9, 2015—$61,880
Apr 9, 2012$1,703$61,880
Apr 9, 2010—$61,880
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
IDX provided courtesy of Realcomp II Ltd. via Zillow, Inc and MLS Copyright 2026 Realcomp II Ltd. Shareholders IDX information is provided exclusively for consumers' personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified. Any use of search facilities of data on the site, other than by a consumer looking to purchase real estate, is prohibited. The data relating to real estate properties on this website was last updated as recently as 2026-02-06 15:35:30 PST Listing Information presented by local MLS brokerage: Zillow, Inc., REALTOR®- Lauren Buttazzoni - (313) 479-2702
No obligation · Same-day response