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 = 549 AND i.igate IN ('usahud','wahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'wahud', 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 = 549 AND i.igate IN ('usahud','wahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'wahud', 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 = 549 AND i.igate IN ('usahud','wahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'wahud', 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;

1510 Holloway-ray Road
Mcintyre, GA 31054
Latham Foster with Robert Binion Real Estate, original listing - (478) 454-4170

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $510,000
Beds: 5
Baths: Full: 4, ½: 1
Status: Active
SqFt: 3701 Square Feet
Agency: Robert Binion Real Estate
Agency Phone: (478) 454-4170

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 25 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2005
Notes: Large home with 25.07 acres total! 2 parcels sold together to make up the 25 acres. With some TLC and finishing work, this home would be perfect for anyone who desires quiet, private living. Make yourself comfortable in this 4 bedroom, 3.5 bathroom home with beautiful views of the pond and wildlife. The half bath just needs a shower put in to make it your forth full bathroom! The kitchen has so much cabinet space with an island, breakfast nook, and room for a dining table. Fear not, you also have a formal dining room or den right next to it! The living room is spacious with a fireplace and built-in storage. The primary bedroom has big windows providing great natural light and a huge bathroom with a walk-in closet. All bedrooms are a great size with nice sized closets as well. The beautiful covered back porch has plenty of space and extends the whole length of the home. Front porch is also covered and provides a nice place to sit and relax. The red barn has a 1 bedroom, 1 bathroom studio style apartment with a 3 car garage underneath it. This could make for a great in-law suite! (Contact agent for pictures of that) There is also a large pole barn on the property. Home is sold AS-IS.
MlsNumber: --
ListingId: 52491


Listing Provided By: Robert Binion Real Estate, original listing
Phone: (478) 251-8976
Office Phone: (478) 454-4170
Agent Name: Latham Foster
Disclaimer: Copyright © 2025 Milledgeville 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