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

801 Walnut Street
Louisville, GA 30434
Charlton Carswell with Keller Williams Realty Augusta Partners, original listing - (706) 868-3772

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $365,000
Beds: --
Baths: --
Status: Active
SqFt: 4917 Square Feet
Agency: Keller Williams Realty Augusta Partners
Agency Phone: (706) 868-3772

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Commercial Sale-Business
Year Built: 1950
Notes: Discover a unique opportunity at 801 Walnut St in the quaint, picturesque, tree-lined town of Louisville, GA. This versatile commercial property was previously licensed by the state of Georgia as a Personal Care Home accommodating up to 11 individuals until 2022. The main house offers a spacious 3,567 sq ft layout featuring six bedrooms and four easily accessible bathrooms. It boasts generous living spaces, a large open dining area, and a beautiful 12' x 40' front porch perfect for relaxation.<br /> <br /> Included on the property is a 1,350 sq ft guest house, built in 2006, with two bedrooms and two bathrooms. This space is ideal for owner or staff living quarters or could be used as a short-term rental property. Situated on a flat corner lot in the heart of Louisville, the property offers the convenience of town living with the charm of a close-knit community.<br /> <br /> With Personal Care Homes in high demand, this property is primed and ready for a new owner to continue its legacy. It already has a fire suppression system in place as well as a wheelchair ramp, meeting key requirements for such facilities. The location is centrally located with easy access to Augusta (46 miles), Millen (35 miles), Milledgeville (56 miles), Sandersville (28 miles), Harlem (42 miles), Wrens (approximately 12 miles), and Swainsboro (34 miles).<br /> <br /> Whether you're looking to re-establish a Personal Care Home, convert it into a grand residence, or explore investment opportunities, this property offers endless possibilities. Don't miss out on this exceptional opportunity in picturesque Louisville, GA.
MlsNumber: --
ListingId: 536395


Listing Provided By: Keller Williams Realty Augusta Partners, original listing
Phone: (706) 836-5180
Office Phone: (706) 868-3772
Agent Name: Charlton Carswell
Disclaimer: Copyright © 2024 Greater Augusta 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