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;

100 Steepside Lane
Kerrville, TX 78028
Glen Boehm with Keller Williams Boerne, original listing - (830) 816-3500

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $4,250,000
Beds: --
Baths: --
Status: Active
SqFt: 7142 Square Feet
Agency: Keller Williams Boerne
Agency Phone: (830) 816-3500

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 24 acre(s)
Property Type: Commercial Sale-Other
Year Built: 1932
Notes: Reimagined 1930s Hilltop Estate Overlooking the Guadalupe River! Whether you envision it as a serene personal retreat, a picturesque wedding venue, or a sophisticated corporate getaway, this estate offers endless possibilities. Discover the captivating history and unparalleled charm of this 1930s hilltop estate, offering sweeping views of the Guadalupe River. Nestled behind a private gate, a winding driveway welcomes you to this architectural masterpiece designed by the renowned Atlee B. Ayers, with an appreciation for San Antonio's cultural heritage. Acquired and lovingly restored by a local businessman and his wife, this estate boasts grand, estate-sized rooms, rich hardwood flooring, multiple cozy fireplaces, and a convenient elevator to the second floor. The upper level hosts the luxurious owner's suite, complete with a spacious closet and a private en-suite bathroom. Three additional bedrooms each provide direct access to the outdoor veranda, featuring stairs that lead to the beautifully landscaped grounds below. The upstairs sitting room, with its stunning river views, served as an enchanting reading nook. Perfect for entertaining, the expansive outdoor pavilion includes an outdoor kitchen and two bathrooms, making it an ideal space for gatherings of any size. Additionally, the property features two separate dwellings-a charming art studio and a cozy guest cabin-providing ample space for guests or creative pursuits. The original architectural plans from the 1930s are still in the owner's possession, adding a layer of authenticity. Don't miss the chance to experience this unique property. Schedule your private showing today and explore the timeless elegance and rich history of this extraordinary estate.
MlsNumber: --
ListingId: 1786087


Listing Provided By: Keller Williams Boerne, original listing
Phone: (210) 213-6886
Office Phone: (830) 816-3500
Agent Name: Glen Boehm
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