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

1646 Fm-906 W
Powderly, TX 75473
Karen Marsh with Glass Land and Home LLC, original listing - (903) 785-8457

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $790,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3204 Square Feet
Agency: Glass Land and Home LLC
Agency Phone: (903) 785-8457

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 26 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2009
Notes: Just in time for the holidays! Stunning home on 26.47 acres in NE Lamar County just waiting for you! Enter through the pipe fenced gated entrance and drive up to the home. Open the door and be amazed at the amount of space this 4 bedroom, 3.5 bath home has to offer. Living-dining-kitchen combination with raised ceilings, concrete stained flooring with plenty of room for furnishings. Kitchen is well equipped with stainless appliance's, gas cooktop, double oven, granite countertops and beautiful cabinetry. Spacious primary bedroom with full bath featuring NEW tiled shower, tub surround, ample counter space and walk-in closet. Downstairs is an additional bedroom just a few steps for a full bath. For the ultimate entertainment opportunity is the large game room, sized perfectly for a pool table with room to spare. Large laundry room with exterior access easily accommodate extra freezer. Take a walk up the stairs to 2 additional bedrooms, bath and bonus room for crafts or just hanging out. Out the back French doors to the inground pool and enjoy swimming and playing. Need a shop? This property has it you covered. 40x60 insulated-cooled shop providing carport space plus an additional 30x40 shop building for storing equipment or family toys. Covered concrete pad and an RV hook-up pad with electric, water and sewer complete the outdoor features. Front and back porches extend end to end of the house for maximum enjoyment. Property also has an inground storm shelter. Pristine pastureland, partially fenced, with ponds and scattered trees. Country living at its best!
MlsNumber: --
ListingId: 20767445


Listing Provided By: Glass Land and Home LLC, original listing
Phone: (903) 517-9383
Office Phone: (903) 785-8457
Agent Name: Karen Marsh
Disclaimer: Copyright © 2024 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