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','nyhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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','nyhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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','nyhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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;

4746 W Hwy 29
Llano, TX 78643

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $699,999
Beds: 2
Baths: 2
Status: Active
SqFt: 1400
Agency: Horseshoe Bay Living 2, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Property Type: Residential
Year Built: 2004
Notes: Nestled on a sprawling 10.5-acre canvas of natural beauty, this property offers a unique blend of tranquility and versatility. The centerpiece is a charming 2-bedroom, 2-bathroom main home, providing a cozy retreat surrounded by nature. In addition to the main home a delightful 12x24 tiny house that adds character and versatility to the property. Ideal for guests, a home office, or income property, this compact dwelling provides a unique and intimate living experience. For those seeking a more rustic charm, a1-bedroom, 1-bathroom cabin awaits, complete with a kitchenette. Ideal as a guest house or as another income property. But that's not all – envision the possibilities with 3 RV spots strategically positioned each with 50 and 30 amps with sewer and water. Ideal for additional income or guests. Additionally the property includes a 30X50X14 closed cell insulated shop with power and lighting and a 40 foot shipping container with power and lighting. The property is a canvas waiting for your vision. With ample acreage,there's room to explore, create, and make this space uniquely yours. The options are endless, from building additional structures to cultivating gardens or simply relishing in the vast open spaces. Main House has 3 mini splits, Tiny House has 1 and cabin has window unit (AC/Heat combo) COMPETELY NEW SEPTIC AS OF JAN. 19, 2024
MlsNumber: 167288


Listing Provided By: Horseshoe Bay Living 2, LLC, original listing
Name: Horseshoe Bay Living 2, LLC
Phone: (512) 550-3624
Office Name: Horseshoe Bay Living 2, LLC
Office Phone: (512) 550-3624
Agent Name: Micha Osloond
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