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

1961 Yellow Finch Trail Se
Atlanta, GA 30316

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $495,000
Beds: 3
Baths: 3
Status: Active
SqFt: 1951
Agency: Keller Williams Realty Intown Atlanta

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2018
Notes: Newer construction 3-bedroom, 2.5-bathroom home is the perfect blend of modern elegance and cozy comfort! Step inside and discover an inviting open floor plan adorned with gorgeous hardwood floors that stretch across the main level. In the living area is a charming fireplace that sets the stage for warm gatherings and cozy evenings that seamlessly flows into the modern eat-in kitchen, where culinary dreams come to life. A stylish kitchen island takes center stage, complemented by sleek stainless steel appliances and dazzling granite counters. There is also a sitting area perfect to enjoy quiet afternoons in while taking a view of the neighborhood. You will LOVE the drop zone when you are going to and from the garage trying to get out of the house on time!<br /> <br /> Upstairs, the main bedroom awaits, boasting elegant touches with a tray ceiling, spacious walk-in closet, and an ensuite main bathroom featuring double vanities with granite counters, a separate soaking tub, and a glass-enclosed shower—a true oasis of relaxation. The secondary bedrooms share a bathroom with a double vanity and a convenient tub/shower combo, ensuring everyone's needs are met with ease.<br /> <br /> Outside, discover your own private paradise—a back patio with a firepit that is perfect for entertaining or simply unwinding after a long day. There is also a shed for you to store tools and much more. Plus, enjoy the convenience of an expanded driveway for hassle-free parking. Located in a vibrant neighborhood of Sugar Creek, this home is just moments away from East Atlanta Village, Oakhurst, and downtown Decatur, ensuring a lifestyle of convenience and enjoyment.
MlsNumber: 7355865


Listing Provided By: Keller Williams Realty Intown Atlanta, original listing
Name: Keller Williams Realty Intown Atlanta
Phone: (404) 541-3500
Office Name: Keller Williams Realty Intown ATL
Office Phone: (404) 541-3500
Agent Name: Community And Council
Disclaimer: Copyright © 2024 First Multiple Listing Service, Inc. 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