Query Template: /themes/irishoward/modules/myrtle-beach-mls/realcfc/mlsnew.cfc:184 Execution Time: 0.131 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.317 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 |
NextGen Plan is a beautiful open floor plan with mother-in-law suite that has it's own private entrance. This home boasts 4 bedrooms, 4 full baths, formal dining room, newly renovated kitchen with breakfast nook, family room with gas fireplace, owner's suite, laundry room, foyer, front porch, all season Carolina room and a 3 car garage. Mother-in-law suite consists of a private entrance, private living room, bedroom, bathroom and kitchenette. Main house boasts a brand new gourmet kitchen with granite counters, stainless steel appliances, breakfast nook, serving bar/work island, lots of cabinets and storage, open to a spacious family room with fireplace, vaulted ceilings and more. Formal dining room features a trey ceiling. Spacious owners suite features a trey ceiling, walk-in closet, master bath with double vanity, garden tub and separate shower. A guest bedroom is situated on the first floor level for easy access. Upstairs offers a perfect 4th bedroom with a large walk-in closet and full bathroom or use as a bonus room..offering many options. Enjoy the beautiful extension of your home in the enclosed four season room overlooking your backyard. The 3 car garage offers lots of room for two vehicles, golf cart, motorcycle, a 3rd vehicle or storage. Situated on a large corner lot, this spacious home has beautiful curb appeal with mature, lush landscaping. Walking distance to pool, clubhouse, fitness facility, and amenities. Awesome community offering resort style pool, outdoor kitchens, fire pits, grill areas, playground, fitness room, covered areas, bocce ball courts, putting green, swings, walking trails, dog park, lakes, restrooms, natural gas and a clubhouse. Great location, less than two miles to the beach, walking distance to Market Common, golf cart ride to everything! Walk, ride your bike or take your golf cart to Market Common, shopping, dining, grocery stores, movies, ball parks, state park, beach, warbird park and other attractions. Great opportunity..the mortgage is assumable at 2.875%...contact your agent for details.
BRG Real Estate
$580,000
2012
Detached
3300
2500
Other
Wind Treat Convey, Garage Door Opener, Security System, Smoke Detector, Wshr/Dryer Connection, Washer/Dryer, Fireplace
4
4
0
Yes
Vaulted/Cathedral Ceiling, Ceiling Fan, Fireplace
Ceiling Fan, 1st Flr Level, Walk-in Closet, Tray Ceiling
Tile, Wood, Carpeting
Formal
Range, Work Island, Dishwasher, Garbage Disposal, Refrigerator, Microwave, Breakfast Bar, Pantry, Breakfast Nook, Range Hood, Stainless Steel Apps., Solid Surface Countertops
Carolina Room, 1st Floor Bedrooms, 1st Floor Baths, Laundry/Utility, Mother in Law Suite
Double Sink, Garden Tub, Shower
Electricity, Natural Gas, Water Public, Sewer, Cable TV, Underground Utilities, Telephone
Front Porch, Rear Porch, Fencing, Insulated Doors/Windows
Concrete Fiber Siding
Slab
Central Heat, Central Air, Electric, Gas, Other
One and One Half
Attached 3-Car
6
Gas
0.21
Corner
Inside City Limits, East of Highway 17 Bypass
Electricity, Natural Gas, Water Public, Sewer, Cable TV, Underground Utilities, Telephone
3-22-2023
Home Owners Assoc. Fees, Restrictions, Clubhouse/Rec/Facilities, Pool - Outdoor Community, Seller Disclosure, Long Term Rental Allowed, Owner Allowed Motorcycle, Tenant Allowed Motorcycle, Owner Allowed Golf Cart, Tenant Allowed Golf Cart, Owner Allowed Pet
Emmens Preserve - Market Commons
16G Myrtle Beach Area--Southern
Horry
44704040108
$83
Electric Common, Pool Service, Manager, Recreation Facilities, Legal and Accounting
Myrtle Beach Elementary School
Myrtle Beach Middle School
Myrtle Beach High School
Copyright 2025 Coastal Carolinas Association of REALTORS®, Inc.
Information Deemed Reliable, but Not Guaranteed.