NOT LISTED FOR SALE

Estimated Value: $1,338,000 - $2,428,000

4 Beds
7 Baths
5,707 Sq Ft
$360/Sq Ft Est. Value

Sale Details

Date Sold: June 2, 2025

Last sale price $2,270,000 $398 Per Sq Ft

Est. 11% decrease in value since last sale

Current estimated payment $11,993 / mo

1 Day on Market

Highlights

  • Private Waterfront
  • Dock Facilities
  • Laundry Room
  • Bloomfield Hills High School Rated A+
  • Wooded Lot
  • Entrance Foyer

About This Home

As of June 2025

FABULOUS 4BR 7 BATH LAKEFRONT RANCH HOME, ON A GORGEOUS 2/3 ACRE LOT ON ALL-SPORTS WALNUT LAKE, WITH BREATHTAKING LAKE VIEWS FROM VIRTUALLY EVERY ROOM IN THE HOUSE, NORTH FACING, SUNRISES & SUNSETS & AN EXTRAORDINARY LAKE-LIVING LIFESTYLE! In a fantastic subdivision, with excellent curb appeal w/ many perennials, mature landscaping & trees, circular drive, new roof (’23), & BLOOMFIELD HILLS SCHOOLS, this home has almost 6,000 SF of living space. A Grand Entrance/Foyer, w/ 18’ vaulted ceilings welcomes you inside. The incredible Great Room has amazing views all around, w/14’ high octagonal ceiling, fireplace, wet bar & 3 doorwalls leading outside to the deck. Large formal Dining Room, for family gatherings & holiday dinners. Spacious open Kitchen w ceramic stone flooring, granite center island, plenty of cabinets & counters, walk-in pantry, SS refrigerator, Jenair cooktop, dble ovens, dishwasher & doorwall overlooking the lake. Primary Bedroom Suite, has deck & lakeview, dual closets, vanity area & TWO primary baths, one with jetted tub, & one with stall shower. An office/flex space on main floor, w/ built-in wall-to-floor shelving, & doorwall to deck. Convenient 1st flr laundry w/ cabinets, fridge/freezer, plus 2 lavs complete the entry level. LOWER LEVEL is a 3,000 SF FINISHED WALK-OUT BASEMENT, featuring a big Family Room, for recreation & gathering, bar area (wet bar, refrig), w/ several door walls out to the patio; 3 spacious Bedrooms, each with their own Full Bath, plenty of closets & two of the bedrooms have door walls leading to lakeside, & the 3rd BR has an egress window. One bath has a sauna. Large workroom, wine cellar and many storage spaces. 2.5 car garage for vehicles/ tools/toys for the lake! Full house generator. This is truly PARADISE IN MICHIGAN, and the home where everyone wants to gather, relax, entertain, enjoy nature, swimming, boating, all sports, fishing, sunsets & more. Dock Included. THIS IS NOT JUST A HOME, IT’S A LIFESTYLE LIKE NO OTHER!

Last Agent to Sell the Property

Rick Nessel

National Realty Centers, Inc License #6501378895 Listed on: 04/25/2025

National Realty Centers, Inc

Co-Listed By

Patty Nessel

National Realty Centers, Inc License #6501410981

Last Buyer's Agent

Sana Brikho

St Jude Realty License #6501352780

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 1977

Lot Details

  • 26,572 Sq Ft Lot
  • Lot Dimensions are 100x204x147x311
  • Private Waterfront
  • Beach Front
  • 147 Feet of Waterfront
  • Lake Front
  • Sprinkler System
  • Wooded Lot

HOA Fees

  • $58 per month

Parking

  • Garage

Home Design

  • Brick Exterior Construction
  • Poured Concrete
  • Asphalt Roof
  • Wood Siding

Interior Spaces

  • Gas Fireplace
  • Entrance Foyer
  • Family Room with Fireplace
  • Great Room with Fireplace
  • Water Views
  • Basement
  • Sump Pump
  • Laundry Room

Bedrooms and Bathrooms

  • 4 Bedrooms

Accessible Home Design

  • Stairway
  • Stair Lift

Outdoor Features

  • Dock Facilities
  • Exterior Lighting

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Natural Gas Water Heater
  • High Speed Internet

Listing and Financial Details

  • Assessor Parcel Number 1824256005

Community Details

Overview

  • Barb Kaufman, (248) 865 9805 Association
  • Walnut Lake Hills Sub Subdivision

