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

2726 Hugo Rd., Conway, SC 29527

Overview:

Live Oak floor plan sitting on a .50 acre lot with NO HOA! This floor plan features 3 BR/ 2 BA with solid surface counter tops in the kitchen and bathrooms, LVP flooring throughout the house. The Live Oak plan has 10 ft ceiling in family room. Stainless steel appliances in the kitchen, ceiling fan in the living room and master bedroom, finished garage with paint, sprinklers and much more. A must see! Just a short drive to Downtown Conway. Estimated completion is mid to end of August 2024. ** Finished pictures are from a previously built, similar home. They are for reference only as some of the features may have been changed.**

Listing Courtesy Of:

Sansbury Butler Properties

Original Price:

$307,900

Year Built:

2024

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

Detached

Total Square Feet:

2315

Total Heated Sq. Ft.:

1606

Interior Features

Style:

Traditional

Interior Features:

Garage Door Opener, Smoke Detector, Wshr/Dryer Connection, Split Bedroom Plan

Bedrooms:

3

Full Baths:

2

Half Baths:

0

Formal Dining Room:

No

Family Room/Great Room:

Ceiling Fan

Master Bedroom:

1st Flr Level, Ceiling Fan, Tray Ceiling, Walk-in Closet

Floor Cover:

Luxury Vinyl Plank/Tile

Dining Room:

Lvr/DR Combo

Kitchen:

Breakfast Bar, Dishwasher, Microwave, Pantry, Range, Solid Surface Countertops, Stainless Steel Apps., Work Island

Other Rooms:

1st Floor Baths, 1st Floor Bedrooms, Laundry/Utility

Master Bathroom:

Double Sink, Shower

Utilities Available:

Electricity, Sewer, Water Public

Exterior

Exterior Features:

Front Porch, Rear Porch, Lawn Sprinkler

Exterior Finish:

Vinyl Siding

Foundation:

Slab

Heating and Cooling:

Central Air, Central Heat, Electric

Levels:

Single Level

Type of Parking:

Attached 2-Car

Parking Capacity:

4

Water Heater:

Electric

Lot Details

Acres:

0.5

Lot Description:

Rectangular

Utilities Available:

Electricity, Sewer, Water Public

Listing Date:

4-26-2024

Community Infomation

Area Information

Section/Subdivision:

Not within a Subdivision

Area:

22A Conway Area--Southwest side

County:

Horry

Tax Map Number:

37911010002

Association Information

Estimated Monthly POA Amount:

$0

Schools

Elementary School:

South Conway Elementary School

Middle School:

Whittemore Park Middle School

High School:

Conway High School

MLS Number:

2410242

Call Us:

843.212.6852

Would you like to see this property?

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

By continuing to use this website, you consent to the use of cookies in accordance with our privacy policy.

View Privacy Policy