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','ilhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 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','ilhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 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','ilhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 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;

22389 Farm Road 410 N
Detroit, TX 75436
Phillip Dodd with Arrowhead Land Company, original listing - (817) 915-2502

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $6,961,500
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Arrowhead Land Company
Agency Phone: (817) 915-2502

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1,547 sqft
Property Type: Land-Unimproved Land
Year Built: --
Notes: Introducing the Red River Investment Farm, a prime 1,547 acre property located in Red River County, Texas! This farm provides you with the opportunity to manage and run a fully operational farming haven with 8 irrigation pivots covering approximately 763 acres under irrigation, supported by 8 water wells to ensure efficient water management. The farm is majority Class 2 soils; refer to documents for the description for the full soils report. The property presents you with an 80x90 hay barn for storage and operations. With over 2 miles of river frontage along the Red River, this property offers both agricultural and recreational opportunities! If you are looking to expand your farming operation, the Red River Investment Farm is ready for you to take over and maximize its potential! But don’t overlook the incredible recreational possibilities this land offers. With expansive agricultural fields and miles of river frontage, this farm has the makings of a waterfowl mecca. The presence of flooded timber adds another dimension, making it a prime location for waterfowl hunting. With proper wildlife management, this property has the potential to be transformed into the ultimate waterfowl hunting destination. Additionally, the land offers hunting opportunities for deer and hogs, further enhancing its appeal. Whether you're interested in farming or recreational hunting opportunities, or both, the Red River Investment Farm is the ultimate investment, offering both productive agricultural assets and exceptional recreational potential! There are also 40 across the road that is part of the 1,547 acres. The farm is located 23 miles from Detroit, 31, 34 miles from Paris, 92 miles from Texarkana, and 140 miles from Dallas. All information is to be verified by buyer and buyer's agent. Listing Brokers are not responsible for any inaccuracies. All showings are by appointment only. This is a Court Ordered Sale. All offers to be approved by Court.
MlsNumber: --
ListingId: 20874245


Listing Provided By: Arrowhead Land Company, original listing
Phone: (817) 915-2502
Office Phone: (817) 915-2502
Agent Name: Phillip Dodd
Disclaimer: Copyright © 2025 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