| Query Template: /themes/irishoward/modules/myrtle-beach-mls/realcfc/mlsnew.cfc:183 Execution Time: 0.171 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.285 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 | |
Opportunity to own right near Conway without a huge price tag... The Trinity with its open floor plan, this 3bed 2 bath home feels spacious from the moment you enter. A cathedral ceiling guides your way through the generous great room to the beautiful kitchen.Ample storage in the kitchen with granite counters and luxury flooring. The master has a large walk-in closet and double sink in the master bath. This split bedroom plan offers 2 other bedrooms both with ample closet space. Two-car garage and a large lot to call your own. Stop by and see all that Rosehaven has to offer, just minutes from downtown. Rosehaven has Several floor plans to choose from, with 3 to 4 bedrooms and a 1 or 2 car garage.
Keller Williams Oak and Ocean
$282,500
2025
Detached
1793
1245
Ranch
Garage Door Opener, Wshr/Dryer Connection
3
2
0
No
Vaulted/Cathedral Ceiling, Ceiling Fan
Vinyl, Carpeting
Area, Lvr/DR Combo
Vaulted/Cathedral Ceiling
Range, Work Island, Dishwasher, Garbage Disposal, Microwave, Pantry, Stainless Steel Apps., Solid Surface Countertops
1st Floor Bedrooms, 1st Floor Baths, Laundry/Utility
Electricity, Water Public, Sewer, Cable TV, Underground Utilities, Telephone
Patio, Front Porch
Vinyl Siding
Slab
Central Heat, Central Air, Electric
Single Level
Attached 2-Car
4
Electric
0.41
Rectangular
Inside City Limits
Electricity, Water Public, Sewer, Cable TV, Underground Utilities, Telephone
9-9-2025
Home Owners Assoc. Fees, Restrictions, Owner Allowed Motorcycle, Owner Allowed Golf Cart, Owner Allowed Pet
Rosehaven
21D Conway central between 501&
Horry
36904040027
$9
Pee Dee Elementary School
Whittemore Park Middle School
Conway High School
Copyright 2026 Coastal Carolinas Association of REALTORS®, Inc.
Information Deemed Reliable, but Not Guaranteed.
