$999,950

Estimated payment $6,105/month

Total Views 7,331
4 Beds
3.5 Baths
3,968 Sq Ft
$252 Price per Sq Ft

Highlights

  • 60 Feet of Waterfront
  • Colonial Architecture
  • No HOA
  • Spa
  • Ground Level Unit
  • Covered Patio or Porch

About This Home

Welcome to 37848 Siesta Drive — A Refined Waterfront Haven on Lake St. Clair
This exceptional canal-front home offers nearly 4,000 sq. ft. of beautifully crafted living space, where timeless design meets modern luxury. Just minutes from the lake, this residence showcases elegant architectural details, gorgeous wainscoting, and rich trim throughout.

Step into a spacious foyer anchored by a dramatic staircase—an architectural centerpiece surrounded by radiant heated wood floors. To the right, a private office offers a quiet retreat for work or study. The home opens to a warm living room with custom built-ins and a formal dining room.

The gourmet kitchen features granite countertops, stainless appliances, and a seamless flow into the main dining area—ideal for entertaining. A built-in granite desk area connects the kitchen to the attached 4-car garage, where a custom locker area keeps things organized.

Off the living area, a cozy four-season room provides year-round comfort with serene views of the landscaped backyard and canal. Step onto the covered rear porch—perfect for grilling—then follow the paver path to the hot tub, firepit lounge, and garden retreat. Boaters will love the 30’ boat hoist and jet ski lift with fast access to open water.

Upstairs, you’ll find four spacious bedrooms, a stunning wood-paneled coved ceiling, an expansive bonus room with skylights, and a built-in dual workstation. The semi-finished basement features a second office, a fitness area, and a huge custom walk-in closet for storing all your outdoor adventure gear. The oversized 4 car garage features heated floors with a drain & includes a workbench and built-in urinal—an ideal hobbyist’s haven.

From its gorgeous finishes and functional layout to its resort-style outdoor living and premier canal location, this home is an extraordinary opportunity to embrace the Lake St. Clair lifestyle in total comfort and style.

Listing Agent

Steven Edward

@properties Christie's Int'l RE Grosse Pointe License #6501360542 Listed on: 08/04/2025

@properties Christie's Int'l RE Grosse Pointe

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 2006

Lot Details

  • 0.25 Acre Lot
  • Lot Dimensions are 46x237x60
  • 60 Feet of Waterfront
  • Home fronts a canal

Home Design

  • Colonial Architecture
  • Brick Exterior Construction
  • Poured Concrete

Interior Spaces

  • 3,968 Sq Ft Home
  • 2-Story Property
  • Central Vacuum
  • Partially Finished Basement

Bedrooms and Bathrooms

  • 4 Bedrooms

Parking

  • 4 Car Attached Garage
  • Heated Garage
  • Front Facing Garage
  • Garage Door Opener
  • Driveway

Outdoor Features

  • Spa
  • Covered Patio or Porch

Location

  • Ground Level Unit

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas

Listing and Financial Details

  • Assessor Parcel Number 1220454005

Community Details

Overview

  • No Home Owners Association
  • Siesta Park Sub Subdivision

Recreation

  • Water Sports

Home Details

Home Type

Single Family

Est. Annual Taxes

$8,000

Year Built

Built in 2006

Lot Details

0

Listing Details

  • Property Type: Residential
  • Architecture Style: Colonial
  • Architecture Level: 2 Story
  • Year Built: 2006
  • State Equalized Value: 390500.0000
  • Entry Location: Ground Level
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2

Interior Features

  • Interior Amenities: Central Vacuum
  • Room Count: 14
  • Total Bedrooms: 4
  • Total Bathrooms: 3.10
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Basement: Yes
  • Basement Type: Partially Finished
  • Sq Ft Combined: 4697
  • Sq Ft Lower Floor: 729
  • Total Sq Ft: 3968
  • Sq Ft Total Bsmt: 1648

Exterior Features

  • Waterfront Name: Lake Saint Clair
  • Waterfront: Yes
  • Foundation Details: Basement
  • Construction Materials: Brick, Wood
  • Exterior Features: Spa/Hot-tub
  • Foundation Materials: Poured
  • Frontage Feet: 46
  • Porch Type: Porch - Covered, Porch, Covered
  • Road Frontage Type: Paved
  • Water Frontage Feet: 60.00
  • Waterfront Description: Canal Front, Direct Water Frontage

