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

2081 Blue Sky Avenue
Covington, GA 30016

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $449,900
Beds: 4
Baths: 3
Status: Active
SqFt: 3048
Agency: Drake Realty of Greater Atlanta, Inc.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2023
Notes: Welcome to your "No Bank" Required, New Construction Dream Home with Guaranteed Seller Financing and only $28,500.00 down! Up to 30 years financing (interest rate fixed for the first 7 years) on this Brand New Luxury Craftsman Home... Don't miss your opportunity to own this Home priced at $449,900.00 in the New Westfield Village Community in Newton County. This home sits on a large corner lot and has tons of curb appeal. The Westfiled Village Community boasts some of the largest homesite in all of Newton County. Take advantage of our Limited Time "No Bank" Hassle-Free Guaranteed Seller Financing. It requires verified income and a minimum credit score of 620 to those who qualify (your actual FICO Score will determine your interest rate). The home is located just 20 minutes from downtown Atlanta and minutes from I-20 and the Stonecrest Mall to the west, and the new Covington Town Center with it's several restaurants and movie production studios as you travel east on I-20. As you enter the foyer there is a grand Office-Study complete with chandelier and accent wall. The lower level half bath features a large vanity and mirror with black fixtures and a modern pendant light. This one-of-a-kind customized luxury home provides elegance and beauty year-round. It has a large open concept kitchen with granite counter tops, Glass Tile Backsplash, Stainless Steel High-end Appliances and a center island as well as white custom cabinets. Modern recessed LED lighting adorns the entire home. The great room features a stunning in-wall LED electric fireplace with wood mantle with exotic tile finishes. Accent pendant lighting finishes out the fireplace wall. 3 inch wood blinds throughout the entire space adds beauty and style to this well appointed home. Upstairs there are 4 bedrooms & 2 full bathrooms with granite countertops, high-end black fixtures and accent pendant lights. There is a large bonus Flex Space-Loft area complete with a custom built-in hardwood entertainment center. The primary bedroom is spacious and has two walk-in closets for added space and storage. The 3 additional bedrooms are large and each has recessed lighting and programmable ceiling fans. The side-entry two car garage is spacious and this home has been professionally landscaped. Neighborhood amenities includes a community membership to the swim center with a kids playground. The HOA dues is only $650 per year and includes street lighting, underground utilities, common area maintenance, as well as sidewalks, paved walking trails and pocket parks. Don't miss the opportunity to make this Seller Financed Dream Home your own! Agent has an affiliation with the Owner Entity.
MlsNumber: 10257956


Listing Provided By: Drake Realty of Greater Atlanta, Inc., original listing
Name: Drake Realty of Greater Atlanta, Inc.
Phone: (770) 565-2044
Office Name: Drake Realty, Inc.
Office Phone: (770) 565-2044
Agent Name: Darryl Terrell
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.


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 = 94 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 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;
Shantel Williams
ASCIILOAN DEPOT
Call Today!: (520) 954-2275

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App