| Query Template: /themes/irishoward/modules/myrtle-beach-mls/realcfc/mlsnew.cfc:183 Execution Time: 0.184 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_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.198 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_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 | |
Charming Coastal Retreat at 187 Alston Road, Pawleys Island, SC 29585 Welcome to your dream home or investment property in the heart of Pawleys Island! This beautiful 3-bedroom, 3.5-bathroom home offers a perfect blend of comfort, charm, and coastal living. Key Features: Spacious Living: 1,931 heated sq. ft. of living space with a total of 4,458 sq. ft., providing ample room for relaxation and entertaining. Prime Location: Situated on a generous 1/2-acre lot east of Hwy 17, this home is just a short walk, bike ride, or golf cart trip to the beach. Picturesque Setting: The property is adorned with majestic, moss-draped live oaks, creating a serene and classic Lowcountry ambiance. Convenience: Close to local restaurants, shopping, and all the amenities Pawleys Island has to offer. Versatile Use: Perfect for short-term or long-term rentals, making it a fantastic investment opportunity or a wonderful place to call home. No HOA: Enjoy the freedom and flexibility of no HOA fees or restrictions. This is your chance to own a slice of coastal paradise in a sought-after location. Whether you're looking for a personal retreat or a lucrative rental property, 187 Alston Road is ready to welcome you home. Schedule your showing today and experience the best of Pawleys Island living!
The Litchfield Company RE
$829,000
1991
Detached
4458
1931
Raised Beach
Wind Treat Convey, Wshr/Dryer Connection, Washer/Dryer, Fireplace
3
3
1
No
Ceiling Fan, Walk-in Closet
Wood, Carpeting
Fam/DR Combo
Vaulted/Cathedral Ceiling, Beam, Ceiling Fan
Range, Dishwasher, Garbage Disposal, Refrigerator, Microwave, Pantry, Double Oven, Range Hood, Stainless Steel Apps., Solid Surface Countertops
Laundry/Utility, Screened Porch
Double Sink, Shower, Vanity
Electricity, Water Public, Sewer, Cable TV
Deck, Balcony, Rear Porch, Outside Storage Attached
Siding
Raised Beach
Central Heat, Central Air, Electric
Split Level
UNDER HOUSE - RAISED BEACH
8
Electric
0.58
Rectangular, Designated Flood Zone
East of Bus 17
Electricity, Water Public, Sewer, Cable TV
12-18-2024
Short Term Rental Allowed, Long Term Rental Allowed, Owner Allowed Golf Cart, Owner Allowed Pet
True Blue
45A Pawleys Island Area
Georgetown
04-0161-046-01-00
$0
Waccamaw Elementary School
Waccamaw Middle School
Waccamaw High School
Copyright 2025 Coastal Carolinas Association of REALTORS®, Inc.
Information Deemed Reliable, but Not Guaranteed.
