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

19000 Nw County Road 3190
Dawson, TX 76639

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,995,000
Beds: 3
Baths: 4
Status: Active
SqFt: 4200
Agency: KELLER WILLIS SAN ANTONIO INC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 334 acre(s)
Property Type: Farm And Agriculture
Year Built: 2001
Notes: 336-acre Waterfall Ranch is a picturesque property located halfway between Hillsboro and Corsicana, just 40 minutes northeast of Waco, and an easy hour and 15 minute drive south of Dallas. This abundant oasis features income-producing pastures, rolling hills, a variety of stately mature trees, and 8+ ponds, making it an ideal habitat for a variety of wildlife and livestock. Waterfall Ranch also boasts a relaxing, spacious, and welcoming 4200 sq ft home overlooking a generously stocked 3-acre lake perfect for fishing and making memories with the ones you love. The home provides plenty of storage, a theater room, safe room or wine cellar, craft room, sun room, and en suites for all bedrooms. Relax and enjoy your morning coffee from the patio that overlooks your private lake. To fish or not to fish, that is the question! The property is cross fenced and complete with a 40ft x 50ft insulated, AC, electrical serviced shop for all your project needs as well as a full-metal construction 50ft x 200ft equipment and hay barn. With RV hookups, an abundance of wildlife including whitetail deer, turkey, ducks, and passing doves, this property is an exceptional opportunity for those seeking a ranch with premier recreational, hunting, and livestock features, as well as potential for expansion of round bail or other pasture production. Only minutes from higher-density development, this land provides a great investment and potential for subdivision with proven comps of $12-14k/acre for 5-7 acre lots. The ranch's prime location, abundant water elements, and ready-to-work improvements make it a wise long-term hold and ideal place to gather with family and friends for endless outdoor adventures away from the city. They say you can't have it all, but Waterfall Ranch proves you can!
MlsNumber: 1692500


Listing Provided By: KELLER WILLIS SAN ANTONIO INC, original listing
Name: KELLER WILLIS SAN ANTONIO INC
Phone: (210) 696-9996
Office Name: Keller Williams City-View
Office Phone: (210) 696-9996
Agent Name: Donald Walker
Disclaimer: Copyright © 2024 San Antonio 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