Skip main navigation
For sale
    • $2,950,099

    5165 Abbey Rd, Rochester, MI 48306

    6beds
    11,486sqft
    : 
    $19,083/mo
    Get pre-qualified
    Single Family Residence
    Built in 2002
    2.3 Acres Lot
    $2,774,900 Zestimate®
    $257/sqft
    $-- HOA

    What's special

    Gated & Private | A Timeless Estate of Uncompromising Luxury Step into a truly breathtaking, one-of-a-kind estate offering over 12,000 square feet of refined living, masterfully designed by an award-winning architect with an unwavering commitment to quality, craftsmanship, and detail. Every element of this residence reflects timeless elegance and elevated luxury. The home features a MAIN-LEVEL PRIMARY SUITE suite along with an equally impressive second-floor primary suite, each over a 1,000 square feet, providing exceptional comfort and privacy. A dramatic 25- foot grand entrance sets the tone, complemented by sweeping, illuminated staircases and a multi-level ELEVATOR. Designed for both grand entertaining and everyday living, the main level showcases an exquisite library and a stunning great room highlighted by barrel-vaulted ceilings, herringbone hardwood floors, and a striking marble fireplace. The gourmet kitchen is a chef’s dream, offering dual islands, a sunlit breakfast nook, and top-tier Thermador and Sub-Zero appliances. Throughout the home, you’ll find 7 fireplaces, extensive marble, and bespoke custom molding and plasterwork, each detail thoughtfully curated. Retreat to your own year-round private oasis, featuring a spectacular INDOOR POOL AND SPA with vaulted ceilings and newly upgraded, state-of-the-art climate and humidification systems. The finished walkout lower level expands the living space with a spacious recreation room, full bar and kitchen, and a private nanny or guest suite. RECENT UPDATES: include all-new HVAC systems and professionally designed landscaping, enhancing both comfort and curb appeal. Set on over two pristine acres, this estate also includes a heated four-car garage with ceiling height suitable for automotive lifts, making it ideal for the discerning car enthusiast. This exceptional property sets a new benchmark for luxury living: an extraordinary retreat where elegance, privacy, and sophistication converge.
    29 days
    |
    1,771
    |
    70
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Andrew F Colburn 248-320-7007,

    The Drew Colburn Real Estate Group 248-786-1777

    Source: Realcomp II,MLS#: 20261049853MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 6
      • Bathrooms: 9
      • Full bathrooms: 7
      • 1/2 bathrooms: 2
      Primary bedroom
      • Level: Second
      • Area: 544
      • Dimensions: 34 X 16
      Bedroom
      • Level: Basement
      • Area: 315
      • Dimensions: 21 X 15
      Bedroom
      • Level: Basement
      • Area: 135
      • Dimensions: 15 X 9
      Bedroom
      • Level: Second
      • Area: 180
      • Dimensions: 15 X 12
      Bedroom
      • Level: Second
      • Area: 180
      • Dimensions: 12 X 15
      Bedroom
      • Level: Second
      • Area: 180
      • Dimensions: 15 X 12
      Primary bathroom
      • Level: Second
      • Area: 286
      • Dimensions: 22 X 13
      Primary bathroom
      • Level: Entry
      • Area: 286
      • Dimensions: 22 X 13
      Other
      • Level: Basement
      • Area: 63
      • Dimensions: 9 X 7
      Other
      • Level: Second
      • Area: 60
      • Dimensions: 10 X 6
      Other
      • Level: Entry
      • Area: 88
      • Dimensions: 11 X 8
      Other
      • Level: Second
      • Area: 42
      • Dimensions: 7 X 6
      Other
      • Level: Basement
      • Area: 64
      • Dimensions: 8 X 8
      Other
      • Level: Basement
      • Area: 30
      • Dimensions: 6 X 5
      Other
      • Level: Entry
      • Area: 36
      • Dimensions: 6 X 6
      Other
      • Level: Entry
      • Area: 130
      • Dimensions: 13 X 10
      Dining room
      • Level: Entry
      • Area: 368
      • Dimensions: 23 X 16
      Family room
      • Level: Basement
      • Area: 760
      • Dimensions: 38 X 20
      Flex room
      • Level: Basement
      • Area: 322
      • Dimensions: 23 X 14
      Game room
      • Level: Basement
      • Area: 975
      • Dimensions: 39 X 25
      Game room
      • Level: Entry
      • Area: 2520
      • Dimensions: 60 X 42
      Great room
      • Level: Entry
      • Area: 740
      • Dimensions: 37 X 20
      Kitchen
      • Level: Entry
      • Area: 667
      • Dimensions: 29 X 23
      Laundry
      • Level: Entry
      • Area: 187
      • Dimensions: 11 X 17
      Library
      • Level: Entry
      • Area: 368
      • Dimensions: 23 X 16
      Living room
      • Level: Entry
      • Area: 448
      • Dimensions: 28 X 16
      Heating
      • Forced Air, Natural Gas
      Cooling
      • Ceiling Fans, Central Air
      Appliances
      • Included: Built In Refrigerator, Down Draft, Dishwasher, Double Oven, Dryer, Exhaust Fan, Gas Cooktop, Microwave, Range Hood, Washer
      • Laundry: Laundry Room
      Features
      • Elevator, Entrance Foyer, High Speed Internet, Jetted Tub, Programmable Thermostat, Spa Hottub, Wet Bar
      • Basement: Finished,Walk Out Access
      • Has fireplace: Yes
      • Fireplace features: Basement, Dining Room, Double Sided, Gas, Great Room, Living Room, Other Locations, Master Bedroom
      Interior area
      • Total interior livable area: 11,486 sqft
      • Finished area above ground: 8,936
      • Finished area below ground: 2,550

      Property

      Parking
      • Total spaces: 4
      • Parking features: Four Car Garage, Attached, Circular Driveway, Direct Access, Driveway, Electricityin Garage, Heated Garage, Garage Door Opener, Oversized, Garage Faces Side
      • Attached garage spaces: 4
      Accessibility
      • Accessibility features: Accessible Bedroom, Accessible Central Living Area, Accessible Doors, Accessible Elevator Installed, Accessible Entrance, Accessible Full Bath
      Features
      • Levels: Two
      • Stories: 2
      • Entry location: GroundLevelwSteps
      • Patio & porch: Deck, Patio, Terrace
      • Exterior features: Balcony, Chimney Caps, Lighting
      • Pool features: In Ground, Indoor
      Lot
      • Size: 2.3 Acres
      • Dimensions: 440 x 376
      Details
      • Parcel number: 1033101002
      • Special conditions: Short Sale No,Standard
      • Other equipment: Air Purifier, Dehumidifier, Satellite Dish

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Colonial,Tuscan
      • Property subtype: Single Family Residence
      Materials
      • Brick
      • Foundation: Basement, Poured
      • Roof: Asphalt
      Condition
      • New construction: No
      • Year built: 2002

      Utilities & green energy

      • Electric: Volts 220, Circuit Breakers
      • Sewer: Septic Tank
      • Water: Well
      • Utilities for property: Cable Available, Underground Utilities

      Community & HOA

      Community
      • Subdivision: DEER CREEK ESTATES OCCPN 544
      HOA
      • Has HOA: Yes
      • Services included: Maintenance Grounds, Snow Removal, Trash
      • HOA fee: $1,465 semi annually
      • HOA phone: 888-646-9888
      Location
      • Region: Rochester

      Financial & listing details

      • Price per square foot: $257/sqft
      • Tax assessed value: $1,018,950
      • Annual tax amount: $24,725
      • Date on market: 7/1/2026
      • Cumulative days on market: 176 days
      • Listing agreement: Exclusive Right To Sell
      • Listing terms: Cash,Conventional

        Estimated market value

        $2,774,900

        $2.64M - $2.91M

        $4,793/mo

        Price history

        DateEventPrice
        7/1/2026Listed for sale$2,950,099+0%$257/sqft
        Source: Realcomp II #20261049853 Report a problem
        7/1/2026Listing removed$2,950,000$257/sqft
        Source: Realcomp II #20261006319 Report a problem
        6/17/2026Price change$2,950,000-1.7%$257/sqft
        Source: Realcomp II #20261006319 Report a problem
        2/7/2026Listed for sale$2,999,950+55.8%$261/sqft
        Source: Realcomp II #20261006319 Report a problem
        7/1/2021Sold$1,925,000$168/sqft
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025$25,116 +0.3%$1,018,950 +0%
        2024$25,036 -2.2%$1,018,490 +0.3%
        2023$25,596 +17.2%$1,015,600 +0.2%
        2022$21,848 -6.3%$1,014,040 -0.8%
        2021$23,314 $1,022,380 -1.5%
        2020-- $1,037,660 +0.8%
        2019$23,054 +1.1%$1,028,980 -6.8%
        2018$22,796 +0.5%$1,103,850 +2.9%
        2017$22,678 $1,072,240 +3%
        2016$22,678 $1,041,360 +4.5%
        2015-- $996,050 +11.3%
        2014-- $894,970 +9.5%
        2011-- $817,420 -4.8%
        2010$24,897 -14.1%$858,560 -18.7%
        2009$28,983 +91%$1,055,630 -50.7%
        2005$15,176 $2,139,390 +86.8%
        2003-- $1,145,420 +13.2%
        2002-- $1,011,660 +9.1%
        2001$41,319 +39.5%$927,050 +35.1%
        2000$29,610 $686,440
        Find assessor info on the county website

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.
        Get pre-qualified

        Climate risks

        Neighborhood: 48306

        Getting around

        1 / 100
        Car-Dependent
        9 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts

        Similar homes

              Nearby cities

              Nearby zip codes

              Other Oakland Topics

                Search
                Updates
                Favorites
                Plan
                Inbox