Query Template: /themes/irishoward/modules/myrtle-beach-mls/realcfc/mlsnew.cfc:184 Execution Time: 0.205 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.193 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 |
GROUND LEVEL LIVING just STEPS from the BEACH!! Listen....you can often hear the sounds of waves from your porch or take the 3 min stroll (approx. 1000') to the sand!!! HIGH AND DRY LOT NOT IN A FLOOD ZONE!! Very rare this close to the beach!! You get a pretty good view of the ocean from the yard!! No wonder the CRESCENT BEACH AREA is one of the MOST DESIRABLE AREAS IN THE ENTIRE GRAND STRAND!! No HOA, A HUGE CORNER LOT (over 1/4 ACRE!!), and a delightfully QUITE NEIGHBORHOOD make this 3 BEDROOM 3 FULL BATH (2 seperate ensuites!!) home with HUGE OVERSIZED GARAGE, a rare find indeed!!! This CUSTOM BUILT home of high QUALITY CONSTRUCTION checks all the boxes when built and then an EXTENSIVE DETAILED RENOVATION was completed in the last few years making for an UPDATED, MODERN LOOK and FEEL!!! OPEN, AIRY, and THOUGHTFUL LAYOUT makes this home the ideal property for your home, second home, or income producing rental!!! TASTEFUL FURNISHINGS CONVEY down to the silverware making the property "MOVE IN READY FROM DAY ONE"!!! Late model appliances and A BRAND NEW WASHER AND DRYER will help you make wonderful family memories!! Tons of storage, multiple outside decks, and a sunroom just completed the picture perfect beach home. "MOVE IN OR RENT READY FROM DAY ONE" and "plenty of room for a pool! THIS IS THE ONE!!!
Myrtle Beach Real Estate LLC
$725,000
1984
Detached
2420
1864
Contemporary
Wind Treat Convey, Garage Door Opener, Washer/Dryer, Furnished, Other
3
3
0
No
1st Flr Level, Linen Closet, Walk-in Closet
Luxury Vinyl Plank/Tile, Vinyl
Kit/DR Combo, Lvr/DR Combo, Vaulted/Cathedral Ceiling
Ceiling Fan, Fireplace, Vaulted/Cathedral Ceiling
Microwave, Range, Range Hood, Refrigerator, Solid Surface Countertops
1st Floor Baths, 1st Floor Bedrooms, Bonus Room, Laundry/Utility, Loft, OTHER
Shower, Tub, Tub/Shower Combo
Cable TV, Electricity, Other, Sewer, Telephone, Underground Utilities, Water Public
Patio, Deck, Front Porch, Rear Porch, Fencing, Boat Parking, RV Parking
Siding, Wood Frame
Slab
Central Air, Central Heat
One and One Half
Attached 2-Car
6
Electric
0.26
Rectangular
Inside City Limits, East of Bus 17, Oceanview Lot
152x74x155x79 ft
Cable TV, Electricity, Other, Sewer, Telephone, Underground Utilities, Water Public
4-26-2024
Short Term Rental Allowed, Long Term Rental Allowed, Owner Allowed Motorcycle, Tenant Allowed Motorcycle, Owner Allowed Golf Cart, Tenant Allowed Golf Cart, Owner Allowed Pet
Ingram Beach
11C North Myrtle Beach Area--Cre
Horry
35712042230
144-13-26-001
$0
Ocean Drive Elementary
North Myrtle Beach Middle School
North Myrtle Beach High School
Copyright 2024 Coastal Carolinas Association of REALTORS®, Inc.
Information Deemed Reliable, but Not Guaranteed.