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;

511 Legends Parkway
Kingsland, TX 78639

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $5,200,000
Beds: 4
Baths: 6
Status: Active
SqFt: 4371
Agency: Dave Hudson

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential
Year Built: 2015
Notes: **MAJOR PRICE REDUCTION**Welcome to 511 Legends Parkway, an exceptional waterfront estate nestled within the prestigious Legends on LBJ community. This custom-built residence sits on a sprawling 3-acre lot, with 506 feet of waterfront and unparalleled luxury. This home is offered FOR SALE FULLY FURNISHED and ready for spring and summer fun with family & friends Custom built by Diamanté homes of Boerne, Texas featuring 4 suite-like bedrooms, each with its own private patio. Crafted with imported tile flooring, specialty woodwork, and hand-painted faux brick barrel ceilings, every detail contributes to its unique elegance. At the heart of this magnificent property is a gourmet kitchen outfitted with commercial-grade appliances from top of the line brands, designed both for aspiring chefs and those who delight in culinary excellence. Outside Entertainment abounds with large covered patio overlooking the swimming pool and Lake LBJ. It's a short walk out to the dock area patio, equipped with high-end amenities including Perlick stainless steel refrigerators, a smoker, wine cooler, ice-maker, griddles, barbecue grill, and stereo system. One the best boat docks on Lake LBJ ! 511 LEGENDS PARKWAY - isn't just a house—it's a lifestyle. The perfect Texas Hill Country Lakefront Home that balances privacy, comfort and style. It's a great location with easy access to local amenities. Embrace the finest in waterfront living at this remarkable estate.
MlsNumber: 167887


Listing Provided By: Dave Hudson, original listing
Name: Dave Hudson
Phone: (512) 990-2512
Office Name: Lake LBJ Partners
Office Phone: (512) 784-4237
Agent Name: Dave Hudson
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