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

2202 St Andrews Way
Phenix City, AL 36867
Keith Williams with Keith Williams Realty Inc, original listing - (706) 256-1000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $999,990
Beds: 7
Baths: Full: 5, ½: 2
Status: Active
SqFt: --
Agency: Keith Williams Realty Inc
Agency Phone: (706) 321-1111

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1991
Notes: Discover elegant Southern living in the prestigious St. Andrews community. This expansive residence, spanning over 7281 heated/cooled square feet, offers six bedrooms, five full baths, two half baths, and a private in-law suite with separte entrance—all wrapped in timeless charm and luxurious details.<br /> The main level invites you in with a two-story foyer, leading to a formal living room, a family room, and a formal dining room. A custom kitchen—complete with stone countertops, gas burning cook top, Wolf oven, walk-in pantry, and Thermador built-in fridge and freezer—flows into a dining area and sunroom, where a cozy fireplace frames picturesque garden views. The owner’s suite boasts a lavish en-suite bath and a spacious custom walk-in closet. Also on this floor are two half baths, a wet bar, a laundry room, and a mudroom with an additional built in Thermador fridge and freezer.<br /> Upstairs, the right wing features three spacious bedrooms with walk-in closets, two full baths, and an office/library. The left wing includes a large bonus room or additional bedroom with a private bath.<br /> The lower level houses a private in-law suite with a bedroom, bathroom, living room, kitchenette, laundry room, and four closets. It opens directly to the lush gardens and provides convenient additional parking.<br /> Outside, the home offers an expansive covered 1000+ sq ft terrace with a wood-burning fireplace and slate flooring, overlooking a sparkling saltwater pool and beautifully landscaped gardens. The three-car garage includes extra storage space. Additional highlights include plantation shutters, custom hardware, spray foam insulation, a fully encapsulated crawl space, a monitored dehumidifier, tankless water heaters, and zoned heating and cooling. Additionally a new roof, septic system, inground salt water pool, fenced yard, muliple gardens and so much more!
MlsNumber: --
ListingId: E100007


Listing Provided By: Keith Williams Realty Inc, original listing
Phone: (706) 256-1000
Office Phone: (706) 256-1000
Agent Name: Keith Williams
Disclaimer: Copyright © 2025 East Alabama Board 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