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

8161 State Highway 16
Pipe Creek, TX 78063
Gianna Rojas with EXIT Premier Realty, original listing - (210) 491-2067

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,222,222
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: EXIT Premier Realty
Agency Phone: (210) 491-2067

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Property Type: Commercial Sale-Other
Year Built: 2020
Notes: Welcome to HILL COUNTRY! Main house is 2500 Sq ft, 2 story, 4 bd, 2 bath home built in 1950. features Large open Kitchen with 2 living spaces, wood fireplace, newly fenced yard around main house. Covered front/back porch with concrete slabs and magnificent views! 9 Cabins custom built, furnished and turnkey. cabins 1 thru 8 sleep 3 to 4 @320 sq ft with private porch and private parking for 2 cars each. Main Cabin is 750 sq ft, large porch, full kitchen, living room and dining. Sleeps 6 to 7 with laundry units. There are 2 spaces for R/V hook ups and parking. Property Has a gravel trail surrounding the cabins, perfect for an early morning walk. Inground pool with waterfalls, large new attached deck (30x40) with covered pavilion. Also conveys 2 pavilions with concrete slabs and concession bldg. All with electricity. Property conveys 1 warehouse (20x30) which has laundry hook up and mini split air conditioning. Barn/shop is 1750 sq ft. with a partial loading dock. ten minutes to Bandera Cowboy Capitol and the Medina River. This area is fast-growing but continues to be a great area to get away from the hustle and bustle of big city life. come and enjoy the country hill Views, Twisted Sister roads and star filled nights, where all you see is STARS. Schedule a viewing with Gianna and you will see all the potential these unrestricted 4 Acres has to offer. More Pictures Coming Soon!
MlsNumber: --
ListingId: 1815091


Listing Provided By: EXIT Premier Realty, original listing
Phone: (630) 806-6663
Office Phone: (210) 491-2067
Agent Name: Gianna Rojas
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