Garage/Parking

  • Garage Size: 4 Car
  • Garage Features: Door Opener, Heated, Attached, Driveway, Garage Faces Front
  • Garage: Yes

Utilities

  • Heating Fuel: Natural Gas
  • Cooling: Central Air
  • Heating: Forced Air
  • Sewer: Sewer (Sewer-Sanitary)
  • Water Source: Public (Municipal)

Condo/Co-op/Association

  • Association Fee: No

Schools

  • School District: Lanse Creuse

Lot Info

  • Homestead: Yes
  • Lot Size Area: 0.25
  • Lot Dimensions: 46X237x60
  • Parcel Number: 1220454005

Tax Info

  • Tax Amount Summer: 5200.0000
  • Tax Amount Winter: 2800.0000
  • Total Tax: 8000.0000
  • Taxable Value: 215663.0000

Multi Family

  • Waterfront Features: All Sports Lake, DIRFRT

MLS Schools

  • School District: Lanse Creuse

Map

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
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

Source: Public Records

Average Home Value in this Area





Source: Public Records

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 $7,432 $428,400 $0 $0
2024 $5,059 $390,500 $0 $0
2023 $4,798 $349,100 $0 $0
2022 $6,723 $341,500 $0 $0
2021 $6,461 $326,600 $0 $0
2020 $4,404 $320,900 $0 $0
2019 $5,961 $333,400 $0 $0
2018 $5,675 $282,600 $0 $0
2017 $5,593 $287,690 $41,750 $245,940
2016 $5,574 $287,690 $0 $0
2015 -- $223,660 $0 $0
2012 $5,741 $169,020 $0 $0
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/04/2025 08/04/25 For Sale $999,950 -- $252 / Sq Ft
Source: Realcomp

Purchase History

Date Type Sale Price Title Company
Interfamily Deed Transfer -- None Available
Quit Claim Deed $116 --
Warranty Deed $115,000 None Available
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $390,000 Unknown
Closed $125,000 Future Advance Clause Open End Mortgage
Previous Owner $355,835 New Conventional
Previous Owner $42,300 Credit Line Revolving
Previous Owner $399,000 Unknown
Previous Owner $386,000 Construction
Previous Owner $112,000 Credit Line Revolving
Previous Owner $60,000 Credit Line Revolving
Source: Public Records

