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

336 Piedmont Ave., Myrtle Beach, SC 29577

Overview:

Welcome to your dream home nestled within the picturesque waterway community! This stunning residence boasts 4 bedrooms and 3 bathrooms, offering ample space for comfortable living and entertaining. As you step inside, be prepared to be bathed in natural light streaming through numerous windows, illuminating the elegant interiors with a warm and inviting ambiance. The spacious layout seamlessly blends functionality with style, creating an ideal setting for both relaxation and gatherings. The heart of the home is undoubtedly the well-appointed kitchen, complete with ample cabinetry, and a convenient center island perfect for meal preparation. Whether you're whipping up a quick breakfast or hosting a dinner party, this kitchen is sure to inspire your culinary adventures. Retreat to the luxurious primary suite, where tranquility awaits. Featuring a generously sized bedroom, a spa-like ensuite bathroom, and ample closet space, this private oasis is your sanctuary from the hustle and bustle of everyday life. Located in a desirable waterway community, with no HOA restrictions your, you're free to make this home truly your own. Conveniently situated close to an array of restaurants, shops, and recreational activities, you'll never be far from entertainment and excitement. Whether you're exploring the local dining scene, hitting the shops, or enjoying outdoor adventures, everything you need is right at your fingertips, including Myrtle Beach Airport. Don't miss your chance to own this exceptional home in a coveted location. Schedule your private showing today and start living the lifestyle you've always dreamed of!

Listing Courtesy Of:

Agent Group Realty - MB

Original Price:

$387,500

Year Built:

1971

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

Detached

Total Square Feet:

2876

Total Heated Sq. Ft.:

2587

Interior Features

Style:

Ranch

Bedrooms:

4

Full Baths:

3

Half Baths:

0

Formal Dining Room:

Yes

Exterior

Type of Parking:

Attached 2-Car

Parking Capacity:

4

Lot Details

Acres:

0.43

Listing Date:

4-19-2024

Community Infomation

Area Information

Section/Subdivision:

Waterside-Area 16G

Area:

16G Myrtle Beach Area--Southern

County:

Horry

Tax Map Number:

42611020003

Association Information

Estimated Monthly POA Amount:

$0

Schools

Elementary School:

Myrtle Beach Elementary School

Middle School:

Myrtle Beach Middle School

High School:

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.