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

Tbd Cr 235 Road
Three Rivers, TX 78071
Brad Adcock with Keller Williams Realty - Waco, original listing - (254) 751-7900

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $233,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Keller Williams Realty - Waco
Agency Phone: (254) 751-7900

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 45 acre(s)
Property Type: Land-Unimproved Land
Year Built: --
Notes: Nestled in the heart of Three Rivers, Texas, this sprawling 45.55-acre parcel of land offers a rare opportunity to own a piece of the vibrant Texas landscape. Surrounded by the natural beauty of the region, this property boasts a prime location for those seeking a serene escape or an investment opportunity.<br /> <br /> Key Features:<br /> <br /> Expansive Space: With 45.55 acres at your disposal, the possibilities are endless. Whether you dream of building your own ranch, developing residential properties, or establishing an agricultural venture, this ample land provides the canvas for your vision.<br /> Tranquil Surroundings: Experience the tranquility of rural living while still enjoying the convenience of nearby amenities. Three Rivers offers a charming community atmosphere with easy access to shopping, dining, and recreational activities.<br /> Natural Beauty: Immerse yourself in the breathtaking landscapes of South Texas. From rolling hills to lush greenery, this property showcases the best of the region's natural beauty, making it ideal for outdoor enthusiasts and nature lovers alike.<br /> Investment Potential: Positioned in a desirable location, this acreage presents a lucrative investment opportunity. Whether you're looking to develop the land or hold it for future appreciation, Three Rivers continues to attract interest from buyers and investors alike.<br /> Additional Details:<br /> <br /> Utilities: Electricity and water utilities are available in the area, providing convenience for future development.<br /> Access: The property offers convenient access via well-maintained roads, ensuring ease of transportation.<br /> Zoning: Zoned for agricultural and residential use, offering flexibility for various development projects.<br /> Local Attractions: Explore nearby attractions such as Choke Canyon State Park, offering opportunities for fishing, hiking, and wildlife viewing.<br /> Don't Miss Out:<br /> <br /> Seize the opportunity to own this remarkable piece of land in Three Rivers, Texas. Whether you're looking to build your dream home, start a new venture, or simply invest in your future, this property offers limitless potential. Schedule a viewing today and discover the endless possibilities that await you!
MlsNumber: --
ListingId: 222315


Listing Provided By: Keller Williams Realty - Waco, original listing
Phone: (254) 315-2636
Office Phone: (254) 751-7900
Agent Name: Brad Adcock
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