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

794 Cureton Mill Road
Rising Fawn, GA 30738
Asher Black with Keller Williams Realty, original listing - (423) 664-1900

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $995,000
Beds: 4
Baths: Full: 4
Status: Active
SqFt: 4423 Square Feet
Agency: Keller Williams Realty
Agency Phone: (423) 664-1900

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 11 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2001
Notes: Surrounded by breathtaking panoramic mountain views, this extraordinary 11.5-acre equestrian estate is a rare gem, offering luxury, tranquility, and top-tier amenities. Boasting 4,423 sq. ft. of beautifully designed living space, 4 spacious bedrooms, and 4 full bathrooms, this home is the perfect blend of elegance and functionality.<br /> <br /> From the moment you arrive, you'll be captivated by the wraparound porch with a classic porch swing, inviting you to take in the unmatched 360-degree mountain vistas. Inside, the home showcases a grand open floor plan, soaring vaulted ceilings, and custom decorative lighting, creating an inviting and sophisticated atmosphere.<br /> <br /> The primary suite is a true retreat, featuring stunning bay windows, a private entrance, and a spa-like en-suite with a jetted tub framed by bay windows, dual vanities, and a spacious walk-in shower. Each bedroom includes a walk-in closet, providing ample storage space.<br /> <br /> Designed with convenience in mind, the home includes an elevator from the garage to the main living area, making accessibility effortless. Cozy up by one of the two fireplaces—one on the main floor and another in the basement. The sunroom offers a peaceful escape, while the basement features a full bathroom, fireplace, and a large storage room—ideal for additional living space, a game room, or a home gym.<br /> <br /> Equestrians will love the double-decker barn, complete with horse stalls, a tack room, an office, a full bathroom, and multiple storage rooms. The barn and home both have brand-new roofs, ensuring long-term durability. The fully fenced property features several fenced pastures, scenic riding trails, a garage, carport, and a convenient pull-around driveway.<br /> <br /> This estate is more than just a home—it's a private sanctuary, an equestrian dream, and a rare chance to own a truly remarkable property. Schedule your private tour today and experience the magic of this mountain paradise!
MlsNumber: --
ListingId: 1506613


Listing Provided By: Keller Williams Realty, original listing
Phone: (423) 208-4943
Office Phone: (423) 664-1900
Agent Name: Asher Black
Disclaimer: Copyright © 2025 Greater Chattanooga Association 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.


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 = 431 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 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;
Real Estate Expert Photo for Kandi Lawson
Kandi Lawson
ASCIIRed Barn Realty/Fletcher Bright
Call Today!: (423) 653-4441

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App