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

4075 Dewberry Ln., Myrtle Beach, SC 29579

Overview:

Excellent opportunity to own a smart home with 5bed, 3 1/2 baths in the desirable Waterbridge in Carolina Forest! This beautiful home sits on a 0.57 acres, backs up to wetlands and all fenced in backyard so you will always have that advantageous privacy! Master bedroom is located downstairs and all other bedrooms plus a huge sitting area upstairs. Waterbridge is a gated community with a resort style pool considered the largest residential pool in South Carolina, clubhouse, fitness center, pickleball courts, basketball court, tennis courts, volleyball court, a huge lake with boat launch. You will have to see it to believe it! Schedule your showing today!

Listing Courtesy Of:

Palms Realty

Original Price:

$544,900

Year Built:

2023

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

Detached

Total Square Feet:

3980

Total Heated Sq. Ft.:

3221

Interior Features

Style:

Traditional

Interior Features:

Wind Treat Convey, Garage Door Opener, Stairs To Attic, Smoke Detector, Wshr/Dryer Connection

Bedrooms:

5

Full Baths:

3

Half Baths:

1

Formal Dining Room:

Yes

Master Bedroom:

1st Flr Level, Walk-in Closet

Floor Cover:

Carpeting, Laminate, Tile

Dining Room:

Formal

Kitchen:

Dishwasher, Double Oven, Garbage Disposal, Microwave, Pantry, Range, Refrigerator, Solid Surface Countertops, Stainless Steel Apps., Work Island

Other Rooms:

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

Master Bathroom:

Double Sink, Shower, Vanity

Utilities Available:

Cable TV, Electricity, Natural Gas, Sewer, Telephone, Water Public

Exterior

Exterior Features:

Patio, Balcony, Front Porch, Rear Porch, Fencing, Lawn Sprinkler, Insulated Doors/Windows

Exterior Finish:

Concrete Fiber Siding, Wood Frame

Foundation:

Slab

Heating and Cooling:

Central Air, Central Heat, Electric, Gas

Levels:

Two-Story

Type of Parking:

Attached 2-Car

Parking Capacity:

4

Water Heater:

Gas, Tankless

Lot Details

Acres:

0.57

Lot Description:

Irregular

Lot Location:

Outside City Limits

Utilities Available:

Cable TV, Electricity, Natural Gas, Sewer, Telephone, Water Public

Listing Date:

4-26-2024

Community Infomation

Amenities:

Home Owners Assoc. Fees, Restrictions, Clubhouse/Rec/Facilities, Pool - Outdoor Community, Tennis Court, Security, Seller Disclosure, Gated Community, Long Term Rental Allowed, Owner Allowed Motorcycle, Tenant Allowed Motorcycle, Owner Allowed Golf Cart, Owner Allowed Pet, Boat Ramp

Area Information

Section/Subdivision:

Waterbridge

Area:

10B Myrtle Beach Area--Carolina

County:

Horry

Tax Map Number:

39703040030

Association Information

Estimated Monthly POA Amount:

$150

Association Fee Includes:

Common Maint/Repair, Electric Common, Manager, Pool Service, Recreation Facilities, Security

Schools

Elementary School:

Ocean Bay Elementary School

Middle School:

Ten Oaks Middle

High School:

Carolina Forest High School

Would you like to see this property?

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