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

21 Pr 52365
Pittsburg, TX 75686

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,185,500
Beds: 4
Baths: 3
Status: Active
SqFt: 3248
Agency: COLDWELL BANKER LAKEHAVEN,REALTORS

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 2000
Notes: Welcome to a beautiful waterfront sanctuary nestled in the exclusive gated community of Cherokee Point on the shores of Bob Sandlin Lake. This exceptional property, spanning 1.36 acres, is a testament to the harmonious blend of natural beauty and refined living. As you approach, you'll be greeted by the shade of mature trees and meticulously landscaped grounds, setting the stage for this lakeside retreat. The property features a one-stall boathouse with a sun deck, offering direct access to the lake, and a perfect place to soak up the sun or enjoy starry nights by the water. Inside, the family room provides a captivating view of the lake, creating a serene backdrop for everyday living. A cozy sitting area with a wood-burning fireplace insert adds warmth and ambiance, making it an ideal spot to relax and unwind. The kitchen boasts granite counters, combining style and functionality. It's complemented by a utility room, offering convenience in your daily routine. A full bath with access to the lake ensures that water activities are a breeze, with no need to track through the home. A formal dining room provides an elegant setting for special occasions, and the primary suite offers a spa-like escape with luxurious amenities. A spiral staircase leads to the upper level, where two bedrooms, a bunk room or game room, and another full bath await. The combination of tile, carpet, and hand-scraped floors adds a touch of sophistication and comfort throughout. This waterfront gem is not just a home; it's a lifestyle. With its blend of indoor and outdoor charm, this property invites you to enjoy the tranquility of lakeside living. It's a place where you can create cherished memories and bask in the beauty of nature while enjoying the comforts of a well-appointed home.
MlsNumber: 23014063


Listing Provided By: COLDWELL BANKER LAKEHAVEN,REALTORS, original listing
Name: COLDWELL BANKER LAKEHAVEN,REALTORS
Phone: (903) 588-2658
Office Name: Coldwell Banker Lakehaven, REALTORS®
Office Phone: (903) 588-2658
Agent Name: Pam Swanner
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