NOT LISTED FOR SALE

Estimated Value: $3,193,037

4 Beds
6 Baths
7,631 Sq Ft
$418/Sq Ft Est. Value

Sale Details

Date Sold: August 8, 2025

Last sale price $3,290,000 $431 Per Sq Ft

Est. 3% decrease in value since last sale

Current estimated payment $20,409 / mo

38 Days on Market

Highlights

  • Water Views
  • Fireplace in Primary Bedroom
  • Laundry Room
  • Lake Privileges
  • Balcony
  • Outdoor Grill

About This Home

As of August 2025

Welcome to a one-of-a-kind custom estate perched on a bluff with commanding views of Turtle Lake, nestled within the prestigious gated community of Turtle Lake. This architectural masterpiece showcases timeless design, refined craftsmanship, and luxurious amenities throughout. A dramatic two-story foyer welcomes you into soaring vaulted ceilings, custom-stained hardwood floors, and beautifully curated living spaces. At the heart of the home, the chef’s kitchen features 2 Sub-Zero refriger/freezer units, custom cabinetry, granite countertops, a large center island, and a walk-in pantry. Wolfe built-in coffee maker and steam oven make this space ideal for both everyday living and entertaining. The spacious first-floor primary suite is a true sanctuary, complete with serene lake views, spa-like bath, and enormous walk-in closets offering exceptional storage and style. The finished walkout lower level is an entertainer’s dream—boasting a large bar, expansive recreation room, and a custom wine cellar—perfect for hosting or relaxing in style. Outdoors, enjoy resort-style living with a professionally landscaped backyard, a stunning in-ground pool, and an expansive patio overlooking the tranquil waters of Turtle Lake. The garage is an oversized 3+ car space with room for a lift, perfect for car enthusiasts or additional storage needs. Set in one of Bloomfield Hills’ most exclusive gated communities, known for its natural beauty, privacy, and elite lifestyle, this exceptional estate offers an unparalleled opportunity to own a home that’s as unique as it is extraordinary. Schedule your private showing today.. BATVAI

Last Agent to Sell the Property

Tushar Vakhariya

KW Domain License #6501279268 Listed on: 06/11/2025

KW Domain

Co-Listed By

Carrie Clement

KW Domain License #6501384177

Last Buyer's Agent

Lena Oskanian

Coldwell Banker Professionals-Birm License #6501224226

Coldwell Banker Professionals-Birm

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 Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 2017

Lot Details

  • 26,136 Sq Ft Lot
  • Lot Dimensions are 100x260x100x260
  • Property fronts a private road
  • Street terminates at a dead end
  • Gated Home

HOA Fees

  • $750 per month

Parking

  • Garage

Home Design

  • Brick Exterior Construction
  • Poured Concrete
  • Wood Siding
  • Stone Siding

Interior Spaces

  • Family Room with Fireplace
  • Living Room with Fireplace
  • Water Views
  • Basement
  • Fireplace in Basement
  • Laundry Room

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Fireplace in Primary Bedroom

Outdoor Features

  • Lake Privileges
  • Balcony
  • Exterior Lighting
  • Outdoor Grill

Location

  • Ground Level
  • Property is near golf course

Utilities

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

Community Details

  • 248 338 6500 Association
  • Turtle Lake Condo Subdivision
  • On-Site Maintenance

Listing and Financial Details

  • Assessor Parcel Number 1906384025

Home Details

Home Type

Single Family

Est. Annual Taxes

$31,805

Year Built

Built in 2017

Lot Details

0.6 Acres

HOA Fees

$750 per month

Parking

3

Listing Details

  • Property Type: Residential
  • Year Built: 2017
  • State Equalized Value: 1216120.00
  • Entry Location: GroundLevelwSteps
  • Property Sub Type: SingleFamilyResidence
  • LotSizeAcres: 0.60
  • Water Body Name: Turtle Lake
  • Co List Office Mls Id: 391898
  • Co List Office Phone: 2485900800
  • Co List Office Mls Id: 391898
  • Above Grade Finished Sq Ft: 5721.00
  • Living Area: 7631.00
  • ClassName: Residential
  • ThirdPartyApprovalRequiredYN: No
  • Special Features: VirtualTour

Interior Features

  • Fireplace: Yes
  • Basement: Yes
  • Full Bathrooms: 4
  • Half Bathrooms: 2
  • Total Bedrooms: 4
  • Below Grade Sq Ft: 1910.00
  • Fireplace Features: Basement, FamilyRoom, LivingRoom, MasterBedroom

