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

1084 Beddo Mountain Road
Santo, TX 76472
Brittany Jones with Texas West Real Estate LLC, original listing - (254) 965-7653

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,999,999
Beds: 4
Baths: Full: 4
Status: Active
SqFt: 3600 Square Feet
Agency: Texas West Real Estate LLC
Agency Phone: (817) 694-6045

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 75 acre(s)
Garage: Garage
Property Type: Residential-Farm
Year Built: 2007
Notes: This Gorgeous Luxury Estate, Nestled on 76 Acres of Pristine Land in Santo, TX, Offers an Unparalleled Combination of Elegance & Functionality. Situated atop Beddo Mountain, this Property is Accessed through a Private Electric Gate, Leading to a Custom-Designed Home that Boasts High-End, Trendy Finishes Throughout. Upon Entering, You'll be Greeted by a Luxurious Entryway that Opens into a Cozy Living Room, Featuring a Beautiful Stone Fireplace. The Gourmet Kitchen is a Chef's Dream, Gas Stove, Complete with an Island, Bar-Top Seating & a Farmhouse Sink. Expansive Windows in Every Room Frame Breathtaking Views of the Picturesque Palo Pinto County Mountains. The Home Includes 4 Large, Well-Appointed Bedrooms & 4 Bathrooms, with an Additional Bonus Room for Flexibility. This Ranch is a Turnkey True Paradise for Horse Enthusiasts. The Lush, Producing Coastal Fields Provide Ample Grazing Space, while the Roping Arena, Complete with Roping Boxes & Chute, & an Additional Riding Arena to Cater to all Equestrian Needs. 2 Horse Barns Offer a Total of 19 Stalls, Barn 1 has Priefert Box Stalls with Fans & Runs, Barn 2 has Large Pipe Stalls with Runs, Abundant Storage for Tack, Equipment, Feed & Hay, & Horse Walker. Completely Fenced & Cross Fenced, to allow Multiple Turnout Pastures, Ideal Setup for Horses & 2 Stock Tanks. Additional Shop with Car Lift. Located in Santo ISD. Don’t Miss the Opportunity to Make this One of a Kind, Extraordinary Property Your NEW Texas Ranch.
MlsNumber: --
ListingId: 20795563


Listing Provided By: Texas West Real Estate LLC, original listing
Phone: (817) 694-6045
Office Phone: (254) 965-7653
Agent Name: Brittany Jones
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