Title Page Background
DEBUG FN args: Array ( [0] => 397 [1] => [2] => [3] => agent ) BEFORE: Site: 397 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 397 Igate: njhud LocID: 397 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 397 AND i.igate IN ('vahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 397 [1] => [2] => [3] => lender ) BEFORE: Site: 397 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 397 Igate: njhud LocID: 397 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 397 AND i.igate IN ('vahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 397 [1] => [2] => [3] => other ) BEFORE: Site: 397 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 397 Igate: njhud LocID: 397 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 397 AND i.igate IN ('vahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

331 Wages
Auburn, GA 30011
Igor Arkhipov with Realco Brokers Intl. LLC, original listing - (404) 671-9321

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,290,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 4000 Square Feet
Agency: Realco Brokers Intl. LLC
Agency Phone: (404) 671-9321

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2020
Notes: Gorgeous Four Sided Brick Custom Built Estate On 1.71 Acres With No HOA/Restrictions! Long Driveway Welcomes You To Your New Home With An Oversized Three Car Garage. Stunning Foyer Featuring A Curved Staircase And A Modern Sphere Chandelier Catch Your Eyes As You Step Inside. Truly Unique And Practical Layout Is What Makes This Home A Winner! There Is A Master On Main Suite And Another Master Suite Upstairs To Accommodate Many Living Styles. On The Main Level, In Addition To The Master Suite, There is Another Bath, Office, Living Room With A Wood Burning Fireplace, Dining Room, Large Kitchen And The Laundry Room Is On The Main. Upstairs, The Layout Is Mirrored With Another Master Suite, Living Room/ Rec Area And Two Generously Sized Bedrooms That Share A Full Bath. Beautifully Upgraded Lighting Fixtures Throughout The Home, Storm Proof European Windows And Solar Panels Add To The Efficiency. Outside, The Backyard Is Fenced And The Land Has Been 100% Cleared For Your Use. As An Added Bonus, 25 Fruit Trees Have Been Planted Including Apple, Plum Cherry, Peach, Pear, Asian Pear And Mulberry. Home Had Propane And A Septic Tank. Great Location Right On The Gwinnett/Barrow County Line. Enjoy The Convenience Of Being Close To Schools, Highways (85&316), Amenities (Mulberry Park,Etc), Shopping And Entertainment. Ideal Location With The Perks Of Gwinnett County And The Benefits Of Low Barrow County Taxes. This Property Is Very Close To Rowen (2K Acre Development Bringing 7500 New Jobs). Groundwork Has Begun. This Will Bring Many Jobs To The Area - Many Of Them Executive Level Jobs. Also New 500+ Acre Development Is In Review And Coming Close And Bringing Commercial /Retail/Fitness Center And A Large Law For Events. Great Opportunity To Buy Before All Of The Development!
MlsNumber: --
ListingId: 10513301


Listing Provided By: Realco Brokers Intl. LLC, original listing
Phone: (678) 362-2427
Office Phone: (404) 671-9321
Agent Name: Igor Arkhipov
Disclaimer: Copyright © 2025 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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => barrow [3] => GA [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: barrow State: GA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: barrow State: GA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 397 AND i.igate IN ('vahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Marcelle Smith
Marcelle Smith
ASCIIPeach State Realty Inc
Call Today!: (678) 665-4864

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App