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

17250 Cardinal Ln.
Troup, TX 75789

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,900,000
Beds: 5
Baths: 5
Status: Active
SqFt: 4410
Agency: Coldwell Banker Apex

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 2017
Notes: REDUCED JUST IN TIME FOR SUMMER FUN; YOU'LL FEEL LIKE YOU ARE ON VACATION YEAR-ROUND! A DREAM WATERFRONT RETREAT ON “THE POINT” W/AWESOME VIEWS ACROSS THE LAKE FROM LGE WINDOWS IN LIVING AREAS, KITCHEN & BEDROOMS. ENTERTAIN ON LGE BACK PORCH WITH OUTDOOR LIVING AREA W/STONE WBFP & KITCHEN. CONCRETE WALKWAY LEADS TO BOATHOUSE FEATURING AIR-CONDITIONED LIVING AREA, KITCHEN, DINING & BAR; LARGE DECK IS A GREAT PLACE TO ENTERTAIN OR JUST RELAX & ENJOY THE PEACE & TRANQUILITY OF LAKE LIVING AT IT’S BEST. EXPANSIVE DOCK TO ENJOY AMAZING EVENING SUNSETS & VIEWS FOR YEAR-ROUND ENJOYMENT. INCLUDES BOAT SLIP, JET SKI LIFTS & STORAGE FOR YOUR LAKE TOYS. PREPARE TO BE IMPRESSED FROM MOMENT YOU ENTER & SEE THE PANORAMIC LAKE VIEWS OF THIS 5 BDRM, 4 ½ BATHS, 3-CAR GARAGE, CUSTOM HOME ON ALMOST 2 AC., HIGHLIGHTED BY RICH WOOD & TILE FLOORS, ELABORATE WOODWORK, HIGH CEILINGS & QUALITY THROUGHOUT! LARGE FAMILY ROOM W/MASSIVE BEAMS & STONE FIREPLACE, OPEN TO DINING & KITCHEN AREA MAKES FOR A GREAT FAMILY HOME IN WHICH YOU WILL LOVE TO ENTERTAIN. A CHEF'S KITCHEN THAT WOULD ENTICE ANY COOK W/TOP OF THE LINE SS APPLIANCES, 6-BURNER GAS RANGE, HUGE SIDE BY SIDE REFRIGERATOR, LGE ISLAND W/BREAKFAST BAR, CUSTOM CABINETS, GRANITE, WALK-IN PANTRY & BUTLERS PANTRY W/DRINK REFRIGERATOR & GREAT STORAGE. WAKE UP TO LAKEVIEWS FROM LGE WINDOWS IN OVERSIZED PRIMARY BEDROOM W/LOVELY STONE FIREPLACE & SITTING AREA. 4 BEDROOMS DOWNSTAIRS + UPSTAIRS GAMEROOM/BEDROOM BOASTS 2 BLT-IN TRUNDLE BEDS & FULL BATH. THIS IS A ONE-OF-A-KIND LAKE HOME YOU MUST SEE W/A MILLION DOLLAR LAKEVIEW! SUBDIVISION OFFERS HELI-PADS FOR EMERGENCIES, 2 BOAT RAMPS & PAVILLION FOR HOMEOWNERS USE. LOCATED ON LAKE TYLER EAST, A GREAT FISHING & RECREATIONAL LAKE IN BEAUTIFUL EAST TEXAS! CONVENIENT TO TYLER SHOPPING & WELL-KNOWN MEDICAL FACILITIES.
MlsNumber: 23011167


Listing Provided By: Coldwell Banker Apex, original listing
Name: Coldwell Banker Apex
Phone: (903) 581-2584
Office Name: Coldwell Banker Apex - Tyler
Office Phone: (903) 581-2584
Agent Name: Beth Edwards
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.


Local Real Estate Expert

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 = 2733 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;
Real Estate Expert Photo for Leda Vance
Leda Vance
ASCIIEbby Halliday Realtors
Call Today!: (903) 245-2839

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App