NOT LISTED FOR SALE

Estimated Value: $921,000 - $986,000

4 Beds
3.5 Baths
4,697 Sq Ft
$204/Sq Ft Est. Value

Sale Details

Date Sold: November 17, 2025

Last sale price $949,900 $202 Per Sq Ft

Est. 1% increase in value since last sale

Current estimated payment $5,857 / mo

104 Days on Market

Highlights

  • 60 Feet of Waterfront
  • Forced Air Heating and Cooling System
  • Central Vacuum
  • Spa
  • Garage
  • Wood Siding

About This Home

As of November 2025

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.

Last Agent to Sell the Property

Steven Edward

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

@properties Christie's Int'l RE Grosse Pointe

Last Buyer's Agent

Bradford Lack

License #6501313289

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 2006

Lot Details

  • 10,890 Sq Ft Lot
  • Lot Dimensions are 46x237x60
  • 60 Feet of Waterfront
  • Home fronts a canal

Parking

  • Garage

Home Design

  • Brick Exterior Construction
  • Poured Concrete
  • Wood Siding

Interior Spaces

  • Central Vacuum
  • Basement

Bedrooms and Bathrooms

  • 4 Bedrooms

Pool

  • Spa

Utilities

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

Listing and Financial Details

  • Assessor Parcel Number 1220454005

Community Details

Overview

  • 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.25 Acres

Parking

4

Listing Details

  • Property Type: Residential
  • Year Built: 2006
  • State Equalized Value: 390500.00
  • Entry Location: GroundLevel
  • Property Sub Type: SingleFamilyResidence
  • LotSizeAcres: 0.25
  • Water Body Name: Lake Saint Clair
  • Co List Office Mls Id: 432217
  • Above Grade Finished Sq Ft: 3968.00
  • Living Area: 4697.00
  • ClassName: Residential
  • ThirdPartyApprovalRequiredYN: No
  • Special Features: None

Interior Features

  • Interior Amenities: CentralVacuum
  • Fireplace: No
  • Basement: Yes
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bedrooms: 4
  • Below Grade Sq Ft: 729.00

Exterior Features

  • Waterfront: Yes
  • Foundation Details: Basement, Poured
  • Construction Materials: Brick, WoodSiding
  • Exterior Features: SpaHottub
  • Road Frontage Type: Paved
  • Water Frontage Feet: 60.00
  • Disclosures: TaxesHomesteadExempt
  • Home Warranty: No

Garage/Parking

  • Garage: Yes

Utilities

  • Cooling: CentralAir
  • Heating: ForcedAir, NaturalGas
  • Sewer: PublicSewer
  • Water Source: Public

Schools

  • Junior High Dist: LanseCreuse

Lot Info

  • Lot Dimensions: 46X237x60
  • Parcel Number: 1220454005
  • Land Lease Expiration Date: 2025-12-31

Tax Info

  • Tax Amount Summer: 5200.00
  • Tax Amount Winter: 2800.00
  • Tax Annual Amount: 8000.00

Multi Family

  • Waterfront Features: AllSportsLake, CanalFront, DirectWaterFrontage
  • Above Grade Finished Area Units: SquareFeet

Ownership History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 3, 2025
Closed on
Nov 17, 2025
Sold by
Bought by
Seller's Agent
Steven Edward
@properties Christie's Int'l RE Grosse Pointe
Buyer's Agent
Bradford Lack
List Price
$949,900
Sold Price
$949,900
Views
546
Current Estimated Value
$958,068

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$8,168
Avg. Annual Appreciation
1.29%
Original Mortgage
$500,000
Interest Rate
0.0627%
Mortgage Type
New Conventional

Purchase Details

Closed on
Mar 17, 2019
Sold by
Bought by

Purchase Details

Closed on
Jan 1, 2015
Sold by
Bought by

Purchase Details

Closed on
Jul 15, 2005
Sold by
Bought by

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$60,000
Interest Rate
0.0589%
Mortgage Type
Credit Line Revolving
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Buyer Sale Price Title Company
$949,900 Ata National Title
-- None Available
$116 --
$115,000 None Available
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Borrower Loan Amount
Open $500,000
Closed $500,000
Previous Owner $390,000
Previous Owner $125,000
Previous Owner $355,835
Previous Owner $42,300
Previous Owner $399,000
Previous Owner $386,000
Previous Owner $112,000
Previous Owner $60,000
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft
11/17/2025 11/17/25 Sold $949,900 0.0% $202 / Sq Ft
11/16/2025 11/16/25 Pending -- -- --
10/18/2025 10/18/25 For Sale $949,900 0.0% $202 / Sq Ft
09/27/2025 09/27/25 Pending -- -- --
09/12/2025 09/12/25 Price Changed $949,900 -5.0% $202 / Sq Ft
08/04/2025 08/04/25 For Sale $999,950 -- $213 / Sq Ft
Source: Realcomp

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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
2026 $7,644 $551,600 $0 $0
2025 $5,203 $428,400 $0 $0
2024 $51 $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

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Realcomp

MLS Number: 20251023515

Realcomp

APN: 17-12-20-454-005

Your Personal Tour Guide

Ask me questions while you tour the home.