Perched atop over 4 breathtaking acres on the bluffs in the prestigious Hawthorne Estates subdivision and located in the Northern portion of the highly sought-after Columbia School District, this extraordinary estate offers a rare combination of luxury, privacy, and versatility. Nestled among mature trees and no neighbors in sight behind the home, this is truly one of the most unique residential opportunities available in Columbia. Boasting an impressive 8 bedrooms and 6 bathrooms, this sprawling 2½-story residence was designed to accommodate large families, multi-generational living, entertaining on a grand scale, and everything in between. From the moment you arrive, you'll be captivated by the home's commanding modern-styled presence, expansive wrap-around porch, and impeccably maintained grounds. The resort-inspired backyard is an entertainer's dream, featuring an L-shaped in-ground pool with slide, spacious concrete surround (you could fit 20+ lounge chairs), outdoor kitchen, hot tub, pool house, outdoor shower, built-in fire pit, tree house, playset, and endless green space for play, pets, gardening, or future expansion. Whether hosting summer gatherings or enjoying a quiet evening under the stars, this outdoor retreat delivers an unmatched lifestyle experience. Inside, the main level welcomes you with a warm yet elegant atmosphere. The front living room is anchored by a beautiful fireplace, while the dining room provides the perfect setting for holidays and special occasions. The rear great room, complete with its own fireplace, creates a cozy gathering space and is openly designed to connect the spectacularly updated chef's kitchen. Thoughtfully designed for both everyday living and entertaining, the kitchen features stainless appliances, an exterior-vented hood, pot filler, tiled backsplash, solid-surface countertops, and abundant cabinetry and workspace. The main floor also includes a laundry room, half bath, and access to a remarkable private in-law suite. This separate, yet connected suite features a spacious family room with built-in bar/kitchenette along with its own exterior entrance, while the upper level offers a loft-style bedroom with walk-in closet, updated bath, and private deck overlooking the picturesque backyard and surrounding trees. The second level of the main residence showcases four generously sized bedrooms, including an exceptional primary suite complete with a fireplace, luxurious spa-inspired bath (full gut renovation almost completed & will be within 30 days), sprawling walk-in closet hosting ample custom storage, and private deck. An adjoining bedroom to the primary offers the perfect nursery, home office, or owner's retreat. Two additional bedrooms and a full bath featuring a tiled-walk in shower complete the the second story. The third level provides even more flexibility with three additional bedrooms, another full bath, and a unique finished storage area ideal for a playroom, kid's hobby space, or the oppurtunity to create a "secret room" every child or "kid-at-heart" has dreamed of! Throughout the home, you'll find neutral paint colors, modern finishes, and beautifully maintained hardwood floors that enhance its timeless character. Additional features include a full walk-up basement with finished half bath, oversized driveway with extensive parking, detached garage, geothermal hvac, recently replaced roof/siding, contemporary aesthetics, plus solar panels that will be owned outright by the new owners, contributing to impressively low utility costs. Properties of this caliber rarely become available. Combining acreage, privacy, luxury amenities, energy efficiency, and extraordinary living space, this one-of-a-kind estate offers a lifestyle that simply cannot be replicated. If you've been searching for the ultimate family compound in Columbia, this remarkable property deserves your attention. Less than 20 minutes from downtown STL & 12 minutes from South County!