Hang on a second...
USDAProperties.com is making sense of this chaotic market...

 

 

 

$3,900,000   Price Analysis
USDAProperties Agent Contact Page  Agent Details  share icon     map icon  QR
362 Keswick Rd
Bloomfield Hills, MI 48304
5 bed 8 bath 8,429 SqFt ($462/SqFt)
1.8 acre lot. Built 1953
Listed 2024-06-18, Taxes $48,634
Ⓧ USDA Ineligible
due to price & location

near Bloomfield Hills

Nestled in the highly sought-after Bloomfield Hills Vaughn Triangle

A long private brick-paved drive leads to an awe-inspiring sprawling estate. Unmatched in both its interior and exterior beauty, this magnificent property rests on 1.8 acres of meticulously manicured grounds, adorned with splendid gardens and inviting outdoor spaces. Step inside the 8, 000+ SF showpiece and be captivated by the refined details found throughout. The double-height marble foyer with its striking staircase sets the tone for the elegance that awaits. The main rooms flow seamlessly, providing an ideal setting for hosting unforgettable gatherings. Each space is graced with custm moldings, artful ceilings and a harmonious blend of marble, onyx and hardwood floors.

Magnificent fireplaces and walls of windows further elevate the ambiance, bathing the interiors in natural light. Ind ulge your culinary passions in the chef's dream kitchen and lose yourself in the allure of the wood-clad library. The master suite with its spa-like bath promises a tranquil retreat. Additionally, a finished basement and a three-car garage provide ample space for your lifestyle needs. Situated near Cranbrook Educational Community, this estate enjoys a top-notch location, adding to its desirability. Prepare to be enchanted by the grandeur and rare beauty of this remarkable residence, meticulously crafted to offer an unparalleled living experience that defines luxury living at its finest. This home is a true marvel.


Presented by Shawn Arnaout at
@properties Christie's Int'l R E Rochester.
Listing Agent Photo

Property MLS #20240043076 from Realcomp

Bedrooms: 5

Total Rooms: 22
Laundry Area/Room: 24.00 x 22.00
Laundry Area/Room Level: First/Entry
Living Room: 24.00 x 22.00
Living Room Level: First/Entry
Great Room: 20.00 x 24.00
Great Room Level: First/Entry
Dining Room: 16.00 x 18.00
Dining Room Level: First/Entry
Bedroom: 15.00 x 14.00
Bedroom Level: Second
Bedroom: 14.00 x 16.00
Bedroom Level: Second
Other: 25.00 x 20.00
Other Level: First/Entry
Kitchen: 16.00 x 20.00
Kitchen Level: First/Entry
Family Room: 20.00 x 20.00
Family Room Level: First/Entry
Butlers Pantry: 8.00 x 10.00
Butlers Pantry Level: First/Entry
Bedroom - Primary: 22.00 x 20.00
Bedroom - Primary Level: First/Entry
Bedroom: 16.00 x 14.00
Bedroom Level: Second
Bedroom: 13.00 x 14.00
Bedroom Level: Second
Basement Description: Unfinished

Total Bathrooms: 5.30
Full Bathrooms: 5
1/2 Bathrooms: 3

High Spd Internet Avail
Furnished - Negotiable
Wet Bar

Dishwasher
Dryer
Washer
Bar Fridge

Cooling Features: Central Air
Fireplace Features: Dining Room
Heating Features: Forced Air
Heating Fuel: Natural Gas

Lighting
Fencing: Fence Allowed
Frontage Length: 160
Road Frontage Type: Paved
Porch Description: Patio, Porch, Terrace

Lot Size Acres: 1.8
Lot Size Dimensions: 160X315X105X272X158X129
Lot Size Square Feet: 78408

Garage Spaces: 3
Garage Features: Attached

Association: No
Calculated Total Monthly Association Fees: 0

School District: Bloomfield Hills

