Title Page Background
DEBUG FN args: Array ( [0] => 479 [1] => [2] => [3] => agent ) BEFORE: Site: 479 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 479 Igate: njhud LocID: 479 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 479 AND i.igate IN ('cahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 479 [1] => [2] => [3] => lender ) BEFORE: Site: 479 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 479 Igate: njhud LocID: 479 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 479 AND i.igate IN ('cahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 479 [1] => [2] => [3] => other ) BEFORE: Site: 479 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 479 Igate: njhud LocID: 479 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 479 AND i.igate IN ('cahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

476 Hickory Grove Road
Leesburg, GA 31763
Carrie Hutchinson with RE/MAX OF ALBANY, original listing - (229) 434-1600

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $535,000
Beds: 4
Baths: Full: 4
Status: Active
SqFt: 3221 Square Feet
Agency: RE/MAX OF ALBANY
Agency Phone: (229) 434-1600

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Garage: Garage
Property Type: Residential-Other
Year Built: 2003
Notes: Welcome to your dream home! This stunning 3,221 sq ft home is situated on a scenic 3-acre corner lot in WEST LEE COUNTY. With 4 bedrooms, 4 full bathrooms, and a host of upgrades, this home offers the perfect blend of comfort, space, and style. Step into a warm and inviting space filled with natural light and timeless charm. This elegant entryway features beautiful hardwood floors that flow throughout the main living areas. The arched windows in the dining area allow sunlight to pour in, creating a bright and airy atmosphere. The open layout allows for seamless flow into the main living area—perfect for entertaining. This beautiful kitchen is the heart of the home, featuring rich wood cabinetry, granite countertops, and a striking brick floor that adds rustic charm with timeless appeal. Enjoy cooking with brand-new appliances and utilizing the spacious countertops that provide ample prep space. The kitchen also offers two options for casual dining, either at the bar or in the breakfast area. The primary suite is a true retreat, featuring a large window with a serene view of the backyard, a luxurious bathroom with a garden tub, separate shower, private toilet room, and an oversized walk-in closet. Upstairs, you'll find a large, 20'x18' BONUS ROOM—perfect for a home office, gym, or playroom. Bedrooms 3 and 4 are spacious and feature walk in closets and two full bathrooms. Fresh paint and brand-new carpet, too! Step outside to your very own backyard retreat! This beautiful outdoor space features a sparkling POOL complete with a tranquil water feature, perfect for relaxing and entertaining. Surrounded by white privacy fencing, you'll enjoy peace, seclusion, and safety for kids and pets alike. The covered back porch offers a shaded area to unwind, host barbecues, or simply enjoy your morning coffee poolside. This outdoor oasis is designed for comfort and enjoyment all year round. This versatile 30'x40' wired workshop and garage is a dream come true for hobbyists, craftsmen, or anyone in need of serious storage and workspace. It features two electric doors that provide easy access for vehicles, lawn equipment, or large projects, while the interior offers endless possibilities for use—whether you're into woodworking, auto repair, or just need extra space to get things done. Don't miss this rare opportunity for space, style, and country charm just minutes from everything! Schedule a showing today!
MlsNumber: --
ListingId: 164791


Listing Provided By: RE/MAX OF ALBANY, original listing
Phone: (229) 344-4992
Office Phone: (229) 434-1600
Agent Name: Carrie Hutchinson
Disclaimer: Copyright © 2025 Albany Board of Realtors and Southwest Georgia MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App