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

405 S Kennedy
Metter, GA 30439
Tripp Jones with Jones Realty, Inc., original listing - (912) 685-5045

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $270,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 2967 Square Feet
Agency: Jones Realty, Inc.
Agency Phone: (912) 685-5045

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1912
Notes: Welcome to this beautiful, vintage brick residence nestled in one of the most charming historic neighborhoods in Metter. Nestled on an 0.52 acre corner lot, this classic beauty offers unique architectural detail that is found so rarely in today's market and boasts 2967 square feet. Inside, you will be greeted by a grand living room complemented by an elegant wood-burning fireplace, large arched doorways, and distinctive glass block windows that allow in natural diffused light. The living areas are light, bright, open, and free-flowing with ample room to entertain or enjoy cozy family time. Rich, red carpet, full-room rugs in the living areas and original white oak hardwood floors add so much character to this beautiful home. Spacious retro-style kitchen with ample cabinetry, large windows, and a layout ready to be tailored to your personal touches. A dining room off the kitchen is bright with lots of windows and built-in shelving perfect for a reading nook or plant haven with views looking out at the tranquil back yard. This house boasts 3 bedrooms, each with their own woodburing fireplace, adjoining bathroom, and cedar-lined closets. The bathrooms boast original tile work, with bold color schemes and original fixtures, adding even more to the charm of the property. The backyard is perfectly balanced between shaded area and open space, providing the ideal setting for outdoor relaxation or entertaining. This home is ideal for any buyer seeking the charm of an older home and will be ready to take action in making this dream a reality. A little TLC could make this home shine and be loved for many years to come. Call today for a showing or just call the listing agent to see for yourself the potential of this historic gem!
MlsNumber: --
ListingId: 10384354


Listing Provided By: Jones Realty, Inc., original listing
Phone: (912) 685-5045
Office Phone: (912) 685-5045
Agent Name: Tripp Jones
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