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;

8 Las Brisas Place
Port Lavaca, TX 77979
Rachel Parsons with Keller Williams Realty, original listing - (512) 448-4111

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $750,000
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 3632 Square Feet
Agency: Keller Williams Realty
Agency Phone: (512) 448-4111

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1980
Notes: Nestled within the serene surroundings of Port Lavaca in a cul de sac, this exquisite property boasts a two-story architectural marvel. With four spacious bedrooms and 2.5 baths, this home is designed to accommodate modern living with elegance and comfort. The two-car garage offers convenience while the waterfront location, featuring a 135 ft bulkhead, provides picturesque views and a tranquil ambiance. <br /> Step inside to discover a blend of sophistication and functionality. Custom cabinets and vanities adorn the interiors, complemented by high-end granite countertops and new stainless steel kitchen appliances. Double-paned windows flood the space with natural light, enhancing the ambiance. Custom tile and luxury vinyl flooring add a touch of opulence to each room, while an oversized garage door adds practicality.<br /> <br /> The indulgence continues in the bathrooms, where custom tile in showers exudes refinement. Two-inch blinds offer both privacy and style. Outside, a private pool and gazebo provide the perfect setting for relaxation, with sweeping views of the Lavaca Bay. Additionally, the property is conveniently located just one mile from Lighthouse Beach, offering endless opportunities for leisure and recreation. Whether seeking a serene retreat or an entertainer's dream, this property epitomizes coastal luxury living at its finest.
MlsNumber: --
ListingId: 539987


Listing Provided By: Keller Williams Realty, original listing
Phone: (361) 772-5548
Office Phone: (512) 448-4111
Agent Name: Rachel Parsons
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