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 = 55 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 = 55 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 = 55 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;

381 Aqua Dr
Wedowee, AL 36278
Westin Brown with EXP REALTY AL, original listing - (888) 923-5547

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,099,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3900 Square Feet
Agency: EXP REALTY AL
Agency Phone: (888) 923-5547

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Escape to Serenity at Lake Wedowee! Your Dream Home Awaits! Welcome to Tranquility III, a stunning gated community where your lakeside living dreams come true! This exquisite 3-level retreat, built in 2018, offers a rare combination of luxury, comfort, and breathtaking views. With 3900 sq ft of meticulously designed space, this home boasts everything you need to create unforgettable memories. Key Features: Location, Location, Location: Nestled on the south end near the Dam, enjoy 149' of year-round water and 30' deep water at the dock-perfect for swimming, fishing, and boating! Master Suite Oasis: Relax in your main-level master suite, featuring ample natural light and easy access to the living areas, ensuring comfort and convenience. Gourmet Kitchen: Cook and entertain in style with leathered granite countertops and sleek Integrity cabinetry. High-end stainless steel appliances make meal prep a pleasure, while the charming pedestal sink in the half bath adds a touch of elegance. Versatile Living Spaces: This home includes two spacious bedrooms on the third level with a shared Jack & Jill bathroom, ideal for family or guests. Plus, a large bonus room with stunning lake views provides the perfect spot for relaxation and fun! Terrace Level Retreat: The fourth bedroom on the terrace level comes complete with a full bath, partial kitchen (including a refrigerator, undercounter ice maker, and dishwasher), and a generous living area-perfect for hosting guests or enjoying movie nights. Outdoor Paradise: The large covered porch, adorned with string lighting, invites you to unwind in the small hot tub or take in the serene surroundings. Stairs lead you down to your private floating aluminum dock equipped with a boat lift and two jet ski ports-your gateway to summer fun on Lake Wedowee! Additional Amenities: Tiled shower for a spa-like experience Covered porch on the main level for year-round enjoyment Generous 2-car garage for all your storage needs Don't miss your chance to own this magnificent lakeside haven! Whether you're looking for a primary residence, vacation home, or investment property, this stunning property has it all! Experience the tranquility and beauty of Lake Wedowee today-schedule your private showing now and make your dream a reality! Your peaceful lakeside lifestyle awaits!
MlsNumber: --
ListingId: 11365097


Listing Provided By: EXP REALTY AL, original listing
Phone: (888) 923-5547
Office Phone: (888) 923-5547
Agent Name: Westin Brown
Disclaimer: Copyright © 2024 My State MLS. 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