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 = 537 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 = 537 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 = 537 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;

6865 Hog Jowl Rd
Chickamauga, GA 30707
Larissa DeBerry with Teems & Teems Realty, original listing - (706) 638-6996

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,900,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 5550 Square Feet
Agency: Teems & Teems Realty
Agency Phone: (706) 638-6996

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 48 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2004
Notes: Discover the epitome of luxury living nestled in the North Georgia mountains between Pigeon and Lookout Mountain. This magnificent estate in the beautiful McLemore's Cove spans 5550 sq. ft. and offers 4 spacious bedrooms and 3 1⁄2 elegant baths. With a 3-car garage, a winding creek running through the property, and a charming pole barn, this property is perfect for those seeking tranquility and natural beauty. The estate boasts a new roof, a stunning floor-to-ceiling rock fireplace, and a Juliet balcony that overlooks the Great Room, adding a touch of romance. A cozy library and a 600 sq. ft. sunroom provide ample space for relaxation and entertainment. The gourmet kitchen features a Sub-zero refrigerator, Wolf gas cook top with French burners, granite countertops, and custom cabinets, making it a chef's dream. Upstairs, a large bonus room offers additional space that can be utilized as an additional bedroom, office, or even a media room. The primary en-suite is a haven of luxury with his and her walk-in closets, a huge walk-in tile shower, soaking tub, bidet, and double vanities. It also features a double-sided fireplace in the bathroom that adjoins a hobby room, creating a versatile and elegant space. The estate includes an unfinished basement with 2131 sq ft, offering plenty of room for a personal gym and workshop, perfect for tailoring the space to your unique needs and interest. Spanning 48 acres, this property adjoins 16,869 acres of Wildlife Management Area, offering endless opportunities for outdoor adventures and unparalleled privacy. Imagine mornings spent kayaking down the nearby West Chickamauga Creek, afternoons hiking or skydiving over the majestic mountains, and evenings enjoying world-class golf and dining at McLemore Estates. For the more adventurous, explore the surrounding caves or indulge in the thrill of hunting. The property itself is a treasure trove of history, with owners having discovered artifacts and arrowheads, telling tales of times gone by. Nature lovers will be delighted by the abundant wildlife, including deer and turkeys, that roam freely across the land. The mountains around provide a breathtaking backdrop, enhancing the serene and picturesque environment. Only 15 minutes to acclaimed McLemore Club, an internationally-ranked golf experience, dining and social club. Also just 30 minutes to Chattanooga, 1:45 hours to Atlanta, 2.5 hours to Birmingham. Embrace the chance to own this enchanting mountain sanctuary, now debuting on the market for the very first time. Create a lasting legacy in this mountain sanctuary, where generations can enjoy the serene beauty and endless adventures that North Georgia has to offer. Reach out today to schedule your private showing.
MlsNumber: --
ListingId: 1395726


Listing Provided By: Teems & Teems Realty, original listing
Phone: (706) 506-8563
Office Phone: (706) 638-6996
Agent Name: Larissa DeBerry
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

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 = 537 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 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