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

684 Phillips Hollow Road
Chickamauga, GA 30707
Melody Broome with RE/MAX Real Estate Center, original listing - (423) 664-6644

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $785,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2444 Square Feet
Agency: RE/MAX Real Estate Center
Agency Phone: (423) 664-6644

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 14 acre(s)
Property Type: Residential-Farm
Year Built: 1986
Notes: This can be your own private paradise on this meticulously maintained 14.5-acre farm, offering a perfect balance of privacy, space, and serene countryside living and award winning schools. Just minutes from Chattanooga, Ft.Oglethorpe, I-24 and I-75. This exceptional property features a beautifully updated home, expansive barns, and multiple outbuildings, all set against the backdrop of a 1 acre pond, lush pastures and views of Lookout Mtn. Home: A well-maintained residence with fresh updates throughout, including James Hardie siding, Window World windows, a Trane HVAC system and two back-up propane heaters in living room fireplace and free standing unit in den. The office with a wall of custom cabinets could be used as 4th bedroom. Property incudes Right of Way deed to/from Garretts Chapel Rd, making easy access with farm equipment. Updated Bathroom: Enjoy the luxury of an updated tile shower in the spacious bathroom with a unique antique vanity with sink. Barns & Outbuildings: Several barns and outbuildings provide ample storage for livestock, equipment, and hobbies, making it ideal for farm life. 30x48 hay barn with electricity, 48x36 pole barn with area to house recreational vehicle and farm equipment. Attached 12x36 bay for shop with water and electricity. Attached concrete floored shed for storing lawn equipment. Farm: This fully fenced property is perfect for livestock, with plenty of pasture space for grazing. Active cattle farm. Pond: A serene, stocked pond provides both beauty and tranquility, offering a peaceful retreat just steps from your door. Outdoor Living & Entertainment: A screened porch and patio area are perfect for entertaining or simply relaxing while enjoying the stunning natural surroundings. Private & Serene: Secluded yet easily accessible, this property offers the ultimate in peaceful, country living while still being within reach of local amenities. Don't miss the chance to own this exceptional piece of property. See Seller's detailed description in Documents. COFFEE BAR DOES NOT REMAIN. CATTLE HEAD CHUTES AND CORRAL GATES, AND CHICKEN COOPS DO NOT TRANSFER WITH PROPERTY BUT ARE NEGOTIABLE IN SEPARATE SALE.
MlsNumber: --
ListingId: 1510504


Listing Provided By: RE/MAX Real Estate Center, original listing
Phone: (423) 314-6611
Office Phone: (423) 664-6644
Agent Name: Melody Broome
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 = 537 AND i.igate IN ('usahud','alhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'alhud', 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 Pam Turley
Pam Turley
ASCIIZach Taylor - Chattanooga
Call Today!: (423) 316-2125

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App