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

1085 County Rd. 1960
Yantis, TX 75497
Brenda Boyd with Staples Sotheby's International Realty, original listing - (903) 876-1051

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $5,000,000
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3200 Square Feet
Agency: Staples Sotheby's International Realty
Agency Phone: (903) 876-1051

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 250 acre(s)
Property Type: Farm-Single Family Residence
Year Built: 1995
Notes: Dreaming of waterfront living in Texas? Little Caney Creek Ranch, an oasis of 202 deeded acres with additional est. 48 acres of lease-back land along 1/2 mile of shoreline of Lake Fork, the renowned world-class fishing lake. The 1/2 mile of cement driveway is guided by 9,100 ft. of white piped fencing running through pristine pastures & shaded woodlands. The stunning 4,500 sq. ft. (3,200 sq. ft interior) Florida-style, 3 bedrooms, 3.5 bath home offers sleek leather furnishings from the living room to the teak bedroom sets. An expansive wrap-around solar screened veranda provides the panoramic views of the surrounding countryside. The unique architecture, oriented 60 degrees off North in homage to Frank Lloyd Wright, is meticulously designed. Crafted with maintenance free Butler Stone, solid steel construction, steel studs, wall insulation, & double foam insulation at roof and ceiling. The residence exudes quality and durability. Offering luxurious amenities, including top-of-the-line appliances such as Miele, Viking, & Gaggenau and a Sub-Zero built-in refrigerator. Two fully furnished offices with fiber-optic Internet are perfect for working remotely. Geothermal heating and cooling, with energy-efficient features throughout. The 32,000 gal. seashell shaped pool complete with beach entry, waterfall, European-style tarps, outdoor kitchenette, and luxury outdoor furniture. A 7,000 sq. ft. shop (4,000 sq. ft. under roof) with John Deere equipment, ranch machines, shop equipment, & a plethora of asstd. tools. A fully furnished apartment inside of the shop & a rustic 2-bedroom cabin provides for guests or rental. An enclosed barn and 3 open air stalls with 3 livestock ponds gives space for livestock. Little Caney Creek Ranch is more than just property; it is a lifestyle defined by luxury, leisure, and natural beauty. Discover the epitome of lakefront living in this exclusive retreat nestled in the heart of East Texas. See associate documents for more information.
MlsNumber: --
ListingId: 24007158


Listing Provided By: Staples Sotheby's International Realty, original listing
Phone: (903) 876-1051
Office Phone: (903) 876-1051
Agent Name: Brenda Boyd
Disclaimer: Copyright © 2024 Greater Tyler 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