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 = 2522 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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 = 2522 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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 = 2522 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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;

21425 Stevenson Rd.
Frankston, TX 75763

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,150,000
Beds: 4
Baths: 3
Status: Active
SqFt: 3240
Agency: Staples Sotheby's International Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2021
Notes: Welcome to your dream waterfront retreat on the serene shores of Lake Palestine in Frankston, TX! This meticulously crafted custom-built home, completed in 2021, offers the perfect blend of luxury, comfort, & natural beauty approximately 30 minutes from thriving Tyler, TX. Spanning two levels, the residence encompasses four bedrooms, including a luxurious master suite on main level, two & a half baths, & a convenient office space that doubles as a dining area. Each level is thoughtfully designed with its own kitchen, living & utility area, offering flexibility & privacy for both family & friends. The expansive windows on both floors flood the interior with natural light & views of the tree shaded back yard & wildlife. The owners' attention to detail is evident in every aspect of the property, from the beamed vaulted ceiling, stone WBFP w/ wrap around seating, to the strategically placed boathouse & carefully trimmed trees, ensuring unobstructed views & maximum enjoyment of the lake. Embrace outdoor living at its finest with three distinct outdoor spaces, including an inviting screened porch off the master suite, an open deck extending from the kitchen, & a covered & open patio & firepit accessible from the walk-out lower level. Situated on a generous .57-acre+ lot, enjoy sparkling views of the tranquil waters. A true haven for the avid fisherman, kayakers, & those who enjoy the peacefulness of nature, this property features a two-level boat house including boat slip w/ lift, ensuring effortless access to endless days of boating adventures. Upper deck of the boathouse provides an ideal vantage point for soaking in the sun or savoring morning coffee against the backdrop of the shimmering lake. And you have plenty of space to add extra slips & seating areas if desired. Don't miss the fish pond, 3 garage bays (2 in front, 1 heated & cooled in back), bonus heated/cooled sleep space above the garage, and an enchanting 'kids cabin' 2 level nook! Let your lake life begin!
MlsNumber: 24004754


Listing Provided By: Staples Sotheby's International Realty, original listing
Name: Staples Sotheby's International Realty
Phone: (903) 876-1051
Office Name: Staples Sotheby's International Realty
Office Phone: (903) 876-1051
Agent Name: Dana Staples
Disclaimer: Copyright © 2024 Greater Tyler 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