Way Elementary School is a public elementary school located approximately 1.2 miles away.
directions icon Map directions

Bloomfield Hills High School is a public high school located approximately 1.7 miles away.
directions icon Map directions

Bloomfield Hills Middle School is a public elementary and middle school located approximately 2.4 miles away.
directions icon Map directions

Cranbrook School is a private elementary, middle and high school located approximately 0.7 miles away.
directions icon Map directions

ActivationDate : 2024-06-18
Annual Tax Amount: 50395
Source Listing Status: Active
County: Oakland
Directions: S of Long Lake, W of Woodward
Source Property Type: Residential
Home Warranty: No
Area: Bloomfield Hills
Source Neighborhood: BRIARBANK
Ownership Type: Short Sale - No, Private Owned
Parcel Number: 1915403013
Postal Code Plus 4: 2740
Subdivision: BRIARBANK
Source System Name: C2C

YearAssessments
Building + Land
Total
Tax
2022$unknown + $unknown
$1,335,110
$48,634
2021$unknown + $unknown
$1,527,170
$40,510
2020$unknown + $unknown
$1,517,460
$48,707
2019$unknown + $unknown
$1,467,030
$32,450
2018$unknown + $unknown
$1,444,740
$32,539
2017$unknown + $unknown
$1,380,130
$32,201
2016$unknown + $unknown
$1,254,370
$32,092
2015$unknown + $unknown
$1,215,670
$31,976
2014$unknown + $unknown
$1,036,040
$31,958
2013$unknown + $unknown
$856,100
$31,649
2012$unknown + $unknown
$935,020
$34,653
2011$unknown + $unknown
$1,133,400
$33,604
2010$unknown + $unknown
$1,203,860
$31,398
2009$unknown + $unknown
$1,263,320
$29,953
2008$unknown + $unknown
$1,470,830
$24,167
2007$unknown + $unknown
$1,343,300
$22,748

