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

4398 Treadle Road Sw
Mableton, GA 30126

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $435,000
Beds: 3
Baths: 3
Status: Active
SqFt: 2009
Agency: Bolst, Inc.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2023
Notes: Newer Construction with Upgrades Galore! From the Covered Front Porch, step inside to find a wonderfully Open Floorplan. The Light-filled Family Room flows effortlessly to a Dining Room then Kitchen lending itself to being perfect for hosting Neighbors, Friends, or Family for Football Games, Game Nights, etc. Situated beside the Kitchen in the Dining Area, you'll find a Custom Built-In Coffee and Beverage Bar with a Temperature Controlled Wine Fridge to hone in on your at-home barista skills. The Kitchen features a Large Breakfast Bar Island, Stainless Steel Appliances, and a Walk-in Pantry with Custom Updated Shelving and Cabinetry. Another Custom built-in feature on the main level is a Mud Room providing a Drop Zone and Additional Storage upon entry through the Garage. A Lofted Living Area sits at the top of the stairs which allows for a second relaxation area in the home. The Oversized Primary Suite is a true retreat with a Tray Ceiling, Spa-like Dual Vanity Bathroom, and Massive Updated Walk-in Closet with Custom Shelving. Two Spacious Secondary Bedrooms each come with generous closet spaces and share a Jack-and-Jill Style Dual Vanity Bathroom. The Laundry Room, also updated with Custom Shelving, is located upstairs for added convenience. All Custom Built-ins (coffee bar, pantry, mudroom, laundry room, and primary closet) were installed by Closet Factory and come with a Lifetime Warranty transferrable to the new homeowner. All Home Warranties are also still in place including an 11-month Builder Walkthrough to fix any nail pops and repaint. To make things even better, the home is wired to be a smart home! Looking to invest? There are still TEN Rental Permits Available! Willowcrest is a Friendly/Social Neighborhood with helpful neighbors that are always willing to help with a package or bringing your trash in. Annual Events focused around the holidays are also common here. Enjoy the neighborhood amenities including a Clubhouse, Pool, and Playground. A second clubhouse and pool are in the works and slated to be completed this year! Outdoor Enthusiasts will love that the Silver Comet Trail is only steps away. Enter from Floyd Rd where you can rent bikes from the Comet Trail Cycles Shop! Steps to several grocery stores including Publix, Kroger, Aldi, and Lidi along with several dining options.
MlsNumber: 7356232


Listing Provided By: Bolst, Inc., original listing
Name: Bolst, Inc.
Phone: (404) 482-2293
Office Name: Bolst, Inc.
Office Phone: (404) 482-2293
Agent Name: The Justin Landis Group
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.


Local Real Estate Expert

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 = 2242 AND i.igate IN ('usahud','pahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'pahud', 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;
Michael Timcheck
ASCIIBerkshire Hathaway The Preferred Realty
Call Today!: (412) 722-7425

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App