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;

505 Rambling Creek
Kerrville, TX 78028
Adriana Rodriguez with Keller Williams City-View, original listing - (210) 696-9996

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $5,495,000
Beds: 4
Baths: Full: 4, ½: 1
Status: Active
SqFt: 5598 Square Feet
Agency: Keller Williams City-View
Agency Phone: (210) 696-9996

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 203 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2005
Notes: Discover the beauty of Rambling Creek Ranch, a stunning 203.21-acre property nestled in the Hill Country, just 20 minutes northeast of Downtown Kerrville. This picturesque ranch features a gorgeous native stone home with approximately 5,600 sq. ft. of living space. Highlights include an arched stained glass entryway, 18-foot cedar ceilings, a cozy gas fireplace, and floor-to-ceiling windows with breathtaking southwest views leading to a covered porch. The home offers two master suites, two guest bedrooms, each with en suite bathrooms, a separate office, a gourmet island kitchen, a utility room, a central vacuum system, and an attached 3-car garage. Additionally, there's a detached 2-car garage with HVAC and a bathroom, and an attached greenhouse. The property is partly wooded with oak and elm trees, high-fenced on two sides, and offers spectacular views and building opportunities. A serene pond, fed by natural springs, attracts Canadian geese and ducks. A deep 400+ ft well ensures a steady water supply, producing 25 gallons per minute. Rambling Creek Ranch is teeming with wildlife, including axis deer, whitetail deer, hogs, and turkeys. Its prime location and unique features make it perfect for family gatherings, outdoor adventures, and excellent hunting. Don't miss this rare opportunity to own a piece of the Texas Hill Country's natural beauty.
MlsNumber: --
ListingId: 1778676


Listing Provided By: Keller Williams City-View, original listing
Phone: (210) 388-2263
Office Phone: (210) 696-9996
Agent Name: Adriana Rodriguez
Disclaimer: Copyright © 2024 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