Back arrow
Real Estate Brokerage

Menu
default user icon
Saved Homes Saved Searches My Properties My Profile Sign Out
855.375.4001
Listing Courtesy of: Lia LoChirco - LoChirco Realty, LLC 248-895-9429
$1,280,000 affordable loan icon Calculate Payment

Majestic Rochester, MI 48306

Down payment assistance icon
Single Family Residence
4 Beds
7 Baths
... Bed/Bath
4,733 Sq. Ft.
save icon Save save icon Save share icon Share checkmark icon Get Pre-Approved

Property Activity

Time on Site
days
Days on Market
Views
Saves
Last updated on 10/3/2026 12:50 AM

Listing Details

CLEAR CREEK ROCHESTER HILLS -- Exceptional Pat Stewart-built custom colonial offering approx. 7,300 sq ft across three beautifully finished levels. Built with substantial materials and exceptional craftsmanship, featuring extensive crown molding and custom millwork, solid-core wood doors, solid-wo...od cabinetry, premium Andersen windows and hardwood flooring. Dramatic 18-ft two-story foyer with open staircase leads to a breathtaking great room with soaring ceiling, floor-to-ceiling windows, automated Hunter Douglas shades and dual-sided fireplace shared with the kitchen. Chef's kitchen features oversized island, granite, GE Monogram appliances, abundant cabinetry and walk-in pantry. Butler's pantry offers additional cabinetry, glass-front displays, granite, prep sink and wine storage. Rare upper-level design--EVERY BEDROOM IS A PRIVATE EN SUITE with full bath and walk-in closet. Expansive primary retreat features sitting area, two walk-in closets and spacious private bath. Main level also offers formal living and dining rooms, private library, two powder rooms and beautifully appointed windowed laundry room. Professionally finished daylight lower level features SECOND KITCHEN & BAR, recreation, game and media areas, built-ins, full bath, exercise room, abundant storage and windowed flex room with potential as a 5th bedroom, office or hobby space. Whole-house sound extends throughout all three levels and patio. Zoned HVAC, alarm system, 3-car garage and widened driveway. One of the few Clear Creek homes backing to a wooded common area with Stony Creek beyond, offering an expansive sodded area, natural backdrop and exceptional privacy with no homes directly behind. NEW ROOF 2025 with CertainTeed Landmark shingles and 50-year limited warranty; furnace and high-efficiency water heater 2023; interior paint 2024; widened driveway 2026. Custom construction, premium materials, thoughtful design and a truly distinctive setting. Continue reading
Source MLS
MiRealSource
Originating MLS
RealComp
MLS#
61026808
Property Type
Single Family
Bedrooms
4
Bathrooms
5 Full/2 Half
Year Built
2008
Square Feet
4,733 sq. ft
Price per Sq. Ft.
$270.44
Lot Size
0.35
See more listing details   See less listing details  

Mortgage Calculator

scales icon

How much home can I afford?

Kickstart your home search journey with our online Pre-Approval.

Get Started
megaphone icon

See How Much You Could Save

Thinking about buying or selling? Talk to one of our Mortgage Professionals today to see how much you could save on your next home. Call us at 833-685-2565.

Let's Talk
Listing Courtesy of: Lia LoChirco - LoChirco Realty, LLC 248-895-9429
Andrea D. Conner, License 6502432340, Xome Inc., License 6505376883, [email protected], 844-400-XOME (9663), 71 Walnut, Suite 206, Rochester, MI 48307

Provided through IDX via MiRealSource. Courtesy of MiRealSource Shareholder. Copyright MiRealSource. The information published and disseminated by MiRealSource is communicated verbatim, without change by MiRealSource, as filed with MiRealSource by its members. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified. Copyright 2026 MiRealSource. All rights reserved. The information provided hereby constitutes proprietary information of MiRealSource, Inc. and its shareholders, affiliates and licensees and may not be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopy, recording, scanning or any information storage and retrieval system, without written permission from MiRealSource, Inc. Provided through IDX via MiRealSource, as the “Source MLS”, courtesy of the Originating MLS shown on the property listing, as the Originating MLS. The information published and disseminated by the Originating MLS is communicated verbatim, without change by the Originating MLS, as filed with it by its members. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified. Copyright 2026 MiRealSource. All rights reserved. The information provided hereby constitutes proprietary information of MiRealSource, Inc. and its shareholders, affiliates and licensees and may not be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopy, recording, scanning or any information storage and retrieval system, without written permission from MiRealSource, Inc.
This content last refreshed on 10/3/2026 12:50 AM. Some properties which appear for sale on this web site may subsequently have sold or may no longer be available.
Information is deemed reliable but is not guaranteed.
Xome Real Estate and Auction Licensing © Xome Inc.; Xome Realty Services LLC. All rights reserved. Xome Inc./Xome CT LLC (Davis E. Owen, Sr.- Broker)(CT properties only)/Xome PR LLC (PR properties only)/ Xome OH LLC (OH properties only), 750 Highway 121 BYP, Suite 100, Lewisville, TX 75067. Use of this Website constitutes acceptance of the Terms of Use and Privacy Policy. By searching you agree to the end user license agreement (TOU).
© Nationstar Mortgage LLC d/b/a Mr. Cooper. Mr. Cooper is a registered service mark of Nationstar Mortgage LLC. NMLS: #2119 NMLS Consumer Access (www.nmlsconsumeraccess.org). Mr. Cooper licensing information (www.mrcooper.com/legal). This site is not authorized by the New York State Department of Financial Services. No mortgage loan applications for properties located in the state of New York will be accepted through this site.
save icon Save
save icon Save
share icon Share
checkmark icon Get Pre-Approved