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

348 Countryside Drive
Lexington, TN 38351
Angie Box with Haltom Real Estate Group, original listing - (731) 984-2200

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,200,000
Beds: 4
Baths: Full: 4
Status: Active
SqFt: 3219 Square Feet
Agency: Haltom Real Estate Group
Agency Phone: (731) 984-2200

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 75 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2018
Notes: This exquisite 4-bedroom custom home on a sprawling 75.3-acre estate offers a perfect blend of luxury and rural charm, making it an ideal retreat for equestrian enthusiasts or those seeking tranquility. The main residence features 4 spacious bedrooms, each with its own private bathroom, ensuring comfort and privacy for all residents and guests. The warmth and elegance of heart pine hardwood flooring flow throughout the home, adding a touch of rustic charm that complements the modern amenities. The eat-in kitchen is a chef's dream, equipped with stainless steel appliances, a double oven, and quartz countertops, making it perfect for intimate family meals or entertaining guests. Additional spaces include a dedicated office and a cozy sitting room, providing ample areas for work and relaxation. Outside, the property is a paradise for nature lovers. Expansive pastures and wooded trails invite exploration on horseback or by foot, offering endless opportunities to connect with the serene environment. A well-maintained barn with stables and a tack room caters to equestrian needs, while a picturesque pond provides a peaceful spot for reflection or an afternoon picnic by the water. In the evening, unwind on the spacious covered porch, where you can savor breathtaking views of the sunset over the rolling hills. Whether you're hosting a lively gathering or enjoying a quiet evening under the stars, this home is designed to enrich every moment with comfort and grace.
MlsNumber: --
ListingId: 247137


Listing Provided By: Haltom Real Estate Group, original listing
Phone: (731) 217-3539
Office Phone: (731) 984-2200
Agent Name: Angie Box
Disclaimer: Copyright © 2024 Central West Tennessee 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