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

617 Llano River Road
Art, TX 76820

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $925,000
Beds: 1
Baths: 2
Status: Active
SqFt: 1012
Agency: Landmasters Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Property Type: Residential
Year Built: 2022
Notes: A Llano River hideaway awaits you just 2 hours from downtown Austin. Travel down to the end of the road and experience your own tranquil oasis with nothing but the sound of the water and the wind. This 10 acre property is the end tract in the Mas-O-Llan development, which means that there are only large ranches to the south and west, giving you unobstructed views of the river, the sunset, and the Hill Country. The improvements have been built with entertaining in mind and include 1) a good sized metal workshop/barn with it's own storm bunker that can sleep two, 2) a separate cabin with sleeping quarters, full bathroom, and deck, 3) another cabin with a kitchen,lounge area, full bathroom, deck, and hot tub, 4) a vintage camper that can sleep two, 5) a lookout tower for maximizing the long distance views, and 6) Four 30-amp RV hookups. The water is supplied from a 15,000 gallon rainwater collection system with advanced filtration system, while the 1500 gallon septic system is fully legally permitted by Mason county. A short drive away is the Castell General Store with BBQ and music. Kayaking, fishing, and swimming are as easy as walking down to the river's edge. With no close neighbors, it's easy to feel the extreme privacy that this property affords and, this far away from any city, the skies at night are brilliant with stars. Come on out and enjoy Rivertime. Priced To Sell- The owner is leaving the state and many of the furnishing and accessories can be negotated for.
MlsNumber: 166793


Listing Provided By: Landmasters Real Estate, original listing
Name: Landmasters Real Estate
Phone: (325) 247-5782
Office Name: Landmasters Hill Country
Office Phone: (325) 247-5782
Agent Name: Richard Houston
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