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

4878 Luster Leaf Circle, 402, Myrtle Beach, SC 29577

Beautifully maintained and move-in ready, this stunning 2-bedroom, 2-bath condo is located in the highly sought-after Magnolia Pointe community. Featuring a bright open-concept floor plan with brand new carpet throughout, this top-floor unit offers comfort, style, and convenience. The spacious primary suite boasts his-and-hers walk-in closets, a sunny bay window, and an en suite bathroom with a tub/shower combo. The second bedroom is conveniently located near the hall bath and full-size washer and dryer. The kitchen is ideal for entertaining with a large peninsula island, bar seating, and open sightlines to the living area. Sliding glass doors fill the space with natural light and lead to a private patio with stunning sunset views over the golf course. Situated on the 4th floor with elevator access and cathedral ceilings, this condo comfortably sleeps six and comes fully furnished—everything you see is included. Magnolia Pointe is a beautifully landscaped golf course community offering multiple pools and a quiet, relaxed atmosphere just minutes from the beach, Broadway at the Beach, dining, shopping, golf, and top entertainment venues. Perfect as a full-time residence, vacation getaway, or a strong rental investment opportunity.

Listing Courtesy Of:

Century 21 Stopper &Associates

Original Price:

$244,900

Year Built:

2006

Unit:

402

Building Location:

On Golf Course,Outside City Limits

Unit Location:

Golf Course View,Top Floor

Date Input:
4-26-2025
Listing Date:
4-26-2025
Floor Number:

04

Total Square Feet:

1120

Total Heated Sq. Ft.:

1070

Total Square Feet:

0

Interior Features

Interior Features:

Smoke Detector,Washer/Dryer,Wshr/Dryer Connection

Levels:

Single Level

Bedrooms:

2

Full Baths:

2

Half Baths:

0

Furnished:

Yes

Floor Cover:

Carpeting,Tile

Dining Room:

Area,Ceiling Fan,Lvr/DR Combo

Kitchen:

Dishwasher,Garbage Disposal,Refrigerator,Range,Breakfast Bar,Oven,Microwave

Dining Room:

Area,Ceiling Fan,Lvr/DR Combo

Living Room:

Ceiling Fan,Vaulted/Cathedral Ceiling

Kitchen:

Dishwasher,Garbage Disposal,Refrigerator,Range,Breakfast Bar,Oven,Microwave

Other Rooms:

Laundry/Utility

Utilities Available:

Cable TV,Sewer,Water Public

Water Heater:

Electric

Heating and Cooling:

Central Heat,Central Air

Exterior

Building Style:

Mid-Rise 4-6 Stories

Exterior Features:

Balcony,Pool-Outdoor Private,Outside Storage Attached

Foundation:

Slab

Parking:

Parking Lot

Levels:

Single Level

Type of Parking:

Yes

Parking Capacity:

Parking Lot

Community Infomation

Amenities:

Clubhouse/Rec/Facilities,Pool-Outdoor Community,Restrictions,Security,Home Owners Assn Fee,Short Term Rental Allowed,Long Term Rental Allowed,Trash Pickup,Cable TV,Internet Access,Lawn Maintenance

Lot Description:

Other

Area Information

Area:

16D Myrtle Beach Area--48th Ave

County:

Horry

Tax Map Number:

42000000760

Association Information

Estimated Monthly POA Amount:

$334

No information available

Schools

Elementary School:

Myrtle Beach Elementary School

Middle School:

Myrtle Beach Middle School

High School:

Myrtle Beach High School

MLS Number:

2510495

Call Us:

843.212.6852

Would you like to see this property?

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