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 ('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] => 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 ('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] => 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 ('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;

8790 Highway W 136
Chickamauga, GA 30707

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $690,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Pending
SqFt: 2904 Square Feet
Agency: Lookout Real Estate LLC
Agency Phone: (423) 681-8778

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 9 acre(s)
Garage: Garage
Property Type: Residential-Farm
Year Built: 2006
Notes: Get ready to be amazed! On this one of a kind 9.3 acre site, you will find a custom ranch estate that was built, with love! Designed for ultimate comfort and enjoyment of the owners with an open concept floor plan, wrap around & covered porches enhance panoramic mountain views. Fabulous kitchen- solid surface counters, breakfast bar & maple cabinets. Fireplace, living room, separate den & sprawling master! Next - wow! There is an attached handicap accessible in-law suite, w/ ramps, fully self contained with full kitchens, living room, 2nd laundry room, full bath and 2-bedrooms. Owners are vacation renting it - rated super-hosts. Get ready for the- Out-buildings: 3 car garage with 4 garage doors. Next outbuilding is for the horse lovers here and is the absolute best barn! 4 deluxe stalls with self cleaning stall drain system and room for many more, 14x52ft breeze-way, tack rooms, inside wash rack. PLUS there is a big party room- 22x54ft, 3rd complete full kitchen, for large family gatherings, they've had lovely weddings and events there. The property offers unique business opportunities if you desire. The design of the barn was brilliant, offering sheds and storage for RVs, lawn epuipment, farm animals or business. More...Looking for a new lifestyle? Look no further. Escape the cities and traffic. Begin a new legacy here with a million dollar view. Great location- only a couple of blocks for shops and 23 miles to the Chattanooga airport! World class equestrian trails and parks are very nearby. The massive barn has been constructed of the highest quality woods. Upgrades to include insulated and heated party room, rest-room, and full 3rd kitchen adds 1350 sq ft. of living area. Seller finished the room with stylish finishes, a functional wood stove for heating and the walls are insulated. The large barn building room could be great a collector of cars too, with side sliding doors. Total sq ft of gathering room + ranch is approx 4260 sq ft of living area & 3 car garage The Stalls are engineer for self-cleaning. There is a gravel bed deep below the stall matting with is cleaned by natural elements and the wash-rack drain in the deluxe barn. 4 spacious stalls will be sold with the stall mats, complete half bath and plenty of room for in the barn building everything you would possibly need. Additionally, the plumbing is in place to add a shower, with the shower enclosure already there on site for the new owners. The venue room is being sold fully equipped for your next party or event. The buyers will receive the folding tables and chairs for large gatherings and some decor as shown. The in-law-suite/ attached cottage will convey fully furnished and ready with everything a guest could need for a vacation rental or to use for whatever your needs may be. Most all of the furnishing there will stay, along full sets of Egyptian cotton linens, luxurious bath towels, pots, pans, dishes and silverware...etc. The place is turnkey and immaculate. The 3 car garage is insullated and equipped with 4 garage doors for the ultimate in comfort for cross breezes when working in there.
MlsNumber: --
ListingId: 1395574


Listing Provided By: Lookout Real Estate LLC, original listing
Phone: (423) 681-8778
Office Phone: (423) 681-8778
Agent Name: Patricia Peddicord
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 ('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;
Real Estate Expert Photo for Logan Blakeley
Logan Blakeley
ASCIIBerkshire Hathaway HomeServices Realty
Call Today!: (423) 402-0009

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App