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 = 478 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 = 478 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 = 478 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;

226 Smithfield Road
Dublin, GA 31021

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $425,000
Beds: 3
Baths: 3
Status: Active
SqFt: 2392
Agency: Century 21 Durden & Kornegay Realty, Inc.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 1974
Notes: Elite Holly Hills Estate: 3BR/2.5BA Masterpiece on Pristine 1.1 Acres. Step into the realm of luxury with this exquisite custom home in the esteemed Holly Hills subdivision. Poised on a manicured 1.1-acre corner lot, this home is a beacon of sophisticated living. Recently upgraded and professionally decorated, it exudes an air of refined elegance. The heart of this home is the chef's kitchen, a culinary haven with sleek tile flooring, lustrous granite countertops, a statement island, and custom maple cabinetry. It's equipped with elite stainless appliances: Jenn Air cooktop and double wall ovens, stainless hood w/ heavy-duty exhaust, Bosch microwave, new Kitchen-Aid dishwasher, and a magnificent 48" Sub-Zero refrigerator. Opulence flows throughout with rich hardwood flooring, sumptuously tiled baths, and a dedicated laundry space. The formal dining area and living room are designed for grand entertaining, while the den, with its gas fire logs, 105" drop-down projection screen, projector, and surround sound, offers an immersive media experience. Elegance is in every detail, from the custom blinds and drapes to the tailor-designed closets in each bedroom. The home's grandeur extends to its colossal expandable attic with its own stairs, ready to transform into a lavish bonus room or additional bedrooms. The screened porch provides a serene vista over the landscaped lawns (complete w/ sprinkler system). The attached double garage has custom floor to ceiling cabinets and storage room and the additional double carport extension both offer ample space and versatility. The elegant gazebo and expansive brick patio area set the stage for unparalleled outdoor entertaining complete with water fountain. Security is paramount with a comprehensive Ring system, (cameras surrounding home, monitoring/memory station, & window and door sensors throughout). The estate has a private well equipped with a Chambers' water filtration system. Recent updates include a new roof, water heater, and newer HVAC system. Located just a stone's throw to Trinity school (zoned for Northwest Laurens Elementary and West Laurens schools) there are NO HOA fees required! Optional community pool access available. This estate is a rare jewel in Holly Hills, offering an unparalleled lifestyle of luxury and comfort. Call listing agent today for a tour! 24 hour notice to show.
MlsNumber: 10230952


Listing Provided By: Century 21 Durden & Kornegay Realty, Inc., original listing
Name: Century 21 Durden & Kornegay Realty, Inc.
Phone: (478) 272-1535
Office Name: Century 21 Durden & Kornegay
Office Phone: (478) 272-1535
Agent Name: Pamela Lee
Disclaimer: Copyright © 2024 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 = 478 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 Greg Norwood
Greg Norwood
ASCIIFickling & Company
Call Today!: (478) 357-2623

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App