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;

26343 Fm 410 N
Bagwell, TX 75436
Jim Long with Southwest Ranch & Farm Sales, original listing - (972) 542-8511

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $8,900,000
Beds: 6
Baths: Full: 9, ½: 2
Status: Active
SqFt: --
Agency: Southwest Ranch & Farm Sales
Agency Phone: (972) 542-8511

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1,270 sqft
Garage: Garage
Property Type: Farm-Farm
Year Built: --
Notes: Acres: 1270 ± Acres. Price: $8,900,000. Terms: No owner financing. Location: Bagwell, TX, Red River County. Approximately two hours northeast of the Dallas Metroplex. Comments: 1270 +/- Acres of sportsman's paradise with one mile of frontage on the Red River. Numerous sloughs, food plots, feeders, blinds, and hunting lodge. Hunting includes trophy whitetail deer, wild hogs, squirrels, and phenomenal duck and goose hunting on the numerous sloughs. Fishing is also outstanding in the Red River and oxbow sloughs. Improvements: The hunting lodge which will sleep up to 20 people comes completely furnished. State of the art kitchen equipment will remain, as well as a large generator that supplies the lodge should electricity go off. An elevator accesses the second floor, if needed. Downstairs there is a large kitchen and extra-large den with a fireplace and meeting area. The lodge has a total of six bedrooms, nine full bathrooms, and two half baths. Bedrooms have fourteen bunk beds, and three king size beds. Upstairs there are two master suites, a full kitchen, a large den with fireplace, utility room, storage closet, and balcony. Each of the bedrooms has its own air and heat unit and controls, as do the kitchens and dens. Water: There are two water wells on the ranch supplying more than ample supply of water. There are sloughs and Red River frontage. Terrain: This Texas hunting ranch is mostly level, tree covered Red River bottom land. There are many openings for food plots. Game: For the hunting enthusiast, you will find whitetail deer, wild hogs, duck and goose hunting at its best. There is great fishing in the Red River and the sloughs.
MlsNumber: --
ListingId: 11456562


Listing Provided By: Southwest Ranch & Farm Sales, original listing
Phone: (972) 542-8511
Office Phone: (972) 542-8511
Agent Name: Jim Long
Disclaimer: Copyright © 2025 My State MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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;
Real Estate Expert Photo for Alan Green
Alan Green
ASCIIGerald Aire Realty
Call Today!: (903) 517-9955

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App