NOT LISTED FOR SALE

Estimated Value: $2,958,000 - $6,483,000

5 Beds
8 Baths
7,057 Sq Ft
$680/Sq Ft Est. Value

Last Sold January 07, 2022

Last sale price $3,850,000 $546 Per Sq Ft

Est. 25% increase in value since last sale

Current estimated payment $29,123/month

150 Days on Market

Highlights

  • 308 Feet of Waterfront
  • Spa
  • 5.12 Acre Lot
  • Dock Facilities
  • Built-In Freezer
  • Lake Privileges

About This Home

As of January 2022

A privately nestled 5-lot parcel plus outlot totaling over 5 acres on all-sports Upper Long Lake. The 10,000 sqft main home completely renovated in 1985 with subsequent major additions and upgrades, designed by Irv Tobocman and Lou Des Rosiers, with breathtaking views of Upper Long Lake, is truly a one-of-a-kind masterpiece situated on a 5+ acre landscaped setting where majestic water views are incorporated into every inch of design. A soaring span of windows, wrap around balconies and a large two story deck, boast architectural details unlike any other. Main home sits on over 2 acres and additional 3 parcels provides endless possibilities to create the ultimate estate. PARCEL ID'S- 1812276002, 1812276003, 1812276001; Main home MLS: 2210013229

Last Listed By

Renee Lossia Acho

KW Domain License #6501305857 Listed on: 04/29/2021

KW Domain

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 1985 | Remodeled in 2000

Lot Details

  • 5.12 Acre Lot
  • 308 Feet of Waterfront
  • Lake Front
  • Irregular Lot

HOA Fees

  • $42 Monthly HOA Fees

Home Design

  • Contemporary Architecture
  • Brick Exterior Construction
  • Poured Concrete

Interior Spaces

  • 7,057 Sq Ft Home
  • 3-Story Property
  • Bar Fridge
  • Family Room with Fireplace
  • Living Room with Fireplace
  • Water Views
  • Dryer

Kitchen

  • Double Oven
  • Warming Drawer
  • Microwave
  • Built-In Freezer
  • Built-In Refrigerator
  • Dishwasher

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Fireplace in Primary Bedroom
  • Jetted Tub in Primary Bathroom

Finished Basement

  • Walk-Out Basement
  • Fireplace in Basement

Parking

  • 4 Car Attached Garage
  • Garage Door Opener

Outdoor Features

  • Spa
  • Dock Facilities
  • Lake Privileges
  • Deck
  • Exterior Lighting

Location

  • Ground Level Unit

Utilities

  • Forced Air Heating and Cooling System
  • Baseboard Heating
  • Heating System Uses Natural Gas
  • Natural Gas Water Heater

Community Details

  • Long Ridge Subdivision

Listing and Financial Details

  • Assessor Parcel Number 1812226043

Home Details

Home Type

Single Family

Est. Annual Taxes

$25,851

Year Built

Built in 1985 | Remodeled in 2000

Lot Details

0

HOA Fees

$42 per month

Listing Details

  • Property Type: Residential
  • Architecture Style: Contemporary
  • Architecture Level: 3 Story
  • Year Built: 1985
  • State Equalized Value: 1261160.0000
  • Year Renovated: 2000
  • Entry Location: Ground Level
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 3

Interior Features

  • Interior Amenities: Jetted Tub
  • Fireplace: Yes
  • Fireplace Locations: Basement, Family Room, Living Room, Primary Bedroom
  • Room Count: 25
  • Total Bedrooms: 5
  • Total Bathrooms: 5.30
  • Full Bathrooms: 5
  • Half Bathrooms: 3
  • Basement: Yes
  • Basement Type: Finished, Walkout Access
  • Kitchen Appliances: Built-In Freezer, Built-In Refrigerator, Dishwasher, Double Oven, Dryer, Microwave, Warming Drawer, Bar Fridge
  • Sq Ft Combined: 10433
  • Sq Ft Lower Floor: 3376
  • Total Sq Ft: 7057
  • Sq Ft Total Bsmt: 3504

Exterior Features

  • Waterfront Name: Upper Long Lake
  • Waterfront: Yes
  • Foundation Details: Basement
  • Construction Materials: Brick, Wood
  • Exterior Features: Spa/Hot-tub, Lighting
  • Foundation Materials: Poured
  • Frontage Feet: 125
  • Porch Type: Deck
  • Road Frontage Type: Paved
  • Water Frontage Feet: 308.15
  • Waterfront Description: Direct Water Frontage, Lake Front, Lake Privileges, Water Front

