Title Page Background
DEBUG FN args: Array ( [0] => 431 [1] => [2] => [3] => agent ) BEFORE: Site: 431 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 431 Igate: njhud LocID: 431 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('gahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 431 [1] => [2] => [3] => lender ) BEFORE: Site: 431 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 431 Igate: njhud LocID: 431 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('gahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 431 [1] => [2] => [3] => other ) BEFORE: Site: 431 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 431 Igate: njhud LocID: 431 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('gahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

697 N Stewart Lane
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: $825,000
Beds: 4
Baths: Full: 5
Status: Active
SqFt: 4149 Square Feet
Agency: Keller Williams Realty
Agency Phone: (423) 664-1900

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2016
Notes: Welcome to 697 N Stewart Ln, a stunning 4-bedroom, 3 full/2 half-bathroom home offering 4,149 sq. ft. of luxurious living space on 3.2 acres in the exclusive, gated Cloudland at Lookout community.<br /> <br /> From the moment you arrive, you're greeted by a grand circular entryway with a 5-foot stone monument and towering light fixtures, leading to a stone-covered front porch and custom double metal doors with muted glass. Inside, the great room boasts soaring vaulted ceilings, a massive stone fireplace, and expansive windows that flood the space with natural light. The open floor plan effortlessly flows into the chef's kitchen, which features high-end cabinetry, a service island, professional wine bar, and a floor-to-ceiling pantry.<br /> <br /> The main-level master suite is a private retreat, offering a luxurious walk-in shower, soaking tub, and custom-designed walk-in closet for exceptional storage. Adjacent to the master, a private office/library provides a peaceful space for work or relaxation.<br /> <br /> Upstairs, three additional spacious bedrooms, each with walk-in closets, provide comfort and privacy. The loft area includes an attached half-bath, perfect for guests or as a flexible living space.<br /> <br /> Outdoor living is nothing short of spectacular. The screened porch with its own LP fireplace offers year-round comfort, while the covered pavilion is equipped with chandeliers, a ceiling fan, TV, and electric—ideal for entertaining or unwinding. The meticulously landscaped grounds feature native plants and gardens, with decorative pots that convey with the home, creating a beautiful, peaceful retreat.<br /> <br /> Additional highlights include two LP fireplaces, a 22KW Generac LP gas generator for automatic power, an encapsulated crawl space with dual-fuel air handlers, antique sensor lights, and a three-car garage with extensive storage.<br /> <br /> Cloudland at Lookout provides miles of hiking and riding trails, adding to the appeal of this one-of-a-kind property.
MlsNumber: --
ListingId: 1513512


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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App