2440 Concord Creek TRL Pending

Cumming,GA 30041

$ 1749900

6 Beds

5 Baths

7630 SqFt


Key Details

Property Type Single Family Home

Sub Type Single Family Residence

Listing Status Pending

Purchase Type For Sale

Square Footage 7,630 sqft

Price per Sqft $229

Subdivision Creekstone Estates

MLS Listing ID 7468211

Style Traditional

Bedrooms 6

Full Baths 5

Construction Status Resale

HOA Fees $1,700

HOA Y/N Yes

Originating Board First Multiple Listing Service

Year Built 2006

Annual Tax Amount $11,563

Tax Year 2023

Lot Size 0.790 Acres

Acres 0.79

Property Description

Nestled on a quiet cul-de-sac premium lot, this breathtaking brick and stone residence delivers unrivaled luxury and convenience. With a rare 4 ½-car garage and an exceptional location, the home showcases dramatic 10-foot-plus ceilings and exquisite custom finishes throughout, creating a perfect blend of grandeur and warmth. This exceptional property also features a brand-new roof, adding peace of mind for years to come.

Enter through the stone porch entryway and custom solid wood front door into a dramatic two-story entrance, where you are greeted by elegant hardwood floors that flow seamlessly throughout the main level.

Step into the gourmet kitchen, a chef’s dream featuring stunning countertops, a Sub-Zero built-in refrigerator, a Wolf 6-burner gas cooktop, Wolf double convection ovens, and an elegant marble backsplash. A walk-in pantry with custom shelving provides ample storage, while the adjacent vaulted keeping room with a stone fireplace offers the ideal space for intimate gatherings or cozy nights in. Step onto the expansive covered deck, which overlooks the stunning gunite pool and hot tub—a true entertainer’s paradise.

On the main level, a full guest suite with a private bath ensures comfort and privacy, while the formal living room, complete with custom built-ins, exudes elegance. The dramatic great room is a showstopper, featuring a stunning stone fireplace, 14-foot coffered ceilings, and a wall of windows that frames views of the magnificent backyard.

Upstairs, the master suite is a serene retreat with vaulted ceilings and a brand-new spa-inspired bath. Luxuriate in heated marble floors, quartz countertops, a soaking tub, a spacious shower, and a custom closet system. A connected bonus room/office adds flexibility for work or relaxation. All secondary bedrooms offer the beauty of hardwood floors and generous space.

The daylight terrace level is designed for entertainment, featuring two media rooms—one enclosed and wired for surround sound for an immersive movie experience, and the other open for casual gatherings. A full bar equipped with premium appliances makes hosting effortless. This level also includes a bedroom that can serve as a guest room or office, along with an adjacent full bath featuring a rain shower for added convenience. Other highlights include Nest thermostats, a whole-house Pegasus water filtration system, and a spacious utility room for extra storage.

Outside, the fenced backyard is a private oasis. Enjoy a lighted basketball court with a bounce-back net for lacrosse, a charming treehouse, a putting green, and a fully equipped outdoor kitchen with a custom stone bar and fireplace. The gunite pool and hot tub with a copper poolside fire and water bowl make for the ultimate outdoor retreat.

Living in Creekstone Estates offers more than just a beautiful home. The community includes a full-time tennis pro, multiple tennis courts, pickleball, two swimming pools, a modern clubhouse, a playground, basketball courts, and an activities director who organizes events year-round. Located just minutes from Route 400, The Collection, and Halcyon, this home also offers the convenience of Alpharetta living with the advantage of low Forsyth County taxes.

This exceptional property combines luxury, lifestyle, and location—an opportunity not to be missed!

Location

State GA

County Forsyth

Lake Name None

Rooms

Bedroom Description Oversized Master,Sitting Room,Other

Other Rooms Outdoor Kitchen,Other

Basement Daylight,Exterior Entry,Finished,Finished Bath,Full,Walk-Out Access

Main Level Bedrooms 1

Dining Room Seats 12+,Separate Dining Room

Interior

Interior Features Beamed Ceilings,Bookcases,Cathedral Ceiling(s),Coffered Ceiling(s),Crown Molding,Disappearing Attic Stairs,Double Vanity

Heating Forced Air,Natural Gas

Cooling Attic Fan,Ceiling Fan(s),Central Air

Flooring Carpet,Ceramic Tile,Hardwood,Marble

Fireplaces Number 3

Fireplaces Type Basement,Electric,Family Room,Gas Starter,Great Room,Keeping Room

Window Features Bay Window(s),Double Pane Windows,ENERGY STAR Qualified Windows

Appliance Dishwasher,Disposal,Double Oven,ENERGY STAR Qualified Water Heater,Gas Cooktop,Gas Oven,Gas Range,Gas Water Heater,Microwave,Refrigerator,Self Cleaning Oven

Laundry Laundry Room,Upper Level

Exterior

Exterior Feature Gas Grill,Lighting,Private Entrance,Private Yard

Garage Attached,Driveway,Garage,Garage Door Opener

Garage Spaces 4.0

Fence Back Yard,Wrought Iron

Pool Gunite,Heated,In Ground

Community Features Clubhouse,Fitness Center,Homeowners Assoc,Near Schools,Near Shopping,Near Trails/Greenway,Pickleball,Playground,Pool,Sidewalks,Street Lights,Tennis Court(s)

Utilities Available Cable Available,Electricity Available,Natural Gas Available,Phone Available

Waterfront Description None

View Pool,Trees/Woods

Roof Type Composition

Street Surface Paved

Accessibility None

Handicap Access None

Porch Covered,Deck,Front Porch,Patio,Rear Porch,Rooftop

Parking Type Attached,Driveway,Garage,Garage Door Opener

Private Pool false

Building

Lot Description Back Yard,Cul-De-Sac,Front Yard,Landscaped,Level,Sprinklers In Front

Story Three Or More

Foundation Brick/Mortar

Sewer Public Sewer

Water Public

Architectural Style Traditional

Level or Stories Three Or More

Structure Type Block,Brick 4 Sides,Stone

New Construction No

Construction Status Resale

Schools

Elementary Schools Shiloh Point

Middle Schools Piney Grove

High Schools Denmark High School

Others

HOA Fee Include Security,Swim,Tennis,Trash

Senior Community no

Restrictions true

Tax ID 110 247

Ownership Fee Simple

Acceptable Financing Cash,Conventional

Listing Terms Cash,Conventional

Special Listing Condition None

View More
Favorite Go Tour