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

3814 Palmetto Dr., Myrtle Beach, SC 29577

Overview:

Premium property located on the 2nd hole of Myrtlewood Palmetto Golf course. Enjoy your morning coffee in private on the huge deck overlooking natures majestic views of the course, or potentially see the mast of a sailboat cruising the intercostal waterway. Lots of walking and biking trails around the Plantation Point general area. The house has been updated with new carpet, new paint, granite countertops, new tile, vanities in master bathroom, and the second full bathroom as well. Air conditioner and heating system has been replaced, new stove and dishwasher. Enjoy your morning coffee surrounded by the mature landscaping on the huge deck overlooking the golf course. The rare Myer's lemon tree produces a bounty of fruit every year, perfect for tea or cocktails. Vaulted ceilings inside, wet bar, parkay floors, new ceramic tile and carpet. TONS OF STORAGE. The kitchen boasts a view of the golf course, granite countertops, tile backsplash, and stainless steel appliances. The color scheme is bright, yet neutral, and gives the layout a more comfortable feel. Close to all dining, shopping, golf, boating, and the Atlantic Ocean. Take your golf cart to the beach or to Myrtlewood for a round of golf. This home has it all for the buyer that wants to be close to everything. All measurements, features, and figures are approximate and not guaranteed. It is the responsibility of the buyer to verify any and all.

Listing Courtesy Of:

Circa Real Estate

Original Price:

$485,000

Year Built:

1981

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

Detached

Total Square Feet:

2317

Total Heated Sq. Ft.:

2200

Interior Features

Style:

Traditional

Bedrooms:

3

Full Baths:

2

Half Baths:

0

Formal Dining Room:

No

Exterior

Type of Parking:

DRIVEWAY

Parking Capacity:

6

Lot Details

Acres:

0.25

Listing Date:

4-23-2024

Community Infomation

Area Information

Section/Subdivision:

Fairway Pointe

Area:

16E Myrtle Beach Area--29th Ave

County:

Horry

Tax Map Number:

42010040058

Association Information

Estimated Monthly POA Amount:

$67

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.