Mid century masterpiece w/ over 300 ft of frontage on Vhay Lk & designed by MOMA architect, Edward Durell Stone. 7634 sqft of breathtaking views, soaring ceils, versatile spaces & indoor 1/2 court basketball court surrounded by 4 acres of scenic, rolling grounds. Mstr inc huge WIC & H/H marble bath w/ sunken tub, steam shower, sauna. 2 sty GR w/ wall of wndws, brick flr. Unique & enchanting. Clay tennis court completes this fascinating property. Generator Pos: CLOSE
Single-familyProperty Type
1954Year Built
4.05 acresLot Size
$479Est. Price/Sq.Ft.
2 car garageParking
Listed by Lanie Cosgrove• Hall & Hunter Realtors
•248-644-3500 (broker)
•rclem@hallandhunter.com (broker)
Bought with . Non MLS Member• NON MLS Member
•248-247-1040 (broker)
Source:MiRealSource-MiMLS #31168919
Redfin Estimate
$2,713,003
$1.2M since sold in August 2024$147K since September
Recently sold homes
Estimate history
Homes for sale
This home's estimate is 63.7% higher than the average sale price ($1.66M) of 6 comparable homes.
Mid century masterpiece w/ over 300 ft of frontage on Vhay Lk & designed by MOMA architect, Edward Durell Stone. 7634 sqft of breathtaking views, soaring ceils, versatile spaces & indoor 1/2 court basketball court surrounded by 4 acres of scenic, rolling grounds. Mstr inc huge WIC & H/H marble bath w/ sunken tub, steam shower, sauna. 2 sty GR w/ wall of wndws, brick flr. Unique & enchanting. Clay tennis court completes this fascinating property. Generator Pos: CLOSE
REALCOMP #213103604
Oct 31, 2013
Sold
$970,000
$171/sq ft
Oct 21, 2013
Listing Removed
—
Oct 7, 2013
Listed
$1,100,000
$194/sq ft
Mid century masterpiece w/ over 300 ft of frontage on Vhay Lk & designed by MOMA architect, Edward Durell Stone. 7634 sqft of breathtaking views, soaring ceils, versatile spaces & indoor 1/2 court basketball court surrounded by 4 acres of scenic, rolling grounds. Mstr inc huge WIC & H/H marble bath w/ sunken tub, steam shower, sauna. 2 sty GR w/ wall of wndws, brick flr. Unique & enchanting. Clay tennis court completes this fascinating property. Generator
Year
Property tax
Land + Additions
Assessment*
2025
$42,620 (+76.6%)
2024
$24,128 (+3.3%)
2023
$23,348 (−0.7%)
2022
$23,501 (+17.8%)
2021
$19,951 (+0.1%)
2020
$19,930 (+8.5%)
2019
$18,369 (−0.3%)
2018
$18,419 (+0.4%)
2017
$18,342 (+0.6%)
2016
$18,226 (+0.7%)
2015
$18,100
2014
$18,090
Tax history for 480 E Long Lake Rd
Year
Property tax
Land + Additions
Assessment*
2025
$42,620 (+76.6%)
2024
$24,128 (+3.3%)
2023
$23,348 (−0.7%)
2022
$23,501 (+17.8%)
2021
$19,951 (+0.1%)
2020
$19,930 (+8.5%)
2019
$18,369 (−0.3%)
2018
$18,419 (+0.4%)
2017
$18,342 (+0.6%)
2016
$18,226 (+0.7%)
2015
$18,100
2014
$18,090
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Permits
Feb 4, 2000 • Final
Mechanical
HVAC
Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.
Property details
Interior
Basement Information
Basement Sq. Ft: 526
Basement Type: Slab
Bathroom Information
# of Full Baths: 4
# of 1/2 Baths: 2
Heating & Cooling
Air Conditioning Type: Central
Heating Fuel Type: Gas
Heating Type: Forced Air
Fireplace Information
Has Fireplace
Room Information
# of Rooms: 15
Exterior
Exterior Information
Exterior Wall: Brick
Roof Shape Type: Flat
Property Information
Living Sq. Ft: 5,658
Ground Floor Sq. Ft: 4,442
# of Units: 1
# of Stories: 2
Stories Type: 2
Legal Description: T2N, R10E, SEC 14 PART OF NE 1/4 BEG AT PT DIST N 88-15-00 W 1907.6 FT & S 34-11-00 W 386.2 FT FROM NE SEC COR, TH S 34-11-00 W 300 FT, TH S 55-49-00 E 605.8 FT, TH N 39-08-00 E 302 FT, TH N 55-49-00 W 630.3 FT TO BEG 4.30 A
Parking & Garage Information
# of Parking Spaces: 2
Parking Type: Detached Garage
Garage/Parking Sq. Ft: 513
Garage / Carport Type: Detached
Lot Information
# of Buildings: 1
Land Sq. Ft: 176,418
Municipality Name: BLOOMFIELD HILLS
Acres: 4.05
Zoning Code: LI
County Use Description: RESIDENTIAL IMPROVED
State Use Description: RESIDENTIAL
Location Information
Parcel Location Influence: Waterfront
Utility Information
Sewer Type: Public
Financial
Assessor Information
Assessment Year: 2025
Public facts
Beds: 5
Baths: 5.0
Sq. Ft.: 5,658
Stories: 2.0
Lot Size: 4.05 acres
Style: Single Family Residential
Year Built: 1954
Year Renovated: 1968
County: Oakland County
APN: 12-19-14-226-004
Home facts updated by county records on Aug 12, 2026
Around this home
Schools
Way Elementary School
Public K-5 • Assigned • 2.2mi
10/10
North Hills Middle School
Public 6-8 • Assigned • 1.7mi
9/10
Bloomfield Hills High School
Public 9-12 • Assigned • 2.7mi
9/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
2/10 Heat Factor
7 days above 98° expected this year, 14 days in 30 years
2/10 Wind Factor
Minor risk of severe winds over next 30 years
3/10 Air Factor
2 unhealthy days expected this year, 5 days in 30 years
Provided by First Street
Historical weather
Bloomfield Hills, MI • 48304
Average low and high temperatures (°F)
28
15
33
19
52
31
60
41
67
48
81
61
85
66
79
61
77
56
65
46
49
37
36
24
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 9.4 hours in
June and 2.5 hours in December, placing it below the
U.S. average for solar exposure.
9.4 hrs
2.5 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$2.58M – $3.12M
Reach more buyers when you sell with Redfin. Save up to $27,130 in fees.3 minutes to get started.