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

400 Etheridge Mill
Milner, GA 30257

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $753,900
Beds: 5
Baths: 4
Status: Active
SqFt: 2940
Agency: BENHAM REAL ESTATE GROUP-GA

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 9 acre(s)
Property Type: Residential
Year Built: 2020
Notes: Welcome home to this AMAZING 5 bedroom, 3.5 bath home situated on 9.24 private acres. Coded, electric, gated entrance. Covered rocking chair front porch. The timeless kitchen showcases white shaker cabinets with granite counters, white subway tile backsplash, stainless appliances including a gas cooktop, and pot filler. Large walk in pantry with custom wood shelving. Oversized owners suite with spacious en-suite. His and hers vanity, soaking tub, and large tiled shower. The en-suite is connected to a huge walk-in closet with custom wood shelving. On the main floor you will also find an additional bedroom with its own bathroom. Upstairs are three additional large bedrooms and one full bath. Relax on the covered back porch with a fire in the outdoor fire place. Hot tub and Pool hook ups have already been installed. 30 x 40 shop equipped with water, power, internet, laundry hook up, and security system. Two RV hooks up are also available. Custom built chicken coop. Fenced in area, ready for goats, pigs, or could house one horse or one cow. Tons of wildlife and acreage making it perfect for hunting. Interior and Exterior of home equipped with security system. This property could be divided and split off into two lots, if buyer desired. The possibiltles are endless and ready for its new owners and furry friends. This home has so much to offer. You do not want to miss this one!! Call today to schedule a private tour.
MlsNumber: 10277377


Listing Provided By: BENHAM REAL ESTATE GROUP-GA, original listing
Name: BENHAM REAL ESTATE GROUP-GA
Phone: (770) 412-1055
Office Name: Benham Realty Group
Office Phone: (678) 688-4246
Agent Name: Mary Ann Wells
Disclaimer: Copyright © 2024 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