Skip main navigation
Off market
  • $1,282,700

    37600 Lakeshore Dr, Harrison Township, MI 48045

    3beds
    5,477sqft
    Single Family Residence
    Built in 1994
    -- sqft lot
    $1,282,700 Zestimate®
    $234/sqft
    $4,449 Estimated rent

    Home value

    $1,282,700

    $1.19M - $1.40M

    $4,449/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $4,449/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $4,449/mo

    Rent Zestimate®

    Refinance and save

    $8,410/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $8,410/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Lakefront propertyFenced yardTrek deckingStorage roomIncredible bonus roomExpansive patioPrep area

    Exquisite Lakefront Property With Breathtaking Views of Lake St Clair. Located in Boat Town USA Harrison Twp! Summer is Here- Entertain Outdoors on Expansive Patio w/ Fenced Yard for Children & Pet Safety. Trek Decking, Extended Well for Your Larger Boats 40ft, "Golden Hoist"w/ 24,000LB Capacity Lift with Remote Capabilities~Steel Sea Wall,& Davit. Step Into This Impressive Home Offering: Formal Dining Rm,Home Office,Gourmet Kitchen w/ Island, Prep Area, Sub Zero Refrigerator, Built in Oven&Stove Top, DSW, Beverage Cooler&Reverse Osmois Alkaline Water Filtration.Magnificent Waterfront Views From Full Wall Windows In Great Room, Spacious Kitchen,Dining Space & Primary Owner Bedroom Suite!(4) Exterior Balconies!(2) Furnaces (2)Central A/C (2)Laundry Rooms (4) Full Baths! Upper Level Boast Large Bedrooms,2nd Floor Laundry Room w/(2) Dryers &(1) Washer! Incredible Bonus Room With Endless Uses That Can Fit Your Lifestyle.Tucked Away Stairs Leads to Finished Storage Room (13x13).Second Set of Stairs Leads YouTo Other Side of Main Level!Utility Room,Mud Room, Storage Room ~ 3 CarOversized(36x25)Garage! NO HOA~Move in Ready~Occupancy Can Be Sooner~

    This property is off market, which means it's not currently listed for sale or rent on Zillow. This may be different from what's available on other websites or public sources.

    Zillow last checked:

    Listing updated:

    Listed by:

    Palmina Vanderziel 586-945-5570,

    Keller Williams Realty Lakeside

    Bought with:

    John W Lambrecht, 6501375482

    Lambrecht Realty LLC

    Source: MiRealSource,MLS#: 50111803MLS LogoOriginating MLS: MiRealSource

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 3
    • Bathrooms: 4
    • Full bathrooms: 4
    Rooms
    • Room types: Den/Study/Lib, Family Room, Great Room, Recreation Room, Laundry, Master Bedroom, Master Bathroom, Bonus Room, Bathroom, Second Flr Full Bathroom, Dining Room
    Bedroom 1
    • Level: Second
    • Area: 520
    • Dimensions: 26 x 20
    Bedroom 2
    • Level: Second
    • Area: 437
    • Dimensions: 19 x 23
    Bedroom 3
    • Level: Second
    • Area: 221
    • Dimensions: 13 x 17
    Bathroom 1
    • Level: First
    • Area: 88
    • Dimensions: 11 x 8
    Bathroom 2
    • Level: Second
    • Area: 306
    • Dimensions: 18 x 17
    Bathroom 3
    • Level: Second
    • Area: 120
    • Dimensions: 12 x 10
    Bathroom 4
    • Level: Second
    • Area: 45
    • Dimensions: 9 x 5
    Dining room
    • Level: First
    • Area: 238
    • Dimensions: 17 x 14
    Great room
    • Level: First
    • Area: 665
    • Dimensions: 35 x 19
    Kitchen
    • Level: First
    • Area: 352
    • Dimensions: 22 x 16
    Office
    • Level: First
    • Area: 144
    • Dimensions: 12 x 12
    Heating
    • Forced Air, Natural Gas
    Cooling
    • Central Air
    Appliances
    • Included: Bar Fridge, Dishwasher, Dryer, Microwave, Range/Oven, Refrigerator, Washer, Gas Water Heater
    • Laundry: Second Floor Laundry, First Floor Laundry
    Features
    • High Ceilings, Interior Balcony, Walk-In Closet(s), Pantry, Eat-in Kitchen
    • Flooring: Hardwood
    • Windows: Bay Window(s)
    • Basement: Crawl Space
    • Has fireplace: Yes
    • Fireplace features: Gas, Great Room
    Interior area
    • Total structure area: 5,477
    • Total interior livable area: 5,477 sqft
    • Finished area above ground: 5,477
    • Finished area below ground: 0

    Property

    Parking
    • Total spaces: 3
    • Parking features: Attached, Garage Door Opener
    • Attached garage spaces: 3
    Accessibility
    • Accessibility features: Accessible Doors
    Features
    • Levels: Two
    • Stories: 2
    • Patio & porch: Deck, Patio, Porch
    • Exterior features: Balcony, Lawn Sprinkler
    • Has view: Yes
    • View description: Water, Lake
    • Has water view: Yes
    • Water view: Water,Lake
    • Waterfront features: All Sports Lake, Lake Front, Lake/River Access, Seawall, Waterfront
    • Frontage length: 56
    Lot
    • Dimensions: 56 x 201 x 68 x 202
    • Features: Subdivision
    Details
    • Parcel number: 171227204007
    • Zoning description: Residential
    • Special conditions: Private

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Colonial
    • Property subtype: Single Family Residence
    Materials
    • Brick, Wood Siding
    Condition
    • Year built: 1994

    Utilities & green energy

    • Sewer: Public Sanitary
    • Water: Public

    Community & HOA

    Community
    • Subdivision: St Clair Haven
    HOA
    • Has HOA: No
    Location
    • Region: Harrison Township

    Financial & listing details

    • Price per square foot: $234/sqft
    • Tax assessed value: $1,282,600
    • Annual tax amount: $15,544
    • Date on market: 6/10/2023
    • Cumulative days on market: 11 days
    • Listing agreement: Exclusive Right To Sell
    • Listing terms: Cash,Conventional
    • Road surface type: Paved

    Price history

    DateEventPrice
    7/27/2023Sold$1,100,000-8.3%$201/sqft
    Source: MiRealSource #50111803 Report a problem
    6/20/2023Pending sale$1,200,000$219/sqft
    Source: MiRealSource #50111803 Report a problem
    6/12/2023Listed for sale$1,200,000+26.3%$219/sqft
    Source: MiRealSource #50111803 Report a problem
    9/20/2017Sold$950,000-5%$173/sqft
    Source: MiRealSource #31317378 Report a problem
    7/31/2017Pending sale$999,900$183/sqft
    Source: Real Estate One #31317378 Report a problem
    7/12/2017Price change$999,900-9%$183/sqft
    Source: Real Estate One #31317378 Report a problem
    6/9/2017Price change$1,099,000-7.6%$201/sqft
    Source: Realty Executives Midwest #31317378 Report a problem
    4/18/2017Listed for sale$1,190,000+1883.3%$217/sqft
    Source: Realty Executives Midwest #31317378 Report a problem
    7/18/2012Sold$60,000-90.5%$11/sqft
    Source: Public Record Report a problem
    12/18/2008Sold$630,000+24.6%$115/sqft
    Source: Public Record Report a problem
    1/22/2008Sold$505,450$92/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025$21,231 +29.8%$641,300 +4.1%
    2024$16,362 +5.3%$616,100 +7.3%
    2023$15,545 +4.1%$574,100 +8.8%
    2022$14,938 $527,600 +1.6%
    2021-- $519,500 +4.4%
    2020-- $497,800 +6.9%
    2019-- $465,800 +12.6%
    2018$13,497 $413,800 +3.6%
    2017-- $399,570
    2016-- $399,570 +9.4%
    2015-- $365,310 +10.2%
    2012$12,285 $331,390 -20.7%
    2010-- $417,770 +0.6%
    2009-- $415,360 -7.5%
    2008-- $449,000 -10.2%
    2007-- $499,810 +43.2%
    2006-- $348,920 +1.9%
    2004-- $342,260 -0.2%
    2003$9,463 +30.6%$342,980 +24.7%
    2001$7,248 -3%$275,090 -1.6%
    2000$7,471 $279,550
    Find assessor info on the county website

    Neighborhood: 48045

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • District: L'anse Creuse Public Schools

    Source: MiRealSource. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $1,282,700
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $1,282,700