Query Template: /themes/irishoward/modules/myrtle-beach-mls/realcfc/mlsnew.cfc:184 Execution Time: 0.22 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.24 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 |
The best in southern living starts here. A picturesque pond setting greets you from this sprawling one level design located in highly desirable Clear Pond at Myrtle Beach National. Looking for square footage? This open and spacious plan features volume ceilings, recessed lighting, crown mouldings, many windows, wainscoting, arched doorways and great storage. The cook in the family is certain to enjoy the oversized eat in Corian kitchen featuring plenty of counter space, 42" cabinetry, center island huge pantry and 2 breakfast bars. There is also a formal dining room. The owners suite is sizable and includes dual walk in closets as well as well planned bath with split double sink vanities. Bedroom 2 and 3 offer great separation from the owner's suite and share access to a large double sink bathroom. The oversized great room enjoys a a natural gas fireplace and opens to a delightful Carolina Room for easy entertaining and family living. A much desired powder room completes the layout. Situated on a well landscaped homesite with in-ground irrigation and rear screened for enhanced outdoor living. Amenities center with community pool.
RE/MAX Southern Shores NMB
$389,000
2008
Detached
2972
2531
Traditional
Wind Treat Convey, Garage Door Opener, Stairs To Attic, Smoke Detector, Wshr/Dryer Connection, Washer/Dryer, Split Bedroom Plan, Fireplace
3
2
1
Yes
Ceiling Fan, Fireplace
Ceiling Fan, 1st Flr Level, Walk-in Closet, Tray Ceiling
Tile, Wood, Carpeting
Formal
Range, Work Island, Dishwasher, Garbage Disposal, Refrigerator, Microwave, Breakfast Bar, Pantry, Breakfast Nook, Ceiling Fan, Stainless Steel Apps., Solid Surface Countertops
Carolina Room, 1st Floor Bedrooms, 1st Floor Baths, Foyer, Laundry/Utility, Screened Porch
Double Sink, Garden Tub, Shower
Electricity, Water Public, Sewer, Cable TV, Underground Utilities, Telephone
Rear Porch, Lawn Sprinkler, Storm Doors
Brick Veneer, Vinyl Siding
Slab
Central Heat, Central Air, Electric
Single Level
Attached 2-Car
4
Gas
0.17
Rectangular
On Lake/Pond, Outside City Limits
Electricity, Water Public, Sewer, Cable TV, Underground Utilities, Telephone
3-22-2023
Home Owners Assoc. Fees, Restrictions, Clubhouse/Rec/Facilities, Pool - Outdoor Community, Seller Disclosure, Long Term Rental Allowed, Owner Allowed Motorcycle, Owner Allowed Golf Cart, Owner Allowed Pet
Clear Pond at Myrtle Beach Natio
10B Myrtle Beach Area--Carolina
Horry
38411030013
$95
Electric Common, Trash Pickup, Pool Service, Manager, Common Maint/Repair, Legal and Accounting
Carolina Forest Elementary Schoo
Ten Oaks Middle
Carolina Forest High School
Copyright 2024 Coastal Carolinas Association of REALTORS®, Inc.
Information Deemed Reliable, but Not Guaranteed.