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

6072 County Road 122
Hallettsville, TX 77964
Kimberly A Hoelter with Cornerstone Properties, original listing - (361) 576-2353

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $875,000
Beds: 4
Baths: Full: 2
Status: Active
SqFt: 2304 Square Feet
Agency: Cornerstone Properties
Agency Phone: (361) 576-2353

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 15 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1966
Notes: Experience country living at its best with this stunning homesite nestled on 15 beautiful unrestricted acres situated outside of Hallettsville. This unique property features an updated 4-bedroom, 2- bathroom two story primary residence. The heart of the home is the wonderfully updated kitchen with custom cabinets, granite countertops and stainless appliances leading to the cozy den area complete with masonry wood-burning fireplace and French doors that overlook the outdoor pool area. This home also features a second living area and a formal dining room perfect for family gatherings. Step outside to the welcoming in-ground pool perfect for those hot summer days. In addition is a wonderful 3- bedroom, 2-bathroom guest house. This 2021, 30x60, 1800 sq ft manufactured home boasts an open floor plan featuring a beautiful kitchen with stainless appliances, huge pantry and a center island breakfast bar that opens up to the spacious living area complete with beamed ceilings, planked accent wall, and dining area that overlooks the back deck and peaceful pasture. The property also includes a pond, storage building and a Conex for additional storage. Fenced and cross fenced with 5 acres in front and 10 acre pasture in the back of open land with scattering of mature trees and an ag exemption already in place for livestock. With room to roam and serene country setting, this property is perfect for multi-generational living or could be used as rental income or Airbnb, the possibilities are endless. It's conveniently located between Houston and San Antonio, with easy access to Splashway Water Park and High Hill Distillery. Don't miss the chance for your very own slice of Texas paradise!
MlsNumber: --
ListingId: 571300


Listing Provided By: Cornerstone Properties, original listing
Phone: (361) 655-0018
Office Phone: (361) 576-2353
Agent Name: Kimberly A Hoelter
Disclaimer: Copyright © 2025 Central Texas Multiple Listing Service. 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