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

429 Cameron Lane
Cotulla, TX 78014
Charles Armstrong with Capital Ranch Sales, LLC, original listing - (830) 387-4076

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $6,296,250
Beds: 4
Baths: Full: 3
Status: Active
SqFt: --
Agency: Capital Ranch Sales, LLC
Agency Phone: (830) 387-4076

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1,679 sqft
Property Type: Other-Acreage
Year Built: --
Notes: Executive Summary:<br /> Located on the south east edge of La Salle County, and in the heart of big deer country sits the Little Alamo Ranch, a diverse 1679+- acre high fenced ranch full of diverse wildlife and an abundance of surface water. Located off Cameron Lane just a couple of miles from HWY 624, Little Alamo Ranch sits in some of the best deer country the state has to offer. The ranch is complete with a fully furnished lodge offering guest comfortable accommodations, and back porch views of the 15-acre lake. The Little Alamo Ranch is truly exceptional, offering new ownership the opportunity to step into a turn-key ranch and enjoy from day one. <br /> <br /> Hunting/Wildlife:<br /> If you are looking for a fantastic hunting property, look no further than the Little Alamo Ranch. Completely high fenced and crossed fenced with pastures being approximately 1000 and 670 acres giving endless opportunity to fulfill your hunting needs. The ranch has been under an MLD harvest program for 7 years along with strict managing yielding in several bucks being harvested that scored over 200”. Complementing the deer hunting is the opportunity to hunt a variety of waterfowl species as well as a healthy population of turkey, quail, doves, hogs and axis.<br /> <br /> <br /> Utilities/Location <br /> <br /> Water: Private 4400’ Carrizo Well 500+ GPM and a shared well<br /> <br /> Electric: Medina Electric Coop<br /> <br /> Taxes: Ag Exempt<br /> <br /> Minerals: Surface Only <br /> <br /> Location: 36+- miles from Tilden, Cotulla and Freer<br /> <br /> San Antonio- 2+- hours
MlsNumber: --
ListingId: 557030


Listing Provided By: Capital Ranch Sales, LLC, original listing
Phone: (512) 997-8855
Office Phone: (830) 387-4076
Agent Name: Charles Armstrong
Disclaimer: Copyright © 2024 Central Texas Multiple Listing Service. 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