Skip main navigation
Sold for $870,000
  • $870,000

    3787 Locust Dr, Oakland, MI 48363

    5beds
    4,535sqft
    Single Family Residence
    Built in 2020
    1.58 Acres Lot
    $923,900 Zestimate®
    $192/sqft
    $4,936 Estimated rent

    Home value

    $923,900

    $859,000 - $998,000

    $4,936/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $4,936/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $4,936/mo

    Rent Zestimate®

    Refinance and save

    $5,680/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $5,680/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Stone gas fireplaceFloor-to-ceiling stone gas fireplaceExtensive landscapingRolling acresHunter douglas solar shadesOpen flowing floor planFinished lower level walk-out
    GORGEOUS 2020 RE-BUILD, w/ EVERY MODERN AMENITY IMAGINABLE AND HIGH-END EVERYTHING! 4,535 TOTAL FINISHED SF IN MAIN HOME plus 960SF in the 2-STORY OUTBUILDING IS A MUST SEE! The winding driveway leads to your own private sanctuary on 1.6 glorious rolling acres. Idyllic, peaceful retreat w/ 3 PONDS and 3 WATERFALLS cascade along the firepit and stone terraces that lead down a path w/ PERSONAL DIRECT ACCESS TO THE PAINT CREEK TRAIL carved through the trees and bushes! Contemporary home, designed by owner/ engineer w/ Bloomingdale Construction & Architectural Firm. 2/3s of the home was torn down and totally re-built inside and out: PELLA, DILMAN & UPTON, WOLFE, SUBZERO, BOSCH to name drop a few! SEE 5 PAGES OF UPGRADES AND CUSTOM AMENITIES ATTACHED TO THE LISTING! Dramatic layout w/ open, flowing floor plan, vaulted ceilings, stylish neutral décor and perfect for entertaining. MAIN LEVEL: breathtaking foyer opens to GREAT ROOM with to floor-to-ceiling stone gas fireplace and 2-story, arched windows to take in the fabulous views. Dining Room and Dream Kitchen have a gas fireplace, with baywindows and large deck with views of the ponds, quartz counters and huge 15' x 6' island and walk-in pantry. Library has closets could become main level 4th bedroom. UPPER LEVEL has an incredible front to back Primary En Suite Bedroom w/ 2 incredible custom walk-in closests and Bath with both tub and shower, his and her vanities. 2 additional Bedrooms and another full Bathroom. FINISHED LOWER LEVEL WALK-OUT features Family Rm w/ stone gas FP, Sun Rm, Rec Rm, Bath, 5th Bedrm/Exercise Rm, Poss Kit. ALL NEW IN 2020: custom cabinetry, appliances, mechanicals, Pella windows & sliding patio doors, remote-controlled Hunter Douglas solar shades, solid core interior doors, 6" interior insulated walls, roof, T1-11 siding, deck, extensive landscaping and more! 2.5 gas heated attached gar plus 2 story OUTBUILDING w/ additional 1 car gar, workshop and wide stairway to second level w/ 12' ceiling. Some exclusions. Rochester schools!

    Zillow last checked:

    Listing updated:

    Listed by:

    Brett Matusz 248-644-4700,

    Max Broock, REALTORS®-Bloomfield Hills,

    Nancy Karas 248-421-2670,

    Max Broock, REALTORS®-Bloomfield Hills

    Bought with:

    Unidentified Agent

    Unidentified Office

    Source: Realcomp II,MLS#: 20240062119MLS Logo

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 5
    • Bathrooms: 4
    • Full bathrooms: 3
    • 1/2 bathrooms: 1
    Primary bedroom
    • Level: Upper
    • Dimensions: 23 x 13
    Bedroom
    • Level: Upper
    • Dimensions: 15 x 11
    Bedroom
    • Level: Upper
    • Dimensions: 15 x 11
    Bedroom
    • Level: Entry
    • Dimensions: 15 x 11
    Bedroom
    • Level: Basement
    • Dimensions: 10 x 12
    Primary bathroom
    • Level: Upper
    • Dimensions: 13 x 14
    Other
    • Level: Basement
    Other
    • Level: Upper
    Other
    • Level: Entry
    Dining room
    • Level: Basement
    • Dimensions: 17 x 14
    Dining room
    • Level: Entry
    • Dimensions: 17 x 14
    Family room
    • Level: Basement
    • Dimensions: 21 x 18
    Game room
    • Level: Basement
    • Dimensions: 21 x 16
    Great room
    • Level: Entry
    • Dimensions: 21 x 18
    Kitchen
    • Level: Entry
    • Dimensions: 21 x 16
    Laundry
    • Level: Entry
    Mud room
    • Level: Entry
    • Dimensions: 9 x 7
    Heating
    • Forced Air, Natural Gas
    Cooling
    • Ceiling Fans, Central Air
    Appliances
    • Included: Built In Electric Oven, Built In Refrigerator, Bar Fridge, Convection Oven, Dishwasher, Dryer, Gas Cooktop, Humidifier, Microwave, Self Cleaning Oven, Stainless Steel Appliances, Vented Exhaust Fan, Washer, Water Softener Owned
    • Laundry: Washer Hookup
    Features
    • Central Vacuum, Entrance Foyer, High Speed Internet, Programmable Thermostat, Sound System
    • Basement: Finished,Full,Walk Out Access
    • Has fireplace: Yes
    • Fireplace features: Dining Room, Family Room, Great Room
    Interior area
    • Total interior livable area: 4,535 sqft
    • Finished area above ground: 3,031
    • Finished area below ground: 1,504

    Property

    Parking
    • Total spaces: 3.5
    • Parking features: Threeand Half Car Garage, Attached, Detached, Garage Faces Side, Workshop In Garage
    • Attached garage spaces: 3.5
    Features
    • Levels: Three
    • Stories: 3
    • Entry location: GroundLevelwSteps
    • Patio & porch: Covered, Deck, Patio, Porch, Terrace
    • Exterior features: Chimney Caps, Lighting
    • Pool features: None
    Lot
    • Size: 1.58 Acres
    • Dimensions: 566 x 128 x 384 x 219 Irregular
    • Features: Adjacentto Public Land, Dead End Street, Hilly Ravine, Irregular Lot, Wooded
    Details
    • Additional structures: Outbuildings Allowed, Second Garage
    • Parcel number: 1020402013
    • Special conditions: Short Sale No,Standard

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Contemporary
    • Property subtype: Single Family Residence
    Materials
    • Wood Siding
    • Foundation: Basement, Poured
    • Roof: Asphalt
    Condition
    • New construction: No
    • Year built: 2020

    Utilities & green energy

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

    Community & neighborhood

    Location
    • Region: Oakland
    • Subdivision: SUPRVR'S PLAT OF BARNEL SUB

    Other

    Other facts
    • Listing agreement: Exclusive Right To Sell
    • Listing terms: Cash,Conventional

    Price history

    DateEventPrice
    12/18/2024Sold$870,000-13%$192/sqft
    Source: Realcomp II #20240062119 Report a problem
    12/6/2024Pending sale$999,980$221/sqft
    Source: Realcomp II #20240062119 Report a problem
    8/21/2024Listed for sale$999,980-7.4%$221/sqft
    Source: Realcomp II #20240062119 Report a problem
    8/21/2024Listing removed--
    Source: Realcomp II #20240052341 Report a problem
    7/20/2024Listed for sale$1,080,000+176.9%$238/sqft
    Source: Realcomp II #20240052341 Report a problem
    3/29/2001Sold$390,000$86/sqft
    Source: MiRealSource #823443 Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2024$5,054 +2.5%$342,850 +6.9%
    2023$4,929 +7.3%$320,800 +7.9%
    2022$4,595 -6.3%$297,330 +2.7%
    2021$4,904 $289,530 -0.1%
    2020-- $289,860 +5.3%
    2019$4,849 +35.5%$275,390 +39.8%
    2018$3,579 +0.5%$197,050 +3%
    2017$3,560 $191,280 +5.3%
    2016$3,560 $181,720 +8.3%
    2015-- $167,860 +13.1%
    2014-- $148,470 +24.7%
    2011-- $119,030 -5.1%
    2010$3,639 -17.8%$125,490 -22.2%
    2009$4,426 +79.8%$161,210 -54.6%
    2005$2,462 $355,470 +91.1%
    2003-- $186,000 +5.1%
    2002-- $177,050 +41.2%
    2001$3,420 +10.4%$125,410 +3.2%
    2000$3,097 $121,530

    Find assessor info on the county website

    Neighborhood: 48363

    Nearby schools

    GreatSchools rating
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $923,900
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $923,900