Query Template: /themes/irishoward/modules/myrtle-beach-mls/realcfc/mlsnew.cfc:183 Execution Time: 0.168 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.317 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 |
Luxurious Coastal Living at it's Finest: This Modern 7 Bedroom, 7.5 Bath estate home nestled in the heart of North Myrtle Beach in prestigious Tilghman Estates. This expansive North Ocean Blvd residence is located right across from the beach! The upper living area has an open floor plan with an incredible view of the Ocean...featuring a custom kitchen with a wrap around island, an expansive living area, and a sizable dining area. Also on the upper level you will find 3 spacious master suites with private bathrooms, along with access to both porches...the front porch overlooks the beautiful Atlantic Ocean! The lower level also has it's own kitchen and dining area, and a spacious great room. On the lower level you will find four generously sized bedrooms, each with it's own full bathroom, a laundry room, and access to both the front and back porches. No detail has been overlooked in this custom, fully furnished home...custom tile showers and vanities along with wi-fi controlled lighting, an irrigation system, and a large amazing pool and spill over hot tub. The home features Natural Gas appliances, tankless water heaters, chef's dream oven, and a whole house generator with an automatic transfer switch. The entire home is protected by hurricane proof windows, and doors and tile flooring throughout the entire home.This custom built residence also features a 14 ft. finished bottom level with an amazing garage for all of your parking needs, there is also an internal garage inside the main garage for extra storage. The craftsmanship and detail are a must see for those seeking an incredible home to call your primary home, second home, or proven investment property!
Realty ONE Group DocksideNorth
$2,450,000
2018
Detached
4234
3878
Raised Beach
Window Treat Convey, Garage Door Opener, Security System, Smoke Detector, Wshr/Dryer Connection, Washer/Dryer, Elevator-Interior
7
7
1
Yes
Bar, Ceiling Fan
Tile
Area, Lvr/DR Combo
Bar, Ceiling Fan
Range, Work Island, Dishwasher, Garbage Disposal, Refrigerator, Microwave, Breakfast Bar, Pantry, Double Oven, Breakfast Nook, Ceiling Fan, Freezer, Range Hood, Stainless Steel Apps., Solid Surface Countertops
Den/Study/Library, Foyer, Laundry/Utility, OTHER
Electricity, Natural Gas, Water Public, Sewer, Cable TV, Underground Utilities
Balcony, Front Porch, Rear Porch, Pool-Outdoor Private, Spa/Hot Tub, Side Load Garage, Generator
Concrete Fiber Siding
Raised Beach
Central Heat, Central Air, Electric, Gas
UNDER HOUSE - RAISED BEACH
6
Gas
0.37
Inside City Limits, East of Bus 17, Second Row Beach
100 x 160 ft
Electricity, Natural Gas, Water Public, Sewer, Cable TV, Underground Utilities
7-18-2025
Pool - Outdoor Community, 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
Tilghman Estates
11B North Myrtle Beach Area--Oce
Horry
35606020011
$0
Ocean Drive Elementary
North Myrtle Beach Middle School
North Myrtle Beach High School
Copyright 2025 Coastal Carolinas Association of REALTORS®, Inc.
Information Deemed Reliable, but Not Guaranteed.