Traditional

15060 Freemanville RD

Alpharetta , GA 30004

MLS#: 10201646

$5,900,000

Status: Closed
Listing number: 10201646
Listing provided by: None
Listing agent phone: None
Last update: 1 year, 11 months ago
On site: 2 years ago
Browse Properties
None - Residential

Property

Beds

9

Full Baths

10

1/2 Baths

2

Year Built

2004

Sq.Footage

18,759

Perfectly situated on 8 acres +/- of manicured lawns and gardens, this gated estate is the epitome of privacy and modernity. Upon entering the home, you are greeted with a winding staircase leading your eyes to the two story grand foyer. A chef's kitchen including SubZero and Wolf appliances and top of the line finishes, this kitchen provides ample space for an inviting family dinner or grand scale entertaining. Off of the kitchen is a family room with vaulted tongue and groove ceiling overlooking the pool and grounds. On the other side of the home, a fireside a gentleman's study with coffered ceilings provides privacy for meetings and the perfect office when working from home is your new normal. Off the study is a pool table complete with a mahogany paneled bar room to entertain or simply pour a scotch and shoot billiards. Privately located on the main floor the owners suite features a fireside sitting area, spa-like bath, separate His & Hers vanities and custom closets. The secondary bedrooms are all suites with walk-in closets. Custom hardwood flooring throughout the home. The Terrace level features; multiple entertaining areas including a custom bar and theatre room, exercise room, conference room, and extra billiards or gaming room. A guest suite with a full private bath, kitchen and living room. Situated adjacent to the property separate from the main home is a full guest house, offering complete and total privacy. With an added two car garage, this guest home is perfect for kids in college, in-laws, or corporate guests. Walking outside you will be blown away by the beautiful lanai with kitchen, multiple covered porches and dining areas. The pool can be heated with waterfall accents and a spa. Past the pool, you will be swept away by acres and acres of flat, green lawns backing up to wooded forest full of visiting deer and other wildlife not seen in typical city life. This is truly a one of a kind property where every need or purposes can be served, all without leaving your home. Bedroom, bathroom and square footage includes the guest house.

Features & Amenities

Interior

  • Other Interior Features

    Breakfast Bar, Kitchen Island, Pantry, Beamed Ceilings, Bookcases, Central Vacuum, In-Law Floorplan, Wet Bar

  • Total Bedrooms

    9

  • Bathrooms

    10

  • 1/2 Bathrooms

    2

  • Above Grade Finished Area

    18759.0

  • Basement YN

    YES

  • Cooling YN

    YES

  • Cooling

    Ceiling Fan(s), Central Air, Dual, Electric, Zoned

  • Fireplace YN

    YES

  • Heating YN

    YES

  • Heating

    Natural Gas, Zoned

  • Main Level Bedrooms

    3

  • Pet friendly

    N/A

Exterior

  • Garage

    No

  • Construction Materials

    Stone

  • Other Exterior Features

    Garden, Gas Grill

  • Parking

    Attached, Garage

  • Patio and Porch Features

    Patio, Porch

  • Pool

    Yes

  • Pool Features

    Heated, In Ground

Area & Lot

  • Lot Features

    Level, Pasture, Private

  • Lot Size(acres)

    8.0

  • Property Type

    Residential

  • Property Sub Type

    Single Family Residence

  • Architectural Style

    Traditional

Price

  • Sales Price

    $5,900,000

  • Tax Amount

    34241.0

  • Sq. Footage

    18, 759

  • Price/SqFt

    $314

HOA

  • Association

    No

School District

  • Elementary School

    Birmingham Falls

  • Middle School

    Northwestern

  • High School

    Cambridge

Property Features

  • Stories

    2

  • Sewer

    Septic Tank

Schedule a Showing

Showing scheduled successfully.

<
>
IN PERSON
VIA CHAT

What is 3 + 4 ?


Change time

Mortgage calculator

