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

3251 Rugby Pike
Jamestown, TN 38556
Dusty Wells with 1 Source Realty Pros, original listing - (931) 261-9752

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $925,000
Beds: 3
Baths: Full: 4
Status: Active
SqFt: 4320 Square Feet
Agency: 1 Source Realty Pros
Agency Phone: (931) 261-9752

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 9 acre(s)
Property Type: Residential-Other
Year Built: 1985
Notes: Nestled in the heart of Tennessee horse, Country, and Rich in the history of bygone times, this house can easily become the home you have always dreamed of. Positioned halfway between Jamestown and Rugby, Tennessee this 9.2 +/- acres property features a 3 bd/4 bath home w/ attached 2 car garage, a detached garage/workshop w/ wood furnace, a stocked pond, and fruit trees, such as peach trees, apple trees, and blueberry bushes.<br /> <br /> Coming in at approximately 4,310 sqft this beautiful modern Greek revival style home with its Doric style columns accompanying a symmetrical façade with pedimented portico - is anything but stoic. This unique home consists of three levels: a main or ground level, a basement or lower level, and a second floor or upper level. Between these three levels, the home features 3 bedrooms, 4 bathrooms, 2 full kitchiens, 4 multi-purpose rooms, a sunroom, a sitting room, a foyer, a living room, a family room, a recreation room, and all the storage space/room you may ever need.<br /> <br /> The main level of the home enjoys 2 master bedroom suites w/ walk-in closets and adjoining bathrooms. The stunning main level kitchen with its granite countertops lies between the dining room and a spacious sitting room that accesses the enclosed sunroom. The dining room affords access to both the living room and the 425 sqft 2 car garage.<br /> <br /> The mostly finished basement level of the home features a large, full kitchen with a large recreation room with a nearby full bathroom, easily facilitating those large family and friends gatherings. This level of the home can comfortably accommodate not only potential access storage and the homes utility room, but any imaginable purpose. Craft room, art studio, office space, workshop, study, library, or even an entertainment room - their versatility can only be limited by the needs of their beholder.<br /> <br /> Second floor or upper level of the home features a common area, 2 multi-purpose rooms, a full bathroom, and access to attic space. Much like the rest of the home these rooms have limitless potential.<br /> <br /> Not far from the home stands the nearby 1,120 sqft (40' x 28') detached garage/workshop with its wood furnace - it is ready to tackle the challenge of your next project, no matter the weather.<br /> <br /> Buyers to verify all measurements.
MlsNumber: --
ListingId: 1284393


Listing Provided By: 1 Source Realty Pros, original listing
Phone: (931) 261-9752
Office Phone: (931) 261-9752
Agent Name: Dusty Wells
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