Query Template: /themes/irishoward/modules/myrtle-beach-mls/realcfc/mlsnew.cfc:183 Execution Time: 0.207 ms Record Count: 21 Cached: Yes Cache Type: timespan Datasource: newccar 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.225 ms Record Count: 21 Cached: No Datasource: newccar 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 Oyster Bluff! A natural gas community just minutes away from shopping, dining, and the beach. The Hayden features a large floor plan with plenty of space for everyone! The great room paired with the spacious kitchen makes this open layout very functional. 36" painted cabinetry, granite countertops, island with breakfast bar, stainless Whirlpool appliances including a gas range, and a walk-in corner pantry! The flex room up front would make a great home office or formal dining room. Beautiful yet durable LVP flooring flows through the foyer, flex room, kitchen, living room, and dining room. Downstairs also features a bedroom and full bath that is perfect for guests visiting you at the beach. Upstairs is home to the impressive primary bedroom suite with a walk-in closet and a private en suite bath. The laundry room, remaining three bedrooms, and versatile loft space complete the upstairs! Spacious rear covered porch, tankless gas water heater, our QuickTie framing system, and a two-car garage with garage door opener also included. It gets better- this is America's Smart Home! Ask an agent today about our industry leading smart home technology package that is included in each of our new homes. *Photos are of a similar Hayden home. (Home and community information, including pricing, included features, terms, availability and amenities, are subject to change prior to sale at any time without notice or obligation. Square footages are approximate. Pictures, photographs, colors, features, and sizes are for illustration purposes only and will vary from the homes as built. Equal housing opportunity builder.)
DR Horton
$384,365
2025
Detached
3122
2511
Traditional
Garage Door Opener, Stairs To Attic, Smoke Detector, Wshr/Dryer Connection
5
3
0
No
Carpeting, Luxury Vinyl Plank/Tile
Area, Lvr/DR Combo
15x15'5
Range, Work Island, Dishwasher, Garbage Disposal, Microwave, Breakfast Bar, Pantry, Stainless Steel Apps., Solid Surface Countertops
Den/Study/Library, 1st Floor Bedrooms, 1st Floor Baths, Foyer, Laundry/Utility, Loft
Electricity, Natural Gas, Water Public, Sewer, Cable TV, Underground Utilities, Telephone
Front Porch, Rear Porch, Insulated Doors/Windows
Wood Frame, Vinyl Siding
Slab
Central Heat, Central Air, Electric, Gas
Two-Story
Attached 2-Car
4
Gas, Tankless
0.17
Outside City Limits
Electricity, Natural Gas, Water Public, Sewer, Cable TV, Underground Utilities, Telephone
2-20-2025
Home Owners Assoc. Fees, Restrictions, Long Term Rental Allowed, Owner Allowed Motorcycle, Owner Allowed Golf Cart, Owner Allowed Pet
Oyster Bluff
26A Myrtle Beach Area--south of
Horry
44807030108
$55
Electric Common, Trash Pickup, Common Maint/Repair
Burgess Elementary School
Saint James Middle School
Saint James High School
Copyright 2025 Coastal Carolinas Association of REALTORS®, Inc.
Information Deemed Reliable, but Not Guaranteed.