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

40 Sunriver
Boerne, TX 78006

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,997,750
Beds: 4
Baths: 4
Status: Active
SqFt: 4689
Agency: KELLER WILLIS SAN ANTONIO INC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 8 acre(s)
Property Type: Residential
Year Built: 2007
Notes: This 8.91AC estate is one of the few existing larger acreage properties in Cordillera Ranch featuring a design by Gustavo Arredondo with a modern Mediterranean contemporary elegance. A custom-made arched iron entry door invites you into a sanctuary of your own with a great room illuminated with a view of the pool and your outdoor private oasis. You will feel the peace, calmness, and quietness unique to this property experience. The Gustavo floor plan flows seamlessly and is well balanced with careful thought to a grand master retreat and study on one wing, the quest bedrooms on the opposite providing their privacy, centered by an open atmosphere great room and formal dining transitioned by a custom see through fireplace with dry stacked stone. Every detail has been thoughtfully designed and executed. Upscale amenities include a prominent proportion of travertine floors accented with wood in the master and study, custom cabinetry, granite counters, design chandeliers, modern hardware, and lighting exhibited tastefully. The open kitchen features a Viking cooktop, stainless steel appliances, dual ovens, a warming drawer, an ice maker, a center aisle, and a breakfast bar with a view. The expansive master retreat offers a sanctuary including a seating area leading to your outdoor living area with a fireplace, a bath area anchored by a jetted garden tub with a private view, a shower with multiple heads, and dual custom wardroom rooms. All secondary bedrooms have ensuite bathrooms providing kids or guests with a private retreat. The fourth room is currently utilized as a study with a custom built-in, adjoining spacious closet and full bath. The outdoor living, with multiple interior access points, including the living area with a fireplace and kitchen, all accentuated by the pool overlooking your private park loaded with expansive trees and pastures. The setting exudes an exceptional feeling of peace and serenity all while providing your wildlife park accented with axis, fox, turkey, whitetail, and an abundance of native bird species. Yes, your private Texas ranch setting could be easily converted to include equestrian lovers' private facilities. The soil of this 8.91AC is a rarity in Cordillera Ranch. The detached garage, approximately 1200sq' per CAD, is sheet rocked and has previous use as a full workshop and storage with garage doors for all your toys. The structure is thoughtfully plumbed for a future finish out for a casita or in-law living and inviting porch to share in the beauty of this property including the pool and outdoor entertainment areas. Draft plans available. For the ultimate unplugging experience, this estate adjoins one of Cordillera's networks of nature trails within walking distance to the 63AC+ Swede Creek and Guadeloupe River Park.
MlsNumber: 1763400


Listing Provided By: KELLER WILLIS SAN ANTONIO INC, original listing
Name: KELLER WILLIS SAN ANTONIO INC
Phone: (210) 696-9996
Office Name: San Antonio Portfolio KW RE
Office Phone: (210) 698-9996
Agent Name: Gary Peterson
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