NOT LISTED FOR SALE

5171 Middlebelt Rd West Bloomfield, MI 48323

Estimated Value: $3,504,670 - $4,006,000

4 Beds
7 Baths
7,152 Sq Ft
$525/Sq Ft Est. Value

Last Sold June 24, 2016

Last sale price $3,500,000 $489 Per Sq Ft

Est. 7% increase in value since last sale

Current estimated payment $24,726/month

7 Days on Market

Highlights

  • Lake Front
  • Dock Facilities
  • Cabana
  • Wylie E. Groves High School Rated A+
  • Stables
  • Second Garage

About This Home

As of June 2016

Don’t miss this opportunity to have it all! Completely rebuilt classic home with newer “Grandfathered” boat house, guest house and servicing garages for the avid car collector. This estate home is the best of both worlds, uniquely deeded with a newer barn for livestock on 6+ acres allowing you to nurture an agricultural environment yet live within minutes of a contemporary lifestyle. The sunrise views over the crystal waters of Walnut Lake are an added bonus to the four season amenities of sports and relaxation. Never have you seen such a meticulous renovation from every angle. 48 hour notice to show and proof of funds required.

Last Agent to Sell the Property

Katherine Broock

Max Broock, REALTORS®-Birmingham License #6501240456 Listed on: 05/04/2016

Max Broock, REALTORS®-Birmingham

Last Buyer's Agent

Gwen Schultz

The Agency Hall & Hunter License #6504219812

The Agency Hall & Hunter

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 1929 | Remodeled in 2001

Lot Details

  • 6.29 Acre Lot
  • Lot Dimensions are 239x1168x300x1084
  • Lake Front
  • Kennel
  • Fenced
  • Wooded Lot

Home Design

  • Tudor Architecture
  • Brick Foundation
  • Slate Roof
  • Stucco

Interior Spaces

  • 7,152 Sq Ft Home
  • 2-Story Property
  • Elevator
  • Wet Bar
  • Central Vacuum
  • Sound System
  • Bar Fridge
  • Gas Fireplace
  • Family Room with Fireplace
  • Water Views
  • Finished Basement
  • Sump Pump
  • Security System Owned

Kitchen

  • <<microwave>>
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Jetted Tub in Primary Bathroom

Laundry

  • Dryer
  • Washer

Parking

  • 6 Car Direct Access Garage
  • Second Garage
  • Heated Garage
  • Garage Door Opener

Pool

  • Cabana
  • Spa

Outdoor Features

  • Dock Facilities
  • Boat Facilities
  • Patio
  • Terrace
  • Exterior Lighting

Utilities

  • Forced Air Heating and Cooling System
  • Humidifier
  • Heating System Uses Natural Gas
  • Natural Gas Water Heater
  • Water Softener is Owned
  • High Speed Internet
  • Cable TV Available

Additional Features

  • Air Purifier
  • Hay Barn
  • Stables

Listing and Financial Details

  • Assessor Parcel Number 1824351033

Community Details

Overview

  • No Home Owners Association
  • Walnut Lake Estates Subdivision

Recreation

  • Water Sports

Home Details

Home Type

Single Family

Est. Annual Taxes

$65,629

Year Built

Built in 1929 | Remodeled in 2001

Lot Details

0

Listing Details

  • Property Type: Residential
  • Architecture Style: Tudor
  • Architecture Level: 2 Story
  • Year Built: 1929
  • Year Renovated: 2001
  • Foundation Features: Sump Pump
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2

Interior Features

  • Interior Amenities: Air Purifier, Cable Available, Central Vacuum, Elevator/Lift, High Spd Internet Avail, Humidifier, Jetted Tub, Security Alarm (owned), Sound System, Spa/Hot-tub, Water Softener (owned), Wet Bar
  • Fireplace: Yes
  • Fireplace Fuel: Natural
  • Fireplace Locations: Family Room
  • Room Count: 22
  • Total Bedrooms: 4
  • Total Bathrooms: 5.20
  • Full Bathrooms: 5
  • Half Bathrooms: 2
  • Basement: Yes
  • Basement Type: Finished
  • Kitchen Appliances: Bar Fridge, Dishwasher, Disposal, Dryer, Microwave, Refrigerator, Range/Stove, Washer
  • Sq Ft Combined: 10237
  • Sq Ft Lower Floor: 3085
  • Total Sq Ft: 7152
  • Sq Ft Total Bsmt: 3085

