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

2440 Emerald Drive
Jonesboro, GA 30236
Pam Landzhev with EXP Realty, LLC., original listing - (888) 959-9461

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,700,000
Beds: 5
Baths: Full: 4, ½: 1
Status: Active
SqFt: 7386 Square Feet
Agency: EXP Realty, LLC.
Agency Phone: (888) 959-9461

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1968
Notes: Luxurious LAKEFRONT Estate on Lake Spivey – A True Oasis of Elegance and Relaxation Welcome to the epitome of luxury living on the prestigious Lake Spivey in Georgia. This breathtaking lakefront estate offers a lifestyle of unparalleled comfort and sophistication. Step into your private oasis, featuring a resort-style heated pool with a water park slide, beach entry, and a stunning stone jacuzzi. The professionally landscaped grounds include atmospheric lighting, elegant stonework, and panoramic lake views that create a serene and picturesque setting. Relax by the striking outdoor stone fireplace, lounge in the comfortable seating areas, or freshen up in the convenient outdoor pool shower—all designed for both grand entertaining and peaceful relaxation. The lake vistas provide a tranquil backdrop, seamlessly blending the outdoor beauty with the luxurious interiors of this home. Inside, discover an expansive layout highlighted by five additional stone fireplaces, a grand entryway, and sweeping views of the pool and lake from nearly every room. The owner’s suite is a masterpiece of luxury, featuring a custom wrap-around closet, a private fireplace, and a balcony that offers spectacular lake views. The open-concept main living area, with direct access to the pool, is centered around impressive fireplaces that add warmth and grandeur. For fitness enthusiasts, a fully equipped gym awaits in one of the bedrooms. This estate also includes a versatile guest house, perfect for entertaining or accommodating visitors. It features a custom stone fireplace, a massive bar, a Turkish bath, a loft, a full kitchen, and a dining area. For outdoor lovers, the property boasts two private docks on Lake Spivey, surrounded by picnic areas, a playground, and greenhouses. The estate’s seclusion ensures complete privacy and tranquility, making it a true haven. This Lake Spivey treasure is more than a home—it’s a lifestyle. From the luxurious amenities to the stunning natural beauty, every day feels like a getaway. Don’t miss the chance to own this extraordinary property. Schedule your private showing today and experience the magic for yourself. <br /> Please note that this home is not located in a mandatory HOA subdivision. Joining the HOA is optional and only necessary if the owners wish to obtain a boat dock permit.
MlsNumber: --
ListingId: 7490516


Listing Provided By: EXP Realty, LLC., original listing
Phone: (404) 429-5216
Office Phone: (888) 959-9461
Agent Name: Pam Landzhev
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 = 421 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 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;
Johnetta Dillard
ASCIINewhouse Alliance Corp
Call Today!: (404) 493-6579

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App