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

8 Rustling Ridge Trail
Fort Mitchell, AL 36856
Amanda Hester with Keller Williams Realty River Cities, original listing - (706) 221-6900

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $499,900
Beds: 6
Baths: Full: 5, ½: 1
Status: Active
SqFt: 5356 Square Feet
Agency: Keller Williams Realty River Cities
Agency Phone: (706) 221-6900

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: --
Notes: This beautiful, spacious home located in Riverside Landing Subdivision is now available for purchase! Featuring three stories, six bedrooms, five and a half bathrooms, and 5,356 square feet of space, it offers ample room for family, guests, and entertainment! The interior includes hardwood and LVP flooring throughout the main level living and kitchen areas. The separate dining room is elegantly trimmed and offers great natural light! The living room boasts two-story ceilings, detailed trim work, numerous windows that provide abundant natural light, built-in cabinets, a wood-burning fireplace with a gas starter, and recently updated paint. Adjacent to the living room is a stunning kitchen equipped with ample cabinet and countertop space, granite countertops, backsplash, stainless steel appliances, an island with a breakfast bar, a pantry, and an eat-in area. There is one spacious bedroom with a full bath located on the main floor, along with a half bath. On the second floor, you will find a master suite with a sitting area, and a gas fireplace that is the perfect place to relax. The master also features an ensuite bath offering his and her vanities as well as a makeup area, a jetted tub, a fully tiled shower, and a walk-in closet that is as large as a bedroom! The second floor also includes two additional spacious bedrooms and two full bathrooms. Additionally, there is a catwalk overlooking the main living area. The third floor is designed for entertainment, offering an incredible space with a theater room and another room suitable for hanging out with friends and family or as a mother-in-law suite with a kitchenette. Also, you'll find another spacious bedroom with a walk in closet and a full bath! The three-car garage has been transformed into a versatile space great for children, a gym, or an office area, and is insulated, heated, and cooled. The insulated wall can be easily removed to restore the original three garage spaces. All carpeting has been recently replac
MlsNumber: --
ListingId: 220073


Listing Provided By: Keller Williams Realty River Cities, original listing
Phone: (229) 376-2352
Office Phone: (706) 221-6900
Agent Name: Amanda Hester
Disclaimer: Copyright © 2025 Columbus Board of Realtors (GA). 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