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

131 Fcr 462
Buffalo, TX 75831
Taylor German with Keller Williams Lonestar, original listing - (979) 232-2017

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $715,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 2280 Square Feet
Agency: Keller Williams Lonestar
Agency Phone: (214) 526-4663

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 38 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2014
Notes: Look no further for your Barndo and 38 acres with an established Ag exemption. 3 bedroom, 2 bath home awaits you on a secluded dead-end<br /> road surrounded by mature trees. Drive up the tree-lined drive that circles in front of the house. Step inside to an inviting open floor plan with a beautifully designed kitchen and living space, perfect for entertaining. The primary ensuite is a true retreat, featuring a luxurious jetted tub, separate shower, gorgeous countertops, and a spacious walk-in closet. Outside, the possibilities are endless with a large shop equipped large front and back porches that await some excellent old-fashioned sitting and animal watching. Enjoy the large fenced-in garden, complete with a 300 sqft greenhouse in your spare time. For the hunting enthusiast, there are over a mile of established trails for hunting or even hiking that lead to an all-weather creek. The house features double-pane windows, two high efficient AC units, and spray foam insulation. Also, an oversized steel-framed carport can be enclosed if desired. The 2400 sqft shop (man cave) is equipped with 2phase electrical, 400 sqft loft, two window AC units, and 2 RV hookups. The property is located less than 5 miles from I-45. Nearby cities are Waco, Huntsville and Tyler, and Dallas is just 1.5 hrs away. Whether you're looking for wide-open spaces, a peaceful escape, or room to grow, this incredible property has it all. Don't miss the chance to make it yours!
MlsNumber: --
ListingId: 20844322


Listing Provided By: Keller Williams Lonestar, original listing
Phone: (903) 390-1707
Office Phone: (979) 232-2017
Agent Name: Taylor German
Disclaimer: Copyright © 2025 North Texas Real Estate Information Systems, 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