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

6700 W Dowlen Road
Happy, TX 79042
Traci Bigham with Coldwell Banker First Equity, original listing - (806) 354-3500

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $625,000
Beds: 3
Baths: --
Status: Active
SqFt: 1960 Square Feet
Agency: Coldwell Banker First Equity
Agency Phone: (806) 354-3500

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 60 acre(s)
Garage: Garage
Property Type: Farm-Other
Year Built: --
Notes: COUNTY LIVING AT IT'S FINEST! BARNDO WITH 60 ACRES. Located South of Canyon just off HWY 87. Enjoy endless views with beautiful sunsets on the 2,076 sq ft of concrete covered porches. The property features space for cattle or horses in the native pasture land. Beautiful BARNDO living with 2 greenhouses, 2 koi ponds, chicken coop and a natural playa lake. There are 2 barns on the property. The larger barn is 2,400 sq ft and the smaller one is 1,200 sq ft. The home has a huge island and open concept with wood burning stove. The unfinished basement is an additional 450 sq ft and provides space for storage and weather shelter. This one has it all!!!! The smaller barn has electric run to it. <br /> The larger barn has a solar panel if needed but electric could be added.<br /> The land to the west of the home has a septic system on it as well but the current owners have never used it. <br /> The covered porches are wired to add ceiling fans and fixtures. <br /> The basement is also wired for more lighting.<br /> Water softner is owned at stays with the property.<br /> The gas cooktop is run off propane. The rest of the home is all electric.<br /> Zoned as agricultural. Listing Agent is related to the Seller.
MlsNumber: --
ListingId: 24-8325


Listing Provided By: Coldwell Banker First Equity, original listing
Phone: (806) 341-8411
Office Phone: (806) 354-3500
Agent Name: Traci Bigham
Disclaimer: Copyright © 2024 Amarillo 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