Query Template: /themes/irishoward/modules/myrtle-beach-mls/realcfc/mlsnew.cfc:183 Execution Time: 0.153 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.18 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 your dream home in the delightful town of Mullins! This stunning 4-bedroom, 2-bathroom property offers endless possibilities with no HOA and a unique mix of residential and commercial zoning, ideal for living and running your business from home. Step onto the large front porch and enter a beautifully refreshed interior featuring hardwood floors throughout and fresh paint. Enjoy cozy evenings with two wood-burning stoves and entertain in the spacious living area. The house boasts two fully-equipped kitchens with stainless steel appliances, including full-size ranges, a Vevor ice maker, and touchless faucets. Both bathrooms have been tastefully remodeled, one with a shower/tub combo and the other featuring a walk-in shower, ensuring comfort and style. The electrical system throughout the home has been upgraded and rewired for safety and efficiency. Outdoor enthusiasts will love the side porch with an outdoor kitchen equipped with a 36" Blackstone grill, a 26" Charbroil grill, a 36" Radiance commercial range, and a Imperial commercial fryer. The fully fenced backyard is a private oasis with mature trees, an above-ground pool with a deck, and a vegetable garden complete with a metal pergola. Enjoy the convenience of an outside hot/cold shower. The front yard features a sprinkler system for easy maintenance. This spacious .77-acre lot includes a 4-bay, 24x55 metal garage with 100-amp electrical service and an 3-bay additional 20x40 metal garage in the backyard with 60-amp service, perfect for all your storage needs. With solar panels installed, this home promotes energy efficiency and reduces your utility costs, enhancing your sustainable lifestyle. Whether you're looking for a forever home or a vacation retreat, this property offers it all. Don't miss out on this incredible opportunity, schedule your showing today!
Century 21 The Harrelson Group
$284,900
1954
Detached
2865
2865
Ranch
Window Treat Convey, Wshr/Dryer Connection, Washer/Dryer, Fireplace, Lead Based Paint Disclose
4
2
0
No
Fireplace
Wood
Lvr/DR Combo
Fireplace
Dishwasher, Stainless Steel Apps., Solid Surface Countertops
1st Floor Bedrooms, 1st Floor Baths, Laundry/Utility, Workshop
Electricity, Natural Gas, Water Public, Sewer, Cable TV, Telephone
Patio, Deck, Front Porch, Additional Garage, Solar Panels, Outdoor Kitchen
Central Heat, Central Air, Electric, Gas, Solar
Single Level
Detached 4-Plus
10
Tankless
0.77
Inside City Limits
Electricity, Natural Gas, Water Public, Sewer, Cable TV, Telephone
7-18-2025
Not within a Subdivision
31A Other counties in South Caro
Marion
410-11-18-000-000
$0
McCormick Elementary School
Palmetto Jr. High
Mullins High School
Copyright 2025 Coastal Carolinas Association of REALTORS®, Inc.
Information Deemed Reliable, but Not Guaranteed.