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;

1139 Sw County Road 2348
Richland, TX 76681

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $895,000
Beds: 5
Baths: 5
Status: Active
SqFt: 3394
Agency: Hayden Outdoors, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 23 acre(s)
Property Type: Residential
Year Built: 2022
Notes: WEATHER YOU ARE SEEKING A CORPORATE RETREAT , A FAMILY GETAWAY, OR A PERMANENT RESIDENCE IN THE COUNTRY, <br /> THIS 23.83 ACRES IS THE ANSWER TO YOUR DREAMS. CLOSE TO THE METROPLEX, YET SECLUDED, THIS LIKE NEW FACILITY HAS ONLY BEEN USED ON OCCASION. PRICED EXTREMELY WELL, 16.74 ARE IN AG EXEMPT. WITH TWO SECURITY GATES, THE ENTIRE HOME IS WIRED WI-FI WITH AN AMAZING INDOOR OUTDOOR SOUND SYSTEM. TRULY A ONE OF A KIND, THIS 5BED 5 BATH HOME INCLUDES 3 HORSE STABLE 12X20 EACH, 20X80 CATTLE LEAN TO, 20X40 HAY BARN, 2 STOCK PONDS, PLENTY OF WILDLIFE, STORM SHELTER, HUNTING BLIND AND FEEDER, 300 SQFT GUEST HOUSE, LARGE EQIPTMENT SHED, FULL WRAP AROUND PORCH, 3 OUTDOOR MEDIA ZONES FOR AUDIO, 5 PERSON JACUZZI, OUTDOOR KITCHEN WITH SINK, REFRIDGERATOR, GRIDDLE AND GRILL, PORCH LIGHTS ALL THE WAY AROUND, 27 FOOT CEILINGS, 22FT FIREPLACE, METALIC EPOXY FLOORING WITHHARDWOOD FLOORING UPSTAIRS, 6 TON HVAH & 4TON HVACSCHEDULE YOUR APPOINTMENT TODAY!! WONT LAST LONG AT THIS PRICE.
MlsNumber: 20553576


Listing Provided By: Hayden Outdoors, LLC, original listing
Name: Hayden Outdoors, LLC
Phone: (254) 688-0087
Office Name: Hayden Outdoors, LLC
Office Phone: (817) 626-2000
Agent Name: Bobby Norris
Disclaimer: Copyright © 2024 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