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 = 1129 AND i.igate IN ('usahud','lahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'lahud', 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 = 1129 AND i.igate IN ('usahud','lahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'lahud', 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 = 1129 AND i.igate IN ('usahud','lahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'lahud', 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;

2314 Teal Street
Cameron, LA 70631

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $650,000
Beds: 4
Baths: 4
Status: Active
SqFt: 2267
Agency: Coldwell Banker Ingle Safari Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2007
Notes: Coastal Gem on Holly Beach! <br /> Nestled on the serene gulf coast of Southwest Louisiana this home includes all furnishings and equipment, just bring your bags and enjoy beach life! Great Opportunity for Fishing and/or Hunting Charter Service with beach access for family members staying behind. Wedding Venue and Premier Bird Watching Opportunities, Endless Possibilities for this Beautiful Beach Home! The 2007-built residence spans 2,267 sq. ft., offering 4 bedrooms, 3.5 bathrooms. This beach home is meticulous! The views are amazing from both the house and the many outdoor entertaing spaces on the expansive deck! This home is breathtaking!<br /> <br /> Main Features:<br /> Home Configuration: Dual HVAC and HWH systems for separate top floor operations, ensuring energy efficiency.<br /> Location: Prime position on 10 lots, stretching from Teal Street to Heron Street.<br /> Exteriors: New roof (2020) with 130 mph wind rating, vinyl siding (120 mph wind-rated), and 2020 Genstone on façade and chimney.<br /> Interiors: Luxurious touches including a Lennox fireplace, Viking kitchen appliances, Maytag washer-dryer, master bedroom jacuzzi with aromatherapy, and granite countertops throughout.<br /> Flooring: Carlisle hardwood and porcelain tile downstairs; durable vinyl rigid-core upstairs.<br /> Entertainment: 6 TVs, Sonos surround sound, DirecTV, and Fastwyre internet connection.<br /> Safety Features: Lightning protection, security alarms, motion detectors, smoke and carbon monoxide detection.<br /> <br /> Additional Highlights:<br /> Sunroom with bar amenities and wrap-around deck.<br /> Ample storage room upstairs off of the large deck area with added Tiki Bar area, custom freight elevator, and generators.<br /> Boat shed: A spacious 40x50 metal Storage/Boat Shed with RV hook-up, commercial ice maker, and a specially designed fish-cleaning area.<br /> <br /> Considering the unique design and the plethora of features this home offers, it’s truly a coastal treasure awaiting its next privileged owner.<br /> $650,000 includes home, storage/carport and boat shed located on 10 lots.<br /> $725,000 total for all, including 4 additional improved RV lots.
MlsNumber: SWL23006794


Listing Provided By: Coldwell Banker Ingle Safari Realty, original listing
Name: Coldwell Banker Ingle Safari Realty
Phone: (337) 274-5684
Office Name: Coldwell Banker Ingle Safari R
Office Phone: (337) 478-1601
Agent Name: Amy Britt
Disclaimer: Copyright © 2024 Greater Southern MLS. 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