Query Template: /themes/irishoward/modules/myrtle-beach-mls/realcfc/mlsnew.cfc:183 Execution Time: 0.144 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.181 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 |
Welcome to an extraordinary opportunity in Longs—an expansive 70.34-acre estate featuring three distinct livable properties that cater to a variety of buyers! There is no other property like this!!! This is a must see in person because there wasn't enough room to post all of the pics of each property! The centerpiece is the stunning low country main house, designed for both comfort and elegance. With 5 bedrooms and 3.5 baths, this home boasts a wrap-around porch that offers breathtaking views of the long driveway and surrounding land, making it the perfect spot to enjoy sunrises and sunsets. The property features a large back deck, an in-ground heated saltwater pool, and an infinity hot tub for ultimate relaxation. Inside, you'll find tall ceilings, an open-concept layout, a formal dining room, a cozy library/den, and a spacious pantry. The bonus room on the third floor and private bar area add to the charm, while the propane fireplaces in both the living room and primary suite create a warm ambiance. The primary suite is a true retreat with a luxurious bathroom, featuring dual vanities, a tiled walk-in shower, a soaker tub, an expansive walk-in closet, and direct access to the screened-in back porch. The property also includes a charming tiny house situated by the pond, remodeled in 2021. This delightful 1-bedroom, 1.5-bath retreat offers modern amenities, including a mini-split system and on-demand water heater. Enjoy peaceful moments on the back dock, overlooking a fully stocked pond that has hosted countless family fishing and paddle boating adventures. Additionally, a three bed/2 bath manufactured home built in 2022 offers modern upgrades throughout, complete with a front covered porch and deck with a ramp added in 2023 for enhanced accessibility. The estate is equipped with two outbuildings at the front, perfect for workshop or storage use, and a greenhouse featuring propane, water, and electric—ideal for gardening enthusiasts. A cozy fire pit area adorned with twinkling lights provides a magical setting for gatherings under the stars. This unique property presents numerous opportunities for families, developers, investors, or anyone seeking a private retreat with endless potential. Don’t miss your chance to own this rare gem in Longs!
Huskins Realty LLC
$4,150,000
2004
Detached
5100
4100
Low Country
Window Treat Convey, Garage Door Opener, Security System, Smoke Detector, Wshr/Dryer Connection, Split Bedroom Plan, Fireplace, Fire Sprinkler
5
3
1
Yes
Wet Bar, Fireplace
Tile, Wood, Carpeting
Formal, Area
Bar, Fireplace, Vaulted/Cathedral Ceiling, Ceiling Fan
Range, Work Island, Dishwasher, Garbage Disposal, Refrigerator, Microwave, Breakfast Bar, Pantry, Double Oven, Breakfast Nook, Freezer, Stainless Steel Apps., Solid Surface Countertops, Cook Top
Den/Study/Library, 1st Floor Bedrooms, 1st Floor Baths, Foyer, Laundry/Utility, Loft
Electricity, Water Public, Sewer, Cable TV, Underground Utilities, Telephone
Deck, Front Porch, Rear Porch, Fencing, Lawn Sprinkler, Pool-Outdoor Private, Spa/Hot Tub, Outside Storage Detached, Storm Windows, Detached Living Quarters, Generator, Golf Cart Garage, Pool-In Ground
Wood Frame
Slab
Central Heat, Central Air, Window/Wall Unit, Electric, Propane
Three or More
Attached 2-Car
6
Gas, Tankless
70.34
Irregular, 5 or More Acres
On Lake/Pond, Outside City Limits, Lake/Pond View
Electricity, Water Public, Sewer, Cable TV, Underground Utilities, Telephone
7-14-2025
Seller Disclosure, Long Term Rental Allowed, Owner Allowed Motorcycle, Tenant Allowed Motorcycle, Owner Allowed Golf Cart, Tenant Allowed Golf Cart, Owner Allowed Pet
Not within a Subdivision
03B Loris to Longs Area--North o
Horry
25800000020
$0
Daisy Elementary School
Loris Middle School
Loris High School
Copyright 2025 Coastal Carolinas Association of REALTORS®, Inc.
Information Deemed Reliable, but Not Guaranteed.