A Stunning like new Modern Farmhouse in Downtown Alpharetta on an unprecedented size lot! This walk-out main-level oasis is what every discerning buyer is looking for. Custom-built and designed for entertaining and everyday living. Starting at the front door the 10 ft double metal doors and sidelights create a grand entrance from the covered bluestone porch with gas lanterns. The 2-story foyer is flanked by a custom metal railing staircase, exquisite made metal lighting, and Designer hardwood floors, vaulted Family room w/wood burning fireplace is open to the Chef's kitchen with massive island, 48" gas range and refrigerator, custom vent hood, floating shelves that match the beautiful beams. The primary suite is on the main with detailed brick accent walls. The spa-like bathroom offers double vanities, custom cabinets, an oversized shower & a soaking tub. Light-filled large walk-in closet. Two covered outdoor living spaces include a kitchen w/gas grill & built-in egg, counter seating overlooking the pool. The main Lanai has a wood-burning fireplace and tv mount for evening events. A backyard with a heated pebble-tec, saltwater pool & Hottub, split rail fencing, and luxurious landscaping for play, pets, and privacy (this is one of the largest lots in the community). The terrace level is finished w/stained concrete floors, custom wood plank & brick walls, exercise room, billiard room, media room, wet bar, bedroom & full bath along with unfinished storage. One of the best locations to Fabulous Downtown Alpharetta via a city cut through at the end of Upshaw/Meadow drive.