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

7115 Port Road
Sulphur, LA 70665
ROBBIE INGLE with COLDWELL BANKER INGLE SAFARI, original listing - (337) 478-1601

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $749,900
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 3678 Square Feet
Agency: COLDWELL BANKER INGLE SAFARI
Agency Phone: (337) 478-1601

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 39,204 sqft
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1990
Notes: Discover tranquility and breathtaking views at this stunning 3-bedroom, 2.5-bathroom home located directly on Moss Lake. Surrounded by majestic oak trees and overlooking serene waters, this property offers a perfect blend of nature and luxury. Fully remodeled including a new roof post-hurricanes, the home features a state-of-the-art kitchen with custom cabinets, granite countertops, a functional island set in a bar, and high-end stainless appliances. Enjoy the comfort of multiple living areas and a formal dining room, ideal for hosting gatherings. The spacious living room, complete with a wood-burning fireplace and built-ins, offers panoramic views of the lake, making it a perfect spot for relaxation. The master suite is a retreat in itself, equipped with his and hers walk-in closets, a jetted soaking tub, and a makeup vanity area. There are too many custom upgrades to list in this home. All bedrooms are generously sized and offer ample closet space. Step up to an extraordinary entertainment area upstairs. This 47 x 28 ft party room includes a living area, built-in Murphy bed for guests, a full bar with an ice machine and dishwasher, and comes complete with a pool table that remains with the home. The outdoor kitchen has been enclosed and climate-controlled, creating a delightful sunroom with a built-in grill and appliances. Outside, a huge covered patio area and concrete seawall extend your living space outdoors. The property boasts 113 ft of waterfront on Moss Lake and includes a boathouse with a Lunmar lift. Set on two lots totaling .9 acres, this home provides ample space and privacy. Note, the home only experienced flooding during Hurricane Ike. This home combines modern updates with charming features, making it a perfect oasis on Moss Lake. Schedule your showing today to experience all the incredible features and the peaceful lifestyle this home has to offer!
MlsNumber: --
ListingId: SWL24003319


Listing Provided By: COLDWELL BANKER INGLE SAFARI, original listing
Phone: (337) 304-0481
Office Phone: (337) 478-1601
Agent Name: ROBBIE INGLE
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.


Local Real Estate Expert

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 = 1127 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;
Scott Moffett
ASCIILATTER & BLUM, INC
Call Today!: (337) 540-3498

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App