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

802 W Washington Avenue
Seadrift, TX 77983
Kathleen Lambright with Pooley Land & Realty Company, original listing - (361) 935-0977

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $265,000
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 1424 Square Feet
Agency: Pooley Land & Realty Company
Agency Phone: (361) 935-0977

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1957
Notes: Corner (75'x142') lot w/limited bay views down unimproved 8th St. Paved access on both 8th St. & Washington Ave. Recent upgrades include: New CHA system, new water-heater, new bath fixtures, and new gas lines from alley to house, new electrical upgrades to 200amp breakers, "French drain" around exterior, new gutters, and recent foundation repairs. Unit is two bedroom (master is in southeast front corner; guest is rear northeast corner with both having access to hall bathroom. Open living room, which accommodates large sectional unit, is open into formal dining room with built in cabinetry. Kitchen has gas appliances, plenty of storage and prep space. Rear of unit has 2nd large bathroom & "mud" room access to rear yard (fully fenced!). Step-down off kitchen has laundry & storage area. Exterior has tool/mower storage attached to west side. And plenty of shade to the front yard with mature trees...driveway has room for 5th-wheel storage and car/truck storage. Walking distance (300' approx.) to Bayfront Park, lighted public fishing pier, pavilion, and walking trail. Minutes to City Harbor & boat ramp access...area is well know for it's sports fishing, duck hunting & birding opportunities. A working City Harbor with active shrimping, crabbing and oystering services. Community is "golf cart" friendly, public library, limited retail, but plenty of eatery's! SHOWN BY APPOINTMENT ONLY! Owner occupied.
MlsNumber: --
ListingId: 556383


Listing Provided By: Pooley Land & Realty Company, original listing
Phone: (361) 648-6781
Office Phone: (361) 935-0977
Agent Name: Kathleen Lambright
Disclaimer: Copyright © 2024 Central Texas Multiple Listing Service. 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