Similar Homes in the area

  • 32560 N River Rd, Harrison Township, MI 48045

    $924,900

    • 3 Beds
    • 4 Baths
    • 2,976 Sq Ft
    • 32560 N River Rd
    • Harrison Township, MI

    Waterfront retreat in Sunny Point Shores, Harrison Township—this stunning three-bedroom, four-bath ranch offers sweeping water views and direct access to Lake St. Clair. Thoughtfully designed with vaulted ceilings and an open layout that captures picturesque water views from multiple rooms, flooding natural light. Rich engineered handscraped hickory hardwood floors throughout the main living

    Jeff Meldrum @properties Christie's Int'l RE Grosse Pointe

    Section Image
  • 38008 Seaway Ct, Harrison Township, MI 48045

    $849,900

    • 3 Beds
    • 3.5 Baths
    • 3,466 Sq Ft
    • 38008 Seaway Ct
    • Harrison Township, MI

    Exquisite waterfront estate, perfectly positioned with over 120 feet of sought after canal frontage with quick, direct access to Lake St. Clair. This beautiful custom built home has 3,466 sq. ft. of luxurious above ground living space. Large first floor primary suite, euro-style kitchen flows into the family room with one of three fireplaces and a large Florida room overlooking the water. Formal

    Brandon Curry Signature Sotheby's International Realty Bham

    Section Image
  • 38573 Primrose Ln, Harrison Township, MI 48045

    $779,900

    • 4 Beds
    • 3.5 Baths
    • 3,423 Sq Ft
    • 38573 Primrose Ln
    • Harrison Township, MI

    This Harrison Township home features 4 beds, 3.5 baths, and 3,400 sq. feet! Pulling up, you’ll notice the gorgeous brick exterior and a huge attached garage. Inside, you’re greeted by a spacious living room with plenty of natural lighting, beautiful wood floors, and a cozy fireplace. Around the corner, the large, eat-in kitchen offers an abundance of space for storing and preparing your favorite

    Joanna Accetta Leone Realty Inc

    Section Image
  • 28800 Old North River Rd, Harrison Township, MI 48045

    $759,308

    • 4 Beds
    • 3 Baths
    • 2,820 Sq Ft
    • 28800 Old North River Rd
    • Harrison Township, MI

    Just in time for boating season! Located on a prime canal in Boat Town U.S.A., just minutes from the lake, this stately TURNKEY canalfront colonial is an absolute showstopper. The seller has spared no expense with thoughtful upgrades throughout this impressive 4-bedroom, 3-full-bath home, set on a spacious over half-acre lot. Step into the gourmet chef’s kitchen, perfect for entertaining,

    Hank Mendez Real Estate One Inc-Shelby

    Section Image
  • 38340 Lakeshore Dr, Harrison Township, MI 48045

    $799,000

    • 4 Beds
    • 2.5 Baths
    • 3,056 Sq Ft
    • 38340 Lakeshore Dr
    • Harrison Township, MI

    Here is your chance to be Lakefront on this exceptional 3,056-square-foot lakefront residence, showcasing a million-dollar view along the highly sought-after Lakeshore Drive. All at an amazing Price! This beautifully updated home offers 64 feet of frontage on Lake St. Clair, providing breathtaking panoramic views and ample space for the entire family. The expansive open floor plan is ideal for

    Keith Reaume Epique Inc.

    Section Image
  • 37337 Lakeshore Dr, Harrison Township, MI 48045

    $1,249,900

    • 3 Beds
    • 2 Baths
    • 1,854 Sq Ft
    • 37337 Lakeshore Dr
    • Harrison Township, MI

    Unmatched Waterfront Opportunity in Huron Pointe!Welcome to a truly rare offering — a massive premium lot measuring approximately 180 feet wide by 150 feet deep, with two full sides of waterfront in the highly sought-after Huron Pointe community! Perfectly positioned at the end of a quiet cul-de-sac, this oversized property boasts nearly 140 feet of deep, wide canal frontage and spectacular,

    Steven Edward @properties Christie's Int'l RE Grosse Pointe

    Section Image
  • 39196 Lakeshore Dr, Harrison Township, MI 48045

    $1,227,729

    • 4 Beds
    • 3.5 Baths
    • 2,793 Sq Ft
    • 39196 Lakeshore Dr
    • Harrison Township, MI

    To Be Built: Beautiful Sienna Colonial by Vitale Real Estate & New Homes! Don’t miss this rare opportunity to own 60 feet of direct lake frontage on Lake St. Clair in Harrison Township. This vacant lot includes a steel seawall, city water and sewer at the street, and endless potential for your dream lakefront home.The proposed Sienna Colonial features 4 bedrooms, 3.1 bathrooms, a 3-car

    Leah Lupo Kaiser Realty Group LLC

    Section Image
  • 31860 N River Rd, Harrison Township, MI 48045

    $859,000

    • 4 Beds
    • 2 Baths
    • 2,402 Sq Ft
    • 31860 N River Rd
    • Harrison Township, MI

    Enjoy exquisite waterfront living where sophistication meets serenity! Immerse yourself in elevated waterfront living with this impeccably appointed residence, designed to capture breathtaking views and offer an unrivaled lifestyle of comfort and sophistication. Every detail has been thoughtfully curated—from rich custom millwork and high-end finishes to designer lighting and smart home

    Christine Lynn The Agency Hall & Hunter

    Section Image
  • 41245 Belvidere St, Harrison Charter Township, MI 48045

    $999,950

    • 3 Beds
    • 6 Baths
    • 3,750 Sq Ft
    • 41245 Belvidere St
    • Harrison Charter Township, MI

    Find yourself in the epitome of luxury waterfront living! This stunning 3 bedroom custom-built home is situated on one of the best canals on Lake St. Clair - highly sought-after Belvidere Sub. With over 3700 plus square feet of exquisitely finished living space, this 2018 masterpiece build blends elegance, amenities, comfort, and thoughtful design throughout the entire space.Everything inside

    Vince Cipriano Brookstone, Realtors LLC

    Section Image

Source: Realcomp

MLS Number: 20251023515

Realcomp

APN: 17-12-20-454-005