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;

10125 Cr 4101
Frankston, TX 75763

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,750,000
Beds: 3
Baths: 3
Status: Active
SqFt: 2272
Agency: Staples Sotheby's International Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 6 acre(s)
Property Type: Residential
Year Built: 2021
Notes: Nestled within the serene beauty of East Texas, this remarkable 6.5 acre wooded waterfront tract on Lake Palestine presents an idyllic retreat for those seeking tranquility within natural splendor. Upon arrival, a concrete entrance drive with electric/solar gate between brick columns turns into a natural road as it meanders through the towering trees toward the lake. Beds of azaleas greet you as you approach the lake & main building site, with underground utilities from the road. Boasting a concrete bulkhead spanning 240' of shoreline, with a 5' concrete sidewalk cap, this property offers direct access to the shimmering waters via wide curved stairs descending into the water. An inviting 2274 sq.ft., 3 bedroom, 2.5 bath guest house exudes charm & modern comfort. As you enter from the covered porch, guests are greeted by an open concept living, dining, & kitchen, complete with a stone fireplace & wood walls. The lakeside screened porch, offers an enchanting retreat, where gentle southerly breezes & birdsong provides the soundtrack for moments of relaxation and reflection. The primary bedroom & bath are located on main floor with two bedrooms & a sublime guest bath with soaking tub & shower located on the second level. The Nantucket style boathouse has boat lift plus double jet ski lift. Enjoy the air conditioned living area year round - complete with casement windows, wood walls & ceiling, kitchen with Kraft Maid cabinetry, granite counters, bar, stove, microwave & refrigerator. Plenty of room for living & dining area too! The open water views are heavenly from this location - facing east across the lake for sunrises & moon rises. Rest easy knowing your boat will still be able to be used when the lake level lowers, with 10' of water depth at full pool (345' elevation)! Whether using guest house as a full time residence or a weekend escape, or building your dream home on the exquisite main building site, let this be the place where dreams really do come true.
MlsNumber: 24006247


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