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

240 El Dorado Cove
Scroggins, TX 75480

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,495,500
Beds: 5
Baths: 5
Status: Active
SqFt: 7000
Agency: Cornerstone Brokerage, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2001
Notes: An Entertainers Dream! This private waterfront Estate located on the South side of Lake Cypress Springs, is just off main lake and combines calm water with highly sought views! On 1 acre in the exclusive gated community of El Dorado Beach, among only 3 other homes. The terraced lot with multiple patios and fire pit, provides ample space for entertaining, relaxing, and taking in those Views! A resort style vanishing edge pool and spa with water features and fire pots, is positioned perfectly to main lake, but tucked away for peace and privacy. 1700 sq. ft. double stall boathouse offers additional covered space to hang with a straight shot to main lake. Remodeling and updates have been done with the utmost attention to detail. An appreciation of original design merged with the new bring a seamless blend of indoor and outdoor luxury living. The layout of this home allows for large crowds and comfortable privacy for guests. 2 en-suites upstairs, primary bedroom on main floor, and downstairs are 2 bedrooms, an office, 2nd full kitchen, oversized game room with bar area, and walk out to the pool. Equipped with Fiber Optic Internet, Control 4 Home Automation System for the music, lighting, alarm, access, pool, and video. The CC Ring Cameras and Mosquito misting system are at house and boathouse. An elevator connects all 3 floors. Spray Foam Insulation, a 500KW generator, 500g Propane Tank, LP Gas Fireplace, 4 car garage, outdoor kitchen, and so much more! Fully furnished with some exclusions. Don’t miss this opportunity to own an iconic lake estate at Lake Cypress Springs, TX!
MlsNumber: 24002521


Listing Provided By: Cornerstone Brokerage, LLC, original listing
Name: Cornerstone Brokerage, LLC
Phone: (903) 581-4141
Office Name: Ebby Halliday, REALTORS® - Tyler
Office Phone: (903) 581-4141
Agent Name: Kareen Linthicum
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