5174 Barrington Drive

$3,999,000 + $500 HOA Fee 5174 Barrington Drive Rochester MI

5174 Barrington Drive, Rochester, MI

House in Rochester, Oakland County, MI, 48306

  • Active
    $3,999,000
    + $500 HOA /mo.
    Est. Mortgage Payment
  • 6 beds /
  • 6.2 baths /
  • 13,298 sqft
  • / 1 lot sqft
  • / 2000 built
  • / 75 days on site
5174 Barrington Drive, Rochester, MI

Get A Personal Guided Tour of this Home

Or Call Us 1-800-241-3327 Call Us and Schedule a Private Showing 1-800-241-3327
Report a problem
Share Map It

Agent's Summary

MLS# 214082540

Magnificent luxury estate in a private gated community surrounded by multi-million dollar estates. Highly contemporary extended home placing it closer to 19000 sq ft if including a media rm theater, finished rec room LL designed spectacularly by orig bldr. Added are spectator rooms upper,and for the fitness or athletically inclined seeking this type home, a fully function indoor regulation Basketball court with maple cushioned floor, complete with locker rm, spa with plunges, fitness gym which all are superior in design and top of the line craftmanship by Bldr Enzo Casadei. This estate is complete with blt on custom cabana Entry dramatic marble foyer offering 6 BD 6.2 BA with a 1525 re-customized Mstr suite. A bonus rm, can be addt'l BD, guest quarters, extended family game area. Updated 2012 Viking appliances throughout. Extensive use of marble, wall to ceiling windows, "smart home" Impossible to list all amenities, pool offers spa, kiddie area. 1.7 acres. Gated w/motivated seller

Schedule a Private Showing Schedule a Private Showing 1-800-241-3327

Amenities of 5174 Barrington Drive, Rochester

  • Last Checked 13 minutes ago
  • Last Changed 6 days ago
  • Price Drop on Oct, 17 $190,000
The Building
Construction Features

Site Condo

Construction Materials

Brick, Stone

Foundation Details

Basement

Foundation Materials

Block, Poured

Garage Features

Attached, Basement Access, Door Opener, Electricity, Side Entrance

Garage Size

4 Car

Garage

Yes

Porch Type

Balcony, Porch

18,472 Sqft

Year Built

2000

Year Remodeled

2010

Interior
Basement Type

Finished

Basement

Yes

Fireplace Fuel

Gas, Other

Fireplace Locations

Basement, Family Room, Great Room, Living Room, Master Bedroom, Other

Fireplace

Yes

Features

Air Cleaner, Cable Available, Central Vacuum, High Spd Internet Avail, Humidifier, Intercom, Jetted Tub, Security Alarm (owned), Sound System, Spa/Hot-tub, Water Softener (owned), Wet Bar

Total Sqft

13,298 Sqft

Total Basement Sqft

5,174 Sqft

Financial & Terms
Association Fee Frequency

Monthly

Location
Road Frontage Type

Paved

Subdivision Name

ORCHARD RIDGE OCCPN 1031

The Property
Exterior Features

Cabana, Fenced, Gate House, Outside Lighting, Pool - Inground, Sprinkler(s)

Frontage Feet

257

Homestead

Yes

Pool

Yes

Waterfront

No

Taxes
Tax Amount Summer

20474.0000

Tax Amount Winter

11594.0000

Beds
Total

6

Baths
Full

6

Half

2

Total

6.20

The Listing
Status

Active

Virtual Tour

Virtual Tour

Heating & Cooling
Cooling

Ceiling Fans 2+, Central Air

Heating

Forced Air, Zoned, Other

Heating Fuel

Gas

Utilities
Sewer

Sewer-Sanitary

Water Heater Fuel

Gas

Water Source

Municipal Water

Appliances
Kitchen

Bar Fridge, Dishwasher, Disposal, Dryer, Microwave, Refrigerator, Stove, Washing Machine, Other

Schools
School District

Rochester

Provided through IDX through Realcomp II Ltd.

Courtesy of RE/MAX Classic

Copyright 2014 Realcomp II Ltd. Shareholders.

REALCOMP logo

The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified. IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing and that the data is deemed reliable but not guaranteed accurate by Realcomp II Ltd. Bob Wiggins, Estately, Inc. Principal Broker & licensed REALTOR® in the state of Michigan

Map of 5174 Barrington Drive

Bing Aerial View

History of 5174 Barrington Drive, Rochester

Date Status Source Price % Change
Aug 10, 2014 Active REALCOMP# 214082540 $4,189,000
Oct 17, 2014 Active REALCOMP# 214082540 $3,999,000 -5%
Email me property alerts

Local Attractions and Places

Walk Score 11

Schools Near 5174 Barrington Drive

Name Type Grades Students GreatSchools
Rating
Distance
Delta Kelly Elementary School Public K-5 576 10.0 1.6 mi
Van Hoosen Middle School Public 6-8 796 7.0 1.8 mi
Adams High School Public 9-12 1492 10.0 2.0 mi
Baldwin Elementary School Public K-5 415 9.0 1.3 mi
Brewster Elementary School Public K-5 386 10.0 1.3 mi
Musson Elementary School Public K-5 406 10.0 1.5 mi
Eagle Creek Academy Private K-8 98 N/A 1.8 mi
Oak Arbor Church School Private K-8 37 N/A 1.8 mi
Long Meadow Elementary School Public K-5 578 9.0 2.6 mi
Living Word Lutheran School Private K-8 125 N/A 2.6 mi

Schools with a green circle serve 5174 Barrington Drive, schools with a red circle do not. Schools with an orange circle are either private or do not have a defined service area and may not serve 5174 Barrington Drive.

The school service areas are not definitive and should only be used as guidance. GreatSchools Ratings provided by www.greatschools.org

Recent 48306, MI Listings on Estately

All Homes for Sale in Rochester, MI