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

234 College St
Blakely, GA 39823
Lindsay Gray with Wiregrass Realty, original listing - (334) 232-7053

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $244,900
Beds: 5
Baths: Full: 6
Status: Active
SqFt: 2971 Square Feet
Agency: Wiregrass Realty
Agency Phone: (334) 232-7053

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1886
Notes: MORE PICTURES COMING SOON OF THIS BEAUTIFUL HISTORIC HOME!!! Step back in time with this stunning 1886 historic home, where Southern charm meets modern possibilities. The eye-catching all-white exterior, oversized front porch & antique screen doors with original hardware set the stage for its rich history. A robin's egg blue porch ceiling & classic swing invite you to sit back, relax & take in the charm of small-town life. Step inside & you'll be captivated by the grandeur of the 12-ft ceilings & 8-ft wide foyer. Registered on the National Register of Historic Places in Georgia, this nearly 3,000 sq. ft. home blends historic character with functional living. Off the foyer, four spacious rooms each feature a private full bath—perfect for a variety of uses. A striking 4-ft wide door separates the front of the home from the back, allowing for a private retreat when needed. Beyond it, two additional bedrooms with private baths offer flexible additional living space. One is currently used as a laundry room but could serve as an office or bonus room while the other is the current master suite. The back floor-to-ceiling windows fill the home with natural light, ideal for a sunroom or extra living space. Original hardwoods grace the elegant dining room & the large kitchen provides ample counter space & storage. While currently a beloved primary residence, this home's layout & location make it ideal for an Airbnb or assisted living. A rare chance to own a piece of history!
MlsNumber: --
ListingId: 202948


Listing Provided By: Wiregrass Realty, original listing
Phone: (229) 220-0921
Office Phone: (334) 232-7053
Agent Name: Lindsay Gray
Disclaimer: Copyright © 2025 Dothan 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