Query Template: /themes/irishoward/modules/myrtle-beach-mls/realcfc/mlsnew.cfc:184 Execution Time: 0.2 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.255 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 |
3205 Fieldstone is a stunning 3 bedroom 2.5 bathroom home in the highly sought after neighborhood of The Farm in Carolina Forest! This immaculate single level home has an open floor plan and features many upgrades! The double front doors make this home stand out even before entering. As you walk through the foyer the high ceilings create a feeling of spaciousness. The main living area features a beautiful family room with a wood burning fireplace, a large kitchen with plenty of counterspace for entertaining, a lovely dining area, and Carolina room overlooking the fenced in back yard. Upon entering the kitchen you will find granite countertops, tile backsplash, a pantry with upgraded shelving, black stainless steel appliances, a large island and pendant lights. The master suite features a beautiful coffered ceiling, large walk-in closet, and private bathroom with double sinks on an L shaped vanity and an abundance of counter space. The two additional bedrooms are large, and one features a tall, built in bookcase. The additional bedrooms share the second full bath with a shower/tub combo and an extra long vanity. This house also has a half bath for guests, a laundry room with cabinets and a utility sink. The HOA includes basic cable, internet and garbage pickup. This home is a "Must See!" The Farm at Carolina Forest has an abundance of amenities which include two pools, a clubhouse, fitness center, playground, and basketball court! This beautiful home is located within the area of the highly desirable Carolina Forest schools, Coastal Carolina University, abundant shopping, entertainment, golf courses, medical facilities and a short drive to the beach. Square footage is approximate and not guaranteed. Buyer is responsible for verification.
Palmetto Coastal Homes
$365,000
2006
Detached
2750
2410
Ranch
Spa/Hot Tub, Wind Treat Convey, Garage Door Opener, Security System, Stairs To Attic, Intercom, Smoke Detector, Wshr/Dryer Connection, Washer/Dryer, Split Bedroom Plan, Fireplace
3
2
1
No
Ceiling Fan, Fireplace
Ceiling Fan, 1st Flr Level, Walk-in Closet, Tray Ceiling
Tile, Wood, Carpeting
Area
Range, Work Island, Dishwasher, Garbage Disposal, Refrigerator, Microwave, Breakfast Bar, Pantry, Breakfast Nook, Stainless Steel Apps.
Carolina Room, 1st Floor Bedrooms, 1st Floor Baths, Foyer, Laundry/Utility
Double Sink, Garden Tub, Shower, Vanity
Electricity, Water Public, Sewer, Cable TV, Underground Utilities
Patio, Fencing
Brick Veneer, Vinyl Siding
Slab
Central Air, Electric
Single Level
Attached 2-Car
4
0.22
Rectangular
64x124x94x135 ft
Electricity, Water Public, Sewer, Cable TV, Underground Utilities
10-16-2021
Home Owners Assoc. Fees, Restrictions, Clubhouse/Rec/Facilities, Pool - Outdoor Community, Owner Allowed Golf Cart, Owner Allowed Pet
Carolina Forest - The Farm
10B Myrtle Beach Area--Carolina
Horry
39608030020
$90
Electric Common, Trash Pickup, Pool Service, Manager, Common Maint/Repair, Recreation Facilities, Legal and Accounting, Master Antenna/Cable TV, Internet Access
Ocean Bay Elementary School
Ocean Bay Middle School
Carolina Forest High School
Copyright 2024 Coastal Carolinas Association of REALTORS®, Inc.
Information Deemed Reliable, but Not Guaranteed.