Iris & Howard Real Estate
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_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.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_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

618 S Main St., Mullins, SC 29574

Overview:

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!

Listing Courtesy Of:

Century 21 The Harrelson Group

Original Price:

$284,900

Year Built:

1954

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

Detached

Total Square Feet:

2865

Total Heated Sq. Ft.:

2865

Interior Features

Style:

Ranch

Interior Features:

Window Treat Convey, Wshr/Dryer Connection, Washer/Dryer, Fireplace, Lead Based Paint Disclose

Bedrooms:

4

Full Baths:

2

Half Baths:

0

Formal Dining Room:

No

Family Room/Great Room:

Fireplace

Floor Cover:

Wood

Dining Room:

Lvr/DR Combo

Living Room:

Fireplace

Kitchen:

Dishwasher, Stainless Steel Apps., Solid Surface Countertops

Other Rooms:

1st Floor Bedrooms, 1st Floor Baths, Laundry/Utility, Workshop

Utilities Available:

Electricity, Natural Gas, Water Public, Sewer, Cable TV, Telephone

Exterior

Exterior Features:

Patio, Deck, Front Porch, Additional Garage, Solar Panels, Outdoor Kitchen

Heating and Cooling:

Central Heat, Central Air, Electric, Gas, Solar

Levels:

Single Level

Type of Parking:

Detached 4-Plus

Parking Capacity:

10

Water Heater:

Tankless

Lot Details

Acres:

0.77

Lot Location:

Inside City Limits

Utilities Available:

Electricity, Natural Gas, Water Public, Sewer, Cable TV, Telephone

Listing Date:

7-18-2025

Community Infomation

Area Information

Section/Subdivision:

Not within a Subdivision

Area:

31A Other counties in South Caro

County:

Marion

Tax Map Number:

410-11-18-000-000

Association Information

Estimated Monthly POA Amount:

$0

Schools

Elementary School:

McCormick Elementary School

Middle School:

Palmetto Jr. High

High School:

Mullins High School

Would you like to see this property?

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