Seller's Agent in 2024
Jozsef Trattner
Real Estate One
(734) 330-8870
2 in this area
81 Total Sales
37841 Lakeshore Dr Harrison Township, MI 48045
Eastern Harrison NeighborhoodEstimated Value: $663,000 - $859,000
4
Beds
2
Baths
3,809
Sq Ft
$206/Sq Ft
Est. Value
Highlights
- 55 Feet of Waterfront
- Colonial Architecture
- Jetted Tub in Primary Bathroom
- Spa
- Deck
- No HOA
About This Home
As of May 2024Indulge 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
Last Agent to Sell the Property
Real Estate One-Northville License #6501345676 Listed on: 02/29/2024
Home Details
Home Type
- Single Family
Est. Annual Taxes
Year Built
- Built in 2017
Lot Details
- 7,841 Sq Ft Lot
- Lot Dimensions are 55.00 x 150.00
- 55 Feet of Waterfront
- Home fronts a canal
- Back Yard Fenced
Home Design
- Colonial Architecture
- Contemporary Architecture
- Traditional Architecture
- Brick Exterior Construction
- Block Foundation
- Asphalt Roof
Interior Spaces
- 3,809 Sq Ft Home
- 3-Story Property
- Sound System
- Ceiling Fan
- ENERGY STAR Qualified Windows
- Crawl Space
Kitchen
- Double Oven
- Free-Standing Gas Range
- Microwave
- Dishwasher
- Disposal
Bedrooms and Bathrooms
- 4 Bedrooms
- 2 Full Bathrooms
- Jetted Tub in Primary Bathroom
Laundry
- Dryer
- Washer
Home Security
- Security System Owned
- Carbon Monoxide Detectors
Parking
- 3 Car Attached Garage
- Garage Door Opener
Outdoor Features
- Spa
- Deck
- Exterior Lighting
- Gazebo
- Porch
Location
- Ground Level
Utilities
- ENERGY STAR Qualified Air Conditioning
- Humidifier
- Zoned Heating
- Heating system powered by renewable energy
- Heating System Uses Natural Gas
- Programmable Thermostat
- Natural Gas Water Heater
- High Speed Internet
- Cable TV Available
Listing and Financial Details
- Assessor Parcel Number 1222381021
Community Details
Overview
- No Home Owners Association
- St Clair Haven Subdivision
Amenities
- Laundry Facilities
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Feb 29, 2024
Closed on
May 1, 2024
Sold by
Prister Robert Jay
Bought by
Geier Christopher A and Geier Sarissa
Seller's Agent
Jozsef Trattner
Real Estate One-Northville
Buyer's Agent
Mary Beth Karash
Kaiser Realty Group LLC
List Price
$799,000
Sold Price
$754,000
Premium/Discount to List
-$45,000
-5.63%
Views
162
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$52,213
Avg. Annual Appreciation
4.44%
Original Mortgage
$640,900
Interest Rate
6.82%
Mortgage Type
New Conventional
Purchase Details
Listed on
Jul 17, 2021
Closed on
Oct 8, 2021
Sold by
Duncan Peter G
Bought by
Prister Robert Jay
Seller's Agent
Linda Hliebay
Lee Realty Inc.
Buyer's Agent
Jozsef Trattner
Real Estate One-Novi
List Price
$899,000
Sold Price
$500,000
Premium/Discount to List
-$399,000
-44.38%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
17.41%
Purchase Details
Closed on
Jun 17, 2013
Sold by
Culverhouse Michael L and Culverhouse Brenda
Bought by
Duncan Peter G
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Values in the Area
Average Home Value in this Area
Purchase History
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Geier Christopher A | $754,000 | Capital Title | |
| Prister Robert Jay | $500,000 | Colonial Title Company | |
| Duncan Peter G | $80,000 | Title Source Inc |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Geier Christopher A | $720,800 | |
| Closed | Geier Christopher A | $95,950 | |
| Closed | Geier Christopher | $640,900 | |
| Previous Owner | Prister Robert | $180,000 | |
| Previous Owner | Duncan Peter G | $332,900 | |
| Previous Owner | Duncan Peter G | $340,000 |
Source: Public Records
Property History
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 05/01/2024 05/01/24 | Sold | $754,000 | -1.4% | $198 / Sq Ft |
| 04/22/2024 04/22/24 | Pending | -- | -- | -- |
| 03/23/2024 03/23/24 | Price Changed | $765,000 | -4.3% | $201 / Sq Ft |
| 02/29/2024 02/29/24 | For Sale | $799,000 | +59.8% | $210 / Sq Ft |
| 10/11/2021 10/11/21 | Sold | $500,000 | -18.7% | $77 / Sq Ft |
| 09/17/2021 09/17/21 | Pending | -- | -- | -- |
| 09/07/2021 09/07/21 | Price Changed | $615,000 | -1.6% | $95 / Sq Ft |
| 07/24/2021 07/24/21 | Price Changed | $625,000 | -30.5% | $97 / Sq Ft |
| 07/17/2021 07/17/21 | For Sale | $899,000 | -- | $139 / Sq Ft |
Source: Realcomp
Tax History Compared to Growth
Tax History
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2025 | $11,555 | $382,500 | $0 | $0 |
| 2024 | $7,821 | $381,000 | $0 | $0 |
| 2023 | $6,482 | $277,500 | $0 | $0 |
| 2022 | $9,207 | $266,400 | $0 | $0 |
| 2021 | $8,527 | $283,000 | $0 | $0 |
| 2020 | $5,779 | $270,200 | $0 | $0 |
| 2019 | $8,954 | $259,000 | $0 | $0 |
| 2018 | $8,954 | $270,200 | $0 | $0 |
| 2017 | $13,557 | $89,020 | $60,420 | $28,600 |
| 2016 | $4,458 | $89,020 | $0 | $0 |
| 2015 | -- | $61,880 | $0 | $0 |
| 2012 | $1,703 | $61,880 | $0 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
-
Buyer's Agent in 2024
Mary Beth Karash
Kaiser Realty Group LLC
(586) 709-6809
1 in this area
34 Total Sales
-
L
Seller's Agent in 2021
Linda Hliebay
Lee Realty Inc.
Map
Source: Realcomp
MLS Number: 20240010358
APN: 17-12-22-381-021
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
IDX provided courtesy of Realcomp II Ltd. via Ten-X and MLS
Copyright 2025 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.
Listing Information presented by local MLS brokerage: Ten-X, local REALTOR®- Arlene Richardson - (888)-952-6393
Nearby Homes
- 37793 Circle Dr
- 37701 Huron Pointe Dr
- 37540 Lakeshore Dr
- 38340 Lakeshore Dr
- 38371 Huron Pointe Dr
- 38156 Huron Pointe Dr
- 38114 Huron Pointe Dr
- 38187 Huron Pointe Dr
- 37337 Lakeshore Dr
- 37384 Lakeshore Dr
- 37330 Lakeshore Dr
- 39196 Lakeshore Dr
- 0 W Archer Dr
- 39470 Lakeshore Dr
- 38251 Cherry Ln
- 38014 Mallast St
- 37910 Mallast St
- 38336 Mallast St
- 38146 Mast St
- 38575 Mallast St
- 37833 Lakeshore Dr
- 37849 Lakeshore Dr
- 37825 Lakeshore Dr
- 37857 Lakeshore Dr
- 37821 Lakeshore Dr
- 37865 Lakeshore Dr
- 37875 Lakeshore Dr
- 37807 Lakeshore Dr
- 37790 Lakeville St
- 37842 Lakeshore Dr
- 37828 Lakeshore Dr
- 37780 Lakeville St
- 37810 Lakeville St
- 37854 Lakeshore Dr
- 37814 Lakeshore Dr
- 37885 Lakeshore Dr
- 37750 Lakeville St
- 37795 Lakeshore Dr
- 37864 Lakeshore Dr
- 37874 Lakeshore Dr