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

115 Skimmer Lane
Port Sulphur, LA 70083
ELIZABETH STROHMEYER with KELLER WILLIAMS REALTY 504-207-2007, original listing - (504) 207-2007

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $649,000
Beds: 4
Baths: Full: 3, ½: 2
Status: Active
SqFt: 3047 Square Feet
Agency: KELLER WILLIAMS REALTY 504-207-2007
Agency Phone: (504) 207-2007

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: --
Notes: THIS ONE MAKES A SPLASH! POOL HOME WITH VIEWS OF MYRTLE GROVE CANAL.! The impressive entryway is a fitting welcome to this captivating 4-bedroom, 3 full bath, 2 half-bath raised water front home. wide-plank pine hardwoods provide warm flooring throughout, beneath a rare combination of fashionable and natural lighting. In the sun-washed open floor layout, your inner stylist will find the freedom of a blank canvas. Sleek flat ceilings are easy to maintain. Opening seamlessly onto the dining room and living room, the kitchen is large enough to accommodate conversation with visitors during food prep. Exceptional granite countertops are in the classic island configuration, maximizing workspace and flexibility. Food preparation is a pleasure in plentiful natural light. Culinary endeavors are powered by premium appliances by DCS. Including a stainless hood! The ensuite primary bedroom, conveniently located on the main -floor, is a roomy recharging station for the day. In addition to the convenience of private b<br /> <br /> athroom( separate tub), you will find plenty of walk-in closet space to let your wardrobe breathe. A sitting area adds yet another functional component. The other 3 bedrooms, unique and with plenty of closet space, are located above the ground floor for enhanced privacy. Whether you are approaching the house or looking out from within, the attractively landscaped yard is a daily pleasure. A driveway with ample accommodation for visiting vehicles leads to an attached two car garage that is available for its original purpose, or you can get creative by treating it as additional flex space. Savor the sunrise from your vantage point on the breezy rear porch. An inviting swimming pool is the social and refreshing centerpiece of the backyard. The property site also includes a outdoor bar. Positioned on a low traffic corner lot, the home is by the fun of Wilkinson Canal. You'll enjoy picturesque Views SCHEDULE A SHOWING TODAY!
MlsNumber: --
ListingId: 2476571


Listing Provided By: KELLER WILLIAMS REALTY 504-207-2007, original listing
Phone: (504) 583-5115
Office Phone: (504) 207-2007
Agent Name: ELIZABETH STROHMEYER
Disclaimer: Copyright © 2024 Gulf South Real Estate Information Network. 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