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 ('gahud','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 = 'gahud', 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 ('gahud','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 = 'gahud', 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 ('gahud','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 = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back | All Foreclosures | | | All Cities

400 Auburn
Auburn, GA 30011
Daniel Peret with eXp Realty, original listing - (888) 959-9461
« Prev
Next »
Currently Displayed Property Photo


Property Details

List Price: $1,450,000
Beds: 5
Baths: Full: 5, ½: 1
Status: Active
SqFt: 5070 Square Feet
Agency: eXp Realty
Agency Phone: (888) 959-9461

Map Details Show Map | Show StreetView



Description/Comments

Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2025
Notes: !!! PRICE IMPROVEMENT - Builder says Let's Sell It !!! Custom Built Luxury Estate in Highly Sought after new City of Mulberry No HOA Welcome to your dream home, a stunning Custom 5-bedroom, 5.5-bath estate home situated on Gated 1.72 Private Acres. Boasting approx. 5,070 square feet of meticulously designed living space, this unique home combines timeless craftsmanship with modern luxury. From the gated entrance to the dusk-to-dawn exterior lighting and multi-zone irrigation system, every detail is thoughtfully curated for comfort, convenience, and elegance. A Welcoming 2 Story Covered Front Entrance greets you Home! Step into the 2 Story Entry Foyer Flanked by a Custom Designed Office with Builtins to one side and a Formal Dining/Lounge on the other! Attention to detail around every corner with Accent Walls, Upgraded Lighting Fixtures, Custom Luxury Trim Package, and Tons of Builtins! Master on Main Concept with Oversized Owners Retreat showcasing Tray Ceiling, Custom Accent Wall, Electric Fireplace Appointed with Venetian Finished Fireplace Surround! Spa Bath featuring Custom Glass Surround Shower w Gold Accent Rainfall Shower head, Oversized Soaking Tub, Dual Vanities with Makeup Desk and Golden Accented Plumbing and Lighting Fixtures. Custom Designed Closet System allows for Tons of Shelving for all your Organizational Needs! Foyer opens up to Grand Great Room with Coffered Ceilings, Electric Fireplace w Venetian Finished Accent Wall and Custom Builtins, Luxury Lighting, Oversized Windows to allow for tons of Natural Lighting. Step into an open-concept Gourmet Chef's Kitchen featuring all white Cabinetry with Under-Cabinet Lighting and Golden Hardware, Viking Appliances, oversized Quartz Waterfall Island perfect for Hosting and Entertaining! All Surround Quartz Countertops and tiled backsplash, Pot Filler for Ease and Versatility. Large walk-in pantry with custom designed shelving. A Grand View through bay windows to a Covered Lounge Patio featuring Tiled Flooring with an inviting outdoor gas/wood fireplace great for gatherings and featuring Stainless Steel Beverage Center Cooler and Sink. Engineered hardwood flooring throughout the entire home leads you up to the Upper Level featuring Smart Layout with Media center appointed with Venetian finish fireplace and custom shelvingCo ideal for relaxing or entertaining. Designed with a Second Owners Suite on Upper Level featuring Custom Trim, Accent Walls, Oversized Walk in Closets and a Spa-style bath appointed with Rainfall Shower creating a Zen-like ambiance. Large Bonus room can be used as a guest room, home gym, play room etc. Upper Secondary Bedrooms showcase oversized Dedicated Bathrooms, Walk-in Closets and Custom Lighting Package. Home also features Delta plumbing fixtures and tankless water heater (you'll never run out of hot water). Premium 3-Car Garage with Smart Features Built-in shelving and storage systems to keep tools, gear, and seasonal items organized and easily accessible. LiftMaster smart garage door openers with integrated cameras for security. Durable epoxy floor coating thatCOs both stylish and easy to cleanCoresistant to stains, cracks, and wear. A utility sink and quartz countertop with EV-ready wiring. All the Bells and Whistles are here waiting for you! WELCOME HOME!!!
MlsNumber: --
ListingId: 10521666


Listing Provided By: eXp Realty, original listing
Phone: (888) 959-9461
Office Phone: (888) 959-9461
Agent Name: Daniel Peret
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 ('gahud','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 = 'gahud', 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

Contact Me

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App