Title Page Background
DEBUG FN args: Array ( [0] => 537 [1] => [2] => [3] => agent ) BEFORE: Site: 537 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 537 Igate: njhud LocID: 537 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 = 537 AND i.igate IN ('cahud','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 = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 537 [1] => [2] => [3] => lender ) BEFORE: Site: 537 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 537 Igate: njhud LocID: 537 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 = 537 AND i.igate IN ('cahud','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 = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 537 [1] => [2] => [3] => other ) BEFORE: Site: 537 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 537 Igate: njhud LocID: 537 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 = 537 AND i.igate IN ('cahud','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 = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

1132 Ga-157
Lookout Mountain, GA 30750

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $869,000
Beds: 4
Baths: Full: 2
Status: Active
SqFt: 2977 Square Feet
Agency: Keller Williams Realty

Map Details Show Map | Show StreetView




House Features

Appliances: Dishwasher, Washer, Refrigerator
Architectural Style: Other
Construction Materials: Vinyl Siding, Aluminum Siding
Flooring: Tile, Wood, Hardwood
Heating: Central Furnace
Interior Features: Pantry, Walk-in Closet(s), Granite Counter Tops, Walk-in Closet, Separate Vanities, Ceiling - 9 Ft Or More, Ceiling - Specialty, Island Work/Center, Laundry Closet, Washer & Dryer Hookup, Sitting Area/Master, Ceiling - Cathedral
Rooms: Bathroom 1, Bathroom 2, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4

Window Features

Exterior Features: Wooded, Porch Covered, Guest House, Patio/Deck, Sloping, Scenic View, Gradual Sloping, Patio/Deck Covered, Landscape Lights, Mountain View
Parking Features: Garage
Other Features: Guest House
Patio and Porch Features: Patio, Porch, Deck
Roof: Shingle
Vegetation: Wooded
View: Mountain

Neighborhood/Schools

Elementary School/District: Fairyland Elementary School
Middle/Junior High School/District:
High School/District: Ridgeland High School
Subvidision Name:

Description/Comments


Lot Size: 3 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1995
Notes: Nestled in Lookout Mountain's Hinkle Community, this captivating property, just four miles from Covenant College and a stone's throw from Lula Lake Land Trust, offers an inviting opportunity!<br /> <br /> The main house, spanning 2977 sq ft, features 3-4 bedrooms, two tiled full baths, and a separate office area. Hardwood floors grace the interior, leading you to a spacious kitchen with Corian countertops, a double oven glass top range, and French door fridge. The living room, adorned with a gas log fireplace, opens to decks overlooking distant eastern mountains. A walk-in basement and security systems enhance functionality.<br /> <br /> A charming 1200+ sq ft guest house with a cathedral ceiling, gas log fireplace, loft bedroom, and full bathroom awaits, presenting an ideal space for a Mother-in-Law suite or Air BnB.<br /> <br /> A separate large garage/workshop with attic storage offers space for one's hobbies and collections, or can be renvoated into an additional guest house.<br /> <br /> This residence offers endless possibilities, from a mother-in-law apartment to rental income streams. Close to Lula Lake Land Trust and 20 minutes from Chattanooga, it is zoned for Fairyland Elementary School. Contact us to explore this unique oppourtunity on Lookout Mountain.
MlsNumber: --


Listing Provided By: Keller Williams Realty, original listing
Phone: (423) 605-4181
Office Phone: (423) 664-1900
Agent Name: Katherine Smith
Disclaimer: Copyright © 2024 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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => walker [3] => GA [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: walker State: GA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: walker State: GA 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 = 537 AND i.igate IN ('cahud','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 = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Stacy Parson
Stacy Parson
ASCIIKeller Williams Realty
Call Today!: (423) 618-3203

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App