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

13810 E Hwy 82
Avery, TX 75554
PAMELA HOLLINGSWORTH with IMPACT REALTY GROUP LLC, original listing - (903) 748-2477

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,565,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: IMPACT REALTY GROUP LLC
Agency Phone: (903) 748-2477

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 231 acre(s)
Property Type: Land-Farm
Year Built: --
Notes: One of a kind cattle ranch just 2 miles from downtown Avery on Hwy 82 W. Picture a beautiful ranch style home sitting almost in the middle of 231 beautiful acres. The home with 3 bedrooms and 2 1/4 baths, large family room with a wood burning stove sitting on authentic river rock that will keep you warm all winter offers 231 acres 185 of which is planted in Tifton Bermuda that produces 3 to 5rolls per acre with fertilizer and a 15 acre lake that has 2 valves allowing you to irrigate the approximately 185 acres of improved fenced and cross fenced pastures. There is also a 30 acre stand of mature pine timber that sits behind the home and scattered oak trees that add to the ambiance of this highly manicured property. This is a working cattle ranch with a 30x70 equipment shop and a 40x60 barn with working pens. Abundant access with 0.75 mile of road frontage on Hwy 82 and .45 mile of frontage on CR 3325 S. Property lends itself to multiple uses. Enjoy it all to yourself or if you aren't looking to run it all on your own there are many ways to sell off a few smaller ranchettes. This place is the finished product. All the hard work has been done making this a true showplace!
MlsNumber: --
ListingId: 20240998


Listing Provided By: IMPACT REALTY GROUP LLC, original listing
Phone: (903) 748-2477
Office Phone: (903) 748-2477
Agent Name: PAMELA HOLLINGSWORTH
Disclaimer: Copyright © 2024 Longview Area 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