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

120 Sunfish
Palacios, TX 77465

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $419,900
Beds: 3
Baths: 2
Status: Active
SqFt: 1764
Agency: Russell Cain Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2020
Notes: MUST SEE barndominium on a 17,568 sq ft corner lots in Boca Chica. This well-maintained 1764 sq ft barndominium, with 3 bedrooms, 2 bathrooms and a bonus room, was custom-built in 2021 with Mueller materials and certified to withstand 146 mile an hour wind. All the interior walls are insulated, doors are wheelchair accessible and extra outlets are placed through the house. Neutral color porcelain tile and wall paint throughout the interior, dimmer controlled can lights in kitchen and living room, and the kitchen has special order “Red Fish” tile over the stove, a lot of cabinets and quartz countertops. The Trane heating and cooling unit provides low energy costs and an additional G.E. Zone Line placed in the master bedroom insures a comfortable night’s sleep. The master bedroom has his & her walk-in closets and the master bathroom has a custom-built vanity with double sinks and a walk-in shower. The covered 1617 sq ft patio/breezeway is perfect for entertaining with ample space for an outdoor kitchen, bar, big screen TV, hot tub and more. The 40’x38’ (1520 sq ft) insulated shop, built in 2022, has 2 remote controlled roll-up doors (12’x10’ and 12’x 12’), high bay LED lights and a 200-amp separate service. The shop has enough space for all needs. The 40’x30’ (1200 sq ft) carport fits 4 vehicles and has an LED wall pack on photocell. Boca Chica offers a community pool, lighted fishing pier with restrooms, playground, boat ramp, community center, café, and general store.
MlsNumber: 531087


Listing Provided By: Russell Cain Real Estate, original listing
Name: Russell Cain Real Estate
Phone: (361) 552-6313
Office Name: Russell Cain Real Estate
Office Phone: (361) 552-6313
Agent Name: Russell Cain
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