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

769 Cr 144 Road
Buckholts, TX 76518
Gary Thweatt with Thweatt Real Estate, original listing - (254) 697-6573

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $895,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 2152 Square Feet
Agency: Thweatt Real Estate
Agency Phone: (254) 697-6573

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 39 acre(s)
Garage: Garage
Property Type: Residential-Farm
Year Built: 2008
Notes: BEAUTIFUL 4 BEDROOM 3 BATH,CUSTOM BRICK HOME SURROUNDED BY A LUSH 39.9 ACRE GREEN GRASS PASTURE. BEAUTIFUL VIEWS FROM BACK PATIO OVERLOOKING A 2 ACRE STOCK POND. POND IS EQUIPED WITH FISHING DOCK. EXCELLENT FENCING ALL AROUND THE ACREAGE. THE HOUSE IS FENCED OFF ON 2 ACRES FROM THE REST OF THE LAND. THE ACREAGE IS UNDER AG EXEMPTION FOR HAY PRODUCTION. THE HOUSE HAS AN ATTACHED GARAGE (APP. 800 SQ FT) USED FOR PARKING, STORAGE AND A WORKSHOP. THE HOUSE IS AN OPEN CONCEPT WITH CUSTOM FLOORING AND BEAUTIFUL GRANITE KITCHEN COUNTERTOPS. THIS HOME IS ALSO EQUIPPED WITH A GENERAC HOME STANDBY GENERATOR THAT AUTOMATICALLY RESTORES POWER TO YOUR HOME DURING AN OUTAGE. AS WELL AS A BEAUTIFUL BACKYARD WITH COVERED PORCH ALONG WITH A COVERED BBQ KITCHEN AREA WITH A SINK AND RUNNING WATER. THIS HOME HAS A PRIVATE ELECTRONIC GATE ENTRANCE EQUIPPED WITH CODE ENTRY. THE PROPERTY IS CENTRALLY LOCATED, BEING APPROXIMATELY 20 MINUTES FROM TEMPLE, APP. 50 MILES FROM WACO AND APP. 55 MILES FROM BRYAN/COLLEGE STATION. PLEASE CALL 24 HOURS IN ADVANCE FOR APPOITMENTS.
MlsNumber: --
ListingId: 224665


Listing Provided By: Thweatt Real Estate, original listing
Phone: (254) 697-6573
Office Phone: (254) 697-6573
Agent Name: Gary Thweatt
Disclaimer: Copyright © 2024 Waco Association 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