Recreation

  • Water Sports

Home Details

Home Type

Single Family

Est. Annual Taxes

$23,359

Year Built

Built in 1977

Lot Details

0.61 Acres

HOA Fees

$58 per month

Parking

2

Listing Details

  • Property Type: Residential
  • Year Built: 1977
  • State Equalized Value: 762640.00
  • Accessibility Features: AccessibleStairway, StairLift
  • Entry Location: GroundLevel
  • Pets Allowed: Yes
  • Property Sub Type: SingleFamilyResidence
  • LotSizeAcres: 0.61
  • Water Body Name: Walnut Lake
  • Co List Office Mls Id: 387480
  • Co List Office Phone: 2484681444
  • Co List Office Mls Id: 387480
  • Above Grade Finished Sq Ft: 2907.00
  • Living Area: 5707.00
  • ClassName: Residential
  • ThirdPartyApprovalRequiredYN: No
  • Special Features: None

Interior Features

  • Interior Amenities: EntranceFoyer, HighSpeedInternet
  • Fireplace: Yes
  • Basement: Yes
  • Full Bathrooms: 5
  • Half Bathrooms: 2
  • Total Bedrooms: 4
  • Below Grade Sq Ft: 2800.00
  • Fireplace Features: FamilyRoom, Gas, GreatRoom

Exterior Features

  • Waterfront: Yes
  • Foundation Details: Basement, Poured, SumpPump
  • Construction Materials: Brick, WoodSiding
  • Exterior Features: Lighting
  • Road Frontage Type: Paved
  • Water Frontage Feet: 147.00
  • Disclosures: TaxesHomesteadExempt
  • Home Warranty: No
  • Roof: Asphalt

Garage/Parking

  • Garage: Yes

Utilities

  • Cooling: CentralAir
  • Heating: ForcedAir, NaturalGas
  • Sewer: PublicSewer
  • Water Heater Fuel: NaturalGas
  • Water Source: Public
  • Laundry Features: LaundryRoom

Condo/Co-op/Association

  • Association Fee Frequency: Annually
  • Phone: kaufmanfun@sbcglobal.net
  • Association Contact: Barb Kaufman, (248) 865-9805

Schools

  • Junior High Dist: BloomfieldHills

Lot Info

  • Lot Features: WaterView, Sprinklers, Wooded
  • Lot Size Area: 0.61
  • Lot Dimensions: 100X204X147X311
  • Parcel Number: 1824256005
  • Land Lease Expiration Date: 2025-10-30

Tax Info

  • Tax Amount Summer: 12248.00
  • Tax Amount Winter: 11111.00
  • Tax Annual Amount: 23359.00

Multi Family

  • Waterfront Features: AllSportsLake, BeachFront, DirectWaterFrontage, DockFacilities, LakeFront, PrivateWaterFrontage

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
Apr 25, 2025
Closed on
Jun 2, 2025
Sold by
Bought by
Seller's Agent
Rick Nessel
National Realty Centers, Inc
Buyer's Agent
Sana Brikho
St Jude Realty
List Price
$1,999,900
Sold Price
$2,270,000
Premium/Discount to List
$270,100
13.51%
Views
34
Current Estimated Value
$2,016,592

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$253,408
Avg. Annual Appreciation
-8.53%
Original Mortgage
$1,816,000
Interest Rate
0.0676%
Mortgage Type
New Conventional

Purchase Details

Closed on
Aug 29, 2005
Sold by
Bought by
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
$2,270,000 None Listed On Document
-- --
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
Closed $750,000
Closed $1,816,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
06/02/2025 06/02/25 Sold $2,270,000 +13.5% $398 / Sq Ft
04/29/2025 04/29/25 Pending -- -- --
04/27/2025 04/27/25 For Sale $1,999,900 -- $350 / 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
2025 $12,519 $820,730 $418,630 $402,100
2024 $12,248 $762,640 $0 $0
2022 $11,853 $596,870 $364,040 $232,830
2021 $21,943 $580,080 $0 $0
2020 $11,828 $658,450 $364,040 $294,410
2018 $22,416 $641,520 $332,200 $309,320
2015 -- $682,770 $0 $0
2014 -- $605,430 $0 $0
2011 -- $545,090 $0 $0
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Realcomp

MLS Number: 20250027880

Realcomp

APN: 18-24-256-005

Your Personal Tour Guide

Ask me questions while you tour the home.