• To Log in to My Property Finder or Sign Up for a New Account  click here
Close
  • Listing status icon

    $2,700,000

  • Active | MLS#: 218074958
  • 6Beds
  • 8Baths
  • 13,298Sq Ft

5174 Barrington Drive Rochester, MI 48306

Favorite
Share
Close
Info Visit Search
My Property Finder members always view full listing details. Login or Register

Listing provided courtesy of: Real Estate One-W Blmfld

Overview

This magnificent luxury 'smart home estate is exquisite in every way! 6 bedroom 6.2 bath in a guard-gated community, w/18,000+ total Sq. Ft. This home opens up with a majestic marble foyer, and a dramatic 2 story living room that is fabulous for entertaining. Home features a private 1525 re-customized master suite and master bath that rivals any 5 star hotel. This dream home includes an spacious dining room, granite, hardwood, and stainless steel appliances perfect for family gatherings. The fully functioning indoor NBA regulation basketball court fits warmly into maple cushioned hardwood, and is truly a fitness enthusiast dream home. Attached with locker room and spa that was designed with top of the line craftsmanship by custom builder Enzo Casadei. Large yard, set on 1.7 acres features a pool, cabana, and jacuzzi thats nestled right next to a 4 car attached beautiful custom porte-cochère. This home is a must see!

General Features

  • Full Bathrooms 6
  • Half Bathrooms 2
  • County Or Parish Oakland
  • Settlement Township
  • Year Built 2000
  • Year Remodeled 2010
  • Sqft Total 13,298
  • Garage Size 4 Car
  • Originating MLS Realcomp II Ltd
  • Bathrooms 6.2
  • Short Sale No
  • Tax Amount - Summer 20474.0000
  • Tax Amount - Winter 11594.0000

Building Features

  • Architecture Style Colonial
  • Construction Materials Brick, Stone
  • Foundation Details Basement
  • Room Count 21
  • Interior 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
  • Kitchen Appliances Bar Fridge, Dishwasher, Disposal, Dryer, Microwave, Refrigerator, Stove, Washing Machine, Other
  • Garage Features Attached, Door Opener, Electricity, Side Entrance
  • Heating Forced Air, Zoned, Other
  • Cooling Ceiling Fans 2+, Central Air
  • Fireplace Locations Basement, Family Room, Great Room, Living Room, Master Bedroom
  • Fireplace Fuel Gas, Other
  • Sqft Combined 18,472
  • Sqft Lower Floor 5,174
  • Sqft Total Bsmt 5,174

Property Features

  • Lot Size Dimensions 257x265x257x265
  • Frontage Feet 257
  • Exterior Features Cabana, Fenced, Gate House, Outside Lighting, Pool - Inground, Sprinkler(s)
  • Road Frontage Type Paved
  • Sewer Sewer-Sanitary
  • Water Source Municipal Water
  • Association Fee 500
  • Association Fee Frequency Monthly

Schools

  • School District Rochester

 

Ask a Question

Price & Status History

Days on Market

  • This property has been listed on the market for 126 days
  • Average days-on-market for homes between $2,160,000 - $3,240,000 = 99 (in zip code 48306)

Location

View the Map

Ask A Question

Community Demographics for Zip Code 48306 (Rochester)

Housing Occupancy
  • Home Owners: 8,946 (87%)
  • Renters: 1,067 (10%)
  • Vacant: 232 (2%)
  • Total Housing Units: 10,245
Households
  • Average Household Size: 2.86
  • Housing Density (People per square mile): 1,261
Age Range (number of people)
  • Age 0-14: 5,027
  • Age 15-24: 4,183
  • Age 25-39: 5,640
  • Age 40-59: 5,807
  • Age 60-79: 6,422
  • Age 80+: 1,586
  • Total: 28,665

* All numbers in this section are 2016 projections provided by Geolytics Inc

School Information for 48306 (Rochester)

Public Schools in Zip Code 48306 (Rochester)

* This list of schools may not match the property above.

ROCHESTER ADAMS HIGH SCHOOL 3200 WEST TIENKEN RD ROCHESTER HILLS, MI 48306 Phone: 2487265200 9th-12th
Grade Size Distribution
  • 9th: 366
  • 10th: 364
  • 11th: 372
  • 12th: 390
School Population
  • Teachers: 68
  • Students per Teacher: 21.9
  • Students: 1492
  • Male/Female: 782/710
School District
  • ROCHESTER COMMUNITY SCHOOL DISTRICT
  • 501 WEST UNIVERSITY DR ROCHESTER, MI 48307
  • Phone: 2487263000
District Population
  • Schools: 22
  • Full-Time Teachers: 814
  • Students per Teacher: 18.4
  • Staff: 1760
  • Students: 14965
STONEY CREEK HIGH SCHOOL 575 EAST TIENKEN RD ROCHESTER HILLS, MI 48306 Phone: 2487265700 9th-12th
Grade Size Distribution
  • 9th: 416
  • 10th: 416
  • 11th: 430
  • 12th: 358
School Population
  • Teachers: 74
  • Students per Teacher: 21.9
  • Students: 1620
  • Male/Female: 807/813
School District
  • ROCHESTER COMMUNITY SCHOOL DISTRICT
  • 501 WEST UNIVERSITY DR ROCHESTER, MI 48307
  • Phone: 2487263000
District Population
  • Schools: 22
  • Full-Time Teachers: 814
  • Students per Teacher: 18.4
  • Staff: 1760
  • Students: 14965
