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

210 Lange Ravine Rd
Hunt, TX 78024

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,600,000
Beds: 10
Baths: 9
Status: Active
SqFt: 8400
Agency: Haley Lehrmann, Broker

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 13 acre(s)
Property Type: Residential
Year Built: 1984
Notes: Four (4) Homes on 13.18 Unrestricted Acre Estate in The Guadalupe River Valley. 1 Primary Home 3600 +/- sq.ft, Three (3) 2/2 Homes 1600+/- sq.ft., Deeded Guadalupe River Access, Insulated Red Iron/Metal Warehouse 41' x 26.5' w/ 2 overhead doors, Beautiful Distant Views from the Secluded 5 Acre Hilltop Hunting or Building Tract with an elevation of 2000+ ft., 520 ft. Water Well and Country Privacy. The Primary home has an Entry into Great Room, Sun Room, Kitchen and Bedrooms or Enter at Media Room w/Sky-Lights, Living Area & 2 Bedrooms. Natural Light illuminates the Great Room with an 18' Rock Wall & Fireplace, 12' Tiled Dining Bar and Glass Doors into the Sun Room. One Private (1) Guest Home w/Office has Shaded Front Porch, Rock Picnic Table & is uphill from the Primary Home. Two (2) Guest Homes have open Lv'g/ Kitchen floor plans, Hill Country Rock and Wood Accents and Tree covered Front & Back Yard Patio Areas. All houses have Separate Driveways. The Gated Guadalupe River Park is 0.7 Mile East of Lange Ravine Rd. on Hwy 39. The 41 X 26 ft. metal Building has cover for ATVs or Equipment. Property is 2.5 miles west of The Hunt Store, 0.7 miles to River Park & Roofs new 2023.
MlsNumber: 109602


Listing Provided By: Haley Lehrmann, Broker, original listing
Name: Haley Lehrmann, Broker
Phone: (830) 238-3057
Office Name: Hill Country Luxury Living
Office Phone: (830) 238-3057
Agent Name: Sherry Davenport
Disclaimer: Copyright © 2024 Kerrville 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