Listing removed 2024-06-18
$0
Realcomp
Listed 2024-06-18
$3,900,000
Realcomp
Relisted 2024-02-17
$4,250,000
Realcomp
Listing removed 2024-02-16
$0
Realcomp
Relisted 2023-12-03
$4,250,000
Realcomp
Listing removed 2023-12-02
$0
Realcomp
Price Changed 2023-09-01
$4,250,000
Realcomp
Price Changed 2023-08-31
$0
Realcomp
Listed 2023-07-28
$4,250,000
Realcomp
Listing removed 2021-07-19
$35,000
Realcomp
Sold 2021-06-25
$2,460,000
Realcomp
Listing removed 2021-06-02
$0
Realcomp
Listed for rent 2021-03-29
$35,000
Realcomp
Listed 2021-03-29
$2,649,000
Realcomp
Listing removed 2021-03-09
$0
Realcomp
Relisted 2021-03-08
$2,499,000
Realcomp
Listing removed 2021-02-18
$0
Realcomp
Listing removed 2021-02-18
$0
Realcomp
Listing removed 2021-01-19
$0
Realcomp
Listing removed 2021-01-19
$0
Realcomp
Listed for rent 2021-01-18
$15,000
Realcomp
Listed 2021-01-18
$2,499,000
Realcomp
Price Changed 2020-11-21
$2,499,000
Realcomp
Price Changed for rent 2020-11-17
$15,000
Realcomp
Listing removed 2020-11-11
$0
Realcomp
Listed 2020-11-10
$2,880,000
Realcomp
Price Changed for rent 2020-11-08
$17,000
Realcomp
Listed for rent 2020-10-01
$20,000
Realcomp
Listed 2020-09-15
$2,880,000
Realcomp
Listing removed 2019-09-21
$0
Realcomp
Listing removed 2019-09-20
$15,000
Realcomp
Listing removed 2019-09-12
$0
Realcomp
Listing removed 2019-09-12
$0
Realcomp
Listed 2019-09-11
$2,995,000
Realcomp
Listing removed 2019-07-16
$0
Realcomp
Listing removed 2019-07-16
$0
Realcomp
Listed for rent 2019-07-15
$15,000
Realcomp
Listed 2019-07-15
$2,995,000
Realcomp
Price Changed for rent 2019-05-24
$15,000
Realcomp
Listing removed 2019-05-18
$0
Realcomp
Listing removed 2019-05-18
$0
Realcomp
Listed 2019-05-17
$3,175,000
Realcomp
Listed for rent 2019-05-17
$20,000
Realcomp
Listing removed 2019-03-28
$3,175,000
Realcomp
Listing removed 2019-03-27
$0
Realcomp
Listed 2019-03-26
$3,175,000
Realcomp
Price Changed for rent 2019-02-01
$20,000
Realcomp
Listing removed 2019-01-12
$0
Realcomp
Listed for rent 2019-01-11
$15,000
Realcomp
Listed 2019-01-11
$3,175,000
Realcomp
Listed 2018-10-15
$3,199,000
Realcomp
Listing removed 2018-06-16
$3,499,000
Realcomp
Listed 2018-02-06
$3,499,000
Realcomp
Listing removed 2017-12-13
$3,999,000
Realcomp
Listed 2017-07-31
$3,999,000
Realcomp
Listing removed 2017-07-20
$3,999,900
Realcomp
Listing removed 2017-03-21
$3,999,900
Realcomp
Listing removed 2016-11-19
$3,999,900
Realcomp
Listed 2016-11-18
$3,999,900
Realcomp
Listed 2016-11-06
$3,999,900
Realcomp
Listing removed 2016-09-07
$3,999,900
Realcomp
Relisted 2016-09-06
$3,999,900
Realcomp
Listing removed 2016-09-03
$3,999,900
Realcomp
Listing removed 2016-08-20
$3,999,900
Realcomp
Listed 2016-08-19
$3,999,900
Realcomp
Listed 2016-08-19
$3,999,900
Realcomp
Price Changed 2016-06-23
$3,999,900
Realcomp
Listed 2016-03-31
$4,495,000
Realcomp
Listing removed 2015-11-12
$4,495,000
Realcomp
Listed 2015-06-18
$4,495,000
Realcomp
Sold 1981-09-01
$306,000
Public Record

Total Square Feet Living: 8429
Year Built: 1953
Construction Materials: Brick, Stone
Foundation Details: Basement
Levels: 2 Story
Property Age: 71
Roof: Asphalt
Levels or Stories: 2 Story
Total Area Sqft: 8429
Total Below Grade Area: 2686
Year Remodeled: 2004
Architectural Style: Colonial

Sewer: Public Sewer (Sewer-Sanitary)
Water Source: Public (Municipal)
Click Thumbnail Images To View Full Size
house_viewunknowngarageunknownunknown
unknownunknownunknownunknownunknown
dining_roomdining_roomdining_roomliving_roomliving_room
living_roomdining_roomunknownkitchendining_room
kitchenkitchenunknownunknownbathroom
unknownliving_roomliving_roombathroomunknown
living_roomunknownliving_roomliving_roomliving_room
living_roomliving_roomliving_roombedroombedroom
living_roomunknownliving_roomliving_roomliving_room
unknownbathroomunknownunknownunknown
unknownunknownbedroombedroombedroom
bedroombedroombathroombathroombedroom
bedroombathroombathroombathroombedroom
living_roombedroombathroombathroomunknown
unknownliving_roomunknowndining_roombathroom
unknowndining_roomunknownliving_roomliving_room
unknownyardhouse_viewunknownyard
porchunknownunknownunknownunknown
unknownunknownunknownunknownunknown
unknownhouse_view

The property loan eligibility may be subject to additional requirements beyond geographical location including but not limited to the condition of the property. Speak with a real estate professional to find out more about the eligibility of a specific property.