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;

21489 Stevenson Rd.
Frankston, TX 75763

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $998,900
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 3438 Square Feet
Agency: Staples Sotheby's International Realty
Agency Phone: (903) 876-1051

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2010
Notes: Imagine spending your days boating or fishing at the lake, enjoying the serene country setting from the deck, or relaxing in your pool!! This custom home with beautiful landscaping on Lake Palestine offers 3 or 4 bedrooms, an open living area with fireplace, a dream kitchen, a separate spectacular lake view living room with vaulted wood ceiling and soaring glass, and an approximate 800sq. ft. bonus room upstairs to meet your needs as a game room, 4th bedroom or crafts room. The kitchen is the heart of this home with gas cook top, stainless appliances, a very functional island, lots of storage with slide out drawers, wine refrigerator and wine rack along with a breakfast bar for family and friends that always migrate to where the food is! French doors in the den and kitchen/dining space allow easy access to the covered porch, deck. The primary suite is spacious, light filled and very functional with bedroom opening to the pool, porch and patio. The en-suite bath with fabulous spa shower & separate walk in closets---oh so well designed! Bedrooms are well sized, bright with large windows and generous closets. Upstairs the flex space can be utilized as a 4th bedroom/bunkroom/man cave or theatre room, perfect bonus space in a lake home. The laundry/mudroom holds more storage as well a second refrigerator. Outside enjoy approximately 138' of serene waterfront with a floating boat house, (never worry about water levels!) though the water here is typically 5-7' deep with easy access to the main body of the lake. Enjoy the gunite pool easily accessible from multiple rooms of the house--it's a wonderful place to entertain or just enjoy family time especially since it also has a misting system to keep pesky insects away! The three car garage holds a surprise--it's climate controlled and a hot tub is located here for year round use. This home offers something for everyone in your family! Furniture, pontoon boat and ATV negotiable with sale. Call for your private showing.
MlsNumber: --
ListingId: 25001397


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