Estimate your monthly mortgage payment, including the principal and interest, property taxes, and HOA. Adjust the values to generate a more accurate rate.

Your payment

Principal and Interest:

$

Property taxes:

$

HOA fees:

$

Total loan payment:

$

Total interest amount:

$

Location

County

Fulton

Elementary School

Birmingham Falls

Middle School

Northwestern

High School

Cambridge

Listing Courtesy of None

RealHub Information is provided exclusively for consumers' personal, non-commercial use, and it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change or withdrawal. RealHub website owner shall not be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless.

Agent Georgia Sandbox

FOUNDER

Georgia Sandbox

Call Georgia today to schedule a private showing.

(980) 055-5555

georgia.sandbox@realhub365.com


* Listings on this website come from the FMLS IDX Compilation and may be held by brokerage firms other than the owner of this website. The listing brokerage is identified in any listing details. Information is deemed reliable but is not guaranteed. If you believe any FMLS listing contains material that infringes your copyrighted work please click here to review our DMCA policy and learn how to submit a takedown request.© 2024 FMLS.
Perfectly situated on 8 acres +/- of manicured lawns and gardens, this gated estate is the epitome of privacy and modernity. Upon entering the home, you are greeted with a winding staircase leading your eyes to the two story grand foyer. A chef's kitchen including SubZero and Wolf appliances and top of the line finishes, this kitchen provides ample space for an inviting family dinner or grand scale entertaining. Off of the kitchen is a family room with vaulted tongue and groove ceiling overlooking the pool and grounds. On the other side of the home, a fireside a gentleman's study with coffered ceilings provides privacy for meetings and the perfect office when working from home is your new normal. Off the study is a pool table complete with a mahogany paneled bar room to entertain or simply pour a scotch and shoot billiards. Privately located on the main floor the owners suite features a fireside sitting area, spa-like bath, separate His & Hers vanities and custom closets. The secondary bedrooms are all suites with walk-in closets. Custom hardwood flooring throughout the home. The Terrace level features; multiple entertaining areas including a custom bar and theatre room, exercise room, conference room, and extra billiards or gaming room. A guest suite with a full private bath, kitchen and living room. Situated adjacent to the property separate from the main home is a full guest house, offering complete and total privacy. With an added two car garage, this guest home is perfect for kids in college, in-laws, or corporate guests. Walking outside you will be blown away by the beautiful lanai with kitchen, multiple covered porches and dining areas. The pool can be heated with waterfall accents and a spa. Past the pool, you will be swept away by acres and acres of flat, green lawns backing up to wooded forest full of visiting deer and other wildlife not seen in typical city life. This is truly a one of a kind property where every need or purposes can be served, all without leaving your home. Bedroom, bathroom and square footage includes the guest house.

15060 Freemanville RD

Message successfully sent.

What would you like to know?

What is 3 + 4 ?

Related Properties

Luxury at its best in Downtown Alpharetta. Absolutely fabulous new construction home with an abundance of stunning appointments and beautifully level, private lot. Foyer opens to tall windowed stairwell and two story Great Room with fireplace. Glass wine room. Flex Room/Dining Room is at the front of the home. Spacious Kitchen includes very large island, top of the line appliances, custom cabinetry, breakfast/dining space that overlooks the pool, walk-in pantry, and wonderful scullery kitchen with additional appliances and additional sink and dishwasher. Full mudroom and main level Laundry Room. Luxurious main level owners suite features a fireside sitting area, coffee/beverage bar, french door access to covered patio, fabulous owners bathroom with spa shower, soaking tub, his & hers toilet rooms, and double vanities. Vaulted owners closet includes built-ins and mirrors. Office/Exercise Room overlooks back patio, pool, and private yard. Entertainment Room/Billiards Room/Game Room complete with a Family Room and bar area has slider doors that open out to covered patio and covered outdoor kitchen and grilling area. Pool Bathroom. Additional main level Guest Suite/Exercise Room with private bathroom and walk-in closet opens out to patio and overlooks yard and pool. Upper level features three bedroom suites-each with a private bathroom and walk-in closet, an upstairs laundry room, and a large loft/media room that opens to covered deck overlooking the pool. The back yard is a relaxing paradise with saltwater pool and tanning ledge, hot tub, covered patio with fireplace, another covered patio at the billiard room & bar, outdoor kitchen, and private level backyard that is fenced. Four car garage- two front facing and two rear facing are connected by a covered motorcourt. This luxurious home is ideally located close to Downtown Alpharetta and is situated on almost 3/4 acre lot. Beautifully appointed house is under construction and will be completed February 2026.
#10643595

