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

2951 Mary Hines Ln., Georgetown, SC 29440

Overview:

Beautifully Renovated Open Floorplan, 3 bedroom 2 bath home just 10 minutes for Historic Downtown Georgetown and One mile form Winyah Bay. The home features a New roof, New HVAC, New Kitchen Countertops and Black Appliances, New vanities and bathroom amenities, New fixtures and faucets, New paint, New flooring and more. The home is at the end of a cul de sac road, private lot within city limits, with NO HOA. Store your boat, vehicle or belongings in the attached extra long garage. Watch the sunrise and listen to the birds flying over the bay in the Newly Screen and Sealed Floor Porch. Just a delightful must see home.

Listing Courtesy Of:

Century 21 Palms Realty

Original Price:

$330,000

Year Built:

2004

Date Input:
5-12-2025
Listing Date:
5-12-2025
Type:

Detached

Total Square Feet:

1540

Total Heated Sq. Ft.:

1430

Interior Features

Style:

Ranch

Interior Features:

Security System, Wshr/Dryer Connection, Split Bedroom Plan

Bedrooms:

3

Full Baths:

2

Half Baths:

0

Formal Dining Room:

Yes

Family Room/Great Room:

Wet Bar, Ceiling Fan

Floor Cover:

Vinyl, Luxury Vinyl Plank/Tile

Dining Room:

Lvr/DR Combo

Living Room:

Ceiling Fan

Kitchen:

Range, Dishwasher, Garbage Disposal, Refrigerator, Microwave, Breakfast Bar, Pantry, Ceiling Fan

Other Rooms:

1st Floor Bedrooms, 1st Floor Baths, Screened Porch

Utilities Available:

Electricity, Water Public, Septic

Exterior

Exterior Features:

Rear Porch

Exterior Finish:

Vinyl Siding

Foundation:

Slab

Heating and Cooling:

Central Heat, Forced Air, Central Air, Electric

Levels:

Single Level

Type of Parking:

Attached 2-Car

Parking Capacity:

3

Water Heater:

Electric

Lot Details

Acres:

0.29

Lot Description:

Rectangular

Estimated Lot Size (in feet):

76x165x76x165 ft

Utilities Available:

Electricity, Water Public, Septic

Listing Date:

5-12-2025

Community Infomation

Amenities:

Short Term Rental Allowed, Long Term Rental Allowed

Area Information

Section/Subdivision:

Not within a Subdivision

Area:

47A Georgetown Area--Maryville/s

County:

Georgetown

Tax Map Number:

05-0051-007-09-00

Association Information

Estimated Monthly POA Amount:

$0

Schools

Elementary School:

Maryville Elementary School

Middle School:

Georgetown Middle School

High School:

Georgetown High School

Would you like to see this property?

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