Exterior Features

  • Waterfront: No
  • Foundation Details: Basement, Poured
  • Construction Materials: Brick, Stone, WoodSiding
  • Exterior Features: Balcony, Barbecue, GateHouse, GroundsMaintenance, Lighting
  • Road Frontage Type: Paved, PrivateRoad
  • Disclosures: ExclusionsDoNotExist, TaxesHomesteadExempt
  • Exclusions: Exclusion(s) Do Not Exist
  • Home Warranty: No

Garage/Parking

  • Garage: Yes

Utilities

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

Condo/Co-op/Association

  • Association Fee Frequency: Annually
  • Association Contact: 248-338-6500

Schools

  • Junior High Dist: BloomfieldHills

Lot Info

  • Lot Features: DeadEndStreet, NearGolfCourse, WaterView
  • Lot Dimensions: 100x260x100x260
  • Parcel Number: 1906384025

Tax Info

  • Tax Amount Summer: 17447.00
  • Tax Amount Winter: 14358.00
  • Tax Annual Amount: 31805.00

Multi Family

  • Waterfront Features: LakePrivileges
  • 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
Jun 11, 2025
Closed on
Aug 8, 2025
Sold by
Baran-Christofis Dolores J and Baran Dolores J
Bought by
Seller's Agent
Tushar Vakhariya
KW Domain
Buyer's Agent
Lena Oskanian
Coldwell Banker Professionals-Birm
List Price
$3,799,000
Sold Price
$3,290,000
Premium/Discount to List
-$509,000
-13.4%
Views
75
Current Estimated Value
$3,193,037

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$96,963
Avg. Annual Appreciation
-2.66%
Original Mortgage
$1,790,000
Outstanding Balance
$1,768,547
Interest Rate
6.13%
Mortgage Type
New Conventional
Estimated Equity
$1,424,490

Purchase Details

Listed on
Jul 10, 2014
Closed on
Apr 24, 2015
Sold by
Puskas Nancy and Puskas Robert J
Bought by
Baran Dolores J and Christofis Mark
Seller's Agent
Robert Campbell
Max Broock, REALTORS®-Birmingham
Buyer's Agent
Robert Campbell
Max Broock, REALTORS®-Birmingham
List Price
$700,000
Sold Price
$700,000

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
16.21%
Original Mortgage
$1,570,205
Interest Rate
4.12%
Mortgage Type
Adjustable Rate Mortgage/ARM

Purchase Details

Closed on
May 15, 2014
Sold by
Puskas Robert and Puskas Nancy
Bought by
Puskas Nancy and Puskas Robert J

Purchase Details

Closed on
May 6, 2004
Sold by
Turtle Lake Development Llc
Bought by
Puskas Robert and Puskas Nancy
Source: Public Records

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Agents Specializing in Bloomfield Hills, MI

See All Agents

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
-- None Listed On Document
Baran Dolores J $700,000 Independent Title Svcs Inc
Puskas Nancy -- None Available
Puskas Robert -- Philip R Seaver Title Co Inc
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 $1,790,000
Previous Owner Christofis Mark $1,000,000
Previous Owner Baran Dolores J $1,570,205
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 Prior Sale
08/08/2025 08/08/25 Sold $3,290,000 -13.4% $431 / Sq Ft
07/21/2025 07/21/25 Pending -- -- --
06/13/2025 06/13/25 For Sale $3,799,000 +442.7% $498 / Sq Ft
04/24/2015 04/24/15 Sold $700,000 0.0% $151 / Sq Ft View Prior Sale
04/24/2015 04/24/15 Pending -- -- --
07/10/2014 07/10/14 For Sale $700,000 -- $151 / 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 $17,934 $1,216,120 $140,190 $1,075,930
2024 $17,447 $1,216,120 $0 $0
2023 $16,647 $1,088,430 $0 $0
2022 $28,416 $960,600 $0 $0
2021 $27,760 $1,052,860 $0 $0
2020 $15,323 $1,015,330 $0 $0
2019 $27,206 $973,610 $0 $0
2018 $41,710 $853,540 $0 $0
2017 $35,632 $708,510 $0 $0
2016 $7,505 $148,410 $0 $0
2015 -- $94,510 $0 $0
2014 -- $82,570 $0 $0
2011 -- $82,570 $0 $0
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Realcomp

MLS Number: 20251005962

Realcomp

APN: 19-06-384-025

Your Personal Tour Guide

Ask me questions while you tour the home.