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

698 N Kahn
Rio Frio, TX 78879
Jerrett Lamb with JVL Real Estate, original listing - (830) 815-1000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $625,000
Beds: --
Baths: --
Status: Active
SqFt: 256 Square Feet
Agency: JVL Real Estate
Agency Phone: (830) 815-1000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 21 acre(s)
Property Type: Land-Other
Year Built: --
Notes: Remarkable Hill Country acreage in the heart of the Frio Canyon area with well, cabin and electric in-place for your enjoyment. Hunting is allowed on this level property with frontage along seasonal Deer Creek. Free ranging exotics as well as Turkey, White-tail and Axis frequent the property. The property is bordered on the West and North by two low-fenced ranches in excess of 4,000 acres giving wildlife freedom to move. Studded by magnificent Oak Trees, the property has been partially cleared near the camp area with the area to the North left selectively dense for hunting and recreational activities. This property offers a good water well with septic in-place supporting two small cabins. One cabin has a kitchen area and there is a composting toilet and shower in the other cabin along with a loft area making the perfect hide-out and secluded (yet accessible) acreage close to Garner State Park and the Frio River. Deer Creek Estates has sensible deed restrictions to protect your investment and provide peace and harmony for all landowners. There is no minimum square footage or time-frame required to build. Deer Creek borders the southern edge of the property and offers seasonally flowing waters in times of adequate rain. Deer Creek also creates a natural corridor for wildlife. This property welcomes a new permanent residence or simply sit back and relax and take in the vast surrounding hills. Ancient artifacts have been found scattered around the ranch and offers adults and kiddos alike the joy of discovery. Property of this size and location are becoming scarce in the Frio River area and with such convenient access it makes this property highly desirable. Don't miss the chance to own a piece of true Texas Hill Country.
MlsNumber: --
ListingId: 1863274


Listing Provided By: JVL Real Estate, original listing
Phone: (830) 815-1000
Office Phone: (830) 815-1000
Agent Name: Jerrett Lamb
Disclaimer: Copyright © 2025 San Antonio Board 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