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

276 Oglesby
Bowersville, GA 30516
Joanie Haley with All Hart Realty, original listing - (706) 376-4554

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $380,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 2432 Square Feet
Agency: All Hart Realty
Agency Phone: (706) 376-4554

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 9 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1997
Notes: Peaceful sportsman's paradise situated on 9.55 acres and conveniently located close to Lavonia, Hartwell, Royston and I -85. Gated End of the Road Privacy! Sit Back & RELAX with Peace & Quiet in this 4 Large Bedrooms & 3 Full bathrooms. This home has been upgraded with new stainless appliances and new granite countertops (deep sinks), New engineered hardwood flooring and new luxury vinyl flooring throughout the home. Open kitchen has plenty of space to move around in while cooking plus 2 spacious pantries, bar for easy/quick lunch, breakfast area, and separate dining area. The master/primary bathroom has 2 separate vanities and a new tub/shower. Large living room and a den with a fireplace offers accesses to 1 of the 3 screened in porches. Also, there is a mudroom with washer & dryer connections plus extra space for a 2nd refrigerator/freezer and household supplies/items. All 3 bathrooms have new granite countertops, new sinks, new faucets, and new light fixtures. All kitchen and bathroom cabinets have been refinished to include new brush nickel cabinet pulls. Still need more space? There are 3 covered screened porches - One screened in porch on the front of the home and two screened in porches on the back of the home. The acreage is wooded with a year-round creek flowing through it with lots of wildlife. It can be made into a pasture, see the plat. There are NO subdivisions around this property/land. Ready to move in and has low maintenance landscaping.
MlsNumber: --
ListingId: 10443240


Listing Provided By: All Hart Realty, original listing
Phone: (706) 376-4554
Office Phone: (706) 376-4554
Agent Name: Joanie Haley
Disclaimer: Copyright © 2025 Georgia Multiple Listing Service. 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