Alpharetta

250 Mayfield RD

5 Beds

5 Baths

6,914 Sq.Ft.

$5,850,000

MLS#: 10643595

Luxury at its best in Downtown Alpharetta. Absolutely fabulous new construction home with an abundance of stunning appointments and beautifully level, private lot. Foyer opens to tall windowed stairwell and two story Great Room with fireplace. Glass wine room. Flex Room/Dining Room is at the front of the home. Spacious Kitchen includes very large island, top of the line appliances, custom cabinetry, breakfast/dining space that overlooks the pool, walk-in pantry, and wonderful scullery kitchen with additional appliances and additional sink and dishwasher. Full mudroom and main level Laundry Room. Luxurious main level owners suite features a fireside sitting area, coffee/beverage bar, french door access to covered patio, fabulous owners bathroom with spa shower, soaking tub, his & hers toilet rooms, and double vanities. Vaulted owners closet includes built-ins and mirrors. Office/Exercise Room overlooks back patio, pool, and private yard. Entertainment Room/Billiards Room/Game Room complete with a Family Room and bar area has slider doors that open out to covered patio and covered outdoor kitchen and grilling area. Pool Bathroom. Additional main level Guest Suite/Exercise Room with private bathroom and walk-in closet opens out to patio and overlooks yard and pool. Upper level features three bedroom suites-each with a private bathroom and walk-in closet, an upstairs laundry room, and a large loft/media room that opens to covered deck overlooking the pool. The back yard is a relaxing paradise with saltwater pool and tanning ledge, hot tub, covered patio with fireplace, another covered patio at the billiard room & bar, outdoor kitchen, and private level backyard that is fenced. Four car garage- two front facing and two rear facing are connected by a covered motorcourt. This luxurious home is ideally located close to Downtown Alpharetta and is situated on almost 3/4 acre lot. Beautifully appointed house is under construction and will be completed February 2026.
#7681325

Alpharetta

250 Mayfield Road

5 Beds

5 Baths

6,914 Sq.Ft.

$5,850,000

MLS#: 7681325

Exquisite Lakefront Estate in Windward – Alpharetta, GA. Discover a rare opportunity to own a premier lakefront estate on the shores of Lake Windward. This residence combines timeless elegance with modern luxury, offering five bedrooms, seven full baths, and two half baths across three impeccably designed levels. Double doors open to a grand foyer, where a sweeping staircase and statement chandelier create an unforgettable first impression. Flanking the entrance are a fireside sitting room and an elegant formal dining room with its own fireplace. The chef’s kitchen is both beautiful and functional, featuring a large island, custom cabinetry, warming drawer, butler’s pantry, and an additional wet bar. A private office on the main level provides an ideal space to work from home. The primary owner’s retreat is a true sanctuary, with a spacious bedroom and dual spa-like bathrooms for ultimate privacy and comfort. For convenience, the home offers laundry rooms on all three levels and an elevator. The finished terrace level was designed for entertaining, complete with a wine cellar, bar, and generous gathering spaces. Outside, resort-style amenities await. Enjoy an outdoor kitchen, heated inground pool, spa with waterfall, and multiple decks overlooking the water. A 5,000-gallon koi pond with advanced filtration and 40 koi fish adds a serene finishing touch. With its unmatched lakefront views, refined interiors, and extraordinary outdoor living spaces, this estate represents the pinnacle of luxury living in Windward.
#7659974

