Iris & Howard Real Estate
Query
Template: /themes/irishoward/modules/myrtle-beach-mls/realcfc/mlsnew.cfc:183
Execution Time: 0.37 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_valuedisplayurlareas
154A Andrews Are--includes city oAndrewsandrews54A
217A Aynor Area--central includesAynoraynor17A,12A,13A
325B Conway Area--between Wacc. RConwayconway25B,21A,21B,21D,21C,21E,14A,15A,23A,20A,18A,22A,15B,23B
409A Conway to Longs Area--BetweeConway to Longsconway-to-longs09A,09B
510A Conway to Myrtle Beach Area-Conway to Myrtle Beachconway-to-myrtle-beach10A
627A Garden City Mainland & PenniGarden Citygarden-city27A,28C
748A Georgetown Area--Belle IsleGeorgetowngeorgetown48A,52A,53A,46A,50A,47A,49A,51A
841A Pawleys Island Area-LitchfieLitchfield Beachlitchfield-beach41A,42A
904B Little River Area--North ofLittle Riverlittle-river04B,04A
1003A Longs to Little River Area--Longs to Little Riverlongs-to-little-river03A
1102A Loris Area--central includesLorisloris02A,05A,01A
1206A Loris to Conway Area--SouthLoris to Conwayloris-to-conway06A,08A
1307A Loris to Longs Area--South oLoris to Longsloris-to-longs07A,03B
1427B Murrells Inlet - Horry CountMurrells Inletmurrells-inlet27B,40A
1525A Myrtle Beach Area--west of SMyrtle Beachmyrtle-beach25A,10B,24A,26A,16F,16E,16D,16C,16B,16A,16G,26B,16J,19A,24B
1631B North CarolinaNorth Carolinanorth-carolina31B
1711D North Myrtle Beach Area--AtlNorth Myrtle Beachnorth-myrtle-beach11D,10C,11A,11C,11B,11F,11E
1831A Other counties in South CaroOther Countiesother-counties31A
1931C Not in South Carolina or NorOther Statesother-states31C
2045A Pawleys Island AreaPawleys Islandpawleys-island45A,43A,44A,45B
2128B Surfside Area-Glensbay to GCSurfsidesurfside28B,29A,29B,28A
Query
Template: /themes/irishoward/page_templates/mls.cfm:75
Execution Time: 0.211 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_valuedisplayurlareas
154A Andrews Are--includes city oAndrewsandrews54A
217A Aynor Area--central includesAynoraynor17A,12A,13A
325B Conway Area--between Wacc. RConwayconway25B,21A,21B,21D,21C,21E,14A,15A,23A,20A,18A,22A,15B,23B
409A Conway to Longs Area--BetweeConway to Longsconway-to-longs09A,09B
510A Conway to Myrtle Beach Area-Conway to Myrtle Beachconway-to-myrtle-beach10A
627A Garden City Mainland & PenniGarden Citygarden-city27A,28C
748A Georgetown Area--Belle IsleGeorgetowngeorgetown48A,52A,53A,46A,50A,47A,49A,51A
841A Pawleys Island Area-LitchfieLitchfield Beachlitchfield-beach41A,42A
904B Little River Area--North ofLittle Riverlittle-river04B,04A
1003A Longs to Little River Area--Longs to Little Riverlongs-to-little-river03A
1102A Loris Area--central includesLorisloris02A,05A,01A
1206A Loris to Conway Area--SouthLoris to Conwayloris-to-conway06A,08A
1307A Loris to Longs Area--South oLoris to Longsloris-to-longs07A,03B
1427B Murrells Inlet - Horry CountMurrells Inletmurrells-inlet27B,40A
1525A Myrtle Beach Area--west of SMyrtle Beachmyrtle-beach25A,10B,24A,26A,16F,16E,16D,16C,16B,16A,16G,26B,16J,19A,24B
1631B North CarolinaNorth Carolinanorth-carolina31B
1711D North Myrtle Beach Area--AtlNorth Myrtle Beachnorth-myrtle-beach11D,10C,11A,11C,11B,11F,11E
1831A Other counties in South CaroOther Countiesother-counties31A
1931C Not in South Carolina or NorOther Statesother-states31C
2045A Pawleys Island AreaPawleys Islandpawleys-island45A,43A,44A,45B
2128B Surfside Area-Glensbay to GCSurfsidesurfside28B,29A,29B,28A

