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

302 Marginal Street
Sylvester, GA 31791
Amanda Wiley & Kyla Standring Team with ERA ALL IN ONE REALTY, original listing - (229) 888-6653

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $249,900
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1766 Square Feet
Agency: ERA ALL IN ONE REALTY
Agency Phone: (229) 888-6653

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Other
Year Built: 1990
Notes: This stunning home was originally built circa 1944, and to keep a piece of Sylvester history, was relocated to where it sits now in 1990. The home has been thoughtfully remodeled while keeping the classic touches that make it so charming! Stepping into the foyer, you are greeted by 9 foot ceilings and original hardwood floors throughout that have been restored to perfection, and original plaster walls with arches that date back to the 1940s. The oversized living room boasts a brick, wood burning fireplace with a built-in flanking the detailed mantle, and is complete with recessed LED lighting and a huge ceiling fan with gold accents. The dining room was made for gathering and flows seamlessly from the living room and into the all-new kitchen, complete with marble countertops, a fluted farmhouse sink, all new stainless steel appliances, and a custom vent hood. The primary suite is LARGE with double closets, recessed LED lighting, 60” ceiling fan, and an all-new primary bathroom with marble countertops, and a spa-like walk-in shower with floor to ceiling ceramic tile and a rain fall showerhead. The other 2 bedrooms are ample size and the hall bathroom boasts a cast iron tub that is sure to last for years to come, with all new tile and marble countertops that flow together with the other wet areas of the home. Other updates include all new plumbing lines, new TANKLESS water heater, an HVAC system only 1 year old, reglazed windows with storm windows over the top, brand new garage door for the one car garage, and all new lighting throughout the entire home. Seller is a licensed realtor in the state of GA.
MlsNumber: --
ListingId: 163740


Listing Provided By: ERA ALL IN ONE REALTY, original listing
Phone: (229) 888-6653
Office Phone: (229) 888-6653
Agent Name: Amanda Wiley & Kyla Standring Team
Disclaimer: Copyright © 2024 Albany Board of Realtors and Southwest Georgia 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