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

959 Cedar Pines Road
Mathews, AL 36052
Norman Schlemmer with ARC Realty, original listing - (186) 628-3253 x2

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $699,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Pending
SqFt: 3558 Square Feet
Agency: ARC Realty
Agency Phone: (186) 628-3253 x2

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1995
Notes: Welcome to Paradise and enjoy a staycation! Ask for the attachment with full detailed description of updates, additions, upgrades of the $280,000+ in upgrades and improvements! Service members and veterans, this stunning property has an assumable VA loan at 2.375%!<br /> Experience Ultimate Tranquility and Luxury on a 10+ Acre Private Wooded Retreat with Lakefront Access to a private stocked 12-Acre Lake<br /> Escape to your very own secluded paradise nestled in over 10.6 acres of pristine woods, offering breathtaking lakefront views, abundant wildlife, and unparalleled peace and privacy. Renovated, custom-built home is the perfect blend of luxury and nature, just 10 minutes from Pike Road, making it ideal for those seeking a serene retreat without sacrificing convenience.<br /> This extraordinary 3500+ square foot home(gym off the MBR is not in square footage, add 160 sq ft+/-)) features 4 spacious bedrooms, 3.5 bathrooms, and a host of high-end upgrades that elevate comfort and style, thoughtfully designed with both elegance and practicality in mind. More sq ft under roof with walk in attic, wraparound porch. From the expansive living areas to the inviting outdoor spaces, every inch of this home is crafted for relaxation and enjoyment.<br /> Step outside to your personal oasis: expansive covered decks overlooking a state-of-the-art pool, a private beach, and a covered dock with a granite prep surface and sink, boat slip, chicken coup, RV cover, 3 pole barns, fishing light and fountain. The tranquil, stocked lake invites you to canoe, kayak, or simply enjoy the view, while the surrounding wildlife—deer, birds, and more—offers a peaceful connection to nature. Whether you're entertaining friends or unwinding in solitude, this property provides the perfect balance of recreation, relaxation, and serenity.<br /> Thoughtful interior design touches with timeless luxury while preserving the natural beauty of woods and water is an unbeatable combination
MlsNumber: --
ListingId: 570280


Listing Provided By: ARC Realty, original listing
Phone: (186) 628-3253 x2
Office Phone: (186) 628-3253 x2
Agent Name: Norman Schlemmer
Disclaimer: Copyright © 2025 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 = 50 AND i.igate IN ('usahud','mihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 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;
Tiffany Gholston
ASCIIeXp Realty
Call Today!: (334) 224-1826

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App