This is the ultimate showstopper! Be Amazed every time you pull home to your beautiful 4 sided brick executive home, nestled in the back part of Sugarloaf Country Club sitting on the 2nd fairway of the TPC Pines Golf Course. No expense was spared in this home as it is filled with magnificence, natural light and attention to details in every corner as it was designed and crafted by Robert Wilkins Homes. Walk into an opulent 2 story foyer with winding staircase and feel the grandeur. The main level is expansive with views with an executive's dream office with fireplace, built-ins, 2 story great room with FP, gourmet eat in kitchen with double islands, butler's pantry, wine fridge and much more! Kitchen overlooks a cozy family room with stone detailed FP and a stunning oyster shell chandelier. Main level continues with a formal dining room, laundry, two half baths and master suite, with FP, overlooking the course with an incredible en-suite with a gigantic walk-in closet equipped with built-ins for plenty of storage. Expansive deck from the kitchen all the way through to the master suite to allow you to feel your stresses walk away overlooking the fairway. As you make your way upstairs details continue at every turn while you overlook the beautiful main level. 5 generously sized bedrooms with oversized closets and 4 full baths. Downstairs is over 4,000 square feet designed to be an entertainer's dream, an incredible family hangout space or a perfect multigenerational set up. Lower level has several large entertaining spaces including a family den with the 5th FP, wine storage, theatre room, gym, billiard room and a full bath. The bar area will be the envy of your guests. Downstairs also includes a fully equipped kitchen.
Single-familyProperty Type
2001Year Built
0.77 acresLot Size
$213Est. Price/Sq.Ft.
3 car garageParking
Listed by MARK SPAIN• Mark Spain Real Estate
Listed by John McAdoo• Mark Spain Real Estate
Bought with SEEMA JAIN• Sugarloaf Realty Partners, LLC.
Source:FMLS #7046698
Redfin Estimate
$2,246,667
$347K since sold in July 2022$26K since August
Recently sold homes
Estimate history
Homes for sale
This home's estimate is 14.3% higher than the average sale price ($1.97M) of 5 comparable homes.
This is the ultimate showstopper! Be Amazed every time you pull home to your beautiful 4 sided brick executive home, nestled in the back part of Sugarloaf Country Club sitting on the 2nd fairway of the TPC Pines Golf Course. No expense was spared in this home as it is filled with magnificence, natural light and attention to details in every corner as it was designed and crafted by Robert Wilkins Homes. Walk into an opulent 2 story foyer with winding staircase and feel the grandeur. The main level is expansive with views with an executive's dream office with fireplace, built-ins, 2 story great room with FP, gourmet eat in kitchen with double islands, butler's pantry, wine fridge and much more! Kitchen overlooks a cozy family room with stone detailed FP and a stunning oyster shell chandelier. Main level continues with a formal dining room, laundry, two half baths and master suite, with FP, overlooking the course with an incredible en-suite with a gigantic walk-in closet equipped with built-ins for plenty of storage. Expansive deck from the kitchen all the way through to the master suite to allow you to feel your stresses walk away overlooking the fairway. As you make your way upstairs details continue at every turn while you overlook the beautiful main level. 5 generously sized bedrooms with oversized closets and 4 full baths. Downstairs is over 4,000 square feet designed to be an entertainer's dream, an incredible family hangout space or a perfect multigenerational set up. Lower level has several large entertaining spaces including a family den with the 5th FP, wine storage, theatre room, gym, billiard room and a full bath. The bar area will be the envy of your guests. Downstairs also includes a fully equipped kitchen.
Year
Property tax
Land + Additions
Assessment*
2025
$34,862 (+7.5%)
$160,120 + $833,360
$993,480
2024
$32,415 (+18.5%)
$160,120 + $825,200
$985,320
2023
$27,353 (−6.1%)
$144,000 + $761,240
$905,240
2022
$29,131 (+35.6%)
$144,000 + $616,000
$760,000
2021
$21,483 (−0.7%)
$140,000 + $671,200
$811,200
2020
$21,627 (+3.9%)
$120,000 + $463,840
$583,840
2019
$20,813 (−0.4%)
$120,000 + $463,840
$583,840
2018
$20,889 (−0.9%)
$120,000 + $463,840
$583,840
2017
$21,081 (+0.9%)
$120,000 + $463,840
$583,840
2016
$20,884 (−1.3%)
$120,000 + $463,840
$583,840
2015
$21,150 (−0.6%)
$120,000 + $463,840
$583,840
2014
$21,283 (−0.1%)
$120,000 + $463,840
$583,840
2013
$21,310 (+5.7%)
$120,000 + $463,840
$583,840
2012
$20,154 (−1.3%)
$120,000 + $463,840
$583,840
2010
$20,415 (−9.1%)
$120,000 + $463,840
$583,840
2009
$22,448
$121,760 + $578,080
$699,840
2008
$22,448
$121,760 + $578,080
$699,840
Tax history for 2957 Major Ridge Trl
Year
Property tax
Land + Additions
Assessment*
2025
$34,862 (+7.5%)
$160,120 + $833,360
$993,480
2024
$32,415 (+18.5%)
$160,120 + $825,200
$985,320
2023
$27,353 (−6.1%)
$144,000 + $761,240
$905,240
2022
$29,131 (+35.6%)
$144,000 + $616,000
$760,000
2021
$21,483 (−0.7%)
$140,000 + $671,200
$811,200
2020
$21,627 (+3.9%)
$120,000 + $463,840
$583,840
2019
$20,813 (−0.4%)
$120,000 + $463,840
$583,840
2018
$20,889 (−0.9%)
$120,000 + $463,840
$583,840
2017
$21,081 (+0.9%)
$120,000 + $463,840
$583,840
2016
$20,884 (−1.3%)
$120,000 + $463,840
$583,840
2015
$21,150 (−0.6%)
$120,000 + $463,840
$583,840
2014
$21,283 (−0.1%)
$120,000 + $463,840
$583,840
2013
$21,310 (+5.7%)
$120,000 + $463,840
$583,840
2012
$20,154 (−1.3%)
$120,000 + $463,840
$583,840
2010
$20,415 (−9.1%)
$120,000 + $463,840
$583,840
2009
$22,448
$121,760 + $578,080
$699,840
2008
$22,448
$121,760 + $578,080
$699,840
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Permits
Beds
6
Baths
7
Stories
2
Lot width
—
Lot depth
—
Lot size
33,541
Year renovated
—
Sq. Ft.
10,564
Year built
2001
Style
Single Family Residential
County
Gwinnett County
APN
R7159 069
Parking Spaces
3
Basement
Yes
Accessible
No
HOA Dues
$2,750 /month
Garage
Yes
Features
Green, Pool
Last updated by owner on Apr 14, 2026.
R100
Single-Family Residence District
This zoning district is intended primarily for single-family detached residences and related uses.
Permitted uses
Include but are not limited to:
Day care facility
Housing-Single unit
Mar 8, 2001 • Final
Building (any single-family structure)
Finish the basement of a residential building and complete all required inspections.
Remodel
Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.
Master Bathroom Features: Bidet,Double Vanity,Separate Tub/Shower,Whirlpool Tub
Bedroom Information
# of Main Level Bedrooms: 1
Bedroom Features: Master on Main,Oversized Master
Interior Features
# of Fireplaces: 5
Fireplace Features: Family Room, Gas Starter, Keeping Room, Living Room, Master Bedroom
Interior Features: Bookcases, Cathedral Ceiling(s), Coffered Ceiling(s), Double Vanity, Entrance Foyer 2 Story, High Ceilings 10 ft Lower, High Ceilings 10 ft Main, High Ceilings 10 ft Upper, Tray Ceiling(s), Walk-In Closet(s), Wet Bar
Common Walls: No Common Walls
Appliances: Double Oven, Dishwasher, Disposal, Gas Cooktop, Electric Oven, Gas Water Heater, Microwave, Refrigerator
Flooring: Carpet, Ceramic Tile, Hardwood
Room Information
LaundryFeatures: Laundry Room, Main Level
Kitchen Features: Cabinets Other,Cabinets Stain,Eat-in Kitchen,Kitchen Island,Keeping Room,Pantry Walk-In,Second Kitchen,Stone Counters,View to Family Room
Dining Room Features: Seats 12+,Butlers Pantry
Room Type: Bonus Room, Den, Exercise Room, Family Room, Great Room - 2 Story, Library, Media Room, Office, Other
Basement: Bath/Stubbed, Daylight, Exterior Entry, Finished Bath, Finished, Full
Exterior
Property Information
Levels: Two
Above Grade Finished Area: 6,167
Below Grade Finished Area: 4,397
Below Grade Unfinished Area: 22
Construction Materials: Brick 4 Sides
Exterior Features: Private Yard, Private Front Entry, Private Rear Entry
Roof: Composition
Patio And Porch Features: Deck, Patio
Property Condition: Resale
Other Equipment: Home Theater, Irrigation Equipment
Lot Information
TaxLegalDescription: L569 BI SUGARLOAF COUNTRY CLUB
Financial
Financial Information
Buyer Financing: Conventional
Utilities
Utility Information
Cooling: Central Air
Heating: Forced Air, Natural Gas
Water Source: Public
Sewer: Public Sewer
Utilities: Cable Available, Electricity Available, Natural Gas Available, Sewer Available, Water Available
Location
HOA Information
Association Fee: $2,750
Association Fee Frequency: Annually
Has Association
School Information
Elementary School: Mason
Middle Or Junior School: Hull
High School: Peachtree Ridge
Location Information
Directions: Use GPS
Road Surface Type: Paved
Road Frontage Type: Private Road
Gwinnett
Community Information
Community Features: Clubhouse, Country Club, Gated, Golf, Homeowners Assoc, Near Schools, Pool, Sidewalks, Swim Team, Tennis Court(s)
Public facts
Beds: 6
Baths: 7.0
Sq. Ft.: 10,564
Stories: 2.0
Parking Spaces: 3
Basement: Yes
Accessible: No
Lot Size: 0.77 acres
Style: Single Family Residential
Year Built: 2001
Year Renovated: —
County: Gwinnett County
APN: R7159 069
HOA Dues: $2,750/month
Garage: Yes
Features: Green, Pool
Home facts updated by owner on Apr 14, 2026
Around this home
Schools
M. H. Mason Elementary School
Public PreK-5 • Assigned • 0.2mi
7/10
Hull Middle School
Public 6-8 • Assigned • 1.5mi
9/10
Peachtree Ridge High School
Public 9-12 • Assigned • 2.2mi
8/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
5/10 Heat Factor
7 days above 103° expected this year, 18 days in 30 years
4/10 Wind Factor
20% chance of strong winds in next 30 years
5/10 Air Factor
5 unhealthy days expected this year, 9 days in 30 years
Provided by First Street
Historical weather
Duluth, GA • 30097
Average low and high temperatures (°F)
50
32
61
39
72
48
79
55
80
61
87
69
91
74
83
69
83
66
74
55
66
47
56
37
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 9.2 hours in
June and 4.5 hours in December, which is comparable to the
U.S. average for solar exposure.
9.2 hrs
4.5 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$2.13M – $2.58M
Reach more buyers when you sell with Redfin. Save up to $22,467 in fees.3 minutes to get started.