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

449 Dogwood Ln
Dunlap, TN 37327

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,100,000
Beds: 6
Baths: 4
Status: Active
SqFt: 3072
Agency: George Hamilton Land & Auction Company

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 96 acre(s)
Property Type: Residential
Year Built: 2003
Notes: Sitting within the heart of the beautiful Sequatchie Valley with breath taking views that are framed by Walden's Ridge to the east and the Cumberland Plateau to the west, this nearly 100 acre estate, along with its unique infrastructure, offers a multitude of opportunities. Within the vast acreage of mixed hardwoods and open fields are two homes which both have 3 bedrooms and two baths, a charming event venue known as The Ridge at Weatherbee Farms, a 4,000 Sq. Ft. work shop/garage with overhead apartment, a custom gunite and mountain stone pool, over 2,000 feet of paved road frontage, bountiful wildlife, a pond and views for miles, and all within the city limits of Dunlap and a pleasant 45-minute drive to Chattanooga. Be it a turn key business, a residential development opportunity or a magnificent private estate (or a mix of all three), the property has significant room for expansion or can be left untouched to be a perfectly balanced landscape and premier estate that offers ultimate privacy with unbeatable convienance.Both homes are attractive and solidly built mountain stone homes, and ready for remodeling to a new owners personal taste. The work shop/garage is a mechanics or handy persons dream, with an upstairs that is ready for finishing out for a guest quarters or rental. The event venue, along with miles of views captured out of the glass bay doors is the real gems of the property. This established and profitable venue offers 6,000 sq ft of enclosed event space, bathrooms, bride and groom suites, and a kitchen area. This is arguably the most stunning event venue in the Sequatchie Valley, and has hosted a multitude of weddings, parties and business events/meetings, and is positioned to continue as a profitable venture if desired by a new owner. This diverse property should be toured in person to fully appreciate all that it has to offer. Offered at $3,100,000.<br /> <br /> While Information is deemed accurate, Buyer is responsible to perform their own due diligence.
MlsNumber: 1393545


Listing Provided By: George Hamilton Land & Auction Company, original listing
Name: George Hamilton Land & Auction Company
Phone: (423) 554-3933
Office Name: George Hamilton Real Estate and Management Co
Office Phone: (423) 554-3933
Agent Name: Jim Thompson
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App