Exceptional development opportunity on approximately 2.8 acres of prime commercial acreage located on Hard Scrabble Road in Richland County, SC, at the entrance to the established Hester Woods subdivision. Zoned R-5, allowing for up to 12 units per acre (note: single-family homes and duplexes are prohibited), this property offers significant potential for multi-family or attached residential development. With a 2018 traffic count of 17, 900 vehicles per day, the site boasts excellent visibility and access along one of the area’s major corridors. The mostly cleared, level terrain and proximity to existing residential neighborhoods, schools, shopping, and other amenities make this an ideal location for a high-density residential project. Utilities are nearby, and the seller is highly motivated. Don’t miss this rare opportunity in a fast-growing area. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.
Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty Object
(
[post_id] => 136372
[post_author] => 1
[ListingKey] => 641795
[ListingId] => 641795
[PropertyType] => Land
[StandardStatus] => Active
[ModificationTimestamp] => 2026-08-28T00:24:24Z
[RFModificationTimestamp] => 2026-08-28T00:27:16Z
[ListPrice] => 34900
[BathroomsTotalInteger] => 0
[BathroomsHalf] => 0
[BedroomsTotal] => 0
[LotSizeArea] => 0.29
[LivingArea] => 0
[BuildingAreaTotal] => 0
[City] => Columbia
[PostalCode] => 29203
[UnparsedAddress] => 126 Broomfield Street, Columbia, SC 29203
[Coordinates] => Array
(
[0] => -80.989055
[1] => 34.064103
)
[Latitude] => 34.064103
[Longitude] => -80.989055
[YearBuilt] => 0
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListOfficeName] => LPT Realty LLC
[ListAgentMlsId] => 14754
[ListOfficeMlsId] => 1744
[OriginatingSystemName] => columbiamls
[PublicRemarks] => Build your next home on this .29-acre residential lot in Columbia. Former homesite with City of Columbia water and septic service previously serving the property. Zoned RM-1 with approximately 67 feet of road frontage. Conveniently located near shopping, schools, and major roadways. Buyer to verify zoning, utility connection status, septic condition, setbacks, building requirements, and suitability for intended use. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.
[AssociationYN] =>
[BuildingAreaUnits] => Sqft
[CountyOrParish] => Richland
[CreationDate] => 2026-08-28T00:26:41.694847+00:00
[Directions] => From I-20, take Farrow Rd north toward Columbia. Turn onto Broomfield St. Property will be on the right at 126 Broomfield St.
[InternetEntireListingDisplayYN] => 1
[ListAgentEmail] => realtorbjohnson@gmail.com
[LivingAreaUnits] => Sqft
[LotSizeUnits] => Sqft
[MlsStatus] => ACTIVE
[OriginalEntryTimestamp] => 2026-08-27
[PhotosChangeTimestamp] => 2026-08-28T00:24:24Z
[PhotosCount] => 1
[RoadFrontageType] => City
[RoadSurfaceType] => Paved
[Sewer] => Septic
[StateOrProvince] => SC
[StreetName] => Broomfield Street
[StreetNumber] => 126
[SubdivisionName] => NONE
[WaterSource] => Public
[TMS] => 14208-02-23
[Address] => 126 Broomfield Street
[LVTDate] => 2026-08-27
[HighSchool] => Keenan High
[class_name] => LD_2
[LA1UserCode] => JOHNSBRI
[MiddleSchool] => Sanders
[GeoSubdivision] => SC
[SchoolDistrict] => Richland One
[LO1MainOfficeID] => 1744
[ElementarySchool] => Greenview
[LA1AgentLastName] => Johnson
[RollbackTax(Y/N)] => No
[LA1AgentFirstName] => Brian
[GeoUpdateTimestamp] => 2026-08-28T00:24:23
[AddressSearchNumber] => 126
[LO1OfficeIdentifier] => 1744
[ListingTypeAgreement] => Exclusive Right to Sell
[PublishtoInternetY/N] => Yes
[LA1AgentMiddleInitial] => W
[LO1OfficeAbbreviation] => LPTR01
[FirstPhotoAddTimestamp] => 2026-08-28T00:24:24.2
[Media] => Array
(
[0] => Array
(
[Order] => 0
[MediaKey] => 6417950
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641795/9eaef6e495d1d303f2b60c515867ed4c.webp
[ClassName] =>
[MediaSize] => 1042627
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641795/thumbnail-9eaef6e495d1d303f2b60c515867ed4c.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641795
)
)
[DaysOnMarket] => 0
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('641795')
[ID] => 136372
)
MLS On The Fly Debug Panel
Array
(
[RF Query: /Property?$select=ALL&$top=20&$filter=(PropertyType eq 'Land' or PropertyType eq 'Residential' or PropertyType eq 'Residential Income') and ListingKey eq 577469 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true] => Array
(
[RF Response] => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse Object
(
[items] => Array
(
[0] => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty Object
(
[post_id] => 101241
[post_author] => 1
[ListingKey] => 577469
[ListingId] => 577469
[PropertyType] => Land
[StandardStatus] => Pending
[ModificationTimestamp] => 2026-06-24T19:17:01Z
[RFModificationTimestamp] => 2026-06-24T19:24:56Z
[ListPrice] => 100000
[BathroomsTotalInteger] => 0
[BathroomsHalf] => 0
[BedroomsTotal] => 0
[LotSizeArea] => 2.8
[LivingArea] => 0
[BuildingAreaTotal] => 0
[City] => Columbia
[PostalCode] => 29229
[UnparsedAddress] => 0 Hard Scrabble Road, Columbia, SC 29229
[Coordinates] => Array
(
[0] => -80.9260754
[1] => 34.13108386
)
[Latitude] => 34.13108386
[Longitude] => -80.9260754
[YearBuilt] => 0
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListOfficeName] => Southern Visions Realty I LLC
[ListAgentMlsId] => 11313
[ListOfficeMlsId] => 357
[OriginatingSystemName] => columbiamls
[PublicRemarks] => Exceptional development opportunity on approximately 2.8 acres of prime commercial acreage located on Hard Scrabble Road in Richland County, SC, at the entrance to the established Hester Woods subdivision. Zoned R-5, allowing for up to 12 units per acre (note: single-family homes and duplexes are prohibited), this property offers significant potential for multi-family or attached residential development. With a 2018 traffic count of 17,900 vehicles per day, the site boasts excellent visibility and access along one of the area’s major corridors. The mostly cleared, level terrain and proximity to existing residential neighborhoods, schools, shopping, and other amenities make this an ideal location for a high-density residential project. Utilities are nearby, and the seller is highly motivated. Don’t miss this rare opportunity in a fast-growing area. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.
[AssociationYN] =>
[BuildingAreaUnits] => Sqft
[CountyOrParish] => Richland
[CreationDate] => 2025-03-21T02:34:44.566995+00:00
[Directions] => North on Hardscrabble Rd. Just before Hester Woods Dr.
[InternetEntireListingDisplayYN] => 1
[ListAgentEmail] => rkelly@svrealty.com
[LivingAreaUnits] => Sqft
[LotSizeUnits] => Sqft
[MlsStatus] => PENDING
[OriginalEntryTimestamp] => 2024-01-19
[PhotosChangeTimestamp] => 2026-06-24T19:17:01Z
[PhotosCount] => 1
[RoadFrontageType] => State
[RoadSurfaceType] => Paved
[Sewer] => Public
[StateOrProvince] => SC
[StreetName] => Hard Scrabble
[StreetNumber] => 0
[StreetSuffix] => Road
[SubdivisionName] => NONE
[WaterSource] => Public
[Zoning] => R5
[TMS] => 20104-03-01
[Address] => 0 Hard Scrabble Road
[LVTDate] => 2024-01-19
[HighSchool] => Westwood
[Topography] => Level
[class_name] => LD_2
[LA1UserCode] => KELLYWR
[MiddleSchool] => Longleaf
[RoadFrontage] => 590
[ShortSaleY/N] => No
[AgentHitCount] => 309
[GeoSubdivision] => SC
[SchoolDistrict] => Richland Two
[LO1MainOfficeID] => 357
[ElementarySchool] => Killian
[LA1AgentLastName] => Kelly
[RollbackTax(Y/N)] => Unknown
[LA1AgentFirstName] => W Rhett
[ForeclosedProperty] => No
[GeoUpdateTimestamp] => 2024-01-19T17:22:00.5
[AddressSearchNumber] => 0
[LO1OfficeIdentifier] => 357
[ListingTypeAgreement] => Exclusive Right to Sell
[PublishtoInternetY/N] => Yes
[LO1OfficeAbbreviation] => SOUV01
[FirstPhotoAddTimestamp] => 2024-01-19T17:22:00.7
[Media] => Array
(
[0] => Array
(
[Order] => 0
[MediaKey] => 5774690
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/577469/7af76516a646018fd4fa822598ca2d54.webp
[ClassName] =>
[MediaSize] => 361775
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/577469/thumbnail-7af76516a646018fd4fa822598ca2d54.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 577469
)
)
[DaysOnMarket] =>
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('577469')
[ID] => 101241
)
)
[success] => 1
[page_size] => 1
[page_count] => 1
[count] => 1
[after_key] =>
)
[RF Response Time] => 0.13 seconds
)
)
MLS On The Fly Debug Panel
[Warning] Undefined array key "file" in /nas/content/live/wilsonprd/wp-content/plugins/houzez-theme-functionality/extensions/meta-box/inc/fields/image.php on line 147