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

2288 County Road 3542
Sulphur Bluff, TX 75481
Janet Martin with Janet Martin Realty, original listing - (903) 885-1234

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $699,900
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 3000 Square Feet
Agency: Janet Martin Realty
Agency Phone: (903) 885-1234

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 6 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1987
Notes: Don't miss this stunning, remodeled home that provides an elegant inside with views of a private lake and wooded 6-acre setting on the outside. Drive past a nice security-gated entrance along a meandering driveway as the stress melts away! Recent updates create a striking first impression, including all new flooring, fresh paint in neutral colors, recessed lights that brighten all the living areas, stylish light fixtures, new quartz countertops, and a delightfully updated kitchen with custom-painted, oversized island, etc. Inside the home, you'll find ornate custom molding & trim in the living room with a granite, wood-burning fireplace, and surround sound media. A large kitchen includes lots of storage and cabinets, built-in china cabinet, seating around the island, double oven, and electric cooktop. Downstairs, in a split layout, are 2 bedrooms with their own full bathroom. In the spacious primary ensuite downstairs, you'll find trey ceilings, beams, freshly painted walls, room for a sitting area, and lots of windows with scenic views. Also on the 1st floor is an oversized laundry room with wall-to-wall cabinets and a built-in desk area, providing office space & extra storage. Upstairs is a large bedroom with a separate sitting room, coffee nook, and full bathroom (which can be used as a huge, 2nd primary ensuite). Or close off the sitting room upstairs and create a 4th bedroom. Imagine watching a sunset while sitting on your private lake's floating dock & pier walkway. From the middle of the lake, a lighted fountain brightens up the night & adds beauty to this secluded getaway. Relax under the pergola or soak in the hot tub on the back patio. Feel safe with the monitored security alarm system. With RV parking space & circle driveway, share this delightful sanctuary with family & friends. Keep it as a private retreat all to yourself or VRBO for extra income!
MlsNumber: --
ListingId: 20833734


Listing Provided By: Janet Martin Realty, original listing
Phone: (903) 243-0184
Office Phone: (903) 885-1234
Agent Name: Janet Martin
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