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 = 426 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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 = 426 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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 = 426 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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;

140 Broadleaf Trail Trail
Grovetown, GA 30813

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $520,000
Beds: 6
Baths: 5
Status: Pending
SqFt: 5294
Agency: Keller Williams Realty Augusta Partners

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2017
Notes: Welcome to luxury living, in this exquisite Biltmore floor plan residence, boasting an impressive 5294 square feet of living space. Nestled on a 0.3 acre corner in the prestigious Indian Springs neighborhood, this meticulously crafted home offers unparalleled comfort and sophistication.<br /> <br /> Step inside to discover a spacious and elegant interior designed to impress. The grand foyer sets the tone with its soaring ceilings and gleaming LVT floors, guiding you into the heart of the home. The expansive living area is bathed in natural light streaming through arrays of windows, creating a warm and inviting ambiance perfect for both relaxation and entertainment.<br /> <br /> The fully fitted gourmet kitchen is a chef's dream, featuring stainless steel appliances, custom-painted cabinetry, and granite countertops. Whether you're hosting a formal dinner party or a casual gathering, the adjacent dining area provides ample space for family and friends to come together. <br /> <br /> The main floor offers an abundance of living areas and additional rooms perfect for formal dining, office, and play room. The secondary bedroom downstairs is currently set up as an exercise room and it has internal access to the full bathroom downstairs. Living room offers gorgeous stone fireplace and access to additional staircase.<br /> <br /> Retreat to the massive master suite upstairs, where tranquility awaits. Complete with enough space to situate the largest bed your heart desires, a study, and a sitting room. It offers a lavish ensuite bathroom and a spacious walk-in boutique-style closet, this private oasis offers the ultimate in comfort and convenience. <br /> <br /> Four additional bedrooms provide plenty of room for guests or family members, each offering their own unique charm and style. There is a Jack 'n' Jill, as well as two full suites.<br /> <br /> Indulge in outdoor living, at its finest, in the expansive fenced backyard. The concrete patio spanning the entire length of the home is fitted with both a covered portion and a large rectangular gazebo. The shed in the backyard is also included in the sale.<br /> <br /> Conveniently located near top-rated schools, shopping, dining, and recreational amenities, this exceptional home offers the epitome of luxury living in a highly desirable location. Don't miss your chance to experience the unparalleled elegance of this Biltmore floor plan masterpiece. Schedule your private showing today!
MlsNumber: 526762


Listing Provided By: Keller Williams Realty Augusta Partners, original listing
Name: Keller Williams Realty Augusta Partners
Phone: (706) 868-3772
Office Name: Keller Williams Realty Augusta Partners
Office Phone: (706) 868-3772
Agent Name: Daniel Ijigbamigbe
Disclaimer: Copyright © 2024 Greater Augusta Association of Realtors. 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 = 426 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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 Emily Aceves
Emily Aceves
ASCIIMeybohm Real Estate
Call Today!: (706) 825-8967

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App