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;

111 Stoney Hills
Center Point, TX 78010
Julie Quest with Hill Country Home & Ranch Team LLC, original listing - (830) 995-2511

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,035,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 730 Square Feet
Agency: Hill Country Home & Ranch Team LLC
Agency Phone: (830) 995-2511

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 9 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1985
Notes: Welcome to your dream retreat! This custom home nestled on 10 acres of picturesque land boasts breathtaking views and a serene rural ambiance, providing the perfect escape from the hustle and bustle of city life. Conveniently located near I-10, with a mere 45-minute drive to San Antonio International Airport, this property offers the ideal blend of tranquility and accessibility. As you step inside, you'll be greeted by an array of custom features that set this home apart. The heart of the house, the kitchen, is a culinary enthusiast's delight, featuring a stunning island and sleek Quartzite counters. With new appliances and ample space, meal preparation is both convenient and enjoyable. Step outside onto the expansive covered deck, where you can soak in the panoramic views and gentle breezes while enjoying al fresco dining or simply unwinding in the fresh air. The deck is perfect for entertaining or simply relaxing with loved ones. The spacious layout includes a generously sized kitchen, perfect for gathering and creating memories with family and friends. Completed in 2024, this home boasts beautiful decor throughout, creating an inviting and comfortable atmosphere. Located in close proximity to Kerrville, Comfort, Fredericksburg, and Boerne, you'll have easy access to a variety of amenities, dining options, and recreational activities. The downstairs suite offers a private retreat, complete with a walkout for easy access to the surrounding natural beauty. Whether you're seeking a peaceful sanctuary or a place to host gatherings, this home offers endless possibilities. With unrestricted property and a private setting, this is truly a rare find. Don't miss your opportunity to make this exceptional property your own - it's more than just a house, it's a place to call home.
MlsNumber: --
ListingId: 1782351


Listing Provided By: Hill Country Home & Ranch Team LLC, original listing
Phone: (210) 535-9463
Office Phone: (830) 995-2511
Agent Name: Julie Quest
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