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

229 Trammell Road
Pine Mountain, GA 31822
Robert Upchurch with Re/Max Results, original listing - (706) 845-7000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,624,500
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Re/Max Results
Agency Phone: (706) 845-7000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 362 acre(s)
Property Type: Land-Single Family Residence
Year Built: --
Notes: Fortress Farms is Hands Down one of the Finest Farms we've ever had the Privilege of Bringing to Market. Rich in History and Framed by a Majestic Pecan Orchard, Fortress Farms is so much More than just a farm- It Truly represents a Once In a Lifetime Opportunity to Live the Lifestyle you've Always Dreamt of. Thoughtful Stewardship has been a Constant Theme for the current owner's and their Top Priority when it comes to their Management Approach for this Magnificent 362 Acre Paradise which is easy to see from the moment you pull in the gated entrance! This Legacy Property offers Unparalleled Diversity to include an abundance of tillable ground, Mature Oaks, Duck Habitat Galore, Thousands of Feet of Frontage on Sulphur Creek, Approximately one mile of Abandoned Rail Road Property providing a lifetime of gravel to be used on the Farm and not to mention-this makes a perfect long distance shooting range, Trophy Managed Lake, Fruit Orchards, Mature Stands of both Dunstan Chestnut and Sawtooth Oaks strategically planted throughout the property, 12 Acres of Established Alfalfa, and so Very Much More! Did I Mention that this Farm also boasts two irrigation wells each providing in excess of 100 gallons per minute, a Red Iron 50X100 Pole Barn featuring an RV Hookup with septic, Farm Manager's Office, Shop, Deer Cooler as well as the first ever 2 Story Alpha Frame Building offering the perfect Blank Canvas to Build out the Barndo you've been longing for, Beautifully Preserved Terra Cotta Silo Apartment offering an Award Winning Vista Views of this Most Captivating Landscape. From the very beginning, this Farm has been intensively managed with the assistance of a highly sought after Wildlife Biologist. Through a combined effort by both the landowner and their management team, they have achieved something Absolutely Remarkable! They have taken QDMA management practices to an entirely New Level and the Results are staggering! The Age Structure of the Deer Herd, Fawn Recruitment an
MlsNumber: --
ListingId: 219739


Listing Provided By: Re/Max Results, original listing
Phone: (706) 523-0014
Office Phone: (706) 845-7000
Agent Name: Robert Upchurch
Disclaimer: Copyright © 2025 Columbus Board of Realtors (GA). 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','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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 Kim Chesser
Kim Chesser
ASCIIBHHS First Magnolia Realty
Call Today!: (952) 857-9423

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App