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

515 Beaver Dam Road
Odum, GA 31555
Erin Vaughn with BHHS Hodnett Cooper Real Estate BWK, original listing - (888) 638-4750

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $550,000
Beds: 3
Baths: Full: 2, ½: 2
Status: Active
SqFt: 3046 Square Feet
Agency: BHHS Hodnett Cooper Real Estate BWK
Agency Phone: (888) 638-4750

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 7 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1999
Notes: OPEN HOUSE-Saturday March 15th 11am-2pm. This property offers a main house PLUS guest house, all situated on 7.92 acres. The main house is a two-story home featuring a wrap-around porch that connects to the guest apartment. Downstairs, the living room boasts vaulted, wood tongue-and-groove ceilings, alongside a formal dining room or flexible space. The spacious kitchen includes a breakfast area, new dishwasher and refrigerator, and lots of cabinetry. The primary bedroom, located on the main level, features hardwood flooring and an ensuite bathroom with a clawfoot tub, separate shower, and dresser vanity sink. Upstairs, a cozy loft area with hardwood flooring leads to two bedrooms, one with an ensuite half bath and the other with a full bathroom. The attached guest apartment is 620 SF and features a 1 bedroom, 1 bathroom layout, along with a living room and kitchenette. The property further includes producing pecan trees with irrigation, a saltwater, heated swimming pool, and a detached metal building/workshop with two roll-up doors. A pasture/fenced area is provided for farm animals, accompanied by a covered lean-to and two chicken coops. Main house has 2 HVAC units and Guest House as 1 HVAC unit - all three install Q4 of 2022. 2of the 3 thermostats are Ecobee wifi. Roof 8 years old. UTILITIES: Satilla Power; Private Well; Septic; Irrigation sprayers at the base of pecan trees; Propane Gas for the Generac generator; Internet- Starlink (high speed) or use TMobile or Windstream. To maintain the home's condition, please remove shoes or utilize the provided shoe covers. For the safety of the animals, please refrain from entering the pasture area where horses and chickens are located. Showings are preferred on Tuesdays, Thursdays, Saturdays, and Sundays.
MlsNumber: --
ListingId: 1652497


Listing Provided By: BHHS Hodnett Cooper Real Estate BWK, original listing
Phone: (888) 638-4750
Office Phone: (888) 638-4750
Agent Name: Erin Vaughn
Disclaimer: Copyright © 2025 Golden Isles Association of REALTORS. 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