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

2008 Pint Circle, Longs, SC 29568

Overview:

Welcome to 2008 Pint Cir in Longs, SC — a beautifully finished 3-bedroom, 2-bath single-wide home offering 1,216 sq ft of upgraded living space on a spacious .24-acre lot with no HOA. Inside, enjoy full drywall construction, luxury vinyl plank flooring, and a modern kitchen with stainless steel appliances and shaker cabinetry. The smart split-bedroom floorplan offers privacy and functionality. Conveniently located near Hwy 90, Hwy 9, and Hwy 22. Eligible for Conventional, FHA, VA & USDA financing — a rare find at this price point. Own your land and your home!

Virtual Tour
Listing Courtesy Of:

Keller Williams The Forturro G

Original Price:

$199,999

Year Built:

2025

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

Manufactured with Land

Total Square Feet:

1216

Total Heated Sq. Ft.:

1216

Interior Features

Style:

Single Wide

Interior Features:

Wshr/Dryer Connection

Bedrooms:

3

Full Baths:

2

Half Baths:

0

Formal Dining Room:

No

Floor Cover:

Laminate

Dining Room:

Kit/DR Combo

Kitchen:

Range, Refrigerator, Range Hood, Stainless Steel Apps.

Other Rooms:

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

Utilities Available:

Electricity, Water Public, Sewer, Septic, Cable TV, Underground Utilities, Telephone

Exterior

Exterior Finish:

Vinyl Siding

Foundation:

Crawl

Heating and Cooling:

Central Heat, Forced Air, Central Air, Electric

Levels:

Single Level

Type of Parking:

DRIVEWAY

Parking Capacity:

4

Water Heater:

Electric

Lot Details

Acres:

0.24

Utilities Available:

Electricity, Water Public, Sewer, Septic, Cable TV, Underground Utilities, Telephone

Listing Date:

12-31-2025

Community Infomation

Area Information

Section/Subdivision:

Not within a Subdivision

Area:

07A Loris to Longs Area--South o

County:

Horry

Tax Map Number:

31614020008

Association Information

Estimated Monthly POA Amount:

$0

Schools

Elementary School:

Riverside Elementary

Middle School:

North Myrtle Beach Middle School

High School:

North Myrtle Beach High School

MLS Number:

2530174

Call Us:

843.212.6852

Would you like to see this property?

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