HART MIDDLE SCHOOL 6500 SHELDON RD ROCHESTER HILLS, MI 48306 Phone: 2487264500 6th-8th
Grade Size Distribution
  • 6th: 380
  • 7th: 391
  • 8th: 383
School Population
  • Teachers: 53
  • Students per Teacher: 21.8
  • Students: 1154
  • Male/Female: 587/567
School District
  • ROCHESTER COMMUNITY SCHOOL DISTRICT
  • 501 WEST UNIVERSITY DR ROCHESTER, MI 48307
  • Phone: 2487263000
District Population
  • Schools: 22
  • Full-Time Teachers: 814
  • Students per Teacher: 18.4
  • Staff: 1760
  • Students: 14965
VAN HOOSEN MIDDLE SCHOOL 1339 NORTH ADAMS RD ROCHESTER HILLS, MI 48306 Phone: 2487264900 6th-8th
Grade Size Distribution
  • 6th: 239
  • 7th: 259
  • 8th: 267
School Population
  • Teachers: 35
  • Students per Teacher: 21.9
  • Students: 765
  • Male/Female: 393/372
School District
  • ROCHESTER COMMUNITY SCHOOL DISTRICT
  • 501 WEST UNIVERSITY DR ROCHESTER, MI 48307
  • Phone: 2487263000
District Population
  • Schools: 22
  • Full-Time Teachers: 814
  • Students per Teacher: 18.4
  • Staff: 1760
  • Students: 14965
BALDWIN ELEMENTARY SCHOOL 4325 BANNISTER RD ROCHESTER, MI 48306 Phone: 2487263200 K-5th
Grade Size Distribution
  • Knd: 63
  • 1st: 81
  • 2nd: 71
  • 3rd: 91
  • 4th: 87
  • 5th: 102
School Population
  • Teachers: 32
  • Students per Teacher: 15.5
  • Students: 495
  • Male/Female: 243/252
School District
  • ROCHESTER COMMUNITY SCHOOL DISTRICT
  • 501 WEST UNIVERSITY DR ROCHESTER, MI 48307
  • Phone: 2487263000
District Population
  • Schools: 22
  • Full-Time Teachers: 814
  • Students per Teacher: 18.4
  • Staff: 1760
  • Students: 14965
BREWSTER ELEMENTARY SCHOOL 1535 BREWSTER RD ROCHESTER HILLS, MI 48306 Phone: 2487263300 K-5th
Grade Size Distribution
  • Knd: 55
  • 1st: 53
  • 2nd: 70
  • 3rd: 53
  • 4th: 55
  • 5th: 69
School Population
  • Teachers: 25
  • Students per Teacher: 14.2
  • Students: 355
  • Male/Female: 171/184
School District
  • ROCHESTER COMMUNITY SCHOOL DISTRICT
  • 501 WEST UNIVERSITY DR ROCHESTER, MI 48307
  • Phone: 2487263000
District Population
  • Schools: 22
  • Full-Time Teachers: 814
  • Students per Teacher: 18.4
  • Staff: 1760
  • Students: 14965
HUGGER ELEMENTARY SCHOOL 5050 SHELDON RD ROCHESTER, MI 48306 Phone: 2487263800 K-5th
Grade Size Distribution
  • Knd: 85
  • 1st: 74
  • 2nd: 89
  • 3rd: 81
  • 4th: 87
  • 5th: 91
School Population
  • Teachers: 28
  • Students per Teacher: 18.1
  • Students: 507
  • Male/Female: 263/243
School District
  • ROCHESTER COMMUNITY SCHOOL DISTRICT
  • 501 WEST UNIVERSITY DR ROCHESTER, MI 48307
  • Phone: 2487263000
District Population
  • Schools: 22
  • Full-Time Teachers: 814
  • Students per Teacher: 18.4
  • Staff: 1760
  • Students: 14965
MUSSON ELEMENTARY SCHOOL 3500 DUTTON RD ROCHESTER HILLS, MI 48306 Phone: 2487264200 K-5th
Grade Size Distribution
  • Knd: 59
  • 1st: 62
  • 2nd: 61
  • 3rd: 69
  • 4th: 75
  • 5th: 76
School Population
  • Teachers: 26
  • Students per Teacher: 15.5
  • Students: 402
  • Male/Female: 220/182
School District
  • ROCHESTER COMMUNITY SCHOOL DISTRICT
  • 501 WEST UNIVERSITY DR ROCHESTER, MI 48307
  • Phone: 2487263000
District Population
  • Schools: 22
  • Full-Time Teachers: 814
  • Students per Teacher: 18.4
  • Staff: 1760
  • Students: 14965

Private Schools in Zip Code 48306 (Rochester)

* This list of schools may not match the property above.

OAK ARBOR CHURCH SCHOOL 4535 Oak Arbor Dr Rochester, MI 48306 Phone: 2486523420 1st-6th
Grade Size Distribution
  • 1st: 3
  • 2nd: 7
  • 3rd: 1
  • 4th: 5
  • 5th: 6
  • 6th: 2
School Population
  • Teachers: 0
  • Students per Teacher: N/A
  • Students: 24

* School data provided by US Department of Education


Listing information is provided through IDX through RealComp II Ltd. All information is deemed reliable but is not guaranteed. 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. Copyright 2018 Realcomp II Ltd. Shareholders.


* Rates and payment information listed in the mortgage calculator are provided as for general reference only. Specific mortgage information should be verified with a qualified lending professional