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

1155 Blue Water Dr
Canyon Lake, TX 78133-5374
Michael Schultz with San Antonio Portfolio KW RE AH, original listing - (210) 832-8327

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $4,895,000
Beds: 6
Baths: Full: 6, ½: 5
Status: Active
SqFt: 6426 Square Feet
Agency: San Antonio Portfolio KW RE AH
Agency Phone: (210) 832-8327

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2003
Notes: Welcome to your own private oasis nestled on the stunning shores of Canyon Lake! This exquisite property boasts a rare and expansive 4.54 acres of land, with a breathtaking 385+/- feet of waterfront, offering unparalleled serenity and seclusion. Step into luxury as you enter the 5,766 SqFt Main Home, where every detail has been meticulously crafted for both comfort and elegance. There is 5 bedrooms & 5.5 bathrooms affording each bedroom to having its on en-suite bath. With spacious living areas, soaring ceilings, and panoramic views of the lake, this home is an entertainer's dream. The gourmet kitchen is a chef's delight, featuring top-of-the-line appliances and custom cabinetry. Relax and unwind in the opulent master suite, which is the entire second story, complete with a spa-like ensuite bathroom, his & hers closets and it's own flex space & private balcony overlooking the water. A kitchen a chef would be envious of, smart home lighting, Sonos throughout, gorgeous wood floors, billiard room and so much more to truly make your Canyon lake living the best it can possibly be. For extra guests or extended family, the charming 660 SqFt guest house provides a cozy retreat with one bedroom and one bathroom, complete with glass shower and claw foot tub overlooking the lake, while also ensuring privacy and comfort for all. Outdoor living takes center stage with a luxurious pool with lake views, perfect for enjoying sunny days and warm evenings with loved ones and positioned next to the oversized outdoor kitchen which is ideal for al fresco dining, while the expansive patio offers plenty of space for lounging and entertaining all year long. But the amenities don't end there - prepare to be amazed by the 2,000 square foot barn, thoughtfully converted into a full dance hall & bar to be the coolest property owner on the lake. Equipped with a stage, sound equipment, and dazzling lighting, this unique space is perfect for hosting unforgettable events and celebrations. It also has a living space and bedroom upstairs. With so much to offer, this property truly stands out as a one-of-a-kind opportunity. Rarely do properties of this caliber come on the market, making it a truly exceptional find. Sold turn-key, with only a few exclusions from the sellers, this is your chance to own a piece of paradise on Canyon Lake. Don't miss out on the opportunity to make this extraordinary property your own - schedule your private showing today!
MlsNumber: --
ListingId: 1775810


Listing Provided By: San Antonio Portfolio KW RE AH, original listing
Phone: (210) 832-8327
Office Phone: (210) 832-8327
Agent Name: Michael Schultz
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.


Local Real Estate Expert

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 = 2567 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;
Real Estate Expert Photo for Rebecca Wiley
Rebecca Wiley
ASCIID. Lee Edwards Realty, Inc
Call Today!: (830) 708-3011

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App