Sold690d on market
38122 Lakeshore Dr
Harrison Township, MI, 48045 • 48045 • Macomb County
$775,000
$162/sqft
5Beds
4Baths
4,790Sqft
0.23 acLot
2001Built
Property DNA
On the Lake St. Clair
All Sports Lake, Boat Facilities, Direct Water Frontage, Dock Facilities, Lake Front, Waterfront
Colonial,Other Style
Built 2001 · 25 years of history
ST CLAIR HAVEN
48045
Enhanced Security
Carbon Monoxide Detectors · Smoke Detectors
Outdoor Living
Patio
3-Car Garage
Three Car Garage · Attached · Electricityin Garage · Garage Door Opener
Market activity
Demand and pricing signals for this listing
7 views
People checking out this listing
690 days on market
Established listing
$162/sqft
Price per square foot
About this home
Single Family · Built 2001
Captivating three-story lakeside retreat tailored for the modern. Revel in the open layout and breathtaking Lake St. Clair views. Meticulously maintained, this residence boasts a gourmet kitchen with a Thermador cooktop, double oven, and wine chiller—a chef's haven. Seamless flow into the dining room and a Three Season room for relaxation or entertaining with panoramic water views. The first floor hosts a versatile bedroom/home gym and an office space/library. The second level's owner suite features vaulted ceilings, a skylight, and a walkout balcony for serene mornings. Three additional bedrooms and a spacious bonus room, ideal for a home theater, complete the second level. The private third floor offers a kitchenette and independent heating/cooling—an all-season oasis. With a deep three-car garage and a two-tiered patio overlooking the lake, this home is the epitome of luxury living for the discerning single man. Experience it firsthand to fully grasp its allure!
Standout features identified
Our analysis highlights vaulted ceilings, deep three-car garage, and open layout as key attractions of this home.
Estimated monthly payment
Based on current rates
$4,807/month
Principal & Interest$3,774
Property Tax$775
Insurance$258
Down payment20% ($155,000)
3%50%
Est. 6.14% rate · 30yr fixed · $620,000 loan
Full calculator →At a glance
Key facts and listing details
TypeSingle Family Residence
Year Built2001
HeatingForced Air, Natural Gas
CoolingCeiling Fans, Central Air
Parking3 Attached Garage spaces
Lot10,018 sqft
Property
Home typeSingle Family
Sub-typeSingle Family Residence
StyleColonial,Other
Year built2001
Stories2
Systems
HeatingForced Air, Natural Gas
CoolingCeiling Fans, Central Air
RoofAsphalt
ConstructionBrick
Water / SewerPublic / Public Sewer
Parking & Outdoor
ParkingThree Car Garage, Attached, Electricityin Garage, Garage Door Opener
Garage3 spaces
Lot10,018 sqft
Location & Tax
Neighborhood48045
Annual tax$11,657
Parcel171222331012
Bathrooms & Fees
Full baths3
Features & details
10 categories of property features
Interior Features
Interior
Jetted Tub
Programmable Thermostat
Appliances
Disposal
Dryer
Energy Star Qualified Dishwasher
Free Standing Refrigerator
Humidifier
Microwave
Other
Wine Cooler
Heating
Forced Air
Natural Gas
Cooling
Ceiling Fans
Central Air
Exterior Features
Exterior
Balcony
Parking
Three Car Garage
Attached
Electricityin Garage
Garage Door Opener
Construction
Brick
Patio & Porch
Patio
Security
Carbon Monoxide Detectors
Smoke Detectors
Pool Features
None
Listing insights
Market data and value estimates
StatusSold
Days on market690
Est. value$899,800
Est. rent$5,493/mo
Tax rate1.32%
Price/sqft$162
On marketJun 9, 2023
PostedSep 24, 2024
Last sold$775,000
MLS updatedAug 4, 2025
Tour days6
Views7
How are the schools in Harrison Township?
3 schools rated nearby
Location
Harrison Township, MI, 48045
Price history
26 events
DateEventPrice$/sqftSource
May 16, 2024Sold$775,000$162Realcomp II
Apr 18, 2024Pending Sale$849,999$177Realcomp II
Apr 16, 2024Listing Removed——Realcomp II
Mar 12, 2024Price Change$849,999$177Realcomp II
Mar 1, 2024Listed For Sale$874,999$183Realcomp II
Feb 15, 2024Listing Removed——Realcomp II
Feb 11, 2024Listed For Sale$874,999$183Realcomp II
Jan 16, 2024Listing Removed——Realcomp II
Oct 29, 2023Price Change$899,999$188Realcomp II
Sep 7, 2023Listed For Sale$950,000$198Realcomp II
Jul 11, 2023Listing Removed——Realcomp II
Jun 13, 2023Listed For Sale$950,000$198Realcomp II
Aug 8, 2012Sold$650,000$136MiRealSource
May 11, 2012Price Change$668,900$140AMERISELL REALTY LLC
Nov 24, 2011Price Change$674,999$141AMERISELL REALTY LLC
Sep 25, 2011Price Change$687,900$144AMERISELL REALTY LLC
Aug 31, 2011Price Change$695,900$145AMERISELL REALTY LLC
Jul 15, 2011Listed For Sale$699,000$146AMERISELL REALTY LLC
Jun 3, 2011Listing Removed$755,000$158BELINE OBEID REALTY
Apr 23, 2011Price Change$755,000$158BELINE OBEID REALTY
Feb 16, 2011Listed For Sale$787,000$164BELINE OBEID REALTY
Dec 12, 2010Listing Removed$797,000$166RE/MAX Suburban, Inc
Nov 29, 2010Listed For Sale$797,000$166RE/MAX Suburban, Inc
Oct 22, 2010Listing Removed$838,000$175RE/MAX Suburban, Inc
Sep 11, 2010Price Change$838,000$175RE/MAX Suburban, Inc
Jul 17, 2010Listed For Sale$849,000$177RE/MAX Suburban, Inc
Sold$775,000
May 16, 2024•$162/sqft•Realcomp II
Pending Sale$849,999
Apr 18, 2024•$177/sqft•Realcomp II
Listing Removed—
Apr 16, 2024•Realcomp II
Price Change$849,999
Mar 12, 2024•$177/sqft•Realcomp II
Listed For Sale$874,999
Mar 1, 2024•$183/sqft•Realcomp II
Listing Removed—
Feb 15, 2024•Realcomp II
Listed For Sale$874,999
Feb 11, 2024•$183/sqft•Realcomp II
Listing Removed—
Jan 16, 2024•Realcomp II
Price Change$899,999
Oct 29, 2023•$188/sqft•Realcomp II
Listed For Sale$950,000
Sep 7, 2023•$198/sqft•Realcomp II
Listing Removed—
Jul 11, 2023•Realcomp II
Listed For Sale$950,000
Jun 13, 2023•$198/sqft•Realcomp II
Sold$650,000
Aug 8, 2012•$136/sqft•MiRealSource
Price Change$668,900
May 11, 2012•$140/sqft•AMERISELL REALTY LLC
Price Change$674,999
Nov 24, 2011•$141/sqft•AMERISELL REALTY LLC
Price Change$687,900
Sep 25, 2011•$144/sqft•AMERISELL REALTY LLC
Price Change$695,900
Aug 31, 2011•$145/sqft•AMERISELL REALTY LLC
Listed For Sale$699,000
Jul 15, 2011•$146/sqft•AMERISELL REALTY LLC
Listing Removed$755,000
Jun 3, 2011•$158/sqft•BELINE OBEID REALTY
Price Change$755,000
Apr 23, 2011•$158/sqft•BELINE OBEID REALTY
Listed For Sale$787,000
Feb 16, 2011•$164/sqft•BELINE OBEID REALTY
Listing Removed$797,000
Dec 12, 2010•$166/sqft•RE/MAX Suburban, Inc
Listed For Sale$797,000
Nov 29, 2010•$166/sqft•RE/MAX Suburban, Inc
Listing Removed$838,000
Oct 22, 2010•$175/sqft•RE/MAX Suburban, Inc
Price Change$838,000
Sep 11, 2010•$175/sqft•RE/MAX Suburban, Inc
Listed For Sale$849,000
Jul 17, 2010•$177/sqft•RE/MAX Suburban, Inc
Tax history
19 years of records
YearTax paidAssessed value
Apr 7, 2025$12,885$406,000
Apr 7, 2024$12,269$550,600
Apr 7, 2023$11,657$512,800
Apr 7, 2022$11,202$470,800
Apr 7, 2021—$463,400
Apr 7, 2020—$435,800
Apr 7, 2019—$414,800
Apr 7, 2018$10,121$364,100
Apr 7, 2017—$357,910
Apr 7, 2016—$357,910
Apr 7, 2015—$326,870
Apr 7, 2012$8,992$295,830
Apr 7, 2010—$312,280
Apr 7, 2009—$289,380
Apr 7, 2008—$332,050
Apr 7, 2007$9,128$334,460
Apr 7, 2006—$292,290
Apr 7, 2004$5,486$289,460
Apr 7, 2003$8,224$292,020
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