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

4608 Mandi Ave., Little River, SC 29566

Overview:

Beautiful 3 bedroom, 2 bathroom single level home, with irrigation system, in the quiet community, Royal Estates in Little River. Featuring a spacious split bedroom floor plan with a large open living area, tall vaulted ceilings, high quality LVP flooring throughout, and more! The kitchen was completed with granite countertops, stainless steel appliances, a breakfast nook overlooking the lush backyard, and a breakfast bar connecting to the great room. Each bedroom offers a ceiling fan, plenty of closet space, and easy access to a bathroom while the master also features tray ceilings, a large walk in closet, and private master bath with a tiled walk in shower and a linen closet. Enjoy your all seasons screened in back porch and your patio for grilling. There is also an abundance of storage space in your two car garage, pantry in the kitchen, and several linen closets throughout the home. Royal Estates is perfectly situated close to all of the Grand Strand's finest dining, shopping, golf, and entertainment attractions! Easy to See! Schedule your showing today!

Listing Courtesy Of:

Century 21 Barefoot Realty

Original Price:

$345,000

Year Built:

2023

Date Input:
7-17-2025
Listing Date:
7-17-2025
Type:

Detached

Total Square Feet:

1892

Total Heated Sq. Ft.:

1328

Interior Features

Style:

Ranch

Interior Features:

Garage Door Opener, Smoke Detector, Wshr/Dryer Connection

Bedrooms:

3

Full Baths:

2

Half Baths:

0

Formal Dining Room:

No

Floor Cover:

Vinyl

Living Room:

Vaulted/Cathedral Ceiling, Ceiling Fan

Kitchen:

Range, Dishwasher, Microwave, Breakfast Bar, Pantry, Breakfast Nook, Range Hood, Stainless Steel Apps., Solid Surface Countertops

Other Rooms:

1st Floor Bedrooms, 1st Floor Baths, Foyer, Laundry/Utility, Screened Porch

Utilities Available:

Electricity, Water Public, Sewer, Cable TV

Exterior

Exterior Features:

Patio

Exterior Finish:

Wood Frame, Masonry Accent

Foundation:

Slab

Heating and Cooling:

Central Heat, Central Air, Electric

Levels:

Single Level

Type of Parking:

Attached 2-Car

Parking Capacity:

4

Water Heater:

Electric

Lot Details

Acres:

0.36

Utilities Available:

Electricity, Water Public, Sewer, Cable TV

Listing Date:

7-17-2025

Community Infomation

Amenities:

Home Owners Assoc. Fees, Restrictions, Seller Disclosure, Long Term Rental Allowed, Owner Allowed Motorcycle, Tenant Allowed Motorcycle, Owner Allowed Golf Cart, Tenant Allowed Golf Cart

Area Information

Section/Subdivision:

Royal Estates

Area:

04A Little River Area--South of

County:

Horry

Tax Map Number:

34903030079

Association Information

Estimated Monthly POA Amount:

$34

Association Fee Includes:

Electric Common, Common Maint/Repair, Legal and Accounting

Schools

Elementary School:

Waterway Elementary

Middle School:

North Myrtle Beach Middle School

High School:

North Myrtle Beach High School

MLS Number:

2517565

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.