array:2 [
"RF Cache Key: 558a7b6d819911141ba1c379acbaad5c87b2e82d048e0049387e2d8326860fdd" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3214
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3213
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "597996"
+"ListingId": "597996"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Commercial"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-10-04T20:27:03Z"
+"RFModificationTimestamp": "2025-10-04T20:35:02Z"
+"ListPrice": 2950000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 1.31
+"LivingArea": 0
+"BuildingAreaTotal": 18934.0
+"City": "Columbia"
+"PostalCode": "29203"
+"UnparsedAddress": "4100 N Main Street, Columbia, SC 29203"
+"Coordinates": array:2 [
0 => -81.0396069153
1 => 34.0397840956
]
+"Latitude": 34.0397840956
+"Longitude": -81.0396069153
+"YearBuilt": 1987
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "Keller Williams Realty"
+"ListAgentMlsId": "12793"
+"ListOfficeMlsId": "669"
+"OriginatingSystemName": "columbiamls"
+"PublicRemarks": "COMPLETELY RENOVATED, HIGHLY VISIBLE PROFESSIONAL/ MEDICAL OFFICE BUILDING with 8 suites located Downtown Columbia approx. 1-2 miles from PRISMA HEALTH on a high-traffic location on US 21 N. Main St. Plenty of parking around the building with egress/ ingress. Clean restrooms and elevator in building. Several long term tenants in place. Ideal for Medical office or health/financial services etc. This is a great investment opportunity is located on the Comet bus line and less than 5 minutes from downtown with easy access to I-20, I-277. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings."
+"BuildingAreaUnits": "Sqft"
+"Cooling": "Central"
+"CountyOrParish": "Richland"
+"CreationDate": "2025-10-04T20:34:38.788079+00:00"
+"Directions": "I-20 to US 21 N. Main St towards Downtown Columbia. Located on the left across from The Lutheran Theological Seminary"
+"Heating": "Central"
+"ListAgentEmail": "levineglent@gmail.com"
+"LivingAreaUnits": "Sqft"
+"LotSizeUnits": "Sqft"
+"MlsStatus": "ACTIVE"
+"OpenParkingSpaces": "50"
+"OriginalEntryTimestamp": "2024-12-04"
+"PhotosChangeTimestamp": "2025-10-01T07:07:37Z"
+"PhotosCount": "19"
+"Roof": "Built-up"
+"Sewer": "Public"
+"StateOrProvince": "SC"
+"StreetDirPrefix": "N"
+"StreetName": "Main"
+"StreetNumber": "4100"
+"StreetSuffix": "Street"
+"WaterSource": "Public"
+"Zoning": "CAC"
+"TMS": "09214-14-01"
+"Address": "4100 N Main Street"
+"Best Use": "Professional/ Medical Office Space"
+"LVT Date": "2024-12-04"
+"Power On": "Yes"
+"New/Resale": "Resale"
+"class_name": "CI_3"
+"Transaction": "Sale"
+"# of Stories": "2"
+"Construction": "Brick"
+"LA1User Code": "LEVING"
+"Miscellaneous": "Other,Restrooms"
+"Status Detail": "0"
+"Price Per SQFT": "155.8"
+"Short Sale Y/N": "No"
+"Agent Hit Count": "156"
+"Geo Subdivision": "SC"
+"Gross Heated SqFt": "18934"
+"LO1Main Office ID": "669"
+"LA1Agent Last Name": "Levine"
+"Rollback Tax (Y/N)": "No"
+"Foreclosed Property": "No"
+"LA1Agent First Name": "Glen"
+"Geo Update Timestamp": "2024-12-04T19:17:46.9"
+"LO1Office Identifier": "669"
+"Address Search Number": "4100"
+"LO1Office Abbreviation": "KELL01"
+"Listing Type Agreement": "Exclusive Right to Sell"
+"LA1Agent Middle Initial": "T"
+"Publish to Internet Y/N": "Yes"
+"First Photo Add Timestamp": "2024-12-04T19:17:47.5"
+"MlsAreaMajor": "City of Columbia, Denny terrace, Lake Elizabeth"
+"Media": array:19 [
0 => array:11 [
"Order" => 0
"MediaKey" => "5979960"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597996/506c2627a6576047e8fcda090e113cd8.webp"
"ClassName" => "Commercial"
"MediaSize" => 32036
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597996/thumbnail-506c2627a6576047e8fcda090e113cd8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "597996"
]
1 => array:11 [
"Order" => 1
"MediaKey" => "5979961"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597996/a5084534e66bcefc5464c6dd42fb2d6c.webp"
"ClassName" => "Commercial"
"MediaSize" => 32036
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597996/thumbnail-a5084534e66bcefc5464c6dd42fb2d6c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "597996"
]
2 => array:11 [
"Order" => 2
"MediaKey" => "5979962"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597996/bffebe5355415fc230190c4ce53071ab.webp"
"ClassName" => "Commercial"
"MediaSize" => 32217
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597996/thumbnail-bffebe5355415fc230190c4ce53071ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "597996"
]
3 => array:11 [
"Order" => 3
"MediaKey" => "5979963"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597996/0aa551f4a114847d090031b3431da97c.webp"
"ClassName" => "Commercial"
"MediaSize" => 51370
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597996/thumbnail-0aa551f4a114847d090031b3431da97c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "597996"
]
4 => array:11 [
"Order" => 4
"MediaKey" => "5979964"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597996/8d1a095281148995b0444eb79672cb69.webp"
"ClassName" => "Commercial"
"MediaSize" => 53100
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597996/thumbnail-8d1a095281148995b0444eb79672cb69.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "597996"
]
5 => array:11 [
"Order" => 5
"MediaKey" => "5979965"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597996/0cfe0abe99eaf09efd2f54bd8ae0cc97.webp"
"ClassName" => "Commercial"
"MediaSize" => 60807
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597996/thumbnail-0cfe0abe99eaf09efd2f54bd8ae0cc97.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "597996"
]
6 => array:11 [
"Order" => 6
"MediaKey" => "5979966"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597996/a1ebec9edc8badbebbd2bc5b13d9e973.webp"
"ClassName" => "Commercial"
"MediaSize" => 59450
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597996/thumbnail-a1ebec9edc8badbebbd2bc5b13d9e973.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "597996"
]
7 => array:11 [
"Order" => 7
"MediaKey" => "5979967"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597996/9e3fef343bfe81c4e0b162d347c70b72.webp"
"ClassName" => "Commercial"
"MediaSize" => 61723
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597996/thumbnail-9e3fef343bfe81c4e0b162d347c70b72.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "597996"
]
8 => array:11 [
"Order" => 8
"MediaKey" => "5979968"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597996/4480db186d70473cf29b7b0d7899554b.webp"
"ClassName" => "Commercial"
"MediaSize" => 42727
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597996/thumbnail-4480db186d70473cf29b7b0d7899554b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "597996"
]
9 => array:11 [
"Order" => 9
"MediaKey" => "5979969"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597996/8960a52cd0133bf1cf82563de1a03ed8.webp"
"ClassName" => "Commercial"
"MediaSize" => 31372
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597996/thumbnail-8960a52cd0133bf1cf82563de1a03ed8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "597996"
]
10 => array:11 [
"Order" => 10
"MediaKey" => "59799610"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597996/28fea36b1c11bfe8e4385f330dcedfa7.webp"
"ClassName" => "Commercial"
"MediaSize" => 78617
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597996/thumbnail-28fea36b1c11bfe8e4385f330dcedfa7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "597996"
]
11 => array:11 [
"Order" => 11
"MediaKey" => "59799611"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597996/b1eac5429c971ccbd466282f0bf04229.webp"
"ClassName" => "Commercial"
"MediaSize" => 67620
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597996/thumbnail-b1eac5429c971ccbd466282f0bf04229.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "597996"
]
12 => array:11 [
"Order" => 12
"MediaKey" => "59799612"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597996/5e4a72643cdd6d8a956dbd850c65faca.webp"
"ClassName" => "Commercial"
"MediaSize" => 33122
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597996/thumbnail-5e4a72643cdd6d8a956dbd850c65faca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "597996"
]
13 => array:11 [
"Order" => 13
"MediaKey" => "59799613"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597996/db346b09f3c8a5cbf40fa8114cf6e4dd.webp"
"ClassName" => "Commercial"
"MediaSize" => 45469
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597996/thumbnail-db346b09f3c8a5cbf40fa8114cf6e4dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "597996"
]
14 => array:11 [
"Order" => 14
"MediaKey" => "59799614"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597996/20b4e65a076b159e92847eb37dd29745.webp"
"ClassName" => "Commercial"
"MediaSize" => 43406
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597996/thumbnail-20b4e65a076b159e92847eb37dd29745.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "597996"
]
15 => array:11 [
"Order" => 15
"MediaKey" => "59799615"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597996/40d98bd33b34829930e2cb884f96167c.webp"
"ClassName" => "Commercial"
"MediaSize" => 33278
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597996/thumbnail-40d98bd33b34829930e2cb884f96167c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "597996"
]
16 => array:11 [
"Order" => 16
"MediaKey" => "59799616"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597996/b27c53eac0bf9df45f025868d819df3d.webp"
"ClassName" => "Commercial"
"MediaSize" => 43908
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597996/thumbnail-b27c53eac0bf9df45f025868d819df3d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "597996"
]
17 => array:11 [
"Order" => 17
"MediaKey" => "59799617"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597996/7be990bb2173c91f034d9c8b4ca11b7b.webp"
"ClassName" => "Commercial"
"MediaSize" => 51124
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597996/thumbnail-7be990bb2173c91f034d9c8b4ca11b7b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "597996"
]
18 => array:11 [
"Order" => 18
"MediaKey" => "59799618"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597996/adc52a26a364ddb7b8cb603dcf23239f.webp"
"ClassName" => "Commercial"
"MediaSize" => 75829
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597996/thumbnail-adc52a26a364ddb7b8cb603dcf23239f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "597996"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('597996')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
]
"RF Cache Key: f35ef885315804bd78564d540c4a2d2fcb3072b70032422e888697fcb0e0bcf5" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3794
+items: array:4 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3771
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "623098"
+"ListingId": "623098"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Commercial"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-11T04:19:45Z"
+"RFModificationTimestamp": "2025-12-11T04:22:12Z"
+"ListPrice": 800000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 1.56
+"LivingArea": 0
+"BuildingAreaTotal": 1.0
+"City": "Union"
+"PostalCode": "29379"
+"UnparsedAddress": "308 And 310 Buffalo West Spring Highway, Union, SC 29379"
+"Coordinates": array:2 [
0 => -81.641659
1 => 34.730165
]
+"Latitude": 34.730165
+"Longitude": -81.641659
+"YearBuilt": 1900
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ERA Wilder Realty"
+"ListAgentMlsId": "3703"
+"ListOfficeMlsId": "404"
+"OriginatingSystemName": "columbiamls"
+"PublicRemarks": "Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings."
+"BuildingAreaUnits": "Sqft"
+"Cooling": "None"
+"CountyOrParish": "Union"
+"CreationDate": "2025-12-11T04:22:05.614801+00:00"
+"Directions": "From I 26 , exit 52 Follow Hwy 49 N Turn Left Hwy 176 W Turn Left onto Main Street , property on the right less than .2 of a mile"
+"Heating": "None"
+"ListAgentEmail": "jpelje@aol.com"
+"LivingAreaUnits": "Sqft"
+"LotSizeUnits": "Sqft"
+"MlsStatus": "ACTIVE"
+"OpenParkingSpaces": "0"
+"OriginalEntryTimestamp": "2025-12-10"
+"PhotosChangeTimestamp": "2025-12-11T04:19:45Z"
+"PhotosCount": "4"
+"Sewer": "Public"
+"StateOrProvince": "SC"
+"StreetName": "BUFFALO WEST SPRING"
+"StreetNumber": "308 AND 310"
+"StreetSuffix": "Highway"
+"WaterSource": "Public"
+"Zoning": "COMMERCIAL"
+"TMS": "064-00-00-111, 064-00-00-112"
+"Address": "308 AND 310 BUFFALO WEST SPRING Highway"
+"BestUse": "RESTAURANT , RETAIL ,SERVICE"
+"LVTDate": "2025-12-10"
+"PowerOn": "No"
+"#ofStories": "0"
+"New/Resale": "Resale"
+"class_name": "CI_3"
+"LA1UserCode": "EMMERJ"
+"Transaction": "Sale"
+"Construction": "Other"
+"PricePerSQFT": "800000"
+"ShortSaleY/N": "No"
+"StatusDetail": "0"
+"GeoSubdivision": "SC"
+"GrossHeatedSqFt": "1"
+"LO1MainOfficeID": "591"
+"LA1AgentLastName": "Emmerling"
+"RollbackTax(Y/N)": "No"
+"LA1AgentFirstName": "Jeffrey"
+"ForeclosedProperty": "No"
+"GeoUpdateTimestamp": "2025-12-11T04:19:43.8"
+"AddressSearchNumber": "308"
+"LO1OfficeIdentifier": "404"
+"ListingTypeAgreement": "Exclusive Right to Sell"
+"PublishtoInternetY/N": "Yes"
+"LA1AgentMiddleInitial": "P"
+"LO1OfficeAbbreviation": "WILD01"
+"FirstPhotoAddTimestamp": "2025-12-11T04:19:45.2"
+"MlsAreaMajor": "All Others SC Counties"
+"Media": array:4 [
0 => array:11 [
"Order" => 0
"MediaKey" => "6230980"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/623098/bb6cf46b2a2d3bf79769a9144fb6e3e8.webp"
"ClassName" => "Commercial"
"MediaSize" => 163925
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/623098/thumbnail-bb6cf46b2a2d3bf79769a9144fb6e3e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "623098"
]
1 => array:11 [
"Order" => 1
"MediaKey" => "6230981"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/623098/74a9e5e923bd53f0fbb9e8293654ba21.webp"
"ClassName" => "Commercial"
"MediaSize" => 306115
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/623098/thumbnail-74a9e5e923bd53f0fbb9e8293654ba21.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "623098"
]
2 => array:11 [
"Order" => 2
"MediaKey" => "6230982"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/623098/46ba451eb4b35e8a74247b518ca80e05.webp"
"ClassName" => "Commercial"
"MediaSize" => 186513
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/623098/thumbnail-46ba451eb4b35e8a74247b518ca80e05.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "623098"
]
3 => array:11 [
"Order" => 3
"MediaKey" => "6230983"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/623098/3969fa644b8fad42fdfbfb551cc03b19.webp"
"ClassName" => "Commercial"
"MediaSize" => 46310
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/623098/thumbnail-3969fa644b8fad42fdfbfb551cc03b19.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "623098"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('623098')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3730
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "612266"
+"ListingId": "612266"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Commercial"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-11T00:31:13Z"
+"RFModificationTimestamp": "2025-12-11T00:35:18Z"
+"ListPrice": 579900.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 1.55
+"LivingArea": 0
+"BuildingAreaTotal": 2450.0
+"City": "Gaston"
+"PostalCode": "29053"
+"UnparsedAddress": "2601 Highway 6 Highway, Gaston, SC 29053"
+"Coordinates": array:2 [
0 => -81.183243
1 => 33.794774
]
+"Latitude": 33.794774
+"Longitude": -81.183243
+"YearBuilt": 1980
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "Coldwell Banker Realty"
+"ListAgentMlsId": "16886"
+"ListOfficeMlsId": "1084"
+"OriginatingSystemName": "columbiamls"
+"PublicRemarks": "High-visibility SC-6 corner commercial value-add with a rare “reopen vs. start-from-scratch” advantage. This ±1.55-acre site offers ±324’ of highway frontage and an existing ±2,450 SF block/brick former grocery building (built 1980), creating a strong foundation for a community-serving destination. With +/- 50 parking spaces and utilities already in place (electric on site, well water, septic), the path to launch can be faster and more cost-efficient than raw land development. New HVAC (seller-reported). Zoning is listed as General Commercial (buyer to verify permitted uses). The most compelling concepts for this location include a neighborhood grocery/mercado or country market, a destination restaurant, a community/event venue, or a boutique farm-supply & feed store—with flexibility for future expansion. Legacy USTs reportedly removed in 1998 under SCDHEC oversight with a closure letter available per marketing/MLS narrative. Buyer to verify utilities, zoning, square footage, and environmental documentation. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings."
+"BuildingAreaUnits": "Sqft"
+"Cooling": "Central"
+"CountyOrParish": "Lexington"
+"CreationDate": "2025-07-03T13:37:13.044894+00:00"
+"Directions": "From Columbia: take Hwy 302 W (Edmund Hwy). Turn left on SC-6 toward Swansea; go ~3 mi. Property on right, directly across from “The Store.”"
+"Heating": "Central"
+"ListAgentEmail": "caroline.dubose@cbrealty.com"
+"LivingAreaUnits": "Sqft"
+"LotSizeUnits": "Sqft"
+"MlsStatus": "ACTIVE"
+"OpenParkingSpaces": "50"
+"OriginalEntryTimestamp": "2025-07-03"
+"PhotosChangeTimestamp": "2025-12-08T21:23:27Z"
+"PhotosCount": "28"
+"Sewer": "Septic"
+"StateOrProvince": "SC"
+"StreetName": "Highway 6"
+"StreetNumber": "2601"
+"StreetSuffix": "Highway"
+"VirtualTourURLUnbranded": "https://s3.amazonaws.com/video.creativeedge.tv/862364-4.mp4"
+"WaterSource": "Well"
+"Zoning": "General Commercial"
+"TMS": "010900-06-012"
+"Address": "2601 Highway 6 Highway"
+"BestUse": "Ideal for a neighborhood grocery/mercado or country market, destination restaurant, event/party venue, or boutique farm-supply & feed store."
+"LVTDate": "2025-07-03"
+"LotSize": "324.27X175.30X324.26X208."
+"PowerOn": "Yes"
+"#ofDoors": "2"
+"LandSqFt": "65340"
+"Location": "Corner lot Intersection"
+"Services": "Electric on site, well water, septic tank."
+"#ofDoors2": "1"
+"#ofStories": "1"
+"DoorHeight": "80"
+"New/Resale": "Resale"
+"class_name": "CI_3"
+"DoorHeight2": "80"
+"LA1UserCode": "DUBOC"
+"Transaction": "Sale"
+"Construction": "Block,Brick"
+"PricePerSQFT": "236.69"
+"ShortSaleY/N": "No"
+"StatusDetail": "0"
+"AgentHitCount": "67"
+"CeilingHeight": "104"
+"Miscellaneous": "Security Fence"
+"GeoSubdivision": "SC"
+"GrossHeatedSqFt": "2450"
+"LO1MainOfficeID": "1089"
+"LA1AgentLastName": "DuBose"
+"RollbackTax(Y/N)": "No"
+"LA1AgentFirstName": "Caroline"
+"ForeclosedProperty": "No"
+"GeoUpdateTimestamp": "2025-07-03T13:32:45.1"
+"AddressSearchNumber": "2601"
+"LO1OfficeIdentifier": "1084"
+"ListingTypeAgreement": "Exclusive Right to Sell"
+"PublishtoInternetY/N": "Yes"
+"LO1OfficeAbbreviation": "CBRB01"
+"FirstPhotoAddTimestamp": "2025-07-03T13:32:46"
+"MlsAreaMajor": "Rural S Lexington Co - Gaston etc"
+"Media": array:28 [
0 => array:11 [
"Order" => 0
"MediaKey" => "6122660"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612266/3cd669d85cb7ced0bfe5bdd1aab48e2b.webp"
"ClassName" => "Commercial"
"MediaSize" => 1185210
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612266/thumbnail-3cd669d85cb7ced0bfe5bdd1aab48e2b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612266"
]
1 => array:11 [
"Order" => 1
"MediaKey" => "6122661"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612266/3b9c5bac42db7fb635e70dac8a3d7b60.webp"
"ClassName" => "Commercial"
"MediaSize" => 1125475
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612266/thumbnail-3b9c5bac42db7fb635e70dac8a3d7b60.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612266"
]
2 => array:11 [
"Order" => 2
"MediaKey" => "6122662"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612266/1882cf14e743894eedb22fff1bb6a3d2.webp"
"ClassName" => "Commercial"
"MediaSize" => 1148441
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612266/thumbnail-1882cf14e743894eedb22fff1bb6a3d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612266"
]
3 => array:11 [
"Order" => 3
"MediaKey" => "6122663"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612266/6bf2f76e04ffdacd438120842eb78197.webp"
"ClassName" => "Commercial"
"MediaSize" => 1107763
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612266/thumbnail-6bf2f76e04ffdacd438120842eb78197.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612266"
]
4 => array:11 [
"Order" => 4
"MediaKey" => "6122664"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612266/b1663d42565dd8dff75d5206522d842e.webp"
"ClassName" => "Commercial"
"MediaSize" => 1120975
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612266/thumbnail-b1663d42565dd8dff75d5206522d842e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612266"
]
5 => array:11 [
"Order" => 5
"MediaKey" => "6122665"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612266/5f4df2cabcd296ea77b42fd8e250f930.webp"
"ClassName" => "Commercial"
"MediaSize" => 1155801
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612266/thumbnail-5f4df2cabcd296ea77b42fd8e250f930.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612266"
]
6 => array:11 [
"Order" => 6
"MediaKey" => "6122666"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612266/9c3d0fdf582f0d9bfc99b9a75cee271d.webp"
"ClassName" => "Commercial"
"MediaSize" => 1157179
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612266/thumbnail-9c3d0fdf582f0d9bfc99b9a75cee271d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612266"
]
7 => array:11 [
"Order" => 7
"MediaKey" => "6122667"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612266/4b883291e7aa1c20528b9de7a198f195.webp"
"ClassName" => "Commercial"
"MediaSize" => 1147878
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612266/thumbnail-4b883291e7aa1c20528b9de7a198f195.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612266"
]
8 => array:11 [
"Order" => 8
"MediaKey" => "6122668"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612266/f69581472593e400e377ad9824af257c.webp"
"ClassName" => "Commercial"
"MediaSize" => 1162091
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612266/thumbnail-f69581472593e400e377ad9824af257c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612266"
]
9 => array:11 [
"Order" => 9
"MediaKey" => "6122669"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612266/ee68b56b68a9df9ee93492e4a81814d0.webp"
"ClassName" => "Commercial"
"MediaSize" => 1194435
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612266/thumbnail-ee68b56b68a9df9ee93492e4a81814d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612266"
]
10 => array:11 [
"Order" => 10
"MediaKey" => "61226610"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612266/5b43ab721d75818a8d94cc0603820864.webp"
"ClassName" => "Commercial"
"MediaSize" => 1185627
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612266/thumbnail-5b43ab721d75818a8d94cc0603820864.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612266"
]
11 => array:11 [
"Order" => 11
"MediaKey" => "61226611"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612266/c60d0e92621c3833b5f2514a9e233430.webp"
"ClassName" => "Commercial"
"MediaSize" => 1138028
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612266/thumbnail-c60d0e92621c3833b5f2514a9e233430.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612266"
]
12 => array:11 [
"Order" => 12
"MediaKey" => "61226612"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612266/060df7e2b6759d17bc0e97fc0a990790.webp"
"ClassName" => "Commercial"
"MediaSize" => 1131918
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612266/thumbnail-060df7e2b6759d17bc0e97fc0a990790.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612266"
]
13 => array:11 [
"Order" => 13
"MediaKey" => "61226613"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612266/cb3df83a687f6edda57babcbe5cc1cba.webp"
"ClassName" => "Commercial"
"MediaSize" => 1197384
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612266/thumbnail-cb3df83a687f6edda57babcbe5cc1cba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612266"
]
14 => array:11 [
"Order" => 14
"MediaKey" => "61226614"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612266/128c41b4dc4ce6d7a11baeac5a7d5a7c.webp"
"ClassName" => "Commercial"
"MediaSize" => 1148198
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612266/thumbnail-128c41b4dc4ce6d7a11baeac5a7d5a7c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612266"
]
15 => array:11 [
"Order" => 15
"MediaKey" => "61226615"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612266/05b08ae2987350bbcccbb4e328b502aa.webp"
"ClassName" => "Commercial"
"MediaSize" => 1146814
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612266/thumbnail-05b08ae2987350bbcccbb4e328b502aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612266"
]
16 => array:11 [
"Order" => 16
"MediaKey" => "61226616"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612266/1c70738e616506ce52ff34d5dce7e2e7.webp"
"ClassName" => "Commercial"
"MediaSize" => 1149259
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612266/thumbnail-1c70738e616506ce52ff34d5dce7e2e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612266"
]
17 => array:11 [
"Order" => 17
"MediaKey" => "61226617"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612266/32625fe2972b501e405872168792d133.webp"
"ClassName" => "Commercial"
"MediaSize" => 1148904
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612266/thumbnail-32625fe2972b501e405872168792d133.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612266"
]
18 => array:11 [
"Order" => 18
"MediaKey" => "61226618"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612266/effd0e7b79f184b02543cfd5e24a5ea1.webp"
"ClassName" => "Commercial"
"MediaSize" => 590147
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612266/thumbnail-effd0e7b79f184b02543cfd5e24a5ea1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612266"
]
19 => array:11 [
"Order" => 19
"MediaKey" => "61226619"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612266/306b7d29342cf45acfddbb29c0f97056.webp"
"ClassName" => "Commercial"
"MediaSize" => 654678
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612266/thumbnail-306b7d29342cf45acfddbb29c0f97056.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612266"
]
20 => array:11 [
"Order" => 20
"MediaKey" => "61226620"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612266/e93a0ef67dcb4669a1b010173d92ea1e.webp"
"ClassName" => "Commercial"
"MediaSize" => 677804
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612266/thumbnail-e93a0ef67dcb4669a1b010173d92ea1e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612266"
]
21 => array:11 [
"Order" => 21
"MediaKey" => "61226621"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612266/d9313d58f5491d56d26a46a22926e762.webp"
"ClassName" => "Commercial"
"MediaSize" => 680814
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612266/thumbnail-d9313d58f5491d56d26a46a22926e762.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612266"
]
22 => array:11 [
"Order" => 22
"MediaKey" => "61226622"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612266/2be30026c29b0def0f11ca60b5711799.webp"
"ClassName" => "Commercial"
"MediaSize" => 431385
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612266/thumbnail-2be30026c29b0def0f11ca60b5711799.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612266"
]
23 => array:11 [
"Order" => 23
"MediaKey" => "61226623"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612266/65fb6e7b262db219ad24112db2eb02a7.webp"
"ClassName" => "Commercial"
"MediaSize" => 701449
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612266/thumbnail-65fb6e7b262db219ad24112db2eb02a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612266"
]
24 => array:11 [
"Order" => 24
"MediaKey" => "61226624"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612266/12841b12a54b9fef7a632ede83600c08.webp"
"ClassName" => "Commercial"
"MediaSize" => 1167776
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612266/thumbnail-12841b12a54b9fef7a632ede83600c08.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612266"
]
25 => array:11 [
"Order" => 25
"MediaKey" => "61226625"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612266/0e074eda8802e1b13ab104bc436ef43c.webp"
"ClassName" => "Commercial"
"MediaSize" => 1146909
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612266/thumbnail-0e074eda8802e1b13ab104bc436ef43c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612266"
]
26 => array:11 [
"Order" => 26
"MediaKey" => "61226626"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612266/95da7e4e652fab739937fe664fd3270c.webp"
"ClassName" => "Commercial"
"MediaSize" => 1110608
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612266/thumbnail-95da7e4e652fab739937fe664fd3270c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612266"
]
27 => array:11 [
"Order" => 27
"MediaKey" => "61226627"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612266/0d9d8b194d30d5b447309bfc7a175105.webp"
"ClassName" => "Commercial"
"MediaSize" => 65834
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612266/thumbnail-0d9d8b194d30d5b447309bfc7a175105.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612266"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('612266')"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3800
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "622704"
+"ListingId": "622704"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Commercial"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-10T23:01:07Z"
+"RFModificationTimestamp": "2025-12-10T23:07:33Z"
+"ListPrice": 795000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0.21
+"LivingArea": 0
+"BuildingAreaTotal": 4225.0
+"City": "Columbia"
+"PostalCode": "29201"
+"UnparsedAddress": "2620. A Main Street, Columbia, SC 29201"
+"Coordinates": array:2 [
0 => -81.041882
1 => 34.020732
]
+"Latitude": 34.020732
+"Longitude": -81.041882
+"YearBuilt": 1930
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX Executive"
+"ListAgentMlsId": "2037"
+"ListOfficeMlsId": "1918"
+"OriginatingSystemName": "columbiamls"
+"PublicRemarks": "This is an interesting Commercial / Residential property, could be a live / work property. The 2 front Commercial units are presently occupied by 1 tenant, as I see it the greatest potential to improve rental income or owner occupy...Conveniently located to Downtown (1 mile), new USC Med School, University of SC, dining in Cotton Town, Main St, Vista, shopping, Interstate access. This unique property has Commercial usage and 4 Residential units, 3 that have been recently completely renovated. The other units bring in respectable rent for what they are, upside potential...The Commercial up front has great street visibility, good off street parking front of Commercial and in back through portechet. We are leaving unit F in back upstairs vac for easy showing, updated with last rent rate $1450 per month. If F rented for prior rent and all else stayed the same gross annual rent of $74,280. Multiple property usages 3 of the 4 residential units renovated. A total of 2896 sq ft in main building. SCDOT Annual Average Daily Traffic Count = 20,100. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings."
+"BuildingAreaUnits": "Sqft"
+"Cooling": "Central,Window Units"
+"CountyOrParish": "Richland"
+"CreationDate": "2025-12-03T23:16:12.688772+00:00"
+"Directions": "Elmwood to Main St just before Geiger, 2620 Main St."
+"Heating": "Central"
+"ListAgentEmail": "budkinnie@sc.rr.com"
+"LivingAreaUnits": "Sqft"
+"LotSizeUnits": "Sqft"
+"MlsStatus": "ACTIVE"
+"OpenParkingSpaces": "10"
+"OriginalEntryTimestamp": "2025-12-03"
+"PhotosChangeTimestamp": "2025-12-10T23:00:54Z"
+"PhotosCount": "18"
+"Sewer": "Public"
+"StateOrProvince": "SC"
+"StreetName": "Main"
+"StreetNumber": "2620. A"
+"StreetSuffix": "Street"
+"WaterSource": "Public"
+"Zoning": "NAC"
+"TMS": "09109-08-08"
+"Address": "2620. A Main Street"
+"BestUse": "Small business,art or music studio,CPA office,attorney,salon,real estate office,high traffic count location,additional space from rentals behind could be incorporated into commercial space up front."
+"LVTDate": "2025-12-03"
+"LotSize": "61x157x60x146"
+"PowerOn": "Yes"
+"LandSqFt": "9150"
+"Location": "Downtown Columbia SC"
+"#ofStories": "1.5"
+"New/Resale": "Resale"
+"class_name": "CI_3"
+"GrossIncome": "74280"
+"LA1UserCode": "KINNIEB"
+"Transaction": "Sale"
+"Construction": "Brick"
+"PricePerSQFT": "188.17"
+"ShortSaleY/N": "No"
+"StatusDetail": "0"
+"AgentHitCount": "17"
+"LockboxNumber": "2468288"
+"GeoSubdivision": "SC"
+"GrossHeatedSqFt": "4225"
+"LO1MainOfficeID": "1074"
+"LA1AgentLastName": "Kinnie"
+"RollbackTax(Y/N)": "No"
+"LA1AgentFirstName": "Bud"
+"ForeclosedProperty": "No"
+"GeoUpdateTimestamp": "2025-12-03T23:10:25.7"
+"AddressSearchNumber": "2620"
+"LO1OfficeIdentifier": "1918"
+"ListingTypeAgreement": "Exclusive Right to Sell"
+"PublishtoInternetY/N": "Yes"
+"LO1OfficeAbbreviation": "RMXE02"
+"FirstPhotoAddTimestamp": "2025-12-03T23:10:26.8"
+"MlsAreaMajor": "City of Columbia, Denny terrace, Lake Elizabeth"
+"Media": array:18 [
0 => array:11 [
"Order" => 0
"MediaKey" => "6227040"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/622704/a22c7e03df085f55873ff9efb32e81a4.webp"
"ClassName" => "Commercial"
"MediaSize" => 107806
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/622704/thumbnail-a22c7e03df085f55873ff9efb32e81a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "622704"
]
1 => array:11 [
"Order" => 1
"MediaKey" => "6227041"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/622704/1df1f84fcaf3d9672c2121267fd2ed3d.webp"
"ClassName" => "Commercial"
"MediaSize" => 115740
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/622704/thumbnail-1df1f84fcaf3d9672c2121267fd2ed3d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "622704"
]
2 => array:11 [
"Order" => 2
"MediaKey" => "6227042"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/622704/950da5829d9bce255defe9c314835f7e.webp"
"ClassName" => "Commercial"
"MediaSize" => 809775
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/622704/thumbnail-950da5829d9bce255defe9c314835f7e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "622704"
]
3 => array:11 [
"Order" => 3
"MediaKey" => "6227043"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/622704/9c28230a76ab223c961b05952d25295e.webp"
"ClassName" => "Commercial"
"MediaSize" => 940955
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/622704/thumbnail-9c28230a76ab223c961b05952d25295e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "622704"
]
4 => array:11 [
"Order" => 4
"MediaKey" => "6227044"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/622704/2e99a58d29524b2999cb5814a596b923.webp"
"ClassName" => "Commercial"
"MediaSize" => 923696
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/622704/thumbnail-2e99a58d29524b2999cb5814a596b923.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "622704"
]
5 => array:11 [
"Order" => 5
"MediaKey" => "6227045"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/622704/ef92db5759b83413e0b1125a410ef917.webp"
"ClassName" => "Commercial"
"MediaSize" => 757076
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/622704/thumbnail-ef92db5759b83413e0b1125a410ef917.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "622704"
]
6 => array:11 [
"Order" => 6
"MediaKey" => "6227046"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/622704/fc3e67b8473076dd61859eee2ad88eea.webp"
"ClassName" => "Commercial"
"MediaSize" => 1118185
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/622704/thumbnail-fc3e67b8473076dd61859eee2ad88eea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "622704"
]
7 => array:11 [
"Order" => 7
"MediaKey" => "6227047"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/622704/607aefa458b9a12a0343f861a149652d.webp"
"ClassName" => "Commercial"
"MediaSize" => 1000935
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/622704/thumbnail-607aefa458b9a12a0343f861a149652d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "622704"
]
8 => array:11 [
"Order" => 8
"MediaKey" => "6227048"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/622704/fa1cfeff8fbe9e9697ca860c9e31415f.webp"
"ClassName" => "Commercial"
"MediaSize" => 1059487
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/622704/thumbnail-fa1cfeff8fbe9e9697ca860c9e31415f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "622704"
]
9 => array:11 [
"Order" => 9
"MediaKey" => "6227049"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/622704/51c3195419b4d6c8e94c639a9d0554e7.webp"
"ClassName" => "Commercial"
"MediaSize" => 1062145
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/622704/thumbnail-51c3195419b4d6c8e94c639a9d0554e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "622704"
]
10 => array:11 [
"Order" => 10
"MediaKey" => "62270410"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/622704/940790e888501068b397c8018397c128.webp"
"ClassName" => "Commercial"
"MediaSize" => 1051746
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/622704/thumbnail-940790e888501068b397c8018397c128.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "622704"
]
11 => array:11 [
"Order" => 11
"MediaKey" => "62270411"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/622704/474320e93d93f82c312d7951139b6d9d.webp"
"ClassName" => "Commercial"
"MediaSize" => 1011992
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/622704/thumbnail-474320e93d93f82c312d7951139b6d9d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "622704"
]
12 => array:11 [
"Order" => 12
"MediaKey" => "62270412"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/622704/100a5828b5112aae192bacd73959623b.webp"
"ClassName" => "Commercial"
"MediaSize" => 753968
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/622704/thumbnail-100a5828b5112aae192bacd73959623b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "622704"
]
13 => array:11 [
"Order" => 13
"MediaKey" => "62270413"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/622704/4b2099cc27edea90d210f4724fef03b2.webp"
"ClassName" => "Commercial"
"MediaSize" => 794778
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/622704/thumbnail-4b2099cc27edea90d210f4724fef03b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "622704"
]
14 => array:11 [
"Order" => 14
"MediaKey" => "62270414"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/622704/3f8be7f2b163b3c633b3e946882b69d0.webp"
"ClassName" => "Commercial"
"MediaSize" => 788106
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/622704/thumbnail-3f8be7f2b163b3c633b3e946882b69d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "622704"
]
15 => array:11 [
"Order" => 15
"MediaKey" => "62270415"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/622704/5f72f811c0459f3179e4127084f96b4f.webp"
"ClassName" => "Commercial"
"MediaSize" => 797466
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/622704/thumbnail-5f72f811c0459f3179e4127084f96b4f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "622704"
]
16 => array:11 [
"Order" => 16
"MediaKey" => "62270416"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/622704/eb4e9ee03ea6ac80ed119ae672dc964f.webp"
"ClassName" => "Commercial"
"MediaSize" => 754700
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/622704/thumbnail-eb4e9ee03ea6ac80ed119ae672dc964f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "622704"
]
17 => array:11 [
"Order" => 17
"MediaKey" => "62270417"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/622704/bcf2c4c57de7e9dff2c5cd2ad63d4c29.webp"
"ClassName" => "Commercial"
"MediaSize" => 798445
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/622704/thumbnail-bcf2c4c57de7e9dff2c5cd2ad63d4c29.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "622704"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('622704')"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3774
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "574039"
+"ListingId": "574039"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Commercial"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-10T22:06:07Z"
+"RFModificationTimestamp": "2025-12-10T22:14:47Z"
+"ListPrice": 50000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0.06
+"LivingArea": 0
+"BuildingAreaTotal": 1170.0
+"City": "Newberry"
+"PostalCode": "29108"
+"UnparsedAddress": "1101 Nance Street, Newberry, SC 29108"
+"Coordinates": array:2 [
0 => -81.620902
1 => 34.273314
]
+"Latitude": 34.273314
+"Longitude": -81.620902
+"YearBuilt": 1950
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "Linda Renwick Realty Inc"
+"ListAgentMlsId": "2403"
+"ListOfficeMlsId": "652"
+"OriginatingSystemName": "columbiamls"
+"PublicRemarks": "Come steal this building sitting on a prime commercial corner of downtown Newberry. Completely open inside - a blank canvas. Become a part of historic downtown amenities. Join shopping, bars, restaurants and historic Opera House. Location, location, location! Only one block off of Main Street. Corner Lot on Nance and Friend Streets, one block from Main Street. Open Space - with a blank canvas.Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings."
+"BuildingAreaUnits": "Sqft"
+"Cooling": "Wall Units"
+"CountyOrParish": "Newberry"
+"CreationDate": "2025-11-17T16:02:59.417984+00:00"
+"Directions": "Corner of Nance St. and Friend St."
+"Heating": "Other"
+"ListAgentEmail": "linda@lindarenwickrealty.com"
+"LivingAreaUnits": "Sqft"
+"LotSizeUnits": "Sqft"
+"MlsStatus": "ACTIVE"
+"OpenParkingSpaces": "0"
+"OriginalEntryTimestamp": "2023-11-13"
+"PhotosChangeTimestamp": "2025-11-02T07:02:46Z"
+"PhotosCount": "1"
+"Roof": "Membrane"
+"Sewer": "Public"
+"StateOrProvince": "SC"
+"StreetName": "Nance"
+"StreetNumber": "1101"
+"StreetSuffix": "Street"
+"WaterSource": "Public"
+"Zoning": "Commercial"
+"TMS": "343-4-23-3"
+"Address": "1101 Nance Street"
+"BestUse": "Open Space - Blank Canvas"
+"LVTDate": "2023-11-13"
+"LotSize": "54.1 x 45.6 x 53 x 45"
+"PowerOn": "No"
+"#ofStories": "1"
+"New/Resale": "Resale"
+"class_name": "CI_3"
+"LA1UserCode": "RENWICKL"
+"Transaction": "Sale"
+"Construction": "Block"
+"PricePerSQFT": "42.74"
+"ShortSaleY/N": "No"
+"StatusDetail": "0"
+"AgentHitCount": "361"
+"LockboxNumber": "31830040"
+"GeoSubdivision": "SC"
+"GrossHeatedSqFt": "1170"
+"LO1MainOfficeID": "652"
+"LA1AgentLastName": "Renwick"
+"RollbackTax(Y/N)": "No"
+"LA1AgentFirstName": "Linda"
+"ForeclosedProperty": "No"
+"GeoUpdateTimestamp": "2023-11-13T21:46:20.5"
+"AddressSearchNumber": "1101"
+"LO1OfficeIdentifier": "652"
+"ListingTypeAgreement": "Exclusive Right to Sell"
+"PublishtoInternetY/N": "Yes"
+"LO1OfficeAbbreviation": "RENW01"
+"BldgAttached/FreeStndg": "Free Standing"
+"FirstPhotoAddTimestamp": "2023-11-14T19:45:52.4"
+"MlsAreaMajor": "Newberry County"
+"Media": array:1 [
0 => array:11 [
"Order" => 0
"MediaKey" => "5740390"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/574039/a672c3dcf472befea14ea025cd1e7cd4.webp"
"ClassName" => "Commercial"
"MediaSize" => 34057
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/574039/thumbnail-a672c3dcf472befea14ea025cd1e7cd4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "574039"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('574039')"
}
]
+success: true
+page_size: 4
+page_count: 44
+count: 176
+after_key: ""
}
]
]