Query Template: /themes/irishoward/modules/myrtle-beach-mls/realcfc/mlsnew.cfc:184 Execution Time: 0.198 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.203 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 |
Your Beach Home Awaits You! This beautiful 3 bed 2 bath home just 6 blocks to the ocean in Windy Hill is perfect for a primary home or a great short term rental. Under the house is 1400 square ft of walk in storage, always dry with a Vapor Barrier! Comes fully furnished, and close to shopping and restaurants galore. No HOA and plenty of parking in the long driveway. Large back yard big enough for a pool or fence it in for the kiddos to play, or both!!
RE/MAX Southern Shores NMB
$549,000
2013
Detached
1456
1456
Ranch
Wind Treat Convey, Smoke Detector, Wshr/Dryer Connection, Washer/Dryer, Split Bedroom Plan, Furnished
3
2
0
No
Vinyl, Tile, Carpeting
Lvr/DR Combo
Ceiling Fan
Range, Dishwasher, Garbage Disposal, Refrigerator, Microwave, Breakfast Bar, Solid Surface Countertops
1st Floor Bedrooms, 1st Floor Baths, Laundry/Utility
Double Sink, Shower
Electricity, Water Public, Sewer, Cable TV, Underground Utilities, Telephone
Front Porch, Outside Storage Attached, Storm Doors, Storm Windows
Block, Vinyl Siding
Crawl
Central Heat, Central Air, Electric
Single Level
DRIVEWAY
4
Electric
0.17
Irregular
Inside City Limits, East of Bus 17
Electricity, Water Public, Sewer, Cable TV, Underground Utilities, Telephone
3-22-2023
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
Windy Hill Beach
11E North Myrtle Beach Area--Win
Horry
39104010066
$0
Ocean Drive Elementary
North Myrtle Beach Middle School
North Myrtle Beach High School
Copyright 2024 Coastal Carolinas Association of REALTORS®, Inc.
Information Deemed Reliable, but Not Guaranteed.