Upgrade
Photo 1 of 51 of 3787 LOCUST Drive house
Photo 2 of 51 of 3787 LOCUST Drive house
Photo 3 of 51 of 3787 LOCUST Drive house
Photo 4 of 51 of 3787 LOCUST Drive house
Photo 5 of 51 of 3787 LOCUST Drive house
Photo 6 of 51 of 3787 LOCUST Drive house
Photo 7 of 51 of 3787 LOCUST Drive house
Photo 8 of 51 of 3787 LOCUST Drive house
Photo 9 of 51 of 3787 LOCUST Drive house
Photo 10 of 51 of 3787 LOCUST Drive house
Photo 11 of 51 of 3787 LOCUST Drive house
Photo 12 of 51 of 3787 LOCUST Drive house
Photo 13 of 51 of 3787 LOCUST Drive house
Photo 14 of 51 of 3787 LOCUST Drive house
Photo 15 of 51 of 3787 LOCUST Drive house
Photo 16 of 51 of 3787 LOCUST Drive house
Photo 17 of 51 of 3787 LOCUST Drive house
Photo 18 of 51 of 3787 LOCUST Drive house
Photo 19 of 51 of 3787 LOCUST Drive house
Photo 20 of 51 of 3787 LOCUST Drive house
Photo 21 of 51 of 3787 LOCUST Drive house
Photo 22 of 51 of 3787 LOCUST Drive house
Photo 23 of 51 of 3787 LOCUST Drive house
Photo 24 of 51 of 3787 LOCUST Drive house
Photo 25 of 51 of 3787 LOCUST Drive house
Photo 26 of 51 of 3787 LOCUST Drive house
Photo 27 of 51 of 3787 LOCUST Drive house
Photo 28 of 51 of 3787 LOCUST Drive house
Photo 29 of 51 of 3787 LOCUST Drive house
Photo 30 of 51 of 3787 LOCUST Drive house
Photo 31 of 51 of 3787 LOCUST Drive house
Photo 32 of 51 of 3787 LOCUST Drive house
Photo 33 of 51 of 3787 LOCUST Drive house
Photo 34 of 51 of 3787 LOCUST Drive house
Photo 35 of 51 of 3787 LOCUST Drive house
Photo 36 of 51 of 3787 LOCUST Drive house
Photo 37 of 51 of 3787 LOCUST Drive house
Photo 38 of 51 of 3787 LOCUST Drive house
Photo 39 of 51 of 3787 LOCUST Drive house
Photo 40 of 51 of 3787 LOCUST Drive house
Photo 41 of 51 of 3787 LOCUST Drive house
Photo 42 of 51 of 3787 LOCUST Drive house
Photo 43 of 51 of 3787 LOCUST Drive house
Photo 44 of 51 of 3787 LOCUST Drive house
Photo 45 of 51 of 3787 LOCUST Drive house
Photo 46 of 51 of 3787 LOCUST Drive house
Photo 47 of 51 of 3787 LOCUST Drive house
Photo 48 of 51 of 3787 LOCUST Drive house
Photo 49 of 51 of 3787 LOCUST Drive house
Photo 50 of 51 of 3787 LOCUST Drive house
Photo 51 of 51 of 3787 LOCUST Drive house
Explore 3D tour

Brett Matusz · Max Broock, REALTORS®-Bloomfield Hills

  • Overview

  • Monthly cost

  • Get pre-approved

  • Sales & tax history

  • Schools

  • Fees & commissions

  • Related

  • Intelligence reports

Save

ActiveOpen house: Sun, Sep 1 · 5-7 AM

Buy a houseat 3787 LOCUST Drive, Oakland Twp, MI 48363

$999,980

$0/mo

Get pre-approved

Residential

3,031 Sq. Ft.

0 Sq. Ft. lot

5 Bedrooms

4 Bathrooms

264 Days on market

20240062119 MLS ID

Click to interact

Property position on map

Click the map to interact

Intelligence

Investor Highlights
Price per square foot history
Property sales history

Subscribe to Intelligence

Discover advanced property insights, stats and many more.

Learn More

