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

218 West Avenue
Long Beach, MS 39560

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,125,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 2633 Square Feet
Agency: Coldwell Banker Alfonso Realty-Lorraine Rd
Agency Phone: (228) 287-1000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2023
Notes: ENJOY PICTURESQUE VIEWS OF THE BEACH FOR MILES!! Brand new construction just a block from the beach and you will absolutely love it!! Need to see this home inside-it is BEAUTIFUL! Such an open layout with light shinning in from all directions-very light and bright! Sit outside on the oversized deck and just enjoy the breeze and views of the Gulf of Mexico. SO MANY EXTRAS WENT INTO BUILDING THIS HOME! Elevated 4 ft above FEMA requirements for reduced insurance and less risk for flooding *Structural Floor & Roof Trusses-large beams for greater support *Upgraded .60 mil Commercial grade TPO roofing for max water protection under roof top deck areas *Short walls & water ports tied into TPO Roofing assembly for better drainage on roof top decks *All Exterior Walls upgraded to 6'' walls for greater strength & higher R rating *Upgraded deck and porch boards from 1'' to 1.5'' treated deck boards for greater rigidity & longevity * Hardie Siding with Board & Batten *Upgraded exterior door package *Custom railing around rooftop deck w/treated lumber & 14-gauge black powder coated wire for greater views *Enclosed outside AC units with complete Hardie cement siding *Added wiring for a back-up generator *Added circuit and disconnects for future hot tub and for future elevator on rear of home *Upgrade insulation package to high-efficiency foam and batt *Added extra HVAC split system to serve 2nd floor *Added conditioned mechanical closet upstairs with access from exterior and from large walk in closet in upstairs bedroom *Added hot and cold water access & exterior shower under home *Plumbing faucets are upgraded with premium finishes *Pedestal sink in powder room *Most windows have 2'' installed blinds *Master shower with dual shower heads and bench *Upgraded tile in showers, tile surround to ceiling in main level bath & upgraded deep tub *Mohawk Revwood flooring though out home *Custom lighting through out *Custom vanities in all baths *Premium Cafe Appliance package *Full size pantry *White Quartz Countertops *Deep copper sink in kitchen *Large Island in Kitchen *Interior 8' Doors *Upgraded Hardware through out *High efficiency windows, impact glass for wind zone-many tempered *Bullnosed corners on drywall at corners and window returns You will absolutely love what you find when you walk in this home! And you will enjoy living just off the Beach and be able to enjoy what living on the Coast is all about!
MlsNumber: --
ListingId: 4106459


Listing Provided By: Coldwell Banker Alfonso Realty-Lorraine Rd, original listing
Phone: (228) 861-1409
Office Phone: (228) 287-1000
Agent Name: Sandy B Webb
Disclaimer: Copyright © 2025 MLS United. 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 = 1428 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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;
Real Estate Expert Photo for Rachel Allen
Rachel Allen
ASCIICoastal Realty Group
Call Today!: (228) 265-3886

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App