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

1990 Jim Harry Loop
Sunset, TX 76270
Chad Odom with Texas Premier Realty, original listing - (210) 884-8683

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,999,000
Beds: 5
Baths: Full: 5, ½: 1
Status: Active
SqFt: 8004 Square Feet
Agency: Texas Premier Realty
Agency Phone: (210) 884-8683

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 35 acre(s)
Garage: Garage
Property Type: Residential-Farm
Year Built: 2020
Notes: Experience Unparalleled Luxury and Versatility on This Stunning 35-Acre Ranch<br /> <br /> Step into a world where rustic charm meets modern sophistication on this breathtaking 35-acre estate. Designed to inspire and impress, this property offers a rare combination of natural beauty, architectural excellence, and limitless potential.<br /> <br /> The crown jewel of this estate is the expansive 6,519 sq. ft. main residence, a masterpiece of craftsmanship and design. Featuring 3 spacious bedrooms, easily convertible to 5, the primary suite is 1250 sf, the home is adorned with unique touches such as rustic tin ceilings, industrial Harley Davidson lighting, and 100+ year-old reclaimed wood, blending timeless elegance with rugged allure. A main living area of 1500 sf, chef’s dream kitchen equipped with top-of-the-line Viking appliances sets the stage for culinary creations and entertaining on a grand scale.<br /> <br /> Adjacent to the main house, a 1,100 sq. ft. guest house provides a private and luxurious retreat for visitors or extended family. The estate also boasts an impressive 10,500 sq. ft. of shop space under a class 4 commercial roof, perfect for car enthusiasts, artisans, or entrepreneurs. With barns, RV storage, and state-of-the-art 74 solar panels, the property is as functional as it is beautiful.<br /> <br /> Nature lovers will find serenity by the 6-acre lake, a tranquil oasis surrounded by lush greenery, complete with a mesmerizing waterfall pond. Whether you're fishing, practicing your shot on a 100-yard shooting range, or simply enjoying the views, this is your private slice of paradise.<br /> <br /> This property isn't just a home; it's an opportunity. With its vast acreage, luxurious amenities, and versatile spaces, it’s ideal for a family retreat, a working ranch, or an income-generating venue.<br /> <br /> Here, the possibilities are as endless as the stunning sunsets. Your dream lifestyle starts now—make this extraordinary ranch your own today!
MlsNumber: --
ListingId: 20805441


Listing Provided By: Texas Premier Realty, original listing
Phone: (214) 662-8447
Office Phone: (210) 884-8683
Agent Name: Chad Odom
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