{"action":"elsewhere","city":"Schenectady","companyRegistrationNumber":null,"conformityFlag":"NON_CONFORMING","country":"US","createdAt":"1997-02-13T00:00:00.000Z","entityCategory":"GENERAL","entityStatus":"ACTIVE","entitySubCategory":null,"expirationReason":null,"expiredAt":null,"family":{"children":[],"childrenTotal":0,"exceptions":[{"category":"DIRECT_ACCOUNTING_CONSOLIDATION_PARENT","reasons":["NON_CONSOLIDATING"],"references":[]},{"category":"ULTIMATE_ACCOUNTING_CONSOLIDATION_PARENT","reasons":["NON_CONSOLIDATING"],"references":[]}],"parents":[]},"headquartersAddress":"310 Wayto Road","headquartersCity":"Schenectady","headquartersCountry":"US","headquartersPostalCode":"12303","headquartersRegion":"US-NY","lastUpdatedAt":"2025-09-21T13:30:00.020Z","legalAddress":"310 Wayto Road","legalFormAbbreviation":null,"legalFormCode":"SDX0","legalFormName":"Limited Liability Company","legalJurisdiction":"US-NY","legalName":"SJM Realty, LLC","lei":"2549005IX2GM1XQ6ZF67","managingLou":"5493001KJTIIGC8Y1R12","managingLouName":"Bloomberg","managingLouWebsite":"http://lei.bloomberg.com","nextRenewalAt":"2025-09-20T17:40:10.538Z","otherLegalForm":null,"postalCode":"12303","region":"US-NY","registeredAt":"2024-09-20T17:40:10.537Z","registrationAuthorityId":"RA000628","registrationAuthorityName":"Corporation and Business Entity Database (Division of Corporations, State Records and UCC, Department of State)","registrationAuthorityWebsite":"http://www.dos.ny.gov/corps/bus_entity_search.html","registrationNumber":"2113185","registrationNumberFormatted":"2113185","registrationStatus":"LAPSED","served":false,"successorLeis":[],"validationAuthorityEntityId":"2113185","validationAuthorityId":"RA000628","validationAuthorityName":"Corporation and Business Entity Database (Division of Corporations, State Records and UCC, Department of State)","validationSources":"FULLY_CORROBORATED"}