Iris & Howard Real Estate
Query
Template: /themes/irishoward/modules/myrtle-beach-mls/realcfc/mlsnew.cfc:183
Execution Time: 0.199 ms
Record Count: 21
Cached: Yes
Cache Type: timespan
Datasource: newccar
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: 136 ms
Record Count: 21
Cached: No
Datasource: newccar
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

800 Egret Circle, 34, Little River, SC 29566

Welcome to Bay Tree I, a charming community nestled in the heart of Little River, SC, where coastal living meets everyday convenience! Just 2.3 miles from the beach, this beautifully renovated 4-bedroom, 3-bathroom home offers the perfect blend of comfort, style, and location. Step inside and be greeted by an inviting open floor plan with wood-look tile flooring throughout the main living area, creating a warm and elegant atmosphere. The spacious living room boasts a freshly painted brick gas log fireplace, perfect for cozy evenings, while the newer sliding doors in both the living and dining areas let in plenty of natural light and provide easy access to the outdoors. The updated kitchen is a chef's delight, featuring stainless steel appliances, sleek countertops, and ample cabinet space. Each of the three upgraded bathrooms showcases granite countertops, modern vanities, and updated toilets, adding a touch of luxury to your daily routine. With over 2200 total square feet, this home offers plenty of space for relaxation and entertaining. Plus, as a Bay Tree I homeowner, you'll enjoy access to a private community pool and clubhouse, perfect for unwinding after a day at the beach. Located in desirable Little River, you'll be just minutes from the sandy shores of the Grand Strand, the waterfront dining and entertainment of the Little River waterfront, and world-class golf courses. Hurry and schedule your showing today.

Virtual Tour
Listing Courtesy Of:

Century 21 The Harrelson Group

Original Price:

$249,900

Year Built:

1974

Unit:

34

Building Location:

Outside City Limits

Date Input:
2-20-2025
Listing Date:
2-20-2025
Floor Number:

01

Total Square Feet:

2200

Total Heated Sq. Ft.:

2200

Total Square Feet:

0

Interior Features

Interior Features:

Wshr/Dryer Connection,Lead Based Paint Disc.

Levels:

Two-Story

Bedrooms:

4

Full Baths:

3

Half Baths:

0

Furnished:

Yes

Floor Cover:

Carpeting,Tile

Dining Room:

Lvr/DR Combo

Kitchen:

Dishwasher,Refrigerator,Range,Oven,Microwave,Stainless Steel Apps.

Dining Room:

Lvr/DR Combo

Living Room:

Fireplace

Kitchen:

Dishwasher,Refrigerator,Range,Oven,Microwave,Stainless Steel Apps.

Other Rooms:

First Floor Bedrooms,First Floor Bathrooms

Utilities Available:

Electricity,Sewer,Telephone,Water Public

Water Heater:

Electric

Heating and Cooling:

Central Heat,Central Air,Electric

Exterior

Building Style:

Townhouse

Exterior Features:

Deck

Parking:

Assigned

Levels:

Two-Story

Type of Parking:

Yes

Parking Capacity:

Assigned

Community Infomation

Amenities:

Pool-Outdoor Community,Restrictions,Seller Disclosure,Owner Allowed Pet,Home Owners Assn Fee,Short Term Rental Allowed,Long Term Rental Allowed

Area Information

Area:

04B Little River Area--North of

County:

Horry

Tax Map Number:

31311010412

Association Information

Estimated Monthly POA Amount:

$495

No information available

Schools

Elementary School:

Waterway Elementary

Middle School:

North Myrtle Beach Middle School

High School:

North Myrtle Beach High School

MLS Number:

2504314

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.