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

1670 Bays Mountain Road
New Market, TN 37820
Tammy Franklin with Franklin Realty, original listing - (865) 484-0660

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,400,000
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: 4375 Square Feet
Agency: Franklin Realty
Agency Phone: (865) 484-0660

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 9 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2022
Notes: Stunning Custom-Built Modern Farmhouse on 9.63 Acres with Pond. Welcome to this breathtaking custom-built modern farmhouse, a perfect blend of rustic charm and contemporary elegance. Situated on 9.63 serene acres, this 3-bedroom, 3.5-bathroom home offers open-concept living, high-end finishes, and an abundance of natural beauty—including a picturesque pond right on the property. Step inside to find luxury vinyl plank (LVP) flooring throughout, combining durability with timeless style. The spacious great room features soaring 12-foot walls and a vaulted ceiling with exposed wood beams, and abundant natural light pouring in through oversized Andersen 400 Series windows. The focal point of the living space is a custom fireplace with a rustic mantle and floor-to-ceiling stone, creating a warm and inviting atmosphere. The rest of the home offers 10 foot ceilings and 8 foot doors throughout. <br /> The chef's kitchen is designed for both function and beauty, featuring quartz countertops, custom cabinetry, an oversized island, high-end appliances, a separate coffee bar area, as well as a walk-in pantry for ample storage and organization. <br /> Each bedroom is designed for comfort and privacy, with en-suite bathrooms featuring custom tile showers. The primary suite is a true retreat, complete with a spa-like bathroom featuring a large custom shower with dual shower heads, a spacious multi-shelf niche with custom tile, and a luxurious soaking tub. Her side of the bathroom is thoughtfully designed with ample storage and a dedicated makeup station, offering both functionality and elegance. Entertainment is at the heart of this home, featuring a dedicated entertainment room with a wet bar, glass-front cabinets with LED lighting, and plenty of space for gatherings. A spiral staircase leads to a spacious 17' x 19' loft office, offering a private and inspiring workspace with beautiful views of the property. This home is also equipped with modern conveniences, including a whole-house generator for uninterrupted power, a 5-zone speaker system for ultimate entertainment, a whole house water conditioning system with reverse osmosis for drinking water, and energy-efficient features throughout. Outdoor living is just as impressive, starting with a large covered front porch with composite decking, perfect for relaxing and enjoying the peaceful surroundings. In the back, an expansive, partially covered rear deck with composite decking offers breathtaking views of the mountains and the pond, making it an ideal space for outdoor dining, entertaining, or simply unwinding in nature. For those who need extra storage and workspace, this property includes a 40'x30' separate 3-bay pole barn with 10' roll-up doors, perfect for storing equipment, vehicles, or creating a workshop. Additionally, a covered RV pad with full hookups provides a convenient space for guests or travel enthusiasts. There is also space available over the garage area to expand and add a 720 sq ft loft apartment with its own entrance if you desire. Outside, the expansive acreage offers endless possibilities—whether you envision a hobby farm, recreational space, or simply a peaceful escape. The pond adds to the tranquility, making this property a rare gem for nature lovers. Located just minutes from town yet offering complete privacy, this exceptional home provides the perfect balance of modern luxury and country living. Schedule your private tour today and experience the beauty for yourself!
MlsNumber: --
ListingId: 306231


Listing Provided By: Franklin Realty, original listing
Phone: (865) 654-1110
Office Phone: (865) 484-0660
Agent Name: Tammy Franklin
Disclaimer: Copyright © 2025 Great Smoky Mountains 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