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;

810 E Fm 321
Montalba, TX 75853
Sarah Barnett with RE/MAX Benchmark, original listing - (903) 677-3819

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,400,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2418 Square Feet
Agency: RE/MAX Benchmark
Agency Phone: (903) 677-3819

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 52 acre(s)
Property Type: Residential-Farm
Year Built: 2002
Notes: Nestled in the rolling terrain along the East Texas Forrest Trails, is the TIDELAND HAVEN HOUSE, exclusively designed for Southern Living by Historical Concepts, LLC. This award-winning home design maximizes views and access to the outdoors. The family room creates a leisurely flow into the foyer, open-kitchen, dining alcove as well as to the wrap around porch. The living room layout is ideal for gathering families and entertaining.<br /> <br /> The primary suite is designed as a private hideaway extending off the back of the house, complete with an open screened-in porch for enjoying morning coffee. The sizable wrap-around porch extends the living area and offers a wheelchair accessible lift. French doors with transoms above allow sunlight to enter the interiors for an open and spacious feeling. The home office could also serve as a sitting room or third bedroom as the second bedroom features an ensuite bathroom.<br /> <br /> The detached guest house offers an efficiency-kitchen, living area, bedroom, extra-large shower and roomy loft for a second bedroom. Complete with an enclosed two-car garage.<br /> <br /> Fencing and cross-fencing surrounding the 52.515 acres of lush east Texas forest and actively producing coastal Bermuda meadow. Property includes a 36x36 stable with 4 stalls and tack room, several shops including a 40 x 60 hay barn, 38 x 76 shop with office, 40x 60 shop with full apartment and 24 x 76 equipment shed. Newly installed generator & RV hookup with more amenities than you can count. Ample native trees offer privacy and an abundance of firewood to fill the Kuma Cascade fireplace. 3 ponds dot the property with access to great fishing, hunting and recreational activities. Call for a showing today.
MlsNumber: --
ListingId: 20765234


Listing Provided By: RE/MAX Benchmark, original listing
Phone: (903) 391-0150
Office Phone: (903) 677-3819
Agent Name: Sarah Barnett
Disclaimer: Copyright © 2024 North Texas Real Estate Information Systems, Inc. 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