Iris & Howard Real Estate
Query
Template: /themes/irishoward/modules/myrtle-beach-mls/realcfc/mlsnew.cfc:184
Execution Time: 0.208 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_valuedisplayurlareas
154A Andrews Are--includes city oAndrewsandrews54A
217A Aynor Area--central includesAynoraynor17A,12A,13A
325B Conway Area--between Wacc. RConwayconway25B,21A,21B,21D,21C,21E,14A,15A,23A,20A,18A,22A,15B,23B
409A Conway to Longs Area--BetweeConway to Longsconway-to-longs09A,09B
510A Conway to Myrtle Beach Area-Conway to Myrtle Beachconway-to-myrtle-beach10A
627A Garden City Mainland & PenniGarden Citygarden-city27A,28C
748A Georgetown Area--Belle IsleGeorgetowngeorgetown48A,52A,53A,46A,50A,47A,49A,51A
841A Pawleys Island Area-LitchfieLitchfield Beachlitchfield-beach41A,42A
904B Little River Area--North ofLittle Riverlittle-river04B,04A
1003A Longs to Little River Area--Longs to Little Riverlongs-to-little-river03A
1102A Loris Area--central includesLorisloris02A,05A,01A
1206A Loris to Conway Area--SouthLoris to Conwayloris-to-conway06A,08A
1307A Loris to Longs Area--South oLoris to Longsloris-to-longs07A,03B
1427B Murrells Inlet - Horry CountMurrells Inletmurrells-inlet27B,40A
1525A Myrtle Beach Area--west of SMyrtle Beachmyrtle-beach25A,10B,24A,26A,16F,16E,16D,16C,16B,16A,16G,26B,16J,19A,24B
1631B North CarolinaNorth Carolinanorth-carolina31B
1711D North Myrtle Beach Area--AtlNorth Myrtle Beachnorth-myrtle-beach11D,10C,11A,11C,11B,11F,11E
1831A Other counties in South CaroOther Countiesother-counties31A
1931C Not in South Carolina or NorOther Statesother-states31C
2045A Pawleys Island AreaPawleys Islandpawleys-island45A,43A,44A,45B
2128B Surfside Area-Glensbay to GCSurfsidesurfside28B,29A,29B,28A
Query
Template: /themes/irishoward/page_templates/mls.cfm:75
Execution Time: 0.228 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_valuedisplayurlareas
154A Andrews Are--includes city oAndrewsandrews54A
217A Aynor Area--central includesAynoraynor17A,12A,13A
325B Conway Area--between Wacc. RConwayconway25B,21A,21B,21D,21C,21E,14A,15A,23A,20A,18A,22A,15B,23B
409A Conway to Longs Area--BetweeConway to Longsconway-to-longs09A,09B
510A Conway to Myrtle Beach Area-Conway to Myrtle Beachconway-to-myrtle-beach10A
627A Garden City Mainland & PenniGarden Citygarden-city27A,28C
748A Georgetown Area--Belle IsleGeorgetowngeorgetown48A,52A,53A,46A,50A,47A,49A,51A
841A Pawleys Island Area-LitchfieLitchfield Beachlitchfield-beach41A,42A
904B Little River Area--North ofLittle Riverlittle-river04B,04A
1003A Longs to Little River Area--Longs to Little Riverlongs-to-little-river03A
1102A Loris Area--central includesLorisloris02A,05A,01A
1206A Loris to Conway Area--SouthLoris to Conwayloris-to-conway06A,08A
1307A Loris to Longs Area--South oLoris to Longsloris-to-longs07A,03B
1427B Murrells Inlet - Horry CountMurrells Inletmurrells-inlet27B,40A
1525A Myrtle Beach Area--west of SMyrtle Beachmyrtle-beach25A,10B,24A,26A,16F,16E,16D,16C,16B,16A,16G,26B,16J,19A,24B
1631B North CarolinaNorth Carolinanorth-carolina31B
1711D North Myrtle Beach Area--AtlNorth Myrtle Beachnorth-myrtle-beach11D,10C,11A,11C,11B,11F,11E
1831A Other counties in South CaroOther Countiesother-counties31A
1931C Not in South Carolina or NorOther Statesother-states31C
2045A Pawleys Island AreaPawleys Islandpawleys-island45A,43A,44A,45B
2128B Surfside Area-Glensbay to GCSurfsidesurfside28B,29A,29B,28A

3906 Seaview St., North Myrtle Beach, SC 29582

Overview:

LOCATION LOCATION LOCATION!!! 4 BEDROOM 3 1/2 BATH 3RD ROW BEACH HOUSE IN THE WINDY HILL SECTION OF NORTH MYRTLE BEACH. KITCHEN HAS GRANITE COUNTER TOPS. DOWNSTAIRS HAS LUXURY VYNAL PLANK FLOORING. HOME HAS AN OPEN FLOOR FLOOR PLAN WITH 2 BEDROOMS DOWNSTAIRS AND 2 BEDROOMS UP STAIRS. BACKYARD HAS PLENTY OF ROOM FOR POOL, HOME WOULD BE AN EXCELLENT VACATION RENTAL. SHORT STROOL TO WINDY HILL BEACHES AND THE BIG BLUE ATLANTIC. SET UP YOUR SHOWING TODAY!

Listing Courtesy Of:

Snead Realty Group

Original Price:

$525,000

Year Built:

1953

Date Input:
4-23-2024
Listing Date:
4-23-2024
Type:

Detached

Total Square Feet:

2224

Total Heated Sq. Ft.:

2224

Interior Features

Style:

Other

Interior Features:

Wind Treat Convey, Smoke Detector, Wshr/Dryer Connection, Washer/Dryer, Split Bedroom Plan, Furnished, Lead Based Paint Disclose

Bedrooms:

4

Full Baths:

3

Half Baths:

1

Formal Dining Room:

Yes

Family Room/Great Room:

Ceiling Fan

Floor Cover:

Carpeting, Luxury Vinyl Plank/Tile

Dining Room:

Area

Kitchen:

Dishwasher, Microwave, Pantry, Range, Refrigerator, Solid Surface Countertops, Stainless Steel Apps.

Other Rooms:

1st Floor Baths, 1st Floor Bedrooms, Laundry/Utility

Utilities Available:

Cable TV, Electricity, Sewer, Telephone, Water Public

Exterior

Exterior Features:

Front Porch

Foundation:

Crawl

Heating and Cooling:

Central Air, Central Heat, Electric

Levels:

Two-Story

Type of Parking:

DRIVEWAY

Parking Capacity:

4

Water Heater:

Electric

Lot Details

Acres:

0.16

Lot Location:

Inside City Limits, East of Bus 17, Oceanview Lot

Utilities Available:

Cable TV, Electricity, Sewer, Telephone, Water Public

Listing Date:

4-23-2024

Community Infomation

Amenities:

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

Area Information

Section/Subdivision:

Windy Hill Beach

Area:

11E North Myrtle Beach Area--Win

County:

Horry

Tax Map Number:

39104040102

Association Information

Estimated Monthly POA Amount:

$0

Schools

Elementary School:

Ocean Bay Elementary School

Middle School:

North Myrtle Beach Middle School

High School:

North Myrtle Beach High School

Would you like to see this property?

Copyright 2024 Coastal Carolinas Association of REALTORS®, Inc.
Information Deemed Reliable, but Not Guaranteed.