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

331 Elm Creek Road
Waelder, TX 78959

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $665,000
Beds: 3
Baths: 2
Status: Active
SqFt: 1980
Agency: Legacy Land Associates

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 13 acre(s)
Property Type: Farm And Agriculture
Year Built: 2021
Notes: Tucked away in the tranquil countryside, perfectly situated between three major Texas cities - Houston, San Antonio, and Austin - this meticulously manicured property offers a serene retreat from the hustle and bustle of everyday life. With a charming 3-bedroom, 2-bathroom modular home filled with natural light and modern comforts, sitting on 13.538 acres embodies country living. Upon entering, you?re greeted by a bright living space, adorned with large windows that offer views of the picturesque landscape. The open and modern kitchen features stainless steel appliances, a coffee bar area, and a spacious center island perfect for casual meals and entertaining. The master suite is a peaceful retreat, complete with a generous walk-in closet and an in-suite bathroom featuring a large walk-in shower, double vanity, and soaking tub - ideal for relaxation. Outside, the large deck overlooks a large stock pond perfect for fishing or gathering around the fire pit under the stars. Adding to the charm of the property is a classic red barn, and a metal garage with electrical service an automatic overhead door. While the colorful crepe myrtles, the young orchard filled with peach, pear, and citrus trees, and the raised garden beds provide the perfect blend of aesthetics and functionality. A few other added amenities include: a reverse osmosis filtration in the kitchen, a water filter and water softener in the pump house, whole-house Generac back up power system, security lights, and a RV pad with water, sewer, & electric hookups. Whether you?re seeking a quaint weekend retreat or a permanent escape to the countryside, this property is sure to delight.
MlsNumber: 146372


Listing Provided By: Legacy Land Associates, original listing
Name: Legacy Land Associates
Phone: (512) 776-1398
Office Name: Legacy Land Associates
Office Phone: (512) 776-1398
Agent Name: Hannah Mica
Disclaimer: Copyright © 2024 South Central Texas Board of Realtors. 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