Iris & Howard Real Estate
Query
Template: /themes/irishoward/modules/myrtle-beach-mls/realcfc/mlsnew.cfc:183
Execution Time: 0.181 ms
Record Count: 21
Cached: Yes
Cache Type: timespan
Datasource: newccar
Lazy: No
SQL:
SELECT long_value, display, url, GROUP_CONCAT(short_value SEPARATOR ',') AS areas FROM L_Area_Lookup GROUP BY display ORDER BY display ASC
long_valuedisplayurlareas
154A Andrews Are--includes city oAndrewsandrews54A
217A Aynor Area--central includesAynoraynor17A,12A,13A
325B Conway Area--between Wacc. RConwayconway25B,21A,21B,21D,21C,21E,14A,15A,23A,20A,18A,22A,15B,23B
409A Conway to Longs Area--BetweeConway to Longsconway-to-longs09A,09B
510A Conway to Myrtle Beach Area-Conway to Myrtle Beachconway-to-myrtle-beach10A
627A Garden City Mainland & PenniGarden Citygarden-city27A,28C
748A Georgetown Area--Belle IsleGeorgetowngeorgetown48A,52A,53A,46A,50A,47A,49A,51A
841A Pawleys Island Area-LitchfieLitchfield Beachlitchfield-beach41A,42A
904B Little River Area--North ofLittle Riverlittle-river04B,04A
1003A Longs to Little River Area--Longs to Little Riverlongs-to-little-river03A
1102A Loris Area--central includesLorisloris02A,05A,01A
1206A Loris to Conway Area--SouthLoris to Conwayloris-to-conway06A,08A
1307A Loris to Longs Area--South oLoris to Longsloris-to-longs07A,03B
1427B Murrells Inlet - Horry CountMurrells Inletmurrells-inlet27B,40A
1525A Myrtle Beach Area--west of SMyrtle Beachmyrtle-beach25A,10B,24A,26A,16F,16E,16D,16C,16B,16A,16G,26B,16J,19A,24B
1631B North CarolinaNorth Carolinanorth-carolina31B
1711D North Myrtle Beach Area--AtlNorth Myrtle Beachnorth-myrtle-beach11D,10C,11A,11C,11B,11F,11E
1831A Other counties in South CaroOther Countiesother-counties31A
1931C Not in South Carolina or NorOther Statesother-states31C
2045A Pawleys Island AreaPawleys Islandpawleys-island45A,43A,44A,45B
2128B Surfside Area-Glensbay to GCSurfsidesurfside28B,29A,29B,28A
Query
Template: /themes/irishoward/page_templates/mls.cfm:75
Execution Time: 0.231 ms
Record Count: 21
Cached: No
Datasource: newccar
Lazy: No
SQL:
SELECT long_value, display, url, GROUP_CONCAT(short_value SEPARATOR ',') AS areas FROM L_Area_Lookup GROUP BY display ORDER BY display ASC
long_valuedisplayurlareas
154A Andrews Are--includes city oAndrewsandrews54A
217A Aynor Area--central includesAynoraynor17A,12A,13A
325B Conway Area--between Wacc. RConwayconway25B,21A,21B,21D,21C,21E,14A,15A,23A,20A,18A,22A,15B,23B
409A Conway to Longs Area--BetweeConway to Longsconway-to-longs09A,09B
510A Conway to Myrtle Beach Area-Conway to Myrtle Beachconway-to-myrtle-beach10A
627A Garden City Mainland & PenniGarden Citygarden-city27A,28C
748A Georgetown Area--Belle IsleGeorgetowngeorgetown48A,52A,53A,46A,50A,47A,49A,51A
841A Pawleys Island Area-LitchfieLitchfield Beachlitchfield-beach41A,42A
904B Little River Area--North ofLittle Riverlittle-river04B,04A
1003A Longs to Little River Area--Longs to Little Riverlongs-to-little-river03A
1102A Loris Area--central includesLorisloris02A,05A,01A
1206A Loris to Conway Area--SouthLoris to Conwayloris-to-conway06A,08A
1307A Loris to Longs Area--South oLoris to Longsloris-to-longs07A,03B
1427B Murrells Inlet - Horry CountMurrells Inletmurrells-inlet27B,40A
1525A Myrtle Beach Area--west of SMyrtle Beachmyrtle-beach25A,10B,24A,26A,16F,16E,16D,16C,16B,16A,16G,26B,16J,19A,24B
1631B North CarolinaNorth Carolinanorth-carolina31B
1711D North Myrtle Beach Area--AtlNorth Myrtle Beachnorth-myrtle-beach11D,10C,11A,11C,11B,11F,11E
1831A Other counties in South CaroOther Countiesother-counties31A
1931C Not in South Carolina or NorOther Statesother-states31C
2045A Pawleys Island AreaPawleys Islandpawleys-island45A,43A,44A,45B
2128B Surfside Area-Glensbay to GCSurfsidesurfside28B,29A,29B,28A

