Title Page Background
DEBUG FN args: Array ( [0] => 548 [1] => [2] => [3] => agent ) BEFORE: Site: 548 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 548 Igate: njhud LocID: 548 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 = 548 AND i.igate IN ('mihud','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 = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 548 [1] => [2] => [3] => lender ) BEFORE: Site: 548 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 548 Igate: njhud LocID: 548 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 = 548 AND i.igate IN ('mihud','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 = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 548 [1] => [2] => [3] => other ) BEFORE: Site: 548 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 548 Igate: njhud LocID: 548 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 = 548 AND i.igate IN ('mihud','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 = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

277 N Hulin Avenue
Tignall, GA 30668
Mabel Strother with J Brand Realty, LLC, original listing - (706) 318-0045

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $615,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: J Brand Realty, LLC
Agency Phone: (706) 318-0045

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 55 acre(s)
Property Type: Farm-Farm
Year Built: --
Notes: Charming 1915 Farmhouse on 57+ Acres with Pond & Timber<br /> Dreaming of a place to call home—where you can cast a line, grow a garden, and roam the woods? This beautifully preserved 1915 farmhouse sits at the front of 57+ gently rolling acres, offering a perfect blend of history, charm, and modern updates. Spacious porches, original pine flooring, and beaded board details add warmth and character to this timeless retreat.<br /> Step inside the welcoming front hall, which leads to the living room, two of the three bedrooms, and a grand staircase to the upper rooms. The living room faces west, offering breathtaking sunset views over the pond. The newly remodeled kitchen features stainless steel appliances (only two years old), granite countertops, and easy access to the attached porch, as well as a deep, covered back porch—perfect for entertaining or enjoying peaceful country mornings.<br /> Recent updates include a new electric panel, a tankless water heater, a new roof, and fresh composite decking, ensuring both comfort and efficiency for years to come. Outside, you'll find a flourishing garden space, fig trees, blueberry bushes, pear trees, and a muscadine trellis. The property also includes a block storage shed, an antique cooler, and a sturdy steel barn on a slab. The open land is fully fenced with wood and wire, while the southwestern portion is covered in natural and planted pine timber.<br /> Across the pond, tucked within the woods and accessible by a separate entrance, stands a 1925 Craftsman-style home waiting to be restored to its former glory. This Northeast Georgia farm is a rare find—a place rich in history, ready to create new memories for generations to come!1. Northeast Georgia Farm, 2. Cattle Farm with Pond!, 3. Farmhouse on 57 Acres with Pond!, 4. Farmhouse with Timber & Pond!
MlsNumber: --
ListingId: CM1023686


Listing Provided By: J Brand Realty, LLC, original listing
Phone: (706) 318-0045
Office Phone: (706) 318-0045
Agent Name: Mabel Strother
Disclaimer: Copyright © 2025 Savannah Multi-List Corporation. 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