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;

305 W Denver Avenue
Seadrift, TX 77983
Gary Holub with Holub Real Estate, LLC, original listing - (830) 221-5550

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $398,500
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 1500 Square Feet
Agency: Holub Real Estate, LLC
Agency Phone: (830) 221-5550

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Other
Year Built: 2021
Notes: LARGE LOT 75 x 142 WITH 1,200 SF ( 30 X 40)  BOAT BARN, 3 ROLL UP DOORS AND 1,500 SF OF COASTAL PALETTE LIVING SPACE.  Property is in like new condition and has been meticulously kept. There are 2 oversized BRs ( approx 17'8" X 11) each have their own beautiful baths, the family living area is approx. 17'6" X 16 ' 6" and a breakfast bar divides a large sure to please kitchen area  with lots of counter space and a pantry. The countertops are granite and the home has easy clean stained concrete floors, and pull out windows, the boat barn is insulated, has plenty of plugs and lighting and even a set in drain. The living area is double insulated with a 2.5 ton HVAC unit. The utility rm is located in the boat barn and has storage cabinets.  Above the living space is a huge storage area,  In this area there is an approx. 17'8" X 18' area built with 2 X 12s which could be used to create more closed in space. Two large covered porch areas provide you with shade to enjoy the breezy outdoors. All appliances to convey with accepted offer. All Electric, WPI certificate of Compliance, Storm windows & doors. <br /> <br /> Seadrift has a public lighted fishing pier, boat harbor and you can Register your ATV and ride the Bayfront!   Seadrift is known for its amazing sunsets and great fishing and duck hunting and the waterfront along Bay Avenue is currently under wonderful improvements: new seawall, boat slips and more.   Whether you’re looking for a permanent home or weekend getaway you will love Seadrift. Conveniently located to Port O Connor, Rockport, Port Comfort and Victoria. Sq ft per seller. Lot sizes per Calhoun CAD. Due to the lot size the East & West Boundaries are 7.5 ' instead of the usual 5 ' set back.
MlsNumber: --
ListingId: 545291


Listing Provided By: Holub Real Estate, LLC, original listing
Phone: (830) 221-5550
Office Phone: (830) 221-5550
Agent Name: Gary Holub
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