253 NW Mayflower Dr., Calabash, NC 28467

Overview:

Welcome to Allston Park! Our newest community in the Calabash Area! Convenient to roadways, beaches, shopping & dining opportunities galore! We will have a community pool too to make a splash and cool off in the hot summer months! This two-story home comes on over a third of an acre of property with four bedrooms and two-and-one-half bathrooms. An office is located on the first floor. Open kitchen with eat-in area, dining room and great room on the first floor. A primary suite located on the first floor, plus three additional bedroom and a loft can be found on the second level. The primary bath has a garden tub and shower, double sinks and a generous walk-in closet. Upgraded shaker-style white cabinets, tiled backsplash, luxury vinyl plank flooring throughout the living space, and carpet in most bedrooms. Each bedroom upstairs also has a walk-in closet, and they share another full bathroom. In addition, the second floor contains a loft space and a walk-in storage room. Great plan for versatile living. Two car garage, front & rear covered porches as well can be found outside to make this style home a great entertaining space inside & out! The planned amenity area will feature a pool, restrooms, mail kiosk and parking -THIS HOME IS UNDER CONSTRUCTION!! PHOTOS FOR ILLUSTRATION ONLY - COLORS/OPTIONS/FEATURES/DESIGN VARY

Listing Courtesy Of:

CPG Inc. dba Mungo Homes

Original Price:

$362,900

Year Built:

2025

Date Input:
9-3-2025
Listing Date:
9-3-2025
Type:

Detached

Total Square Feet:

2511

Total Heated Sq. Ft.:

2152

Interior Features

Style:

Traditional

Interior Features:

Garage Door Opener, Wshr/Dryer Connection

Bedrooms:

4

Full Baths:

2

Half Baths:

1

Formal Dining Room:

No

Floor Cover:

Luxury Vinyl Plank/Tile

Dining Room:

Fam/DR Combo

Kitchen:

Range, Dishwasher, Microwave, Pantry, Solid Surface Countertops

Other Rooms:

Den/Study/Library

Utilities Available:

Electricity, Water Public, Sewer, Underground Utilities

Exterior

Exterior Features:

Front Porch, Rear Porch

Exterior Finish:

Vinyl Siding

Foundation:

Slab

Heating and Cooling:

Electric

Levels:

Two-Story

Type of Parking:

Attached 2-Car

Parking Capacity:

4

Water Heater:

Electric

Lot Details

Acres:

0.22

Lot Description:

Rectangular

Estimated Lot Size (in feet):

75x125 ft

Utilities Available:

Electricity, Water Public, Sewer, Underground Utilities

Listing Date:

9-3-2025

Community Infomation

Amenities:

Pool - Outdoor Community

Area Information

Section/Subdivision:

Allston Park - NC

Area:

31B North Carolina

County:

Brunswick

Tax Map Number:

102615516826

Association Information

Estimated Monthly POA Amount:

$46

Association Fee Includes:

Pool Service, Common Maint/Repair

Schools

Elementary School:

Jesse Mae Monroe Elementary Scho

Middle School:

Shallotte Middle School

High School:

West Brunswick High School

MLS Number:

2521480

Call Us:

843.212.6852

Would you like to see this property?

Copyright 2025 Coastal Carolinas Association of REALTORS®, Inc.
Information Deemed Reliable, but Not Guaranteed.