NOT LISTED FOR SALE

Estimated Value: $3,365,277 - $4,200,000

5 Beds
7 Baths
5,203 Sq Ft
$727/Sq Ft Est. Value

Last Sold November 30, 2023

Last sale price $4,350,000 $836 Per Sq Ft

Est. 13% decrease in value since last sale

Current estimated payment $27,079/month

14 Days on Market

Highlights

  • 228 Feet of Waterfront
  • Built-In Refrigerator
  • Ranch Style House
  • Roosevelt Elementary School Rated A-
  • 2.12 Acre Lot
  • Jetted Tub in Primary Bathroom

About This Home

As of November 2023

This Orchard Lake, Michigan, residence is a rare gem, offering an unparalleled combination of luxury, privacy, and stunning lakefront living. Situated on a sprawling 2.08-acre lot with 217 feet of lakefront, this 9,000+ square foot home is a masterpiece of design and craftsmanship. You'll immediately notice the grandeur and exclusivity of this estate. Offering a sense of seclusion and tranquility. The expansive 90-foot deck that stretches across the front of the home provides panoramic views of Orchard Lake and Apple Island, creating an impressive backdrop for outdoor enjoyment. Upon entering the home, you'll be greeted by the dramatic living room with a soaring ceiling and a two-story fireplace. The living room serves as a focal point and seamlessly connects to the outdoor deck, allowing for a seamless indoor-outdoor lifestyle.
The kitchen is a chef's dream, featuring a spacious layout, a seated island, and premium appliances. It's designed for both functionality and aesthetics, making it a central hub for culinary creations and gatherings. The master suite is a luxurious retreat in its own right. It boasts a fireplace, a cozy sitting area, two vanities, two walk-in closets, and even a dedicated laundry area. This space provides the utmost in comfort and convenience. The home offers a variety of living areas, including a generously sized dining room, an office, and a den. Additionally, there is a separate but easily accessible apartment and an executive office, both with garden and lake views.
The walkout lower level is an entertainer's paradise, featuring a family room, a second kitchen, a media room, an exercise room with a sauna, and three ensuite bedrooms. This level offers ample space for recreation and relaxation while enjoying stunning lake views.
In addition to the main garage, the property includes a new oversized second garage with heated floors.This garage can accommodate five or more cars, is car lift capable, and provides extra depth for boat storage, catering to car enthusiasts and watercraft owner

Last Listed By

Lindsey Broadwell

Real Broker LLC Clarkston License #6501393074 Listed on: 10/27/2023

Real Broker LLC Clarkston

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 1970 | Remodeled in 1999

Lot Details

  • 2.12 Acre Lot
  • Lot Dimensions are 154x524x217x458
  • 228 Feet of Waterfront
  • Lake Front

Parking

  • 3 Car Attached Garage

Home Design

  • Ranch Style House
  • Brick Exterior Construction
  • Poured Concrete
  • Asphalt Roof

Interior Spaces

  • 5,203 Sq Ft Home
  • Wet Bar
  • Furnished or left unfurnished upon request
  • Bar Fridge
  • Gas Fireplace

Kitchen

  • Double Oven
  • Built-In Gas Range
  • Range Hood
  • Warming Drawer
  • Microwave
  • Built-In Refrigerator
  • Dishwasher
  • Wine Refrigerator
  • Trash Compactor
  • Disposal

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Jetted Tub in Primary Bathroom

Laundry

  • Dryer
  • Washer

Finished Basement

  • Walk-Out Basement
  • Natural lighting in basement

Utilities

  • Forced Air Heating and Cooling System
  • Humidifier
  • Heating System Uses Natural Gas
  • Programmable Thermostat
  • High Speed Internet

Additional Features

  • Accessible Elevator Installed
  • Ground Level Unit

Listing and Financial Details

  • Assessor Parcel Number 1809426019

Community Details

Overview

  • No Home Owners Association
  • Assr's Plat Of West Shores Subdivision

Amenities

  • Laundry Facilities

Recreation

  • Water Sports

Home Details

Home Type

Single Family

Est. Annual Taxes

