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;

4074 Medina Highway South
Mountain Home, TX 78028
Lynzee Lewis with Circle L Realty, original listing - (830) 719-2799

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,500,000
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 5000 Square Feet
Agency: Circle L Realty
Agency Phone: (830) 719-2799

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 154 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1940
Notes: https://www.land.com/property/4074-Medina-Highway-Kerrville-Texas-78028/20832942/ Lambs Creek/2 acre Spring Fed Lake/3 Ponds/Hill Country Views/Hunting/ Mineral Interests Fronting Medina Highway ( Highway 16 ) only 10 mins to downtown Kerrville lies this fantastic 154 acre original 1940's ranch estate. Offering the best of both worlds with a 30 acre field to rolling hills, secluded hunting land and a billion dollar view. Beautiful vegetation located all over the property. Oak, sycamore, pecan and cottonwood trees. Native american mounds and many arrowheads found on the property. Approximately 100 acres of untouched land. Water galore Frontage on Lambs creek that runs along the eastern edge of the property. 2 acre lake with potential to be much larger 3 ponds all stocked 2 wells on property 9000 gallon cistern Fenced for livestock and Ag exempt taxes High fence on north side.Cross fenced for 2 separate pastures,Deer blinds and feeders,Whitetail deer and some exotics have seen on the property, along with hogs and turkeyGood road system throughout the property Main House Built in 1940,Original 1940s feel Offering 3500 sf,4 bedroom 2 bath, Saltillo tile and original hardwood flooring,Tons of storage,Screened in porch with view,5 fireplaces, one in each room,Large kitchen and living area,Cheerful garden area,Patio area with fountain. 3 bedroom 1 bath cottage nestled near Lambs Creek surrounded by blossoming trees and fertile soil. Nice kitchen area and open concept living space. One bedroom bungalow nestled under big beautiful oak trees next to the lake Fully equipped kitchen,Living Dining combo,Large bedroom with en suite bathroom,Screened in porch. With this amount of acreage this property has so much potential. Investment Opportunity. Multiple build sites up on the ridge and on the western part of the property. Excellent hunting retreat. Beautiful place for a wedding venue, a bed and breakfast or any kind of show place you desire.
MlsNumber: --
ListingId: 205850


Listing Provided By: Circle L Realty, original listing
Phone: (830) 719-2799
Office Phone: (830) 719-2799
Agent Name: Lynzee Lewis
Disclaimer: Copyright © 2024 Del Rio 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