| Query Template: /themes/irishoward/modules/myrtle-beach-mls/realcfc/mlsnew.cfc:183 Execution Time: 0.164 ms Record Count: 21 Cached: Yes Cache Type: timespan 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_value | display | url | areas | ||
| 1 | 54A Andrews Are--includes city o | Andrews | andrews | 54A | |
| 2 | 17A Aynor Area--central includes | Aynor | aynor | 17A,12A,13A | |
| 3 | 25B Conway Area--between Wacc. R | Conway | conway | 25B,21A,21B,21D,21C,21E,14A,15A,23A,20A,18A,22A,15B,23B | |
| 4 | 09A Conway to Longs Area--Betwee | Conway to Longs | conway-to-longs | 09A,09B | |
| 5 | 10A Conway to Myrtle Beach Area- | Conway to Myrtle Beach | conway-to-myrtle-beach | 10A | |
| 6 | 27A Garden City Mainland & Penni | Garden City | garden-city | 27A,28C | |
| 7 | 48A Georgetown Area--Belle Isle | Georgetown | georgetown | 48A,52A,53A,46A,50A,47A,49A,51A | |
| 8 | 41A Pawleys Island Area-Litchfie | Litchfield Beach | litchfield-beach | 41A,42A | |
| 9 | 04B Little River Area--North of | Little River | little-river | 04B,04A | |
| 10 | 03A Longs to Little River Area-- | Longs to Little River | longs-to-little-river | 03A | |
| 11 | 02A Loris Area--central includes | Loris | loris | 02A,05A,01A | |
| 12 | 06A Loris to Conway Area--South | Loris to Conway | loris-to-conway | 06A,08A | |
| 13 | 07A Loris to Longs Area--South o | Loris to Longs | loris-to-longs | 07A,03B | |
| 14 | 27B Murrells Inlet - Horry Count | Murrells Inlet | murrells-inlet | 27B,40A | |
| 15 | 25A Myrtle Beach Area--west of S | Myrtle Beach | myrtle-beach | 25A,10B,24A,26A,16F,16E,16D,16C,16B,16A,16G,26B,16J,19A,24B | |
| 16 | 31B North Carolina | North Carolina | north-carolina | 31B | |
| 17 | 11D North Myrtle Beach Area--Atl | North Myrtle Beach | north-myrtle-beach | 11D,10C,11A,11C,11B,11F,11E | |
| 18 | 31A Other counties in South Caro | Other Counties | other-counties | 31A | |
| 19 | 31C Not in South Carolina or Nor | Other States | other-states | 31C | |
| 20 | 45A Pawleys Island Area | Pawleys Island | pawleys-island | 45A,43A,44A,45B | |
| 21 | 28B Surfside Area-Glensbay to GC | Surfside | surfside | 28B,29A,29B,28A | |
| Query Template: /themes/irishoward/page_templates/mls.cfm:75 Execution Time: 0.364 ms Record Count: 21 Cached: No 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_value | display | url | areas | ||
| 1 | 54A Andrews Are--includes city o | Andrews | andrews | 54A | |
| 2 | 17A Aynor Area--central includes | Aynor | aynor | 17A,12A,13A | |
| 3 | 25B Conway Area--between Wacc. R | Conway | conway | 25B,21A,21B,21D,21C,21E,14A,15A,23A,20A,18A,22A,15B,23B | |
| 4 | 09A Conway to Longs Area--Betwee | Conway to Longs | conway-to-longs | 09A,09B | |
| 5 | 10A Conway to Myrtle Beach Area- | Conway to Myrtle Beach | conway-to-myrtle-beach | 10A | |
| 6 | 27A Garden City Mainland & Penni | Garden City | garden-city | 27A,28C | |
| 7 | 48A Georgetown Area--Belle Isle | Georgetown | georgetown | 48A,52A,53A,46A,50A,47A,49A,51A | |
| 8 | 41A Pawleys Island Area-Litchfie | Litchfield Beach | litchfield-beach | 41A,42A | |
| 9 | 04B Little River Area--North of | Little River | little-river | 04B,04A | |
| 10 | 03A Longs to Little River Area-- | Longs to Little River | longs-to-little-river | 03A | |
| 11 | 02A Loris Area--central includes | Loris | loris | 02A,05A,01A | |
| 12 | 06A Loris to Conway Area--South | Loris to Conway | loris-to-conway | 06A,08A | |
| 13 | 07A Loris to Longs Area--South o | Loris to Longs | loris-to-longs | 07A,03B | |
| 14 | 27B Murrells Inlet - Horry Count | Murrells Inlet | murrells-inlet | 27B,40A | |
| 15 | 25A Myrtle Beach Area--west of S | Myrtle Beach | myrtle-beach | 25A,10B,24A,26A,16F,16E,16D,16C,16B,16A,16G,26B,16J,19A,24B | |
| 16 | 31B North Carolina | North Carolina | north-carolina | 31B | |
| 17 | 11D North Myrtle Beach Area--Atl | North Myrtle Beach | north-myrtle-beach | 11D,10C,11A,11C,11B,11F,11E | |
| 18 | 31A Other counties in South Caro | Other Counties | other-counties | 31A | |
| 19 | 31C Not in South Carolina or Nor | Other States | other-states | 31C | |
| 20 | 45A Pawleys Island Area | Pawleys Island | pawleys-island | 45A,43A,44A,45B | |
| 21 | 28B Surfside Area-Glensbay to GC | Surfside | surfside | 28B,29A,29B,28A | |
Welcome to Allston Park in Calabash, NC. Calling all golf lovers! Allston Park is located behind Meadowlands Golf Resort! Allston Park boasts large lots, many floorplans to fit your needs and an amenity center sure to please! Centrally located to entertainment, shopping, famous Calabash restaurants and gorgeous Carolina beaches, this is sure to be your next home sweet home. The planned amenity area will feature a pool, restrooms, mail kiosk and parking. This home is under construction - Gwinnett with second floor guest bedroom - two story home with 3 car garage featuring 4 bedrooms, 3 full baths-with primary suite on the first floor, large rear covered porch! EZ entertaining and split bedroom plan. The primary suite offers a walk in closet, double sinks, shower stall & an attached office/snore room/workout area right off the bedroom suite! The open living space is versatile for everyone to enjoy and kitchen comes complete with an island and a pet pad! PHOTOS FOR ILLUSTRATION ONLY - COLORS/OPTIONS/FEATURES/DESIGN VARY!
CPG Inc. dba Mungo Homes
$395,900
2025
Detached
2917
2595
Traditional
4
3
0
No
Attached 2-Car
4
0.34
8-2-2025
Allston Park - NC
31B North Carolina
Brunswick
102614448569
$46
Jesse Mae Monroe Elementary Scho
Shallotte Middle School
West Brunswick High School
Copyright 2025 Coastal Carolinas Association of REALTORS®, Inc.
Information Deemed Reliable, but Not Guaranteed.
