array:2 [▼
"RF Cache Key: ada526759ca74e31cb83f81ebcee15b33cc032bcab0eff21e6dd32595a0d22eb" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3208
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3210
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "601446"
+"ListingId": "601446"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Commercial"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2025-06-04T07:02:36Z"
+"RFModificationTimestamp": "2025-06-04T07:09:18.416917+00:00"
+"ListPrice": 230000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0.42
+"LivingArea": 0
+"BuildingAreaTotal": 3505.0
+"City": "Columbia"
+"PostalCode": "29203"
+"UnparsedAddress": "5334 Fairfield Rd, Columbia, Sc 29203"
+"Coordinates": array:2 [
0 => -81.026574
1 => 34.05726
]
+"Latitude": 34.05726
+"Longitude": -81.026574
+"YearBuilt": 1969
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "JPAR Magnolia Group"
+"ListAgentMlsId": "5298"
+"ListOfficeMlsId": "1316"
+"OriginatingSystemName": "columbiamls"
+"PublicRemarks": "Fantastic Opportunity for Retail Redevelopment with fantastic visibility just off the I-20 corridor. More than 150 of frontage on Fairfield Rd…minutes from Downtown Columbia. 1 parcel- 3 SEPARATE but attached UNITS: Unit A- most recently used as beauty/barber shop. Unit B- last used as a church. Don’t miss your chance to claim a highly visible location near the heart of Downtown Columbia. Choose your best and preferred possible uses: retail, restaurant, church, daycare, beauty/barber, multi-family, and so much more! Sold as is/where is. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.
Fantastic Opportunity for Retail Redevelopment with fantastic visibility just off the I-20 corridor. More than 150 of frontage on Fairfield Rd…minutes from Down
"
+"BuildingAreaUnits": "Sqft"
+"Cooling": "Central,Other,None"
+"CountyOrParish": "Richland"
+"CreationDate": "2025-05-09T15:08:07.236210+00:00"
+"Directions": "I-20 to Fairfield Rd (towards Columbia). Property on the left at the corner of Fairfield and Rosedale Arch"
+"Heating": "Central,Other,None"
+"ListAgentEmail": "cdesireem.realtor@gmail.com"
+"LivingAreaUnits": "Sqft"
+"LotSizeUnits": "Sqft"
+"MlsStatus": "PENDING"
+"OpenParkingSpaces": "15"
+"OriginalEntryTimestamp": "2025-02-04"
+"PhotosChangeTimestamp": "2025-06-04T07:02:36Z"
+"PhotosCount": "26"
+"Sewer": "Public"
+"StateOrProvince": "SC"
+"StreetName": "Fairfield Rd"
+"StreetNumber": "5334"
+"WaterSource": "Public"
+"Zoning": "CAC"
+"Miscellaneous": "Restrooms"
+"Address": "5334 Fairfield Rd"
+"New/Resale": "Resale"
+"Gross Heated SqFt": "3505"
+"# of Stories": "1"
+"LVT Date": "2025-02-04"
+"Status Detail": "0"
+"LO1Office Identifier": "1316"
+"Best Use": "CAC zoning allowed uses include live/work, multi-family, mixed-use, offices, recreation, restaurants. Some auto-oriented uses are allowed under specific conditions
CAC zoning allowed uses include live/work, multi-family, mixed-use, offices, recreation, restaurants. Some auto-oriented uses are allowed under specific conditi
"
+"Listing Type Agreement": "Exclusive Right to Sell"
+"Geo Subdivision": "SC"
+"Power On": "Yes"
+"class_name": "CI_3"
+"Short Sale Y/N": "No"
+"LO1Main Office ID": "1269"
+"Bldg Attached/Free Stndg": "Free Standing"
+"Construction": "Block,Brick"
+"Rollback Tax (Y/N)": "No"
+"List Price Tot SqFt": "440476.19"
+"Lockbox Number": "32792733"
+"Price Per SQFT": "65.62"
+"LO1Office Abbreviation": "JPAR02"
+"Publish to Internet Y/N": "Yes"
+"First Photo Add Timestamp": "2025-02-04T20:12:05"
+"Agent Hit Count": "50"
+"LA1Agent Last Name": "Merriweather"
+"Transaction": "Sale"
+"LA1User Code": "MERRIWD"
+"Lot Size": "151x287.5x237.5"
+"TMS": "11702-07-01"
+"LA1Agent First Name": "Desiree"
+"Geo Update Timestamp": "2025-02-04T20:12:04.3"
+"Address Search Number": "5334"
+"Location": "Street front, corner lot"
+"Foreclosed Property": "No"
+"MlsAreaMajor": "City of Columbia, Denny terrace, Lake Elizabeth"
+"Media": array:26 [
0 => array:11 [
"Order" => 0
"MediaKey" => "6014460"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601446/8c18c6a5d9795501b37ead0033d04228.webp"
"MediaSize" => 1149042
"ResourceRecordKey" => "601446"
"ResourceName" => "Property"
"ClassName" => "Commercial"
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601446/thumbnail-8c18c6a5d9795501b37ead0033d04228.webp"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
]
1 => array:11 [
"Order" => 1
"MediaKey" => "6014461"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601446/0c9484804c9cd91b3f5bae63bc905f9d.webp"
"MediaSize" => 214723
"ResourceRecordKey" => "601446"
"ResourceName" => "Property"
"ClassName" => "Commercial"
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601446/thumbnail-0c9484804c9cd91b3f5bae63bc905f9d.webp"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
]
2 => array:11 [
"Order" => 2
"MediaKey" => "6014462"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601446/12d30459a25a7769517c489638a2b0cc.webp"
"MediaSize" => 830008
"ResourceRecordKey" => "601446"
"ResourceName" => "Property"
"ClassName" => "Commercial"
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601446/thumbnail-12d30459a25a7769517c489638a2b0cc.webp"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
]
3 => array:11 [
"Order" => 3
"MediaKey" => "6014463"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601446/92b94e4c29abb105ef23cc8b845204fc.webp"
"MediaSize" => 785779
"ResourceRecordKey" => "601446"
"ResourceName" => "Property"
"ClassName" => "Commercial"
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601446/thumbnail-92b94e4c29abb105ef23cc8b845204fc.webp"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
]
4 => array:11 [
"Order" => 4
"MediaKey" => "6014464"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601446/820545022ee74315cbc110d2722fce4b.webp"
"MediaSize" => 766229
"ResourceRecordKey" => "601446"
"ResourceName" => "Property"
"ClassName" => "Commercial"
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601446/thumbnail-820545022ee74315cbc110d2722fce4b.webp"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
]
5 => array:11 [
"Order" => 5
"MediaKey" => "6014465"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601446/cd2ec999feca4fe69627d9acd2b773b3.webp"
"MediaSize" => 708567
"ResourceRecordKey" => "601446"
"ResourceName" => "Property"
"ClassName" => "Commercial"
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601446/thumbnail-cd2ec999feca4fe69627d9acd2b773b3.webp"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
]
6 => array:11 [
"Order" => 6
"MediaKey" => "6014466"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601446/98073ad4944a504e1f3fe6a7704e7e20.webp"
"MediaSize" => 725499
"ResourceRecordKey" => "601446"
"ResourceName" => "Property"
"ClassName" => "Commercial"
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601446/thumbnail-98073ad4944a504e1f3fe6a7704e7e20.webp"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
]
7 => array:11 [
"Order" => 7
"MediaKey" => "6014467"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601446/74ce08044d33a1c6230ce4696a89e98f.webp"
"MediaSize" => 729350
"ResourceRecordKey" => "601446"
"ResourceName" => "Property"
"ClassName" => "Commercial"
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601446/thumbnail-74ce08044d33a1c6230ce4696a89e98f.webp"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
]
8 => array:11 [
"Order" => 8
"MediaKey" => "6014468"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601446/88be9e0e23d9b87875f329e8ea393c11.webp"
"MediaSize" => 789618
"ResourceRecordKey" => "601446"
"ResourceName" => "Property"
"ClassName" => "Commercial"
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601446/thumbnail-88be9e0e23d9b87875f329e8ea393c11.webp"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
]
9 => array:11 [
"Order" => 9
"MediaKey" => "6014469"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601446/fac48c0e27625eff235401855f9fed8a.webp"
"MediaSize" => 740601
"ResourceRecordKey" => "601446"
"ResourceName" => "Property"
"ClassName" => "Commercial"
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601446/thumbnail-fac48c0e27625eff235401855f9fed8a.webp"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
]
10 => array:11 [
"Order" => 10
"MediaKey" => "60144610"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601446/fee6fc467d64bd6d39fac41e247055a6.webp"
"MediaSize" => 775101
"ResourceRecordKey" => "601446"
"ResourceName" => "Property"
"ClassName" => "Commercial"
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601446/thumbnail-fee6fc467d64bd6d39fac41e247055a6.webp"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
]
11 => array:11 [
"Order" => 11
"MediaKey" => "60144611"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601446/b50c3d77728e5ff84e80c51540b946cd.webp"
"MediaSize" => 598286
"ResourceRecordKey" => "601446"
"ResourceName" => "Property"
"ClassName" => "Commercial"
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601446/thumbnail-b50c3d77728e5ff84e80c51540b946cd.webp"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
]
12 => array:11 [
"Order" => 12
"MediaKey" => "60144612"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601446/6783129cc026ddfa95fa85e10a0d50ca.webp"
"MediaSize" => 708130
"ResourceRecordKey" => "601446"
"ResourceName" => "Property"
"ClassName" => "Commercial"
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601446/thumbnail-6783129cc026ddfa95fa85e10a0d50ca.webp"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
]
13 => array:11 [
"Order" => 13
"MediaKey" => "60144613"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601446/457531407a44a382af547b1eefcdab33.webp"
"MediaSize" => 241598
"ResourceRecordKey" => "601446"
"ResourceName" => "Property"
"ClassName" => "Commercial"
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601446/thumbnail-457531407a44a382af547b1eefcdab33.webp"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
]
14 => array:11 [
"Order" => 14
"MediaKey" => "60144614"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601446/f15928b01aa6af4e825c0d99b85fbfef.webp"
"MediaSize" => 732155
"ResourceRecordKey" => "601446"
"ResourceName" => "Property"
"ClassName" => "Commercial"
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601446/thumbnail-f15928b01aa6af4e825c0d99b85fbfef.webp"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
]
15 => array:11 [
"Order" => 15
"MediaKey" => "60144615"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601446/e1fbdbfa655fbd712ea5954cc1967301.webp"
"MediaSize" => 250840
"ResourceRecordKey" => "601446"
"ResourceName" => "Property"
"ClassName" => "Commercial"
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601446/thumbnail-e1fbdbfa655fbd712ea5954cc1967301.webp"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
]
16 => array:11 [
"Order" => 16
"MediaKey" => "60144616"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601446/bfede87df90f7e91eaaf3af6200bd331.webp"
"MediaSize" => 638971
"ResourceRecordKey" => "601446"
"ResourceName" => "Property"
"ClassName" => "Commercial"
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601446/thumbnail-bfede87df90f7e91eaaf3af6200bd331.webp"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
]
17 => array:11 [
"Order" => 17
"MediaKey" => "60144617"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601446/b74cf47307d2a61b43781069fb1cf979.webp"
"MediaSize" => 667705
"ResourceRecordKey" => "601446"
"ResourceName" => "Property"
"ClassName" => "Commercial"
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601446/thumbnail-b74cf47307d2a61b43781069fb1cf979.webp"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
]
18 => array:11 [
"Order" => 18
"MediaKey" => "60144618"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601446/bed830564952139373bd2aa4a0ca9f65.webp"
"MediaSize" => 594327
"ResourceRecordKey" => "601446"
"ResourceName" => "Property"
"ClassName" => "Commercial"
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601446/thumbnail-bed830564952139373bd2aa4a0ca9f65.webp"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
]
19 => array:11 [
"Order" => 19
"MediaKey" => "60144619"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601446/79aaeaacef0734ab02f19bef907a5540.webp"
"MediaSize" => 780449
"ResourceRecordKey" => "601446"
"ResourceName" => "Property"
"ClassName" => "Commercial"
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601446/thumbnail-79aaeaacef0734ab02f19bef907a5540.webp"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
]
20 => array:11 [
"Order" => 20
"MediaKey" => "60144620"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601446/4b05a2cf75011d854925fae29b521a5e.webp"
"MediaSize" => 767126
"ResourceRecordKey" => "601446"
"ResourceName" => "Property"
"ClassName" => "Commercial"
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601446/thumbnail-4b05a2cf75011d854925fae29b521a5e.webp"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
]
21 => array:11 [
"Order" => 21
"MediaKey" => "60144621"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601446/bc2fb2e9cb3d7112e1ace99d1885a98c.webp"
"MediaSize" => 735274
"ResourceRecordKey" => "601446"
"ResourceName" => "Property"
"ClassName" => "Commercial"
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601446/thumbnail-bc2fb2e9cb3d7112e1ace99d1885a98c.webp"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
]
22 => array:11 [
"Order" => 22
"MediaKey" => "60144622"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601446/a154655ea540a2ca1eee3e6c0e80f93d.webp"
"MediaSize" => 472248
"ResourceRecordKey" => "601446"
"ResourceName" => "Property"
"ClassName" => "Commercial"
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601446/thumbnail-a154655ea540a2ca1eee3e6c0e80f93d.webp"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
]
23 => array:11 [
"Order" => 23
"MediaKey" => "60144623"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601446/c6d7ed21298616148c77db9efeb72510.webp"
"MediaSize" => 1435772
"ResourceRecordKey" => "601446"
"ResourceName" => "Property"
"ClassName" => "Commercial"
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601446/thumbnail-c6d7ed21298616148c77db9efeb72510.webp"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
]
24 => array:11 [
"Order" => 24
"MediaKey" => "60144624"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601446/10f268262cd65a860db78a8e136e19c5.webp"
"MediaSize" => 1216377
"ResourceRecordKey" => "601446"
"ResourceName" => "Property"
"ClassName" => "Commercial"
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601446/thumbnail-10f268262cd65a860db78a8e136e19c5.webp"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
]
25 => array:11 [
"Order" => 25
"MediaKey" => "60144625"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601446/245ad684c26143489f2996d9045b2a2d.webp"
"MediaSize" => 1128336
"ResourceRecordKey" => "601446"
"ResourceName" => "Property"
"ClassName" => "Commercial"
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601446/thumbnail-245ad684c26143489f2996d9045b2a2d.webp"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('601446')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
]
"RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=4&$filter=PropertyType in ('Commercial Sale', 'Commercial')/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=4&$filter=PropertyType in ('Commercial Sale', 'Commercial')&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=4&$filter=PropertyType in ('Commercial Sale', 'Commercial')/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=4&$filter=PropertyType in ('Commercial Sale', 'Commercial')&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3792
+items: array:4 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3793
+post_id: "107422"
+post_author: 1
+"ListingKey": "611074"
+"ListingId": "611074"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Commercial"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-07-10T18:29:14Z"
+"RFModificationTimestamp": "2025-07-10T18:31:24.395046+00:00"
+"ListPrice": 475000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 1470.0
+"City": "Chapin"
+"PostalCode": "29036"
+"UnparsedAddress": "241 Columbia Avenue, Chapin, SC 29036"
+"Coordinates": array:2 [
0 => -81.345051
1 => 34.167718
]
+"Latitude": 34.167718
+"Longitude": -81.345051
+"YearBuilt": 1900
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "Home Advantage Realty"
+"ListAgentMlsId": "10743"
+"ListOfficeMlsId": "1370"
+"OriginatingSystemName": "columbiamls"
+"PublicRemarks": "Excellent location in the center of downtown Chapin with high visibility and constant traffic flow. One acre lot with a 1400 square foot structure that was previously residential. Zoned for commercial use and ideal for small business owners or investors. Minutes from I26 and east access to Columbia and surrounding areas. Please contact agent for additional information. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.
Excellent location in the center of downtown Chapin with high visibility and constant traffic flow. One acre lot with a 1400 square foot structure that was pre
"
+"BuildingAreaUnits": "Sqft"
+"Cooling": "None"
+"CountyOrParish": "Lexington"
+"CreationDate": "2025-06-17T18:52:03.354349+00:00"
+"Directions": "From I26 take Exit 91 toward Chapin. Property will be on the right."
+"Heating": "None"
+"ListAgentEmail": "ttimmerman@homeadvantagerealty.com"
+"LivingAreaUnits": "Sqft"
+"LotSizeUnits": "Sqft"
+"MlsStatus": "ACTIVE"
+"OpenParkingSpaces": "4"
+"OriginalEntryTimestamp": "2025-06-17"
+"PhotosChangeTimestamp": "2025-07-10T18:29:14Z"
+"PhotosCount": "1"
+"Sewer": "Public"
+"StateOrProvince": "SC"
+"StreetName": "Columbia"
+"StreetNumber": "241"
+"StreetSuffix": "Avenue"
+"WaterSource": "Public"
+"Zoning": "commercial"
+"TMS": "000719-02-008"
+"Address": "241 Columbia Avenue"
+"LVT Date": "2025-06-17"
+"Power On": "No"
+"New/Resale": "Resale"
+"class_name": "CI_3"
+"Transaction": "Sale"
+"# of Stories": "1"
+"Construction": "Frame"
+"LA1User Code": "TIMMERT"
+"Status Detail": "0"
+"Price Per SQFT": "323.13"
+"Agent Hit Count": "29"
+"Geo Subdivision": "SC"
+"Gross Heated SqFt": "1470"
+"LO1Main Office ID": "182"
+"LA1Agent Last Name": "Timmerman"
+"Rollback Tax (Y/N)": "No"
+"Foreclosed Property": "No"
+"LA1Agent First Name": "Tony"
+"Geo Update Timestamp": "2025-06-17T18:48:47.9"
+"LO1Office Identifier": "1370"
+"Address Search Number": "241"
+"LO1Office Abbreviation": "HOMA03"
+"Listing Type Agreement": "Exclusive Right to Sell"
+"Publish to Internet Y/N": "Yes"
+"First Photo Add Timestamp": "2025-07-10T18:29:13.9"
+"MlsAreaMajor": "Rural NW Rich Co & NE Lex Co - Chapin"
+"Media": array:1 [
0 => array:11 [
"Order" => 0
"MediaKey" => "6110740"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/611074/a5de6f5834d23c44e55e02ff9e12df42.webp"
"ClassName" => "Commercial"
"MediaSize" => 1096302
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/611074/thumbnail-a5de6f5834d23c44e55e02ff9e12df42.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "611074"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('611074')"
+"ID": "107422"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3791
+post_id: "108034"
+post_author: 1
+"ListingKey": "611726"
+"ListingId": "611726"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Commercial"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-07-10T16:47:32Z"
+"RFModificationTimestamp": "2025-07-10T16:57:42.706646+00:00"
+"ListPrice": 735000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0.98
+"LivingArea": 0
+"BuildingAreaTotal": 9104.0
+"City": "Pelzer"
+"PostalCode": "29669"
+"UnparsedAddress": "9538 Augusta Road, Pelzer, SC 29669"
+"Coordinates": array:2 [
0 => -82.388772
1 => 34.624543
]
+"Latitude": 34.624543
+"Longitude": -82.388772
+"YearBuilt": 2005
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "Southern Visions Realty I LLC"
+"ListAgentMlsId": "9720"
+"ListOfficeMlsId": "357"
+"OriginatingSystemName": "columbiamls"
+"PublicRemarks": "GREAT RETAIL OPPORTUNITY – Former Dollar General – 9,014 SF!! This versatile 9,014 square foot commercial building, formerly occupied by Dollar General, offers an exceptional opportunity for a wide range of retail or service-based businesses. Strategically located with excellent visibility and easy access, the property features a spacious open floor plan ideal for a seamless retail layout, showroom, or customer-focused service operation. Property Highlights: *Size: 9,014 SF of flexible retail space. *Open Floor Plan: Ready for customization to suit your business needs. *Prime Location: High-traffic area with strong visibility and signage potential. *Ample Parking: On-site customer and employee parking available with marked handicap spaces. *Turnkey Potential: Previously used as a national retail chain, infrastructure is in place for quick occupancy. *Zoning: Commercial – suitable for retail, service businesses, or specialty shops. Whether you’re expanding your retail footprint or launching a new venture, this well-maintained property offers the space, location, and adaptability to make your business thrive. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.
GREAT RETAIL OPPORTUNITY – Former Dollar General – 9,014 SF!! This versatile 9,014 square foot commercial building, formerly occupied by Dollar General, offers
"
+"BuildingAreaUnits": "Sqft"
+"CoListAgentEmail": "renlow@svrealty.com"
+"Cooling": "Central"
+"CountyOrParish": "Greenville"
+"CreationDate": "2025-06-26T15:07:06.139558+00:00"
+"Directions": "From Greenville, take 25 towards Pelzer, property on R just past intersection with Highway 418 & Highway 8."
+"Heating": "Central"
+"ListAgentEmail": "scouch@svrealty.com"
+"LivingAreaUnits": "Sqft"
+"LotSizeUnits": "Sqft"
+"MlsStatus": "ACTIVE"
+"OpenParkingSpaces": "35"
+"OriginalEntryTimestamp": "2025-06-26"
+"PhotosChangeTimestamp": "2025-06-26T15:04:51Z"
+"PhotosCount": "4"
+"Sewer": "Septic"
+"StateOrProvince": "SC"
+"StreetName": "Augusta"
+"StreetNumber": "9538"
+"StreetSuffix": "Road"
+"WaterSource": "Public"
+"Zoning": "Unzoned"
+"TMS": "0604010101601"
+"Address": "9538 Augusta Road"
+"LVT Date": "2025-06-26"
+"Power On": "Yes"
+"New/Resale": "Resale"
+"class_name": "CI_3"
+"Transaction": "Sale"
+"# of Stories": "1"
+"Construction": "Metal"
+"LA1User Code": "COUCHS"
+"Co-List Agent": "6566"
+"Status Detail": "0"
+"Co-List Office": "357"
+"Price Per SQFT": "80.73"
+"Agent Hit Count": "20"
+"Geo Subdivision": "SC"
+"Gross Heated SqFt": "9104"
+"LO1Main Office ID": "357"
+"LA1Agent Last Name": "Couch"
+"Rollback Tax (Y/N)": "No"
+"LA1Agent First Name": "Stephanie"
+"Geo Update Timestamp": "2025-06-26T15:04:51.3"
+"LO1Office Identifier": "357"
+"Address Search Number": "9538"
+"LO1Office Abbreviation": "SOUV01"
+"Listing Type Agreement": "Exclusive Right to Sell"
+"Publish to Internet Y/N": "Yes"
+"Bldg Attached/Free Stndg": "Free Standing"
+"First Photo Add Timestamp": "2025-06-26T15:04:51.8"
+"MlsAreaMajor": "All Others SC Counties"
+"Media": array:4 [
0 => array:11 [
"Order" => 0
"MediaKey" => "6117260"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/611726/7b19fc3eb46efb424f4e865a1492a94b.webp"
"ClassName" => "Commercial"
"MediaSize" => 661819
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/611726/thumbnail-7b19fc3eb46efb424f4e865a1492a94b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "611726"
]
1 => array:11 [
"Order" => 1
"MediaKey" => "6117261"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/611726/11c5714eea0f2670f4e831e71e00934c.webp"
"ClassName" => "Commercial"
"MediaSize" => 626357
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/611726/thumbnail-11c5714eea0f2670f4e831e71e00934c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "611726"
]
2 => array:11 [
"Order" => 2
"MediaKey" => "6117262"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/611726/e75fc98c2100bd8ea01580b037ad1e9e.webp"
"ClassName" => "Commercial"
"MediaSize" => 683969
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/611726/thumbnail-e75fc98c2100bd8ea01580b037ad1e9e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "611726"
]
3 => array:11 [
"Order" => 3
"MediaKey" => "6117263"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/611726/3e3df977bcba291ce603811bde87f7ce.webp"
"ClassName" => "Commercial"
"MediaSize" => 352884
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/611726/thumbnail-3e3df977bcba291ce603811bde87f7ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "611726"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('611726')"
+"ID": "108034"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3818
+post_id: "98567"
+post_author: 1
+"ListingKey": "601841"
+"ListingId": "601841"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Office"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2025-07-09T15:49:45Z"
+"RFModificationTimestamp": "2025-07-09T15:56:47.884353+00:00"
+"ListPrice": 479900.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 6.41
+"LivingArea": 0
+"BuildingAreaTotal": 13133.0
+"City": "Eastover"
+"PostalCode": "29044"
+"UnparsedAddress": "120 Clarkson Street, Eastover, Sc 29044"
+"Coordinates": array:2 [
0 => -80.687988
1 => 33.878635
]
+"Latitude": 33.878635
+"Longitude": -80.687988
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "Carolina RE & Inv Group LLC"
+"ListAgentMlsId": "9416"
+"ListOfficeMlsId": "634"
+"OriginatingSystemName": "columbiamls"
+"PublicRemarks": "Priced to sell! Previously occupied by DSS & other medical and government tenants. Ample parking, brick building built to last. Exam rooms, X-Ray rooms, break rooms, offices, reception, bathrooms, storage and more. Sale also includes TMS R36807-10-10 & R311-01-05. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.
Priced to sell! Previously occupied by DSS & other medical and government tenants. Ample parking, brick building built to last. Exam rooms, X-Ray rooms, break r
"
+"BuildingAreaUnits": "Sqft"
+"Cooling": "Central"
+"CountyOrParish": "Richland"
+"CreationDate": "2025-03-20T21:48:56.762776+00:00"
+"Directions": "Take 378 to Eastover. Right on Old Eastover Rd. Left on Vanboklen. Right on Clarkson."
+"Heating": "Central"
+"ListAgentEmail": "carolina_realestate@yahoo.com"
+"LivingAreaUnits": "Sqft"
+"LotSizeUnits": "Sqft"
+"MlsStatus": "PENDING"
+"OpenParkingSpaces": "92"
+"OriginalEntryTimestamp": "2025-02-11"
+"PhotosChangeTimestamp": "2025-07-09T15:49:45Z"
+"PhotosCount": "18"
+"Sewer": "Public"
+"StateOrProvince": "SC"
+"StreetName": "Clarkson"
+"StreetNumber": "120"
+"StreetSuffix": "Street"
+"WaterSource": "Public"
+"Zoning": "T"
+"TMS": "36807-10-09"
+"Address": "120 Clarkson Street"
+"Best Use": "Medical or Government facility"
+"LVT Date": "2025-02-11"
+"Lot Size": "0"
+"New/Resale": "Resale"
+"class_name": "CI_3"
+"Transaction": "Sale"
+"# of Stories": "1"
+"Construction": "Block,Brick"
+"LA1User Code": "FILERR"
+"Status Detail": "0"
+"Occupancy Date": "2023-08-07"
+"Price Per SQFT": "36.54"
+"Agent Hit Count": "81"
+"Geo Subdivision": "SC"
+"Gross Heated SqFt": "13133"
+"LO1Main Office ID": "634"
+"LA1Agent Last Name": "Filer"
+"Rollback Tax (Y/N)": "No"
+"LA1Agent First Name": "Rachel"
+"Geo Update Timestamp": "2025-02-11T14:39:49.3"
+"LO1Office Identifier": "634"
+"Address Search Number": "120"
+"LO1Office Abbreviation": "CARR01"
+"Listing Type Agreement": "Exclusive Right to Sell"
+"LA1Agent Middle Initial": "C"
+"Publish to Internet Y/N": "Yes"
+"First Photo Add Timestamp": "2025-02-11T14:39:50"
+"MlsAreaMajor": "Rural Richland Co Southeast - Eastover"
+"Media": array:18 [
0 => array:11 [
"Order" => 0
"MediaKey" => "6018410"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601841/79d8778f01bd0a669039f4bd82ca0f98.webp"
"ClassName" => "Office"
"MediaSize" => 155397
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601841/thumbnail-79d8778f01bd0a669039f4bd82ca0f98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "601841"
]
1 => array:11 [
"Order" => 1
"MediaKey" => "6018411"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601841/a8c65f612625ee45c83527cf6bcc81a8.webp"
"ClassName" => "Office"
"MediaSize" => 154545
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601841/thumbnail-a8c65f612625ee45c83527cf6bcc81a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "601841"
]
2 => array:11 [
"Order" => 2
"MediaKey" => "6018412"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601841/b2b3aa798fcd846391d4bb8c6b01b49e.webp"
"ClassName" => "Office"
"MediaSize" => 111324
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601841/thumbnail-b2b3aa798fcd846391d4bb8c6b01b49e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "601841"
]
3 => array:11 [
"Order" => 3
"MediaKey" => "6018413"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601841/43e915f698fa1682983d7a6df3174e0d.webp"
"ClassName" => "Office"
"MediaSize" => 136802
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601841/thumbnail-43e915f698fa1682983d7a6df3174e0d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "601841"
]
4 => array:11 [
"Order" => 4
"MediaKey" => "6018414"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601841/653259075630554038c79ddcd90e7742.webp"
"ClassName" => "Office"
"MediaSize" => 162915
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601841/thumbnail-653259075630554038c79ddcd90e7742.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "601841"
]
5 => array:11 [
"Order" => 5
"MediaKey" => "6018415"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601841/30111bbdab4eb65d3d3f6f242dae25ef.webp"
"ClassName" => "Office"
"MediaSize" => 168176
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601841/thumbnail-30111bbdab4eb65d3d3f6f242dae25ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "601841"
]
6 => array:11 [
"Order" => 6
"MediaKey" => "6018416"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601841/862deaf553d1407bd51e033d1a62d881.webp"
"ClassName" => "Office"
"MediaSize" => 252671
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601841/thumbnail-862deaf553d1407bd51e033d1a62d881.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "601841"
]
7 => array:11 [
"Order" => 7
"MediaKey" => "6018417"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601841/8d798357d43e52a11a310521116b3914.webp"
"ClassName" => "Office"
"MediaSize" => 71974
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601841/thumbnail-8d798357d43e52a11a310521116b3914.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "601841"
]
8 => array:11 [
"Order" => 8
"MediaKey" => "6018418"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601841/efbbb70f32814f46964116fd07dd7904.webp"
"ClassName" => "Office"
"MediaSize" => 212671
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601841/thumbnail-efbbb70f32814f46964116fd07dd7904.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "601841"
]
9 => array:11 [
"Order" => 9
"MediaKey" => "6018419"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601841/5da8b11d4a160bf29865556ea4270ca9.webp"
"ClassName" => "Office"
"MediaSize" => 724125
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601841/thumbnail-5da8b11d4a160bf29865556ea4270ca9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "601841"
]
10 => array:11 [
"Order" => 10
"MediaKey" => "60184110"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601841/8e72cff8dd3146450144db4a393c9b2e.webp"
"ClassName" => "Office"
"MediaSize" => 812024
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601841/thumbnail-8e72cff8dd3146450144db4a393c9b2e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "601841"
]
11 => array:11 [
"Order" => 11
"MediaKey" => "60184111"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601841/bde39a11823d627944bf27089186dd03.webp"
"ClassName" => "Office"
"MediaSize" => 118057
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601841/thumbnail-bde39a11823d627944bf27089186dd03.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "601841"
]
12 => array:11 [
"Order" => 12
"MediaKey" => "60184112"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601841/8ab42d80cb6d3788dc280c73d8c2faf4.webp"
"ClassName" => "Office"
"MediaSize" => 202829
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601841/thumbnail-8ab42d80cb6d3788dc280c73d8c2faf4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "601841"
]
13 => array:11 [
"Order" => 13
"MediaKey" => "60184113"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601841/d59dd3bb0d55c85fad9bed771904db70.webp"
"ClassName" => "Office"
"MediaSize" => 213736
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601841/thumbnail-d59dd3bb0d55c85fad9bed771904db70.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "601841"
]
14 => array:11 [
"Order" => 14
"MediaKey" => "60184114"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601841/80cecd8d5897f11b6e6aaf32cb6cb870.webp"
"ClassName" => "Office"
"MediaSize" => 131881
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601841/thumbnail-80cecd8d5897f11b6e6aaf32cb6cb870.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "601841"
]
15 => array:11 [
"Order" => 15
"MediaKey" => "60184115"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601841/f1e503ac6e7ec29d650fb388751f126d.webp"
"ClassName" => "Office"
"MediaSize" => 344355
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601841/thumbnail-f1e503ac6e7ec29d650fb388751f126d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "601841"
]
16 => array:11 [
"Order" => 16
"MediaKey" => "60184116"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601841/bf3d0b587d42e4d63fc6fcf8f3e334c6.webp"
"ClassName" => "Office"
"MediaSize" => 352692
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601841/thumbnail-bf3d0b587d42e4d63fc6fcf8f3e334c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "601841"
]
17 => array:11 [
"Order" => 17
"MediaKey" => "60184117"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/601841/a1032967ef169716a8a6f8ce6168cdb7.webp"
"ClassName" => "Office"
"MediaSize" => 202829
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/601841/thumbnail-a1032967ef169716a8a6f8ce6168cdb7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "601841"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('601841')"
+"ID": "98567"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3790
+post_id: "108868"
+post_author: 1
+"ListingKey": "612619"
+"ListingId": "612619"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Office"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-07-08T20:19:03Z"
+"RFModificationTimestamp": "2025-07-08T20:25:02.162718+00:00"
+"ListPrice": 175000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 3788.0
+"City": "Columbia"
+"PostalCode": "29201"
+"UnparsedAddress": "4120 North Main Street, Columbia, SC 29201"
+"Coordinates": array:2 [
0 => -81.038792
1 => 34.040917
]
+"Latitude": 34.040917
+"Longitude": -81.038792
+"YearBuilt": 1904
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "SM Realty & Associates LLC"
+"ListAgentMlsId": "16570"
+"ListOfficeMlsId": "1061"
+"OriginatingSystemName": "columbiamls"
+"PublicRemarks": "Unlock the potential of this high-visibility property located in the heart of Columbia's revitalized North Main corridor. 4120 N Main Street offers a unique blend of character, convenience, and commercial promise just minutes from downtown, BullStreet District, and major transit routes. This versatile building features ample frontage along N Main Street, ideal for attracting foot and drive-by exposure. Whether you're looking for office spaces, converting to multi-purpose, or a creative studio, this property is a blank canvas ready for your vision. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.
Unlock the potential of this high-visibility property located in the heart of Columbia's revitalized North Main corridor. 4120 N Main Street offers a unique ble
"
+"BuildingAreaUnits": "Sqft"
+"Cooling": "Central,Window Units"
+"CountyOrParish": "Richland"
+"CreationDate": "2025-07-08T20:12:50.749467+00:00"
+"Directions": "Following I-277 into downtown Columbia, exit Beltine Blvd./Sunset Drive and turn right at the left. Travel to .04 miles to N Main Street and make another right. The property will be located .08 of a mile on the right.
Following I-277 into downtown Columbia, exit Beltine Blvd./Sunset Drive and turn right at the left. Travel to .04 miles to N Main Street and make another right.
"
+"Heating": "Central,Forced Air"
+"ListAgentEmail": "aldermaa@gmail.com"
+"LivingAreaUnits": "Sqft"
+"LotSizeUnits": "Sqft"
+"MlsStatus": "ACTIVE"
+"OpenParkingSpaces": "2"
+"OriginalEntryTimestamp": "2025-07-08"
+"PhotosChangeTimestamp": "2025-07-08T20:01:43Z"
+"PhotosCount": "19"
+"Sewer": "Public"
+"StateOrProvince": "SC"
+"StreetDirPrefix": "N"
+"StreetName": "Main Street"
+"StreetNumber": "4120"
+"WaterSource": "Public"
+"Zoning": "Commercial General"
+"TMS": "09214-14-08"
+"Address": "4120 N Main Street"
+"LVT Date": "2025-07-08"
+"New/Resale": "Resale"
+"class_name": "CI_3"
+"Transaction": "Sale"
+"# of Stories": "2"
+"Construction": "Mason"
+"LA1User Code": "ALDERMA"
+"Status Detail": "0"
+"Price Per SQFT": "46.2"
+"Geo Subdivision": "SC"
+"Gross Heated SqFt": "3788"
+"LO1Main Office ID": "1061"
+"LA1Agent Last Name": "Alderman"
+"Rollback Tax (Y/N)": "No"
+"LA1Agent First Name": "Alexander"
+"Geo Update Timestamp": "2025-07-08T20:12:32.6"
+"LO1Office Identifier": "1061"
+"Address Search Number": "4120"
+"LO1Office Abbreviation": "SMSC01"
+"Listing Type Agreement": "Exclusive Right to Sell"
+"Publish to Internet Y/N": "Yes"
+"First Photo Add Timestamp": "2025-07-08T20:01:43"
+"MlsAreaMajor": "City of Columbia, Denny terrace, Lake Elizabeth"
+"Media": array:19 [
0 => array:11 [
"Order" => 0
"MediaKey" => "6126190"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612619/57cf6fcd66c8c45457afa890214563ba.webp"
"ClassName" => "Commercial"
"MediaSize" => 840914
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612619/thumbnail-57cf6fcd66c8c45457afa890214563ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612619"
]
1 => array:11 [
"Order" => 1
"MediaKey" => "6126191"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612619/0a81108bfe0ec01260fb553a96e9e28e.webp"
"ClassName" => "Commercial"
"MediaSize" => 711485
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612619/thumbnail-0a81108bfe0ec01260fb553a96e9e28e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612619"
]
2 => array:11 [
"Order" => 2
"MediaKey" => "6126192"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612619/25852a8dbafee8bca2e73e202e9e4678.webp"
"ClassName" => "Commercial"
"MediaSize" => 945555
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612619/thumbnail-25852a8dbafee8bca2e73e202e9e4678.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612619"
]
3 => array:11 [
"Order" => 3
"MediaKey" => "6126193"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612619/62edce795e54fbfa99452ce105eff7a0.webp"
"ClassName" => "Commercial"
"MediaSize" => 1093815
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612619/thumbnail-62edce795e54fbfa99452ce105eff7a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612619"
]
4 => array:11 [
"Order" => 4
"MediaKey" => "6126194"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612619/c652fa10393e1567fe2f18cbd13dfd02.webp"
"ClassName" => "Commercial"
"MediaSize" => 990735
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612619/thumbnail-c652fa10393e1567fe2f18cbd13dfd02.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612619"
]
5 => array:11 [
"Order" => 5
"MediaKey" => "6126195"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612619/697dd26ad3f21052714eafdb827f4031.webp"
"ClassName" => "Commercial"
"MediaSize" => 420341
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612619/thumbnail-697dd26ad3f21052714eafdb827f4031.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612619"
]
6 => array:11 [
"Order" => 6
"MediaKey" => "6126196"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612619/792450a0b87ad0ad602fb4d8cd83097a.webp"
"ClassName" => "Commercial"
"MediaSize" => 1058879
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612619/thumbnail-792450a0b87ad0ad602fb4d8cd83097a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612619"
]
7 => array:11 [
"Order" => 7
"MediaKey" => "6126197"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612619/88f76326bb4cd1d2da6028b9f06628e2.webp"
"ClassName" => "Commercial"
"MediaSize" => 740275
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612619/thumbnail-88f76326bb4cd1d2da6028b9f06628e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612619"
]
8 => array:11 [
"Order" => 8
"MediaKey" => "6126198"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612619/4dd5b79b60e0fa72bcc6ae58b10d39f4.webp"
"ClassName" => "Commercial"
"MediaSize" => 714580
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612619/thumbnail-4dd5b79b60e0fa72bcc6ae58b10d39f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612619"
]
9 => array:11 [
"Order" => 9
"MediaKey" => "6126199"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612619/8e1a21ab75efc20ec3694e36525de877.webp"
"ClassName" => "Commercial"
"MediaSize" => 680847
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612619/thumbnail-8e1a21ab75efc20ec3694e36525de877.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612619"
]
10 => array:11 [
"Order" => 10
"MediaKey" => "61261910"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612619/a9820e453f1327aed09c87437ac7aac4.webp"
"ClassName" => "Commercial"
"MediaSize" => 660290
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612619/thumbnail-a9820e453f1327aed09c87437ac7aac4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612619"
]
11 => array:11 [
"Order" => 11
"MediaKey" => "61261911"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612619/813b38216e193273c0b4b6c5948debef.webp"
"ClassName" => "Commercial"
"MediaSize" => 681795
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612619/thumbnail-813b38216e193273c0b4b6c5948debef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612619"
]
12 => array:11 [
"Order" => 12
"MediaKey" => "61261912"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612619/5ee2b9b1fea497d29f0c266ca48527f3.webp"
"ClassName" => "Commercial"
"MediaSize" => 588820
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612619/thumbnail-5ee2b9b1fea497d29f0c266ca48527f3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612619"
]
13 => array:11 [
"Order" => 13
"MediaKey" => "61261913"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612619/0fdab1f5732b26db0e887457435892e6.webp"
"ClassName" => "Commercial"
"MediaSize" => 627336
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612619/thumbnail-0fdab1f5732b26db0e887457435892e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612619"
]
14 => array:11 [
"Order" => 14
"MediaKey" => "61261914"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612619/606e6f87acca7e32ca49d2e3d868105a.webp"
"ClassName" => "Commercial"
"MediaSize" => 405957
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612619/thumbnail-606e6f87acca7e32ca49d2e3d868105a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612619"
]
15 => array:11 [
"Order" => 15
"MediaKey" => "61261915"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612619/0c858b149dfdfdefbb77e49b0913413f.webp"
"ClassName" => "Commercial"
"MediaSize" => 806747
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612619/thumbnail-0c858b149dfdfdefbb77e49b0913413f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612619"
]
16 => array:11 [
"Order" => 16
"MediaKey" => "61261916"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612619/b90c39a2df22aad8cbd242dd93e77ec5.webp"
"ClassName" => "Commercial"
"MediaSize" => 938875
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612619/thumbnail-b90c39a2df22aad8cbd242dd93e77ec5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612619"
]
17 => array:11 [
"Order" => 17
"MediaKey" => "61261917"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612619/ba6e1630195ba3cc93eb821115736037.webp"
"ClassName" => "Commercial"
"MediaSize" => 1006435
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612619/thumbnail-ba6e1630195ba3cc93eb821115736037.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612619"
]
18 => array:11 [
"Order" => 18
"MediaKey" => "61261918"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612619/3d9a231dc3a2ce7e3dc60cc7123b7c5b.webp"
"ClassName" => "Commercial"
"MediaSize" => 738815
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612619/thumbnail-3d9a231dc3a2ce7e3dc60cc7123b7c5b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "612619"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('612619')"
+"ID": "108868"
}
]
+success: true
+page_size: 4
+page_count: 42
+count: 165
+after_key: ""
}
"RF Response Time" => "0.4 seconds"
]
]