If you need assistance, please call 586-202-0499

  • DESCRIPTION

    Immaculate Pat Stewart-built Estate in Clear Creek Subdivision. One of very few homes in Clear Creek that back up to Stoney Creek (the creek not the High School). The lot is incredibly private. A large common area behind the lot is sodded and used as if owned by the homeowner. Original owners are retiring and selling this wonderful family home. Spectacular curb appeal with professional lush landscaping. Grand front entrance leads to a bright 2-story Foyer with a grand open staircase. Every detail in this incredible colonial is done to perfection. The spectacular millwork will astound you. The Chef's Kitchen has a huge island, granite countertops, built-in gas cooktop, stainless steel appliances, wine storage and so much more. Formal Dining Room has a beautiful Butler Pantry that leads to the Kitchen. Family Room with dual fireplace and floor-to-ceiling windows. Two conveniently located Powder Rooms (one formal, one casual) are on the main level. The Master Retreat with a Sitting Area overlooks the backyard. All 4 upper-level Bedrooms have their own private Baths & Walk-in Closets. The beautifully finished Lower Level is an open concept and boasts a Bar/Kitchen, full Bath, Recreation Area, Exercise Area (this could easily be converted to a 5th Bedroom with windows) & ample amounts of storage. The two furnaces are electronically dampered and each floor has its own zone keeping the entire home comfortable no matter the time of year.

    KEY DETAILS
    • Price:
    • $1,079,000
    • Bedrooms:
    • 4
    • Full Baths:
    • 5
    • Half Baths:
    • 2
    • Square Footage:
    • 4,733
    • Acreage:
    • 0.35
    • Year Built:
    • 2008
    • MLS #:
    • 20221004594
    • Street Address:
    • 739 Majestic
    • City:
    • Rochester Hills
    • State:
    • MI
    • Postal Code:
    • 48306
    • County:
    • Oakland
    • Area:
    • Rochester Hills
    • Subdivision:
    • Clear Creek Sub No 1
    • Listing Status:
    • For Sale - Pending

    Building

    • Architecture Style:
    • Colonial
    • Basement Type:
    • Daylight, Finished
    • Exterior Features:
    • Lighting
    • Fireplace:
    • 1
    • Fireplace Location:
    • Double Sided, Family Room, Kitchen
    • Foundation:
    • Basement
    • Foundation Material:
    • Poured
    • Has Basement:
    • 1
    • Interior Features:
    • Other, Programmable Thermostat, Sound System, Wet Bar, Laundry Facility, De-Humidifier, Cable Available, Egress Window(s)
    • Porch Description:
    • Porch - Covered, Patio, Porch
    • Siding:
    • Brick, Stone, Wood
    • Stories:
    • 2 Story
    • Total Building Square Footage:
    • 4733
    • Type Of Roof:
    • Asphalt
    • Year Built:
    • 2008

    Land

    • Lot Features:
    • Sprinkler(s), Wooded
    • Road Frontage:
    • 112
    • Road Frontage Type:
    • Paved, Pub. Sidewalk

    Listing

    • Days On Market:
    • 18
    • Financing Options:
    • Cash, Conventional
    • For Sale Or Lease?:
    • Sale

    Money

    • Association Fee Payment Frequency:
    • Annually
    • Hoa Fee Includes:
    • Insurance
    • Hoa Y/N:
    • 1
    • Summer Tax:
    • 5767.0000
    • Winter Tax:
    • 4588.0000

    Rooms

    • Kitchen Appliances:
    • Built-In Electric Oven, Dishwasher, Disposal, Dryer, Exhaust Fan, Free-Standing Refrigerator, Gas Cooktop, Microwave, Range Hood, Stainless Steel Appliance(s), Washer
    • Total Rooms:
    • 21

    Structures

    • Garage Description:
    • Direct Access, Door Opener, Side Entrance, Attached
    • Garage Dimensions:
    • 33 X 21
    • Garage Type:
    • 3 Car
    • Has Garage:
    • 1

    Systems

    • Cooling System:
    • Ceiling Fan(s), Central Air
    • Existing Water:
    • Public (municipal)
    • Heating:
    • Forced Air
    • Heating Fuel:
    • Natural Gas
    • Sewage Type:
    • Public Sewer (sewer-Sanitary)
    • Water Heater:
    • Natural Gas

    Water

    • Water Name:
    • Stony Creek
    • Waterfront Description:
    • Creek

    Source

    IDX provided courtesy of Realcomp II Ltd., via Top Agent Realty and Realcomp II Ltd, ©2022 Realcomp II Ltd. Shareholders

    FARMHILL
    REQUEST SHOWING
    SCHOOL RATINGS
    n/a

    SCHOOL DISTRICT: ROCHESTER

    NOTES

    No notes have been added for this home.

    SCORECARD

    0
    PROS
    0
    CONS
    Condition
    Location
    Nearby
    Schools
    Taxes
  • Add Note
  • Add to Notebook
  • Share