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

602 Cr 3215 Road
Clifton, TX 76634

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $650,000
Beds: 2
Baths: 2
Status: Active
SqFt: 815
Agency: Whitetail Properties Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 25 acre(s)
Property Type: Residential
Year Built: 2022
Notes: PRICE REDUCED! Welcome to the charming and picturesque ranch property you have been dreaming of! Conveniently located and nestled in the heart of Bosque County, this delightful ranch boasts a new cozy and custom-built 2 bedroom, 2 bath home that is perfect for those seeking a peaceful retreat. Step inside this lovely dwelling and you'll be greeted by a warm and inviting atmosphere, thanks to its thoughtful design and meticulous attention to detail. The house features a beautiful porch with solid wood beams on each end and above the front entry. You'll find all the modern comforts you desire with none of the city noise. The property also features a newly drilled water well that stretches an impressive 1190 +/- feet to the second Trinity Aquifer, ensuring an inexpensive, safe and reliable water supply. With electric, septic and propane systems in place, you can enjoy a hassle-free and convenient lifestyle. As you step outside, you'll be captivated by the breathtaking views and the nature surrounding you. The ranch boasts a seasonal pond, adding a touch of tranquility and a perfect spot to relax and unwind. The entire ranch is fully fenced to keep your livestock on the property. Ample grassland is available, providing abundant grazing opportunities for your livestock or horses. The gated entrance ensures privacy and adds an extra layer of security. Additionally, the road frontage provides easy access to and from the property, making your daily commute a breeze. Whether you are looking for a weekend property to unwind on after a long week in the city, or a permanent homestead, this attractive and conveniently located ranch will exceed your expectations! Call today to schedule a private showing!<br /> <br /> - New custom built 2 bed 2 bath home<br /> - 1190' +/- water well drilled to the second Trinity Aquifer<br /> - Electric, Propane and Septic systems in place<br /> - Fully fenced<br /> - Wildlife Management Tax Exemption in Place<br /> - Electric service is wired to be able to add a second home
MlsNumber: 221265


Listing Provided By: Whitetail Properties Real Estate, original listing
Name: Whitetail Properties Real Estate
Phone: (830) 428-0096
Office Name: Whitetail Properties Real Estate
Office Phone: (830) 428-0096
Agent Name: Jonathan Wise
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