$74,204

Year Built

Built in 1970 | Remodeled in 1999

Lot Details

0

Listing Details

  • Property Type: Residential
  • Architecture Style: Ranch
  • Architecture Level: 1 Story
  • Assessment: 426.00
  • Year Built: 1970
  • State Equalized Value: 1462710.0000
  • Year Renovated: 1999
  • Accessibility Features: Accessible Elevator Installed
  • Entry Location: Ground Level
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 1

Interior Features

  • Interior Amenities: Elevator/Lift, High Spd Internet Avail, Humidifier, Jetted Tub, Furnished - Negotiable, Programmable Thermostat, Wet Bar
  • Fireplace: Yes
  • Fireplace Fuel: Gas
  • Room Count: 25
  • Total Bedrooms: 5
  • Total Bathrooms: 5.20
  • Full Bathrooms: 5
  • Half Bathrooms: 2
  • Basement: Yes
  • Basement Type: Daylight, Finished, Walkout Access
  • Kitchen Appliances: Built-In Electric Range, Built-In Gas Range, Built-In Refrigerator, Dishwasher, Disposal, Double Oven, Dryer, Free-Standing Refrigerator, Gas Cooktop, Microwave, Range Hood, Trash Compactor, Warming Drawer, Washer, Wine Refrigerator, Bar Fridge
  • Sq Ft Combined: 9203
  • Sq Ft Lower Floor: 4000
  • Total Sq Ft: 5203
  • Sq Ft Total Bsmt: 4324

Exterior Features

  • Roof Material: Asphalt
  • Waterfront Name: Orchard Lake
  • Waterfront: Yes
  • Foundation Details: Basement
  • Construction Materials: Brick
  • Foundation Materials: Poured
  • Frontage Feet: 154
  • Road Frontage Type: Paved
  • Water Frontage Feet: 228.00
  • Waterfront Description: Lake Front

Garage/Parking

  • Garage Size: 3 Car
  • Garage Features: Attached
  • Garage: Yes

Utilities

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

Condo/Co-op/Association

  • Association Fee: No

Schools

  • School District: West Bloomfield

Lot Info

  • Homestead: Yes
  • Lot Size Area: 2.12
  • Lot Dimensions: 154x524x217x458
  • Parcel Number: 1809426019

Tax Info

  • Tax Amount Summer: 71036.0000
  • Tax Amount Winter: 3168.0000
  • Total Tax: 74204.0000
  • Taxable Value: 1462710.0000

Multi Family

  • Waterfront Features: All Sports Lake

MLS Schools

  • School District: West Bloomfield

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Oct 27, 2023
Closed on
Nov 30, 2023
Sold by
Hall David J and Hall Andrea
Bought by
3333 West Shore Llc
Seller's Agent
Lindsey Broadwell
Real Broker LLC Clarkston
Buyer's Agent
Jeffrey Kucemba
New Michigan Realty
List Price
$3,900,000
Sold Price
$4,350,000
Premium/Discount to List
$450,000
11.54%
Total Days on Market
14
Views
155
Current Estimated Value
$3,780,569

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$569,431
Avg. Annual Appreciation
-9.54%

Purchase Details

Listed on
Oct 27, 2023
Closed on
Nov 29, 2023
Sold by
David J Hall Revocable Trust
Bought by
Hall David J and Hall Andrea
Seller's Agent
Lindsey Broadwell
Real Broker LLC Clarkston
Buyer's Agent
Jeffrey Kucemba
New Michigan Realty
List Price
$3,900,000
Sold Price
$4,350,000
Premium/Discount to List
$450,000
11.54%
Views
155

Purchase Details

Closed on
Sep 19, 2023
Sold by
Hall Andrea
Bought by
David J Hall Revocable Living Trust and Hall

Purchase Details

