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

275 Mulberry Road
Molena, GA 30258
Tommy Allen with NextHome MainStreet, original listing - (678) 283-1407

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $828,500
Beds: 3
Baths: Full: 2, ½: 3
Status: Active
SqFt: --
Agency: NextHome MainStreet
Agency Phone: (678) 283-1407

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 25 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2020
Notes: THE PERFECT PLACE TO LIVE, WORK, AND PLAY! BARNDOMINIUM AND EVENT BARN SITTING ON 25.26 PEACEFUL COUNTRYSIDE ACRES OF UPSON COUNTY. MOSTLY OPEN LAND WITH ROLLING HILLS SPOTTED WITH BANANA TREES, BLUEBERRY BUSHES, PEAR TREES, POMEGRANATE, BLACKBERRIES, ELDERBERRY, MULBERRY, AND MUSCADINE, INCLUDING A 7+/- STOCKED POND (BREAM, BASS, CRAPPIE). EASY ACCESS FROM ATLANTA, MACON, AND COLUMBUS. THE BARNDOMINIUM IS COMPLETE WITH FULL LIVING QUARTERS INCLUDING AN OPEN KITCHEN WITH GRANITE COUNTERS, STAINLESS APPLIANCES, DINING AND LIVING AREA AND A BEAUTIFUL WOOD PANELED, VAULTED CEILING. FANTASTIC MUDROOM WITH STORAGE CABINETS, LARGE GRANITE COUNTER WORKSPACE, PLUS LARGE LAUNDRY ROOM. THE OWNER'S BEDROOM, FULL BATH WITH A LARGE TILE SHOWER AND DOUBLE VANITY, WALK IN CLOSET IS ALSO A SAFE ROOM. THE INVITING FRONT PORCH SERVES AS AN ADDITIONAL LIVING AND DINING AREA, AND THERE IS ALSO A COVERED BACK PATIO. A 30X60 PULL THROUGH COVERED RV/BOAT/CARPORT SEPARATES THE LIVING QUARTERS FROM 3 20X16 STORAGE AND WORKSHOP ROOMS. THE BARN AT CALLAWAY POND HOSTS MANY EVENTS THROUGHOUT THE YEAR, AND HAS LOADS OF GROWTH POTENTIAL. WITH A TOTAL OF 3120 SQFT, THE DOWNSTAIRS SPACE EASILY HOSTS 120 GUESTS, FULL KITCHEN, ONE HALF BATH, AND ONE FULL BATH, PLUS STORAGE AREAS. UPSTAIRS IS HEATED AND COOLED, INCLUDES TWO BEDROOMS, TWO LIVING/LOUNGE AREAS, AND TWO HALF BATHS, PLUS LARGE STORAGE AREAS. THERE IS A 30 AMP HOOK-UP AND CLEAN OUT SITE AVAILABLE FOR AN RV. PHOTOS OF EVENTS CAN BE SEEN AT WWW.CALLAWAYPOND.COM. FUTURE BOOKINGS ARE INCLUDED IN THE "SALE". PLEASE NOTE - SQUARE FOOTAGE LISTED IS TOTAL FOR BOTH BUILDINGS. BARNDOMINIUM HAS 1200 SQ FT OF LIVING SPACE. EVENT BARN HAS 3120 ON THE MAIN LEVEL, PLUS AN ADDITIONAL 720 UPSTAIRS.
MlsNumber: --
ListingId: 10490957


Listing Provided By: NextHome MainStreet, original listing
Phone: (770) 468-2506
Office Phone: (678) 283-1407
Agent Name: Tommy Allen
Disclaimer: Copyright © 2025 NextHome, Inc. 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