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

112 Applehead Island
Horseshoe Bay, TX 78657

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $12,500,000
Beds: 5
Baths: 9
Status: Active
SqFt: 7152
Agency: Kay A Lowe, Broker

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2003
Notes: Are you hunting the absolutely incredible lake retreat? You just found the perfect family compound on exclusive Applehead Island in beautiful Horseshoe Bay Resort, Texas hill country, on Lake LBJ. This beautiful home sits on over .55 acre, boasting over 220' of gorgeous N/NE open water & has a main house, 2 casitas & a fabulous outdoor living area, heated pool, cabana, covered double boat slips, floating dock, ample storage & too many details to list! The main house was basically gutted in 2016/17, taken down to studs and truly updated to create a newer, modern, WOW space! This home HAS to be looked at from the inside, wall of beautiful windows, over 2,000 additional sq/' of covered patio with fireplace. The living/dining/chef's kitchen is accented by a BRONZE Wine Cellar/wet bar for a perfectly fun lake house! The main home has the primary bedroom suite, with a sitting area/f/p, his/her walk-in closets & grand private bathroom. There is a cute bonus area up above, not officially counted as a bedroom. There are two casitas outside, both opening onto the outdoor living, overlooking the pool & lake. One has a private master suite, other has two master suites along with a full kitchen & large bunkroom. Guests can enjoy the peace & quiet of the beautiful lakeside resort, private island amenities, along with the excitement of the lake life! Summary, 4 fireplaces, unbelievable chef's kitchen with every possible appliance, Wolf stove, tons of workspace, separate dining area, office & relaxing spaces to enjoy.
MlsNumber: 167825


Listing Provided By: Kay A Lowe, Broker, original listing
Name: Kay A Lowe, Broker
Phone: (830) 596-1010
Office Name: Kay A. Lowe, Broker
Office Phone: (830) 385-4646
Agent Name: Kay Lowe
Disclaimer: Copyright © 2024 Highland Lakes Association of Realtors MLS. 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