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

2283 Sturdivant Rd
Jacksons Gap, AL 36853

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,675,000
Beds: 5
Baths: Full: 4, ½: 1
Status: Active
SqFt: 3345 Square Feet
Agency: Aronov Realty Brokerage - Lake Martin Division
Agency Phone: (256) 825-4033

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Single Family Residence
Year Built: 2024
Notes: Presenting a masterpiece by Jim Mathews Builder in the prestigious Miner's Cove Phase III, this quality-built residence offers a perfect blend of elegance and comfort. Boasting 5 bedrooms, 4.5 bathrooms, a 3-car garage, and a stone seawall, this stunning property sits on a picturesque flat lot with breathtaking views of the lake.The Lake level floor welcomes you with a spacious kitchen, a cozy living area with a fireplace, and an abundance of dining space. Enjoy the serenity of the outdoors on two large covered porches, including one vaulted porch with an outdoor fireplace, perfect for lakeside gatherings and al fresco entertaining. On the main floor, you'll find a large primary on-suite and a guest suite for easy accessibility. The primary suite offers a tranquil lake view, a spacious bathroom with a generous walk-in closet, separate shower, and tub areas. Upstairs, discover two additional bedrooms, a bonus room, and two more bathrooms, providing ample space for relaxation and privacy. With an estimated completion in October 2024, seize the opportunity to personalize this exceptional home to your liking. Don't miss your chance to own this magnificent lakeside retreat. Embrace luxury living at its finest - schedule a showing today and envision the lifestyle awaiting you at Miner's Cove Phase III.<br /> Key Features:**<br /> - 5 bedrooms, 4.5 bathrooms<br /> - 3-car garage and stone seawall<br /> - Gorgeous flat lot with stunning lake views<br /> - Spacious kitchen with Kitchen Aid appliances with buyer's choice of range or cooktop and living area with gas fireplace<br /> - Two large covered porches, including one with vaulted ceiling with outdoor wood burning fireplace<br /> - Main floor primary on-suite and guest suite<br /> - Upstairs bedrooms, bonus room, and baths<br /> - Estimated completion in October 2024<br /> Make this exceptional lakefront property your own oasis of tranquility. Act now and secure your piece of paradise in Mine's Cove Phase 3!
MlsNumber: --
ListingId: 24-869


Listing Provided By: Aronov Realty Brokerage - Lake Martin Division, original listing
Phone: (334) 549-3933
Office Phone: (256) 825-4033
Agent Name: Virginia Pettus
Disclaimer: Copyright © 2024 Lake Martin Area 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.


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 = 61 AND i.igate IN ('usahud','alhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'alhud', 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;
Real Estate Expert Photo for Stacey Sanders
Stacey Sanders
ASCIIThe Key Agency
Call Today!: (334) 319-2249

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App