Title Page Background
DEBUG FN args: Array ( [0] => 401 [1] => [2] => [3] => agent ) BEFORE: Site: 401 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 401 Igate: njhud LocID: 401 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 = 401 AND i.igate IN ('alhud','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 = 'alhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 401 [1] => [2] => [3] => lender ) BEFORE: Site: 401 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 401 Igate: njhud LocID: 401 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 = 401 AND i.igate IN ('alhud','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 = 'alhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 401 [1] => [2] => [3] => other ) BEFORE: Site: 401 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 401 Igate: njhud LocID: 401 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 = 401 AND i.igate IN ('alhud','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 = 'alhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back | All Foreclosures | | | All Cities

727 Latrobe Way
Macon, GA 31220
Joanna Jones with Sheridan, Solomon & Associates, original listing - (478) 746-2000
« Prev
Next »
Currently Displayed Property Photo


Property Details

List Price: $1,750,000
Beds: 6
Baths: Full: 6, ½: 1
Status: Active
SqFt: 7919 Square Feet
Agency: Sheridan, Solomon & Associates
Agency Phone: (478) 746-2000

Map Details Show Map | Show StreetView



Description/Comments

Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2007
Notes: Chance of a lifetime opportunity to purchase this stunning, well-appointed dream home, meticulously custom-designed and built by the current owner. This exquisite, close-to 8000 square-foot estate is situated on a serene 2.5 acre cul-de-sac lot, offering unparalleled privacy and stunning lake views. The architecture is like no other with her high, barreled ceilings and breathtaking 24-foot incredible window giving you a peaceful tranquil view of the lake with an abundance of natural light throughout the house. High-end is an understatement! Marble floors, hardwoods and special, unique attention to curves throughout the home, including the wrought iron railing, plus fabulous, wide staircases purposely created to flow with the design of the home. Expansive formal living and dining rooms perfect for hosting gatherings and special occasions. The gourmet kitchen is a chef's delight featuring top of the line, stainless-steel appliances ensuring every meal is prepared with ease and style with a huge spacious granite island. Surround sound system adds to the fun! A house created for entertainment with big rooms throughout, porches and patios. A lower level walk-out for grilling with game areas and a gorgeous salt water pool. The downstairs boasts your own private movie theatre. Parties galore! Other amenities include an automatic Moen water shut-off valve, intercom system, central internet wiring, central vac, electric car charging station and everything nearly new. You will be enchanted as you stroll through the private acreage where you may relax and enjoy your own getaway spot away from the world. This chic, ritzy and luxurious place will bring you the cosmopolitan prestige you deserve in this North Macon exclusive community.
MlsNumber: --
ListingId: 175548


Listing Provided By: Sheridan, Solomon & Associates, original listing
Phone: (478) 731-1302
Office Phone: (478) 746-2000
Agent Name: Joanna Jones
Disclaimer: Copyright © 2024 Mid Georgia MLS. 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] => bibb [3] => GA [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: bibb State: GA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: bibb 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 = 401 AND i.igate IN ('alhud','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 = 'alhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Vicky Wylie
ASCIIFickling and Company
Call Today!: (404) 545-5320

Contact Me

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App