5174 Barrington Drive $2,700,000

    Close

    5174 Barrington Drive Rochester, MI 48306

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

    $2,700,000

    Request Info
    Days On Market: 288 72 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
    • BuildingFeatures
      • 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

    Contact

    Leslie Mihalak

    Sales Associate

    RE/MAX Defined

    Cell: 248-892-4300

    Neighborhood

    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

    $335,000 Median Sales Price
    5 Homes Sold
    72 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
        11/26/2018 10:41:40 AM Price Reduced Source New Value: $2,700,000 -6.9%
        8/5/2018 8:43:00 PM New in Database Source New Value: $2,900,000

        Payment Calculator

        $0 per month
        Year Fixed, Interest
        Principal and Interest
        $0
        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.