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

88 Forrest Lane
Bath Springs, TN 38311
Adam Arnold with L A Realty,LLC, original listing - (731) 686-9899

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $549,900
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 2300 Square Feet
Agency: L A Realty,LLC
Agency Phone: (731) 686-9899

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2012
Notes: Experience breathtaking Tennessee River views from this beautifully designed home in Martins Landing Resort. Perfect for both entertaining and relaxing, the open main level features a stylish kitchen with stainless steel appliances, quartz countertops, a built-in pantry, and a kitchen island/bar with seating. The cozy gas log fireplace in the living area complements the many windows that flood the space with natural light and showcase the spectacular river vistas.<br /> <br /> On the main floor, you'll find two bedrooms, each with beautifully decorated full bathrooms. Head upstairs to discover a versatile bonus room and the primary bedroom, which includes his-and-her closets and a luxurious private bath. Enjoy serene moments with morning coffee or evening drinks on the A-frame deck off the primary bedroom, offering uninterrupted river views.<br /> <br /> The home is thoughtfully appointed with luxury vinyl plank and ceramic tile flooring throughout. In Addition, it includes ample parking below, an exterior dumb waiter, and a convenient storage room in the carport area.<br /> <br /> As part of the Martins Landing community, you’ll benefit from a private beach, a marina featuring Mio Myo's, a general store with a farmers market, and the convenience of your own boat ramp. Whether you seek year-round living or a weekend retreat, this property offers exceptional riverfront enjoyment and community amenities.
MlsNumber: --
ListingId: 245458


Listing Provided By: L A Realty,LLC, original listing
Phone: (731) 695-0708
Office Phone: (731) 686-9899
Agent Name: Adam Arnold
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