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

5061 Cr146
Stamford, TX 79553
Linda Camp with Coldwell Banker Apex, REALTORS, original listing - (325) 690-4000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $850,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 3188 Square Feet
Agency: Coldwell Banker Apex, REALTORS
Agency Phone: (325) 690-4000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 59 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1981
Notes: OWNER AGENT - Country living at it's best. Welcome to your owe private oasis that sits on almost 60 acres. This stunning 3 bedroom, 3 bath home perfectly balances and functionality with it's open floor plan, making it ideal for entertaining family and friends and has a split concept. This home also boasts 2 living spacious areas, 2 dining areas, and a cozy fireplace for those cozy chilly nights. The kitchen features stainless steel appliances, large double ovens, new counter tops with new backsplash, and plenty of counter space for meal prep, and plenty of cabinet space. The cabinets and drawers are also soft close. The huge master bedroom features 2 large walk-in closets and a nice size master bath. The utility room features plenty of close space and a bath room just off of it with a stand up shower. The other 2 large bedrooms also have nice size closets and great space for everyone. The 2 car garage also has a large storage room. <br /> WILDLIFE - This property is great for the ideal hunter. Featuring whitetail deer, turkey, hogs. ducks, a few quail, and an abundance of dove. You also have the California creek for fishing.<br /> The 59.050 acres is fenced and cross fenced and is in great shape. The barn is a wonderful place for your FFA and 4 H projects. There is also workable chutes and pens. The workshop with electricity is a great place for any project and also has an over hang attached to it great to store your small toys such 4 wheelers or even extra firewood. <br /> If that is enough let's talk about water supply. City water feeds the house. There is also 2 water wells, 2 tanks, and the California creek runs in the middle of the property. Call for your appointment today.
MlsNumber: --
ListingId: 20834309


Listing Provided By: Coldwell Banker Apex, REALTORS, original listing
Phone: (325) 280-7294
Office Phone: (325) 690-4000
Agent Name: Linda Camp
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