Iris & Howard Real Estate
Query
Template: /themes/irishoward/modules/myrtle-beach-mls/realcfc/mlsnew.cfc:184
Execution Time: 0.465 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.409 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

1235 Glenns Bay Rd., Myrtle Beach, SC 29575

Overview:

Fantastic Home in excellent location. Can walk or golf cart to Surfside Beach, grocery stores, restaurants and bars. This home has exceptional value as it is zoned OPI which means this property can be used as a residential home, rental or be used as a professional office including medical, dental, financial, educational, and religious purposes. Copy of code located in associated documents. Horry County can also be contacted directly for questions on specific uses. The home is located only minutes away from Surfside Beach with easy access to Business and Bypass 17.

Listing Courtesy Of:

Gainforth Real Estate

Original Price:

$399,999

Year Built:

1993

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

Detached

Total Square Feet:

1324

Total Heated Sq. Ft.:

1324

Interior Features

Style:

Ranch

Interior Features:

Smoke Detector, Wshr/Dryer Connection

Bedrooms:

3

Full Baths:

2

Half Baths:

0

Formal Dining Room:

No

Master Bedroom:

1st Flr Level

Floor Cover:

Tile, Wood

Dining Room:

Lvr/DR Combo

Living Room:

Ceiling Fan, Vaulted/Cathedral Ceiling

Kitchen:

Microwave, Range, Refrigerator

Other Rooms:

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

Master Bathroom:

Shower, Vanity

Utilities Available:

Cable TV, Electricity, Sewer, Water Public

Exterior

Exterior Features:

Rear Porch, Fencing

Exterior Finish:

Vinyl Siding

Foundation:

Crawl

Heating and Cooling:

Central Air, Central Heat, Electric

Levels:

Single Level

Type of Parking:

DRIVEWAY

Parking Capacity:

2

Water Heater:

Electric

Lot Details

Acres:

0.26

Lot Location:

Outside City Limits, East of Highway 17 Bypass

Utilities Available:

Cable TV, Electricity, Sewer, Water Public

Listing Date:

4-19-2024

Community Infomation

Area Information

Section/Subdivision:

Caropines

Area:

28B Surfside Area-Glensbay to GC

County:

Horry

Tax Map Number:

46101010021

Association Information

Estimated Monthly POA Amount:

$0

Schools

Elementary School:

Seaside Elementary School

Middle School:

Saint James Middle School

High School:

Saint James High School

MLS Number:

2409625

Call Us:

843.212.6852

Would you like to see this property?

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

By continuing to use this website, you consent to the use of cookies in accordance with our privacy policy.

View Privacy Policy