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;

9118 E Hwy 82
Annona, TX 75550

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $899,000
Beds: 5
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3434 Square Feet
Agency: TEXAS REAL ESTATE EXECUTIVES, THE DANIELS GROUP - GILMER
Agency Phone: (903) 680-4663

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 65 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2003
Notes: Attention all wildlife enthusiasts! The perfect hunter's dream awaits with an abundance of nature and wildlife. This beautiful 5-bedroom, 3.5-bath brick home is nestled on over 65+ acres. It features a large kitchen with an island and custom cabinets, a walk-in pantry, a dining area, and a separate formal dining room. The home is equipped with a gas stove and an on-demand water heater, serviced by a 1000-gallon in-ground propane tank. The spacious master bedroom and bath offer outside access, separate large walk-in closets, two separate vanities, a large walk-in shower, and a Maax jetted tub. Two bedrooms share a Jack and Jill bathroom. Ascend the beautiful staircase to discover two very large bedrooms, a huge storage area with a full bathroom, and a potential game room with an extra sitting area. The home includes two dining areas or a possible office space. An attached oversized 2-car garage with a personnel door adds convenience. Security is provided by a wired entry alarm system with Camera system. The house is set back from the road, offering seclusion and privacy, with three ponds and cross-fencing. A separate building site with water and electric is available at the front of the property for additional builds. Deer blinds are included on this prime hunting property teeming with wildlife. The land is a blend of pasture and hardwoods, adjoining the Northeast Texas trail to the south. A 40x60 shop with 3 remote openers and a 20x30 shop are on-site. Enjoy the covered back porch with views and sounds of nature and plentiful wildlife. Come and let your cattle roam or hunt-This property is a "DREAM"...Call today for your private tour of this one of a kind!!
MlsNumber: --
ListingId: 20247480


Listing Provided By: TEXAS REAL ESTATE EXECUTIVES, THE DANIELS GROUP - GILMER, original listing
Phone: (903) 680-4663
Office Phone: (903) 680-4663
Agent Name: Bree Shimpock
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