Alpharetta

1075 Carnoustie Lane

5 Beds

7 Baths

13,100 Sq.Ft.

$4,950,000

MLS#: 7659974

Exquisite Lakefront Estate in Windward - Alpharetta, GA. Discover a rare opportunity to own a premier lakefront estate on the shores of Lake Windward. This residence combines timeless elegance with modern luxury, offering five bedrooms, seven full baths, and two half baths across three impeccably designed levels. Double doors open to a grand foyer, where a sweeping staircase and statement chandelier create an unforgettable first impression. Flanking the entrance are a fireside sitting room and an elegant formal dining room with its own fireplace. The chef's kitchen is both beautiful and functional, featuring a large island, custom cabinetry, warming drawer, butler's pantry, and an additional wet bar. A private office on the main level provides an ideal space to work from home. The primary owner's retreat is a true sanctuary, with a spacious bedroom and dual spa-like bathrooms for ultimate privacy and comfort. For convenience, the home offers laundry rooms on all three levels and an elevator. The finished terrace level was designed for entertaining, complete with a wine cellar, bar, and generous gathering spaces. Outside, resort-style amenities await. Enjoy an outdoor kitchen, heated inground pool, spa with waterfall, and multiple decks overlooking the water. A 5,000-gallon koi pond with advanced filtration and 40 koi fish adds a serene finishing touch. With its unmatched lakefront views, refined interiors, and extraordinary outdoor living spaces, this estate represents the pinnacle of luxury living in Windward.
#10624692

Alpharetta

1075 Carnoustie LN

5 Beds

7 Baths

13,100 Sq.Ft.

$4,950,000

MLS#: 10624692

Beautiful Custom Home on gorgeous estate lot in exclusive Milton. This amazing European Provencal cement stucco and stone home combines all the Traditional luxuries with Modern style. This estate home is situated on a private 4.48 acre lot. The Open Concept floor plan has a custom modern Staircase visible from the front through the dramatic black framed two story window. Upon entering the Iron Framed double doors the two story Family room opens to the beautiful backyard. As you walk out the main level into The backyard Oasis, complete with expansive Travertine patio you look out to the beautiful pool, and spa facing the private woods with a creek in the distance. Pool bathroom is just one of the details this home includes. The Chef's kitchen has a dramatic marble island which opens to the Family Room and Keeping Room. Kitchen Boasts a 60" Wolfe Duel Fuel Range, Two Miele Dishwashers, Sub Zero Refrigerator and Separate Freezer, Large pantry, Butlers pantry, and Mud Room. This home has Two Laundry Rooms. The main floor includes an Owner's Suite with separate sitting room, which has private balcony. Large bathroom, which also opens to balcony, and amazing His and Hers closets. The Guest En Suite, also on main, has its own door leading to the back guest terrace over looking small fountain. There are 3 additional bedrooms upstairs with private baths and an oversized bonus room. The finished Terrace level includes an Office, Exercise Room, Steam Shower, Cold Plunge Room, Bar, Theatre Room, and tons of storage! This is an amazing Home for Entertaining. 2 Car garage and an additional separate 2 Car Garage with option of future teen or in-law suite above. Amazing Milton location! Minutes from Down Town Alpharetta and Avalon! Great Schools! Professional photos coming soon!
#7657400

Alpharetta

14801 HOPEWELL Road

5 Beds

6 Baths

8,966 Sq.Ft.

$5,945,000

MLS#: 7657400

