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

414 Barrineau Road
Whigham, GA 39897
Teresa H. Heard with Coldwell Banker Brock Realty, original listing - (229) 246-5127

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $369,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Coldwell Banker Brock Realty
Agency Phone: (229) 246-5127

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 31 acre(s)
Property Type: Land-Other
Year Built: --
Notes: Pride has been taken in developing this stunning 31.5 acres that is ready for you to build your new home overlooking cleared land, and dotted with mature oaks and magnolia trees, privately set back 2000 feet off the road, this property is surrounded by crops and woods. There are 3 new outbuildings, ready with power, well, septic and painted to match. 2 could be finished to become your new home! #1. 36 x 36 raised center RV pole barn with 6" concrete pad, 50amp service, water and septic. This could become your barndominium home, RV parking, or 6 additional horse stalls! #2, A 2nd pole barn is 42 X 60 equipped with 100-amp service and water. The open area (30 x 60) under the pole barn roof, is additional space for other equipment,,,,,, OR this could be the beginning of your new home. The lean-to area (12x60) has concrete pad and workshop (12x36) is ready for tools and additional space. #3. The 32x30 horse barn boast 3 finished stalls with turnouts that lead directly into the pasture, a tack room and covered wash area. 5.5 acres is fenced with 4 strand poly electric fencing, all ready for horse buddies. Two 400-watt solar panels are already mounted and ready for solar inverter. 15 additional acres can easily be fenced for livestock. Additionally, this property has a 7-acre hay field, pond, lots of room for gardens, fruit trees and play area and just 5 MILES TO CAIRO, and convenient to Bainbridge, Havana and Tallahassee!
MlsNumber: --
ListingId: 13906


Listing Provided By: Coldwell Banker Brock Realty, original listing
Phone: (229) 220-4546
Office Phone: (229) 246-5127
Agent Name: Teresa H. Heard
Disclaimer: Copyright © 2025 Southwest Georgia Board of Realtors 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