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.188 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 |
500 Steps from the beach and TURN KEY... Ready to live in or rent day one! Standout with this ONE-OF-A-KIND HOME –LOT & LOCATION! *This well-built and well-maintained, never rented, practically all new and worry-free home has a modern-coastal design and sits high on an EXTRA-LARGE gorgeous LOT! THE most desirable area of NMB – has NO HOA!! HEAR THE WAVES and get a peek of the ocean! *Can be sold mostly furnished list provided, some items do not convey. *Indeed, GORGEOUS one-of-a-kind outdoor oasis or make it your own!!– (pool/guest house, lanai, hammocks, putting green, etc.) You’ll be proud and excited to own this rare piece of paradise! With 3 bedrooms up (including 2 main en-suites), 1 bed/bath down, 2 Sitting Rooms (and extra sleeping space), Lower-Level Kitchenette, Upstairs AND Downstairs Laundry options, this house has been thoughtfully designed to accommodate as a full-time or2nd home, including a separate entry with a “lock-out” option, or as an in-demand rental. (Listing indicates the house was built in 1979,however in 2021 this property was taken to the studs and given a complete top-to-bottom overhaul including a greatly expanded footprint and all-new layout.) • Excellent natural light! • Great kitchen with new appliances (GAS range with double oven, wine fridge,Bosch dishwasher), pullouts, coffee station and a walk-in pantry! • 60” 2-person corner jacuzzi tub • Upgraded electrical amp from standard 200 amp to 400 amp so that could easily accommodate for an additional house expansion and/or guest/pool house and/or EVStation in the future. • All electrical has been replaced, including the control panel, all wiring, and every outlet/switch with upgrades of all flat panel, screwless switches and dimmers. • Gas services were ran/capped for any future expansions; we also paid to have outdoor electrical lines removed from pole and buried for safety and aesthetics. • New roof, new gutters and all worry-free Hardie exterior • All plumbing/pipes have been replaced, including the outside meter with the city. • Tankless, ON DEMAND GAS WATER HEATER and circulation pump for quick hot water at all fixtures. • All new duct work for clean air/less dust; dual zone controls. • All new - every window, door, flooring, fixtures, sheetrock,etc.; SOLID CORE doors and soundproof insulation added for interior walls and floors • New deck approx. 12 x 35 that includes a screened in area of approx. 12x25. • New landscaping, sod, lighting, etc.; Lawn irrigation/sprinkler system. • Kitchenette space has been included downstairs (refrigerator included). • Custom Plantation Shutters and custom tile in all bathrooms. •
Myrtle Beach Real Estate LLC
$1,288,000
1979
Detached
4105
2395
Raised Beach
Spa/Hot Tub, Wind Treat Convey, Garage Door Opener, Workshop, Smoke Detector, Wshr/Dryer Connection, Washer/Dryer, Split Bedroom Plan, Furnished, Other
4
3
1
No
Beam, Ceiling Fan, Fireplace
Ceiling Fan, Walk-in Closet
OTHER
Beam Ceiling, Kit/DR Combo, Lvr/DR Combo, Vaulted/Cathedral Ceiling
Breakfast Bar, Dishwasher, Double Oven, Garbage Disposal, Microwave, Pantry, Range, Range Hood, Refrigerator, Solid Surface Countertops, Stainless Steel Apps., Work Island
1st Floor Baths, 1st Floor Bedrooms, Converted Garage, Laundry/Utility, Mother in Law Suite, OTHER, Screened Porch, Workshop
Double Sink, Shower, Whirlpool Tub
Cable TV, Electricity, Natural Gas, Other, Sewer, Telephone, Underground Utilities, Water Public
Patio, Deck, Balcony, Front Porch, Fencing, Boat Parking, Outside Storage Detached, Insulated Doors/Windows, Other, RV Parking, Golf Cart Garage
Concrete Fiber Siding, Masonry Accent, Wood Frame
Brick/Masonry,Raised Beach,Slab
Central Air, Central Heat
Two-Story
UNDER HOUSE - RAISED BEACH
6
Gas, Tankless
0.37
Corner, Irregular
Inside City Limits, East of Bus 17, Oceanview Lot
191x132x156x60 ft
Cable TV, Electricity, Natural Gas, Other, Sewer, Telephone, Underground Utilities, Water Public
4-26-2024
Seller Disclosure, Other, 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
35712040032
144-13-26-003
$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.