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

400 Yacht Club Road
Titus, AL 36080
Stacy St. Cin with Securance Realty, original listing - (334) 268-3071

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $895,000
Beds: 4
Baths: Full: 4, ½: 1
Status: Active
SqFt: 4850 Square Feet
Agency: Securance Realty
Agency Phone: (334) 268-3071

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1986
Notes: STUNNING WATERFRONT home on LAKE JORDAN! Discover this beautiful and spacious 4 BR, 4.5-BATH home located on the SERENE SHORES of Lake Jordan. With breathtaking views of the main lake, this property offers plenty of room for family and friends to gather and create unforgettable memories. Home Features ample parking, Private Boat Landing, two car carport and a full basement with a roll-up garage door for storage. Basement Amenities include a cleaning station for fish, a dedicated storage area for tools and fishing gear, and a second roll-up garage door facing the lake with a built-in electric winch for easy access. There is a spacious double-level deck (20x55 ft) featuring a covered two-slip boathouse. The lighted upper deck is perfect for sunbathing or entertaining, all while enjoying stunning lake views. An adjacent pier provides additional access. Main Level features GREAT ROOM with a gorgeous stone fireplace, 2 bedrooms, a spacious kitchen with pantry, dining room with a bar, an exercise room/office, and a guest bathroom. The main bedroom opens to a wraparound porch and boasts a large walk-in closet and a luxurious en-suite with a double vanity, Jacuzzi tub, and sauna. Upper level includes a large family area ideal for relaxing, complete with a built-in bar. The second level offers two bedrooms sharing a Jack and Jill bathroom with a Jacuzzi tub and shower. One bedroom features a cozy fireplace. There is an additional small room that provides flexibility and can be used as an office or extra sleeping area. Built in 1986, this home is constructed with a steel and concrete foundation for added stability. The exterior features durable brown cypress wood siding and insulated walls. The home is equipped with four central air units. With 499 feet of waterfront and an additional 2.3-acre lot behind the house, you'll enjoy seclusion and privacy while being just minutes away from local amenities. Don’t miss your chance to own this remarkable lakefront property!
MlsNumber: --
ListingId: 566427


Listing Provided By: Securance Realty, original listing
Phone: (334) 268-3071
Office Phone: (334) 268-3071
Agent Name: Stacy St. Cin
Disclaimer: Copyright © 2024 Montgomery Area Association of Realtors 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

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 = 25 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;
Diana Goodson
ASCIICentury 21 Prestige
Call Today!: (334) 657-0465

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App