324 54th Ave. N, North Myrtle Beach, SC 29582

Overview:

Introducing Cabin by the Sea, a truly one-of-a-kind property featuring 5-Bedrooms, 3-Bathrooms. This Home has been fully renovated unlike any other in the entire area! Professionally designed, this 5-bedroom, 3-bath retreat combines style, comfort, and impressive rental income. Perfect for accommodating up to 16 guests, the home offers three king beds, four queens, and one full bed. As you enter the home you will truly see the level of thought and detail that was put into both the renovation & design. The inviting living room,complete with a Smart TV and an elegant antler chandelier, sets the tone for relaxation, while the modern, fully equipped kitchen features a striking black backsplash and bar seating for five. A spacious dining table for eight welcomes gatherings of all kinds. Each bedroom is fitted with a Smart TV, and the versatile sleeping arrangements ensure flexibility for family & friends. Step outside to indulge in the large hot tub, enjoy a barbecue on the outdoor grill, or challenge friends to a game at the poker table. The expansive outdoor area includes a Carolina room, private dock, and a wood-inlaid bar, offering spaces to unwind or entertain in style. Convenient parking for 6-8 cars and a washer/dryer complete this exceptional property, making it a beautiful, income-generating, RARE escape in the heart of Cherry Grove Beach.

Listing Courtesy Of:

Century 21 Palms Realty

Original Price:

$999,000

Year Built:

1968

Date Input:
7-27-2025
Listing Date:
7-27-2025
Type:

Detached

Total Square Feet:

2738

Total Heated Sq. Ft.:

1868

Interior Features

Style:

Raised Beach

Interior Features:

Window Treat Convey, Wshr/Dryer Connection, Washer/Dryer, Furnished

Bedrooms:

5

Full Baths:

3

Half Baths:

0

Formal Dining Room:

No

Floor Cover:

Luxury Vinyl Plank/Tile

Dining Room:

Lvr/DR Combo, Kit/DR Combo, Vaulted/Cathedral Ceiling, Beam Ceiling

Living Room:

Vaulted/Cathedral Ceiling, Beam

Kitchen:

Range, Work Island, Dishwasher, Refrigerator, Microwave, Breakfast Bar, Stainless Steel Apps., Solid Surface Countertops

Other Rooms:

Carolina Room, Laundry/Utility

Utilities Available:

Electricity, Water Public, Sewer, Cable TV, Telephone

Exterior

Exterior Features:

Patio, Deck, Balcony, Spa/Hot Tub

Exterior Finish:

Vinyl Siding, Concrete Fiber Siding

Foundation:

Raised Beach

Heating and Cooling:

Central Heat, Central Air, Electric

Type of Parking:

UNDER HOUSE - RAISED BEACH

Parking Capacity:

6

Water Heater:

Electric

Lot Details

Acres:

0.14

Lot Description:

Rectangular

Lot Location:

On Channel, East of Bus 17, Marsh/Wetlans View, Channel View

Utilities Available:

Electricity, Water Public, Sewer, Cable TV, Telephone

Listing Date:

7-27-2025

Community Infomation

Amenities:

Seller Disclosure, 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

Area Information

Section/Subdivision:

Not within a Subdivision

Area:

11A North Myrtle Beach Area--Che

County:

Horry

Tax Map Number:

35209010017

Association Information

Estimated Monthly POA Amount:

$0

Schools

Elementary School:

Ocean Drive Elementary

Middle School:

North Myrtle Beach Middle School

High School:

North Myrtle Beach High School

Would you like to see this property?

Copyright 2025 Coastal Carolinas Association of REALTORS®, Inc.
Information Deemed Reliable, but Not Guaranteed.