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

1116 County Road 107
Cisco, TX 76437
Rylan Harrison with Harrison Farm and Ranch LLC, original listing - (254) 631-3200

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,600,000
Beds: 2
Baths: Full: 1
Status: Active
SqFt: 748 Square Feet
Agency: Harrison Farm and Ranch LLC
Agency Phone: (254) 631-3200

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 256 acre(s)
Property Type: Residential-Farm
Year Built: 2015
Notes: Exceptional 256-Acre Hunting Retreat in Cisco, TX<br /> <br /> Located just north of Cisco off County Road 107, this rare 256-acre hunting getaway offers the perfect blend of seclusion and exceptional hunting and ATV riding opportunities. Whether you’re looking for a weekend escape or a full-time retreat, this property checks all the boxes.<br /> <br /> The property features a cozy hunting cabin with two bedrooms, a spacious living room, and a fully equipped kitchen—ideal for relaxing after a long day in the field. The cabin is fully furnished, making this a turn-key property that’s ready for you to enjoy immediately.<br /> <br /> This hunting paradise boasts an abundance of wildlife, including whitetail deer, hogs, turkey, dove, and ducks, ensuring year-round hunting opportunities. With expertly placed stands and feeders already in place, everything you need to start hunting right away is provided. The property currently features two ponds, but there is potential to dam a creek that winds through the land, creating the opportunity for a much larger body of water.<br /> <br /> A reliable water well with an advanced filtration system adds to the property’s appeal—especially considering that water wells are often scarce in the area.<br /> <br /> Turnkey properties this size are a rare find these days and this one offers everything you need to create lasting memories in the great outdoors. Come take a look and make this exceptional hunting retreat yours today!
MlsNumber: --
ListingId: 20827547


Listing Provided By: Harrison Farm and Ranch LLC, original listing
Phone: (254) 631-3200
Office Phone: (254) 631-3200
Agent Name: Rylan Harrison
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