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

29472 Indian Springs Loop
Andalusia, AL 36421
David Miller with United Country Fulford Realty, original listing - (334) 588-3124

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,100,000
Beds: 6
Baths: Full: 3, ½: 1
Status: Active
SqFt: 4219 Square Feet
Agency: United Country Fulford Realty
Agency Phone: (334) 588-3124

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2007
Notes: Nestled on the serene shores of Gantt Lake in Covington County, this breathtaking lakefront home offers a perfect blend of luxury and relaxation. Spanning an impressive 3,894 square feet, this 2 -story residence boasts 6 spacious bedrooms and 3 baths, making it an ideal retreat for families or those who love to entertain. The heart of the home is its custom kitchen, designed with elegance and functionality in mind. It features granite countertops, a working island, and a top-of-the-line Viking refrigerator, making it a dream for cooking enthusiasts. The living room is equally impressive, showcasing soaring ceilings that create a grand and open atmosphere. Crown molding adorns every room, adding an extra touch of sophistication throughout the home. The master suite, located on the main floor, provides a private and serene escape, while the second floor houses four bedrooms and two baths, offering ample space for family and guests. A second-story deck overlooks the pristine lake, providing a tranquil space to enjoy sunrises, sunsets, and the beauty of nature. The property's level lot offers easy access to the water's edge, ensuring you can fully enjoy lakeside living without the challenges of hilly terrain. The boathouse, located directly over the water, includes two boat slips and a dedicated relaxation deck, perfect for fishing, sunbathing, or simply soaking in the lake's natural beauty. This home is a rare find for anyone seeking a peaceful lakeside lifestyle.
MlsNumber: --
ListingId: 201930


Listing Provided By: United Country Fulford Realty, original listing
Phone: (334) 790-7208
Office Phone: (334) 588-3124
Agent Name: David Miller
Disclaimer: Copyright © 2024 Dothan Association of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App