Query Template: /themes/irishoward/modules/myrtle-beach-mls/realcfc/mlsnew.cfc:184 Execution Time: 0.203 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.225 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 |
Presenting this luxurious Mediterranean style tri-level home located on a 1.72 acre tranquil & scenic Intracoastal Waterway lot residing in the exclusive gated Cliffwood Estates community. Boasting an impressive layout with 5 bedrooms, 3 well-appointed bathrooms along with 2 half baths. This home is a testament to impeccable craftsmanship and features a private sparkling in-ground pool overlooking the ICW, hardwood, carpet, & tile flooring, elegant arched entryways, recessed lighting, a family room with sliders leading out to the court yard, a formal dining room, an exciting exercise room, a vaulted ceiling living room with a cozy fireplace, and showcases an inviting entertainment suite with a fireplace, built-ins, and a distinctive full sized wet bar. The family friendly kitchen is equipped with a kitchen island with a cook top, refrigerator, dishwasher, built-in microwave, dual wall ovens, a computer niche, a breakfast nook, tile back splash, along with ample cabinets and counter spaces. Retire to the grand master suite that offers a dual door entryway, a relaxing retreat area, a fireplace place, sliding glass doors access to the back decking, private access to the master bath that hosts a single sink vanity, a classic tub/shower steamer combo, and a separate soothing jetted tub. This home is completed with four additional bedrooms, two full baths along with two half baths, a laundry room, 246 feet of Intracoastal Waterway frontage, and a three car side load attached garage. This home affords you easy access to the beach and golfing along with all of the other activities and happenings in Myrtle Beach including fun eateries, award winning off-Broadway shows, public fishing piers, and intriguing shopping adventures along the Grand Strand. Conveniently located to your everyday needs, including grocery stores, banks, post offices, doctors’ offices, pharmacies, and only 2 miles to Grand Strand Medical Center. Check out our state of the art 3-D Virtual Tour.
The Ocean Forest Company
$2,450,000
1985
Detached
5000
4048
Mediterranean
Smoke Detector, Wshr/Dryer Connection, Fireplace
5
3
2
Yes
Fireplace, Sitting Area, Walk-in Closet
Carpeting, Tile, Wood
Formal
Beam, Ceiling Fan, Fireplace, Vaulted/Cathedral Ceiling
Breakfast Nook, Dishwasher, Double Oven, Microwave, Range, Refrigerator
Foyer, Laundry/Utility
Shower, Tub/Shower Combo, Vanity
Cable TV, Electricity, Sewer, Telephone, Water Public
Patio, Deck, Pool-Outdoor Private, Side Load Garage, Pool-In Ground
Stucco
Slab
Central Air, Central Heat
Split Level
Attached 3-Car
8
Electric
1.72
On ICW, Inside City Limits, In ICW community, ICW View
250 x 301 x 246 x 303 ft
Cable TV, Electricity, Sewer, Telephone, Water Public
4-26-2024
Home Owners Assoc. Fees, Restrictions, Security, Gated Community
Cliffwood - Dunes in MB
16C Myrtle Beach Area--79th Ave
Horry
39407010011
$100
Common Maint/Repair, Security
Myrtle Beach Elementary School
Myrtle Beach Middle School
Myrtle Beach High School
Copyright 2024 Coastal Carolinas Association of REALTORS®, Inc.
Information Deemed Reliable, but Not Guaranteed.