Rare multi-generational home or premium family home with investment opportunity. Nestled in a highly desirable St. Clair neighborhood! This expansive home beautifully blends classic character with incredible modern updates. The carpet-free main level showcases brand-new engineered hardwood, original oak trim, a gas fireplace with remote and an ornate mantle, and an updated 4-pc bath with floor-to-ceiling tile & main floor bedroom or home office. The second level serves as a self-contained suite, complete with its own modern kitchen, family room, luxury 4-pc bath featuring a clawfoot tub, a primary bedroom with a private balcony, and a separate entrance with a fire escape. Hidden from sight is a rough in for a second floor laundry. The third-floor attic retreat offers two additional bedrooms and a 2-pc bath, highlighted by a walk-out to a massive 14' x 15' private composite deck with escarpment views. Major structural peace of mind includes new shingles (Spring 2025), a brand-new asphalt driveway (Fall 2025), a 200-amp main panel, and a rebuilt composite front porch. The solid stone basement offers a walk-out and excellent storage. Add peace of mind with a complete security system along with cameras protecting both the home and garage. The ultimate showstopper is the detached triple-car garage and loft! Spanning roughly 800 sqft of total space, it features a separate 60-amp panel, 220V power for heavy equipment, and endless potential for a premium workshop, studio, or luxury car collection. Don't miss the endless possibilities of this unique property!