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

516 Cottonseed Run
Martindale, TX 78655

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $795,000
Beds: 6
Baths: 4
Status: Pending
SqFt: 2514
Agency: Keller Williams Realty International

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1994
Notes: Looking for a river front home with everything? A large gorgeous pool, two guest houses, an oversized garage/workshop, and all sorts of bespoke artistic accents? This housing compound is a blissful retreat for the soul! The 0.65 acres includes endless flagstone walkways leading from building to building to courtyard to sitting area to pool to gazebo! All surrounded by natural gardens, fountains, and a wide variety of fruiting trees (peach, plum, fig, pomegranate). Nestled in the banks of the tranquil San Marcos River this home comes with elevated views of the clear aqua water, enjoying over 100 ft of riverfront with direct access to kayaking, fishing & tubing. The MAIN HOME is 1,969sf, with 4 large bedrooms, 3 baths, rich hardwood floors, and high ceilings. The POOL includes complete fencing/wall around it for safety, a large entertaining patio, and a new pump. The RIVERSIDE CASITA has AC, a complete kitchenette, a bathroom with a shower, and a view straight out to the river. The BARNDOMINIUM has AC, an inviting barn door entry, and artistic touches. The GARAGE + WORKSHOP include another large, attractive barn door, a plethora of work space, tons of shelving, and a loft for storage. So many other bits add to the incredible magic of the property: the breakfast garden patio (nestled into the main home), the gazebo, the grill area, the fire pit area, the pond (with fountain!), the playground, and the lookout sitting spot over the river! Not only that, but the main home has central AC, with one unit only a year old and the other unit being replaced this week. All appliances in the main home have been replaced in the last two years, including washer/dryer, dishwasher, oven, and refrigerator. The main home has never flooded, the lower half of the staircase to the river can be rebuilt by a number of quality vendors nearby. Unrestricted with low taxes, no HOA, and overnight rentals allowed. This lush oasis has everything!
MlsNumber: 8557156


Listing Provided By: Keller Williams Realty International, original listing
Name: Keller Williams Realty International
Phone: (512) 448-4111
Office Name: Keller Williams - Austin SW
Office Phone: (512) 448-4111
Agent Name: Alyse Black
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