Title Page Background
DEBUG FN args: Array ( [0] => 2623 [1] => [2] => [3] => agent ) BEFORE: Site: 2623 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2623 Igate: njhud LocID: 2623 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2623 AND i.igate IN ('txhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2623 [1] => [2] => [3] => lender ) BEFORE: Site: 2623 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2623 Igate: njhud LocID: 2623 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2623 AND i.igate IN ('txhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2623 [1] => [2] => [3] => other ) BEFORE: Site: 2623 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2623 Igate: njhud LocID: 2623 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2623 AND i.igate IN ('txhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

1390 Webb Rogers Road
Waskom, TX 75692

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $695,000
Beds: 4
Baths: Full: 2
Status: Active
SqFt: 3275 Square Feet
Agency: Keller Williams Realty-Tyler

Map Details Show Map | Show StreetView




House Features

Appliances: Dishwasher, Washer, Microwave, Range, Garbage Disposer, Oven - Gas, Range - Gas
Architectural Style: Other
Interior Features: Ceiling Fan, Carpeting, Smoke Detectors, Vinyl Flooring, Other Floors
Rooms: Bathroom 1, Bathroom 2, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Dining Room, Utility Room

Window Features

Exterior Features: Fence, Pool, Barn, Patio Covered, Barn/Stable
Fencing: Fenced
Parking Features: Driveway
Other Features: Barn(s), Stable(s)
Patio and Porch Features: Patio

Neighborhood/Schools

Elementary School/District: Canyon
Middle/Junior High School/District: Canyon
High School/District: Canyon
Subvidision Name:

Description/Comments


Lot Size: 39 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2020
Notes: Discover your dream property in Waskom, Texas! This stunning Bardominium, boasting 4 beds and 2 baths, sits on 39.63 acres with I-20 frontage, offering both convenience and a serene escape. An automatic security gate ensures privacy and security at the entrance, while the fenced backyard creates a safe haven for your family. For animal lovers, a 5-stall barn awaits, catering to equestrian pursuits or other livestock interests. The circle drive adds an elegant touch to the entrance, making arrivals and departures effortless. Step inside to be greeted by 14ft high ceilings, creating a sense of grandeur and spaciousness. The home is thoughtfully designed, with a large laundry room featuring cabinets for added convenience. The open kitchen is a culinary haven, boasting a gourmet La Cornue Stove that elevates your cooking experience. Entertain guests with ease while preparing delicious meals. Retreat to the master suite, a spacious sanctuary with a well-appointed master bath, complete with a walk-in shower and storage-filled walk-in closet. Three additional bedrooms provide ample space for family members or guests, and the second bathroom ensures everyone's comfort. Sustainability is embraced with well water on the property, complemented by a reliable filtration system, ensuring pure, clean water. Live the Texas dream with this Bardominium on 39.63 acres, offering luxury, comfort, and the serenity of country living. Come experience this unique opportunity today! *Can be combined with 2 additional listings: 10 Acres with Shop - MLS#20234240 / 10 Acres with1200sf Unfinished Barndo - MLS#20234240
MlsNumber: --


Listing Provided By: Keller Williams Realty-Tyler, original listing
Phone: (318) 210-6939
Office Phone: (903) 534-6600
Agent Name: Hayli Cagle
Disclaimer: Copyright © 2024 Longview Area 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