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','mihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 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','mihud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 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','mihud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 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;

150 Willow Bend
Center Point, TX 78010

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $690,000
Beds: 4
Baths: 4
Status: Active
SqFt: 3058
Agency: Spyglass Realty and Investments

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 6 acre(s)
Property Type: Residential
Year Built: 2008
Notes: Welcome to your own slice of Hill Country paradise at 150 Willow Bend in Center Point, Texas. This exquisite property offers everything you've been dreaming of and more. Step inside this spacious 4-bedroom, 4-bathroom home and be greeted by a modern open floorplan that effortlessly blends style and functionality. The large open kitchen with a center island is a chef's delight, boasting granite counters and ample space for meal preparation and entertaining. With a sprawling nearly 7 acres of pristine Hill Country land, this property provides the perfect backdrop for outdoor enthusiasts and nature lovers alike. Take in the breathtaking views from the observation deck or unwind on the covered patio, soaking in the sights and sounds of the surrounding landscape. For those with a passion for horses, this property offers the perfect space to indulge your equestrian pursuits. With ample room to roam and explore, your four-legged friends will feel right at home. Multiple outbuildings and shops on the property provide ample storage space or the opportunity to create your own unique spaces for hobbies or creative endeavors. Conveniently located close to town, and just a short drive away from Kerrville, Fredricksburg, and Comfort, you'll have easy access to a wealth of dining, shopping, and entertainment options. Plus, with San Antonio just a scenic drive away, you'll enjoy all the amenities of city living while still savoring the tranquility of the Hill Country. Don't miss your chance to own this exceptional property in one of Texas's most sought-after locations. Schedule your showing today and make 150 Willow Bend your new home sweet home.
MlsNumber: 1771469


Listing Provided By: Spyglass Realty and Investments, original listing
Name: Spyglass Realty and Investments
Phone: (512) 965-1480
Office Name: Spyglass Realty
Office Phone: (512) 759-0889
Agent Name: Dustin Raye
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