EXCEPTIONALLY RARE OPPORTUNITY to SECURE the "Idea Show House" Model in Prestigious & Highly Desirable Clear Creek! Featuring over 7,000 Square Feet of Finished Living Space. Inspired Design meets Timeless Luxury & Functionality. Unique Floor Plan w/Grand Raised Study w/Turret & Built-In Floor to Ceiling Shelves. 4 Bdrms, 4 Full & 2 Half Baths. EXTENSIVE Upgrades Include 10’ Entry Door, STUNNING 2 Story Foyer Flooded w/Natural Sunlight, Tile & Hardwood Flooring. Wrought Iron Stairway Detail, Millwork, Crown Molding, Coffered Ceiling, Solid Wood Doors, Designer Light Fixtures, Custom Closet Systems, Entertainers Dream Kitchen w/DuraSupreme Cabinetry, Expansive Quartz Island & Counters, Custom Backsplash, Sub Zero & Wolf Appliances, Warming Drawer, Steamer, Butlers Pantry, Wine Grotto w/Waterfall & Pet Room w/Shower. Great Room w/Gas Fireplace & Impressive Custom Mantle, Built-In Wood Shelving & Exquisite Coffered Ceiling. Heated Loggia Off Kitchen, Formal Dining Room w/Fireplace, Breathtaking Luxurious Primary Suite w/Lounge Area, Double Sided Fireplace w/Soaking Tub & Shower, His & Hers Walk-In Closets, 1 Bedroom w/Ensuite, 2 Bedrooms w/Jack-and-Jill & Laundry Room. Finished Walk-Out Basement w/ Indoor Sport Gym, Hidden Room w/Leather Flooring, Locker Room & Full Bath. Courtyard Driveway w/3 Car Side-Turned Heated Garage w/Epoxy Floors & Office Space. Luxury Home w/Extensive Professional Landscaping, Impeccable Design & Extraordinary Craftsmanship.
Listing Snapshot
Inside Area (SqFt)
7,156 sqft
HOA/Condo/Coop Fees
$41.67 monthly
Sq Ft Source
Public Records
Recent Activity
| 6 days ago | | Listing first seen on site |
| 6 days ago | | Listing updated with changes from the MLS® |
General Features
Cross Street
E Tienken & Sheldon
Disclosures
Exclusions Do Not Exist, No Restrictions, Taxes Homestead Exempt
Parking
AttachedElectric Vehicle Charging Station(s)Direct AccessDrivewayHeated GarageGarage Door OpenerOversizedGarage Faces Side
Pets
CallCats OKDogs OKYes
Property Sub Type
Single Family Residence
Security
Security System LeasedSmoke Detector(s)
Special Circumstances
Standard
Utilities
Cable AvailableUnderground Utilities
Interior Features
Appliances
Gas Water HeaterBuilt-In Electric OvenBar FridgeDishwasherDisposalDryerFree-Standing Gas OvenFree-Standing Gas RangeHumidifierIce MakerMicrowaveOtherRange HoodStainless Steel Appliance(s)WasherWine Refrigerator
Basement
FinishedFullWalk-Out Access
Fireplace Features
Dining RoomFamily RoomGasMaster Bedroom
Heating
Forced AirNatural Gas
Interior
High Speed InternetSound SystemWet BarSmart ThermostatWaterSense Fixture(s)
Laundry Features
Gas Dryer HookupLaundry RoomWasher Hookup
BathDualEntry
Dimensions - 20 X 12Level - Second
BathFull
Dimensions - 13 X 5Level - Basement
BathLav
Dimensions - 8 X 6
BathOther
Dimensions - 8 X 5
Bedroom
Dimensions - 17 X 15Level - Second
BreakfastNookRoom
Dimensions - 19 X 11
ButlersPantry
Dimensions - 7 X 5
Dining Room
Dimensions - 19 X 14
Family Room
Dimensions - 19 X 16
FlexRoom
Dimensions - 18 X 12Level - Basement
Game Room
Dimensions - 26 X 22Level - Basement
Kitchen
Dimensions - 19 X 13
Kitchen2nd
Dimensions - 18 X 9Level - Basement
Laundry
Dimensions - 11 X 8Level - Second
Library
Dimensions - 16 X 12Level - Second
Living Room
Dimensions - 30 X 24Level - Basement
Master Bathroom
Dimensions - 21 X 16Level - Second
Master Bedroom
Dimensions - 21 X 12Level - Second
MudRoom
Dimensions - 19 X 9
SittingRoom
Dimensions - 14 X 10Level - Second
Exterior Features
Construction Details
AsphaltBrickStone
Patio And Porch
CoveredPatioTerrace
Community Features
Building Access
GroundLevelwSteps
Financing Terms Available
CashConventional
HOA Fee Frequency
Annually
MLS Area
Area02151RochesterHills
School District
Rochester
Listing courtesy of Arterra Realty Michigan LLC:
[email protected]
IDX provided courtesy of Realcomp II Ltd. via
RealcompIILtd. Copyright © 2026 Realcomp II Ltd. Shareholders.
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 and that the data is deemed reliable but not guaranteed accurate by the MLS.
Source: Walkscore
Did you know? You can invite friends and family to your search. They can join your search, rate and discuss listings with you.