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

6045 Vz County Road 1110
Grand Saline, TX 75140
Charlotte Williams with Keller Williams Realty-Tyler, original listing - (903) 534-6600

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $800,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2118 Square Feet
Agency: Keller Williams Realty-Tyler
Agency Phone: (903) 534-6600

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 13 acre(s)
Property Type: Farm-Single Family Residence
Year Built: 2022
Notes: This custom built 3 bedroom 2.5 bath home on over 13 acres boasts luxurious features and beautiful finishes throughout! Ceramic tile throughout the home, crown molding, oiled bronze finishes, custom cabinetry, and granite countertops along with a state-of-the-art filtration system and hot water heaters that can be controlled by a smart phone make living here easy! The open floor plan with rock, brick, and wood accents is exquisitely enhanced by large windows, abundant natural light, and incredible countryside views. Find peace and calm in the master bath with an oversized jacuzzi tub and walk-in shower, while laundry will be pleasant in the large laundry room with separate sink. A screened-in porch, paved driveway, front porch, back patio, and surveillance cameras make living indoors and out effortless. A fully insulated shop with an equipment barn has incredible storage space, and you'll love to spend your evenings down at the stocked pond with aerating fountains and fishing pier. The 3-car garage has a 14ft ceiling on one side to house an RV, and a storm cellar under the garage floor will give you peace-of-mind. The land is fenced and cross-fenced with gorgeous level pastureland! Located just a little over an hour east of Dallas or 45 minutes west of Tyler, you’ll have easy access to Canton, Tyler, and Terrell. Enjoy big Texas skies, sunrises, and sunsets from this slice of heaven! Call today!
MlsNumber: --
ListingId: 24015218


Listing Provided By: Keller Williams Realty-Tyler, original listing
Phone: (903) 520-2985
Office Phone: (903) 534-6600
Agent Name: Charlotte Williams
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