About 3787 LOCUST Drive house

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, Hardie 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. Rochester schools!
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, Hardie 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. Rochester schools!

Open houses

Sun, Sep 1, 5:00 AM - 7:00 AM

Sun, Aug 25, 4:00 AM - 6:00 AM

Sun, Sep 8, 5:00 AM - 7:00 AM

Property details

Appliances

Humidifier

Water Softener

Microwave

Washer

Dishwasher

Dryer

Refrigerator

Cooling

Ceiling Fan(s)

Central Air

Fireplace features

Dining Room

Family Room

Great Room

Heating

Forced Air

Interior features

Central Vacuum

Sound System

Lot features

Rolling Slope

Irregular Lot

Wooded

Parking features

Attached

Patio and porch features

Deck

Patio

Porch

Covered

Pets allowed

Yes

Road surface type

Gravel

Roof

Asphalt

Utilities

Cable Available

Monthly cost

Estimated monthly cost

$7,022/mo

All calculations are estimates and provided by Unreal Estate, Inc. for informational purposes only. Actual amounts may vary.

Sale and tax history

Sales history

Date

May 4, 2001

Price

$390,000

DatePrice
May 4, 2001$390,000

Schools

This home is within the Rochester Community School District.

Oakland & Rochester Hills & Lake Orion enrollment policy is not based solely on geography. Please check the school district website to see all schools serving this home.

Private schools

Seller fees & commissions

Home sale price

$

Outstanding mortgage

$

Selling with traditional agent

Selling with Unreal Estate agent

Your total sale proceeds$939,981

+$29,999

$969,981

Seller agent commission$29,999 (3%)*

$0 (0%)

Buyer agent commission$29,999 (3%)*

$29,999 (3%)*

*Commissions are based on national averages and not intended to represent actual commissions of this property All calculations are estimates and provided by Unreal Estate, Inc. for informational purposes only. Actual amounts may vary.

Get $29,999 more selling your home
with an Unreal Estate agent

Start free MLS listing
View related pages

State

  • Land for sale in Michigan
  • Mobile homes in Michigan
  • Real Estate in Michigan

Unreal Estate checked: Sep 10, 2024 at 1:33 p.m.

Data updated: Sep 8, 2024 at 7:21 p.m.

Learn more about this property

Request edits for this property

By proceeding, you consent to receive calls and texts at the number you provided, including marketing by autodialer and prerecorded and artificial voice, and email, from unrealestate.com and others about your inquiry and other home related matters, but not as a condition of any purchase.
*By checking this box, I confirm that I am the legal owner of the property listed. Please note, all information is verified for accuracy per U.S. real estate regulations, and submissions from non-owners cannot be processed.

Properties near 3787 LOCUST Drive

Unreal Estate stacked logo

About

BuySellMortgageAgentsCompany

Updated January 2023: By using this website, you agree to our Terms of Service, and Privacy Policy.

⁠Unreal Estate holds real estate brokerage licenses under the following names in multiple states and locations:
Unreal Estate LLC (f/k/a USRealty.com, LLP)
Unreal Estate LLC (f/k/a USRealty Brokerage Solutions, LLP)
Unreal Estate Brokerage LLC
Unreal Estate Inc. (f/k/a Abode Technologies, Inc. (dba USRealty.com))
Main Office Location: 991 Hwy 22, Ste. 200, Bridgewater, NJ 08807
California DRE #01527504
New York § 442-H Standard Operating Procedures
TREC: Info About Brokerage ServicesConsumer Protection Notice

UNREAL ESTATE IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT.

If you are using a screen reader, or having trouble reading this website, please call Unreal Estate Customer Support for help at 1-866-534-3726 
Open Monday – Friday 9:00 – 5:00 EST with the exception of holidays.

*See Terms of Service for details.

LinkedIn Social IconInstagram social iconFacebook social icontwitter social iconYoutube Social Icon

© 2023 Unreal Estate Inc. All Rights Reserved.

Unreal Estate certified trust badge
LinkedIn Social IconInstagram social iconFacebook social icontwitter social iconYoutube Social Icon