Query Template: /themes/irishoward/modules/myrtle-beach-mls/realcfc/mlsnew.cfc:183 Execution Time: 0.168 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.174 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 |
Country living only 30 minutes to the beach! Say hello to your new home-sweet-home at 2420 Mt Zion Road, a sprawling estate on nearly 8 ACRES of property! A long driveway and mature trees welcome you home as you approach the 3300 square feet brick ranch featuring 4 bedrooms, 2.5 bathrooms, and all the space you could ever need. Every room in the home is large, and the living spaces are massive. The kitchen is the heart of this home and could definitely win an award for the most cabinet space, and the most countertop space EVER. The living spaces of this home truly provide the ideal setting for hosting gatherings with your family and friends. Let's talk bedrooms - downstairs is home to the owner's suite (private ensuite bathroom and closets galore) and a secondary bedroom, as well as a hall bathroom, half bath, and the laundry room. Upstairs features 2 more bedrooms, and an unfinished storage room that could become a 5th bedroom (heated and cooled already). Venture outdoors to the expansive 7.52 acreage that features enormous front and back yards, a horse barn complete with 4 horse stalls, storage, and a horse shower, a two-acre stocked pond for fishing, mature trees providing ample shade throughout, two car attached garage, and relaxing covered porches to sip on your sweet tea on a warm South Carolina afternoon. Country living with a coastal flare. With Myrtle Beach being only 30 minutes away, location is key keeping you conveniently close to several top beaches, local attractions, and all of the dining/shopping you could possibly need. All while being tucked away on your land to enjoy the tranquility, serenity, and the country living that this home can provide. Endless opportunities for recreation and enjoyment for the whole family, at home or nearby! Schedule your showing today, and be sure to bring your cowboy boots and beach hat!
A & A Realty & Co, LLC
$737,500
2008
Detached
4300
3332
Ranch
Smoke Detector, Wshr/Dryer Connection, Fireplace
4
2
1
Yes
Ceiling Fan, Fireplace
Tile, Carpeting, Luxury Vinyl Plank/Tile
Formal, Lvr/DR Combo
Fireplace, Ceiling Fan
Work Island, Dishwasher, Microwave, Breakfast Bar, Pantry, Double Oven, Breakfast Nook, Range Hood, Stainless Steel Apps., Solid Surface Countertops, Cook Top
1st Floor Bedrooms, 1st Floor Baths, Foyer, Laundry/Utility, Bonus Room
Electricity, Water Public, Well Private, Sewer, Septic, Cable TV, Telephone
Patio, Front Porch, Fencing, Lawn Well, Outside Storage Attached, Insulated Doors/Windows, Side Load Garage
Brick Veneer
Slab
Central Heat, Central Air, Electric
Two-Story
Attached 2-Car
10
Electric
7.52
5 or More Acres
On Lake/Pond, Lake/Pond View
Electricity, Water Public, Well Private, Sewer, Septic, Cable TV, Telephone
7-3-2025
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
Not within a Subdivision
02A Loris Area--central includes
Horry
15504020001
$0
Green Sea Floyds Elementary Scho
GreenSea Floyds
GreenSea Floyds High School
Copyright 2025 Coastal Carolinas Association of REALTORS®, Inc.
Information Deemed Reliable, but Not Guaranteed.