Exterior Features

  • Roof Material: Slate
  • Waterfront Name: WALNUT LAKE
  • Waterfront: Yes
  • Foundation Details: Basement
  • Construction Materials: Stucco
  • Exterior Features: Cabana, Fenced, Lighting, Spa/Hot-tub
  • Foundation Materials: Brick/Mortar
  • Frontage Feet: 239
  • Porch Type: Patio, Terrace
  • Road Frontage Type: Paved
  • Waterfront Description: Lake Front

Garage/Parking

  • Garage Size: 6 or More
  • Garage Features: Attached, Direct Access, Door Opener, Electricity, Heated, Side Entrance
  • Garage: Yes

Utilities

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

Condo/Co-op/Association

  • Association Fee: No

Schools

  • School District: Birmingham

Lot Info

  • Homestead: Yes
  • List Price per Acre: 620031.7965
  • Lot Features: Water View, Wooded
  • Lot Size Area: 6.29
  • Lot Dimensions: 239X1168X300X1084
  • Parcel Number: 1824351033

Tax Info

  • Tax Amount Summer: 36876.0000
  • Tax Amount Winter: 28753.0000
  • Total Tax: 65629.0000

Multi Family

  • Waterfront Features: All Sports Lake, Boat Facilities, Dock Facilities

MLS Schools

  • School District: Birmingham

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 4, 2016
Closed on
Jun 24, 2016
Sold by
Ford Benson and Larsen David P
Bought by
Margolis Jeffrey and Margolis Jennifer
Seller's Agent
Katherine Broock
Max Broock, REALTORS®-Birmingham
Buyer's Agent
Gwen Schultz
The Agency Hall & Hunter
List Price
$3,900,000
Sold Price
$3,500,000
Premium/Discount to List
-$400,000
-10.26%
Current Estimated Value
$3,755,335

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$255,335
Avg. Annual Appreciation
0.29%
Original Mortgage
$2,275,000
Outstanding Balance
$1,843,795
Interest Rate
3.64%
Mortgage Type
New Conventional
Estimated Equity
$1,749,084

Purchase Details

Listed on
May 4, 2016
Closed on
May 24, 2016
Sold by
Ford Benson
Bought by
Margolis Jeffrey and Margolis Jennifer
Seller's Agent
Katherine Broock
Max Broock, REALTORS®-Birmingham
Buyer's Agent
Gwen Schultz
The Agency Hall & Hunter
List Price
$3,900,000
Sold Price
$3,500,000
Premium/Discount to List
-$400,000
-10.26%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$2,275,000
Outstanding Balance
$1,843,795
Interest Rate
3.64%
Mortgage Type
New Conventional
Estimated Equity
$1,749,084

Purchase Details

Closed on
Mar 29, 2011
Sold by
Ford Francee
Bought by
Ford Benson

Purchase Details

Closed on
Jan 16, 2001
Sold by
Dietz Anthony E
Bought by
Ford Jr B
Source: Public Records

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
Margolis Jeffrey -- Capital Title Ins Agency
Margolis Jeffrey -- Capital Title Ins Agency
Ford Benson -- None Available
Ford Jr B -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Margolis Jeffrey $2,275,000
Previous Owner Ford Benson $1,100,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
06/24/2016 06/24/16 Sold $3,500,000 -10.3% $489 / Sq Ft
05/11/2016 05/11/16 Pending -- -- --
05/04/2016 05/04/16 For Sale $3,900,000 -- $545 / 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 $47,827 $2,434,070 $0 $0
2022 $45,898 $2,203,960 $894,240 $1,309,720
2021 $77,438 $2,019,500 $0 $0
2020 $48,652 $2,251,020 $894,240 $1,356,780
2018 $84,272 $2,106,300 $804,820 $1,301,480
2015 -- $2,282,170 $0 $0
2014 -- $1,767,260 $0 $0
2011 -- $1,552,530 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Realcomp

MLS Number: 216042847

Realcomp

APN: 18-24-351-033