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

5174 Barrington Drive $2,700,000


5174 Barrington Drive Rochester, MI 48306

  • 6 Beds
  • 8 Baths
  • 13,298 sq.ft.
  • Single-Family
MLS# 218074958 | Active


Request Info
Days On Market: 381 102 Views
Add to Favorites Share

Go Tour This Home

Schedule A Showing

Property Details

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 Area 0
    • 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


Linda Abraham

Associate Broker

RE/MAX Defined

Cell: 248-885-0610


48306 (Rochester) Demographics

44Median Age
1,229Population Density (per sq. mile)
73%College Educated
$129,414 Estimated Median Income
8,830Estimated Total Home Owners
847Estimated Total Renters
91% / 9%Estimated Owner / Renter Divide
3Estimated Average Household Size
27,936Total Population
Community data courtesy of LiveBy, Inc.

Market Last 30 Days

$430,000 Median Sales Price
3 Homes Sold
78 New On Market

Average Days on Market

    Properties for Sale

      Property History

      Date Event Price Percent Change
      -- Current Price Source New Value: $2,700,000
      8/5/2018 8:43:00 PM New in Database Source

      Payment Calculator

      $0 per month
      Year Fixed, Interest
      Principal and Interest
      Property Taxes
      Homeowners' Insurance

      Home Price
      Down Payment
      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 2019 Realcomp II Ltd. Shareholders.