Listed on
Oct 13, 2020
Closed on
Sep 30, 2021
Sold by
Hurley Donna Ann and The Donna Ann Hurley Trust
Bought by
Hall David J and Hall Andrea
Seller's Agent
Katherine Broock
Max Broock, REALTORS®-Birmingham
Buyer's Agent
Lindsey Broadwell
Real Broker LLC Clarkston
List Price
$3,290,000
Sold Price
$2,950,000
Premium/Discount to List
-$340,000
-10.33%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
7.20%
Original Mortgage
$2,000,000
Interest Rate
2.25%
Mortgage Type
New Conventional

Purchase Details

Closed on
Oct 16, 2017
Sold by
Walton Dona A
Bought by
Walton Donna A and The Donna A Walton Trust

Purchase Details

Listed on
Jul 24, 2015
Closed on
Oct 19, 2015
Sold by
The Harold Keith Sperlich Revocable Trus and Sperlich Harold Keith
Bought by
Walton Donna A
Seller's Agent
Katherine Broock
Max Broock, REALTORS®-Birmingham
Buyer's Agent
Jasin Kjoller
RE/MAX Platinum
List Price
$2,895,000
Sold Price
$2,660,000
Premium/Discount to List
-$235,000
-8.12%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
3.76%

Purchase Details

Closed on
Aug 1, 2012
Sold by
Sperlich Harold K and Sperlich Harold Keith
Bought by
Sperlich Harold Keith and The Harold Keith Sperlich Revocable Trus

Purchase Details

Closed on
Apr 5, 2012
Sold by
Sperlich Polly A
Bought by
Sperlich Harold K

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

Purchase History

Date Buyer Sale Price Title Company
3333 West Shore Llc -- None Listed On Document
Hall David J -- None Listed On Document
David J Hall Revocable Living Trust -- None Listed On Document
Hall David J $2,950,000 Capital Title Ins Agcy Inc
Walton Donna A -- None Available
Walton Donna A $2,660,000 None Available
Sperlich Harold Keith -- None Available
Sperlich Harold K -- None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Hall David $2,000,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
11/30/2023 11/30/23 Sold $4,350,000 +11.5% $836 / Sq Ft
11/11/2023 11/11/23 Pending -- -- --
10/27/2023 10/27/23 For Sale $3,900,000 +32.2% $750 / Sq Ft
09/30/2021 09/30/21 Sold $2,950,000 -10.3% $567 / Sq Ft
08/04/2021 08/04/21 Pending -- -- --
10/13/2020 10/13/20 For Sale $3,290,000 +23.7% $632 / Sq Ft
10/19/2015 10/19/15 Sold $2,660,000 -8.1% $511 / Sq Ft
09/28/2015 09/28/15 Pending -- -- --
07/24/2015 07/24/15 For Sale $2,895,000 -- $556 / Sq Ft
Source: Realcomp

Tax History Compared to Growth

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
2024 $71,733 $1,474,060 $0 $0
2023 $71,036 $1,462,710 $0 $0
2022 $69,054 $1,421,760 $0 $0
2021 $48,177 $1,434,070 $0 $0
2020 $45,589 $1,437,340 $0 $0
2019 $46,757 $1,418,800 $0 $0
2018 $45,827 $1,405,510 $0 $0
2017 $46,416 $1,389,430 $0 $0
2016 $48,415 $1,330,000 $0 $0
2015 -- $1,572,600 $0 $0
2014 -- $1,314,520 $0 $0
2011 -- $1,236,270 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Similar Home in Orchard Lake, MI

  • 5820 Lakeview Ave, Orchard Lake, MI 48323

    $4,500,000

    • 4 Beds
    • 8 Baths
    • 5,576 Sq Ft
    • 5820 Lakeview Ave
    • Orchard Lake, MI

    Experience unparalleled luxury in this stunning 8,500 sq. ft. waterfront estate on all-sports Upper Straits Lake in Orchard Lake, Michigan. This exceptional 4-bedroom, 5 full-bath, 3 half-bath mansion boasts 80 feet of pristine lake frontage on a double lot with breathtaking views.Step inside to soaring 20-foot ceilings, heated floors, and three grand fireplaces. The gourmet kitchen is a

    Edinam Moten Bridge Cross Realty

    Section Image

Source: Realcomp

MLS Number: 20230088303

Realcomp

APN: 18-09-426-019