Garage/Parking

  • Garage Size: 4 Car
  • Garage Features: Electricity, Door Opener, Attached
  • Garage: Yes

Utilities

  • Heating Fuel: Natural Gas
  • Cooling: Central Air
  • Heating: Baseboard, Forced Air
  • Sewer: Septic Tank (Existing)
  • Water Heater Fuel: Natural Gas
  • Water Source: Public (Municipal)
  • Laundry Facilities: No

Condo/Co-op/Association

  • Association Fee Frequency: Annually
  • Association Fee: 500
  • Association Fee: Yes

Schools

  • School District: Pontiac

Lot Info

  • Homestead: Yes
  • List Price per Acre: 878906.2500
  • Lot Features: Irregular, Water View
  • Lot Size Area: 5.12
  • Lot Dimensions: IRREGULAR
  • Parcel Number: 1812226043

Tax Info

  • Tax Amount Summer: 14588.0000
  • Tax Amount Winter: 11263.0000
  • Total Tax: 25851.0000
  • Taxable Value: 827130.0000

Multi Family

  • Waterfront Features: Dock Facilities, DIRFRT

MLS Schools

  • School District: Pontiac

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
May 20, 2024
Sold by
Borenstein Jonathan and Borenstein Karen
Bought by
Khatri Hitesh Vasantkumar and Naik Karuna
Total Days on Market
150
Current Estimated Value
$4,800,179

Purchase Details

Closed on
Sep 23, 2021
Sold by
Tauber Joel D
Bought by
Borenstein Jonathan and Borenstein Karen

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$2,195,000
Interest Rate
2.8%
Mortgage Type
New Conventional

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

Similar Homes in the area

  • 3856 Vista Ln, West Bloomfield, MI 48323

    $4,500,000

    • 6 Beds
    • 9 Baths
    • 6,000 Sq Ft
    • 3856 Vista Ln
    • West Bloomfield, MI

    Nestled in a prestigious gated community on All-Sports Orchard Lake and within the highly regarded Bloomfield Hills School District, this stunning estate offers a perfect blend of luxury, privacy, and breathtaking lakefront living. Boasting nearly 9,000 square feet of meticulously designed living space, this home is the ultimate retreat, offering unparalleled elegance and spectacular views.

    Renee Lossia Acho KW Domain

    Section Image
  • 5295 Middlebelt Rd, West Bloomfield, MI 48323

    $4,500,000

    • 6 Beds
    • 8 Baths
    • 7,568 Sq Ft
    • 5295 Middlebelt Rd
    • West Bloomfield, MI

    Custom built and designed by DesRosiers architects, the spectacular contemporary is perched up high, over rolling grounds with 269 feet of water front on Walnut Lake. Floor to ceiling windows capture lakefront views from every angle. Kitchen with granite island, stainless appliances, breakfast nook, built in work area and more. For the person that needs a real office space this home offers a

    Katherine Broock Max Broock, REALTORS®-Birmingham

    Section Image
  • 5820 Lakeview Ave, Orchard Lake, MI 48323

    $4,275,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 chef’s

    Edinam Moten Bridge Cross Realty

    Section Image

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
Khatri Hitesh Vasantkumar -- None Listed On Document
Borenstein Jonathan -- Equity Title Agency Llc
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Khatri Hitesh Vasantkumar $2,500,000
Previous Owner Borenstein Jonathan $972,680
Previous Owner Borenstein Jonathan $2,195,000
Previous Owner Tauber Joel D $2,400,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
01/07/2022 01/07/22 Sold $3,850,000 -14.4% $546 / Sq Ft
09/27/2021 09/27/21 Pending -- -- --
04/29/2021 04/29/21 For Sale $4,500,000 -- $638 / 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 $28,089 $1,696,290 $0 $0
2022 $26,800 $1,553,510 $324,450 $1,229,060
2021 $26,055 $1,240,460 $0 $0
2020 $14,588 $1,261,160 $324,450 $936,710
2018 $24,878 $1,129,660 $294,960 $834,700
2015 -- $879,160 $0 $0
2014 -- $772,210 $0 $0
2011 -- $716,650 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: Realcomp

MLS Number: 2210021923

Realcomp

APN: 18-12-226-043