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

2585 Forge Ridge Rd
Harrogate, TN 37752
Amy Welch with Fathom Realty TN LLC, original listing - (606) 269-1807

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $949,990
Beds: 5
Baths: Full: 4, ½: 1
Status: Active
SqFt: 3762 Square Feet
Agency: Fathom Realty TN LLC
Agency Phone: (888) 455-6040

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Garage: Garage
Property Type: Residential-Other
Year Built: 2023
Notes: This stunning property is move-in ready and provides the perfect opportunity for you to add your personal touches. Located in Harrogate, only 10 minutes from LMU. This 'never been lived in' newer built home features breathtaking views from every window and porch. It has 3,762 square feet of living space and an additional 3,207 square feet in a full basement that's ready for your finishing. You can create a movie room, apartment, workout area, or safe room. The chef's kitchen boasts a 48'' gas range with a custom hood, double oven, pot filler, a 48'' refrigerator, and custom Amish cabinets with soft-close features. The large island and open floor plan are ideal for entertaining, and the gas fireplace adds a warm, cozy ambiance. The master suite is conveniently located on the main floor, complete with a luxurious master bath, walk-in shower, and ample closet space. Additionally, there are four more bedrooms and 2 and a half more baths on the main floor. Also, there is a sizable bonus room and another full sized bathroom upstairs. The property spans 10.43 acres, and includes a detached shop/garage, and features a serene pond. <br /> <br /> The home is equipped with city water and a high output tankless water heater. The laundry room is conveniently situated on the main floor, and the home is outfitted with two zoned HVAC units. You can access the patio through the oversized sliding doors in the living room, or from the master bedroom. There's also a three-car garage on the main floor with a deep wash sink, and an additional garage in the basement. Don't miss out on this incredible property—schedule a showing today! BUYER TO VERIFY SQUARE FOOTAGE!
MlsNumber: --
ListingId: 1285624


Listing Provided By: Fathom Realty TN LLC, original listing
Phone: (606) 269-1807
Office Phone: (606) 269-1807
Agent Name: Amy Welch
Disclaimer: Copyright © 2024 East Tennessee 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