{"action":"elsewhere","city":"COLUMBUS","companyRegistrationNumber":null,"conformityFlag":"NON_CONFORMING","country":"US","createdAt":"2014-05-28T00: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":"4568 Mayfield Road, Suite 204","headquartersCity":"Cleveland","headquartersCountry":"US","headquartersPostalCode":"44121","headquartersRegion":"US-OH","lastUpdatedAt":"2026-05-14T19:11:04.154Z","legalAddress":"C/O REGISTERED AGENT SOLUTIONS, INC., 4400 EASTON COMMONS WAY, SUITE 125","legalFormAbbreviation":"limited liability company","legalFormCode":"EZNQ","legalFormName":"Limited Liability Company","legalJurisdiction":"US-OH","legalName":"Sheffield Realty LLC","lei":"5493000N8DD5BDW1WH31","managingLou":"5493001KJTIIGC8Y1R12","managingLouName":"Bloomberg","managingLouWebsite":"http://lei.bloomberg.com","nextRenewalAt":"2019-06-26T19:48:00.000Z","otherLegalForm":null,"postalCode":"43219","region":"US-OH","registeredAt":"2018-07-02T16:08:00.000Z","registrationAuthorityId":"RA000629","registrationAuthorityName":"Corporation Database (Ohio Secretary of State)","registrationAuthorityWebsite":"https://businesssearch.ohiosos.gov/","registrationNumber":"2298984","registrationNumberFormatted":"2298984","registrationStatus":"LAPSED","served":false,"successorLeis":[],"validationAuthorityEntityId":"2298984","validationAuthorityId":"RA000629","validationAuthorityName":"Corporation Database (Ohio Secretary of State)","validationSources":"FULLY_CORROBORATED"}