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;

110 Clearwater Dr
Kingsland, TX 78639

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,295,000
Beds: 4
Baths: 5
Status: Active
SqFt: 4218
Agency: Keller Williams - Lake Travis

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2024
Notes: JUST COMPLETED MODERN/TRANSITIONAL CUSTOM WATERFRONT HOME WITH 4218 SQFT PLUS A 654 SQFT CLIMATE CONTROLLED BOAT HOUSE! This gorgeous home is situated in a private cove beyond the gates of Clearwater Landing, a scenic neighborhood on the Colorado Arm of Lake LBJ. As you enter the main gates of the Legends Golf Course and exclusive neighborhood, the beauty of the rolling hills and winding roads offer a very special welcome home. Custom is key in describing this Clearwater Treasure. You will enter through a stunning 9 foot steel pivot door designed to reveal a modern linear fireplace, soaring ceilings, and walls of windows. The main house includes 4 BDRMS (2 Primary), 4.5 BATHS, fully plumbed lg game rm/flex rm, a holiday closet, huge laundry rm & enormous kit w- designer quartz surfaces and custom maple soft close cabinets. The unique oversized kitchen island comfortably seats 10 and is the heart of the home. There is a catering kitchen w- space for 2 additional refrigerators & a pantry full of storage options. The entire house is adorned w- European White Oak Flooring & designer wall & floor tile. With access out back from the kit/din/liv areas, the pool/spa w- swim up bar are perched high above the yard & boat house overlooking the cove, Lake LBJ, & the stunning Hill Country Views. The fun happens at the Boat House with 2 Remote Control Boat Lifts and RC Double Jet Ski Lifts. The full bath, bar sink, and spacious climate-controlled interior will ensure awesome memories are made year-round! Enjoy paddleboarding, kayaking, & other water sports in the protected cove or go right out onto the open waters of Lake LBJ for fun on the lake! There are so many special features & amenities & just too many to list--this is a MUST SEE.
MlsNumber: 1106755


Listing Provided By: Keller Williams - Lake Travis, original listing
Name: Keller Williams - Lake Travis
Phone: (512) 263-9090
Office Name: Keller Williams - Lake Travis
Office Phone: (512) 263-9090
Agent Name: LESLI AKERS
Disclaimer: Copyright © 2024 Keller Williams Realty, Inc. 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