Beautiful Custom Home on gorgeous estate lot in exclusive Milton. This amazing European Provencal cement stucco and stone home combines all the Traditional luxuries with Modern style. This estate home is situated on a private 4.48 acre lot. The Open Concept floor plan has a custom modern Staircase visible from the front through the dramatic black framed two story window. Upon entering the Iron Framed double doors the two story Family room opens to the beautiful backyard. As you walk out the main level into The backyard Oasis, complete with expansive Travertine patio you look out to the beautiful pool, and spa facing the private woods with a creek in the distance. Pool bathroom is just one of the details this home includes. The Chef's kitchen has a dramatic marble island which opens to the Family Room and Keeping Room. Kitchen Boasts a 60" Wolfe Duel Fuel Range, Two Miele Dishwashers, Sub Zero Refrigerator and Separate Freezer, Large pantry, Butlers pantry, and Mud Room. This home has Two Laundry Rooms. The main floor includes an Owner's Suite with separate sitting room, which has private balcony. Large bathroom, which also opens to balcony, and amazing His and Hers closets. The Guest En Suite, also on main, has its own door leading to the back guest terrace over looking small fountain. There are 3 additional bedrooms upstairs with private baths and an oversized bonus room. The finished Terrace level includes an Office, Exercise Room, Steam Shower, Cold Plunge Room, Bar, Theatre Room, and tons of storage! This is an amazing Home for Entertaining. 3 Car garage and an additional separate 2 Car Garage with option of future teen or in-law suite above. Amazing Milton location! Minutes from Down Town Alpharetta and Avalon! Great Schools! Professional photos coming soon!
#10614694

Alpharetta

14801 HOPEWELL RD

5 Beds

6 Baths

8,966 Sq.Ft.

$5,945,000

MLS#: 10614694

Custom Madewell NEW construction luxury and STEPS away from Downtown Alpharetta. Upon walking into the 2 story foyer, you are greeted with a stunning curved staircase and steel and glass tube elevator that services all 3 floors. Open floor plan throughout with 12 foot ceilings. Extra wide fireplace flanked by intricate windows and built-ins. Bi-fold sliders open out to the pool and outdoor turfed space. Chefs dream kitchen with both a working AND eat in island. Formal dining with massive curved corbels separate that space. Oversized hood and Wolf paneled appliances. A thoughtfully planned out scullery with ample cabinets plus a separate "Costco" pantry. TWO master bedrooms on the first floor both with gorgeous spa like bathrooms. One overlooks the pool through the massive sliders. Oversized laundry and drop area plus half bath. The second floor has a loft with a huge balcony and sliders overlooking the pool. 3 more en-suite bedrooms are on this floor. Ample closets and light filled office overlooking the pool. Massive gym with steam shower and window that lowers for an infinite balcony. Second laundry room. Take the next staircase up to the 3rd floor speakeasy or man-cave with half bath and another deck with sliders. Room is plumbed for a wet bar, an endless opportunity to make it your own entertaining paradise. The outdoor pool boosts floating glass globes, silver travertine and access to the pool house with outdoor kitchen, half bath, fireplace and plenty of room to enjoy games or cocktails. 4 car garage (3 stalls plus one tandem). This massive home is one of the last high end new construction minutes to downtown.
#7617140

Alpharetta

221 ACADEMY Street

5 Beds

6 Baths

7,780 Sq.Ft.

$6,850,000

MLS#: 7617140

- property

Send a message

Message successfully sent.

Your message

What is 3 + 4 ?

Reason for contacting?

Sign Out

Virtual Assistant

Would you like to take the next step with this property? We can help you schedule a showing or virtual tour, or send you more details.

Yes, I would like more information.

Thank You for Your Reply, One of Our Agents will contact you as soon as possible

No, maybe later.

Thank you, you can always contact me via email, phone number or through the contact form.

Realhub AI

Lucy - Your AI-Powered Realtor

Update Your Temporary Password

Personalize your search

Enter your email and we'll notify you immediately when new listings match what you're looking for.

or enter email address

Already have an account ? Login here

Continue your home search

Already have an account ? Login here

We use cookies

We use cookies primarily for analytics to enhance your experience. By accepting, you agree to our use of these cookies. You can manage your preferences or learn more about our cookies policy.

Privacy Policy Terms of Service