Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 462 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 462 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 462 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

2547 Piedmont Lake
Pine Mountain, GA 31822
Alisa Matheny with Coldwell Banker Spinks Brown, original listing - (706) 884-5681

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,150,000
Beds: 4
Baths: Full: 5, ½: 1
Status: Active
SqFt: 5466 Square Feet
Agency: Coldwell Banker Spinks Brown
Agency Phone: (706) 884-5681

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2001
Notes: WOW, this remarkable WATERFRONT property nestled on a sprawling 2.48 of professionally landscaped acres of paradise in the GATED, SWIM, TENNIS & LAKE community of Piedmont Lake! This exquisite home offers luxurious living space with its 4 bedrooms, 5.5 bathrooms, circular driveway, attached 3-car garage and all of the amazing things it has to offer. One front entrance greets you with a solid wooden door leading you into the extraordinary Foyer featuring a unique triple tray ceiling with specialty lighting. Dining Room has space for an extra-long table, amazing brick floors & soaring windows. Opposite side of Foyer is a Living Room with a unique fireplace which includes gas logs, brick floors & soaring windows. Great Room is oversized, offers stack-stoned fireplace with gas logs, bookended by built-in entertainment centers & bookshelves and unparalleled lake views from the wall of windows & set of French Doors. Gormet Kitchen is a chef's dream and was reconstructed & upgraded in 2022 including new floors, custom cabinets, countertops & custom shelving. Equipped with a 6-burner Wolf stovetop, KitchenAid double wall oven, 2 KitchenAid dishwashers, Subzero refrigerator & freezer, wine cooler, beverage cooler, ice maker, built-in chopping board, 2 breakfast bars, gorgeous custom cabinets with built-ins galore, solid surface countertops, brick backsplash, various prep sinks, two oversized walk-in pantries, Butler's Pantry, breakfast area with lake views and 2 separate exterior doors, one leading to Summer Porch & other to a patio. Powder Room is located near the Kitchen making it convenient for guests. Double Mudroom offers built-in cabinets & unique custom sink, brick floors, door to driveway, door to garden area that includes a fishpond, door to Bonus Room & another door to Garage. Bonus Room is amazing with a full Bathroom, built-in cabinets that includes a mini sink, mini-KitchenAid dishwasher, ice maker, microwave, beverage cooler & beautiful window with a view of front yard. Laundry Room is spacious & includes built-in cabinets & laundry sink. Office/Library has 2 walls of built-in cabinets & shelving, French doors leading to enclosed porch & an Original National Wild Turkey Limited Edition ceiling fan. Owner's Suite is amazing with 2 oversized walk-in closets with custom built-ins and a wall of windows & French doors leading onto enclosed porch. Bathroom is amazing offering a jetted tub, custom built stepless steam shower, double vanity with lots of cabinets & custom lighting including foot motion lighting & toilet room. Guest Suite is located on opposite end of the house, offering 3 Guest Bedrooms & 2 Bathrooms with one being a Jack & Jill. Other Bedroom has a foyer entrance which includes a full Bathroom & closets along with windows & French doors leading onto a private patio. This area also has a doorway that can be closed off when not in use. Garage offers 3 bays with one having a front & back entrance. There is a heated/cooled workshop located inside the Garage which includes a half-bath & entrance to the outside where you will find a covered back porch. Summer Porch includes a large eating/sitting area along with an incredible outdoor Kitchen which includes built-in grills, cooktop, sink, beverage cooler & solid surface countertops. Covered back porch and patio area offers more space for entertaining and gives beautiful views of the professionally landscaped backyard and lake. Another patio beside the lake offers more sitting area along with a firepit for those chilly nights or making S'mores. Boathouse offers space for storing the boat along with a large storage room. Brazilian cherry flooring, Lite Touch lighting system, 10-12-foot ceilings, decorative lighting, heavy decorative molding, irrigation & alarm system, fresh interior paint, new carpet on main floor, new-upgraded water heaters, new gas logs, new firepit, new HVAC unit, new seawall, dock supports & dock planking. SO MUCH MORE..JUST HAVE TO SEE IT TO BELIEVE!
MlsNumber: --
ListingId: 10451017


Listing Provided By: Coldwell Banker Spinks Brown, original listing
Phone: (706) 594-6344
Office Phone: (706) 884-5681
Agent Name: Alisa Matheny
Disclaimer: Copyright © 2025 Georgia Multiple Listing Service. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 462 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Real Estate Expert Photo for Nancy Jordan
Nancy Jordan
ASCIIChampions Realty
Call Today!: (706) 536-4392

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App