{"action":"elsewhere","city":"Wilmington","companyRegistrationNumber":null,"conformityFlag":"NON_CONFORMING","country":"US","createdAt":"2012-06-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":"C/O A&E Real Estate, 31st Floor, 1065 Avenue of the Americas","headquartersCity":"New York","headquartersCountry":"US","headquartersPostalCode":"10018","headquartersRegion":"US-NY","lastUpdatedAt":"2026-07-23T13:31:42.629Z","legalAddress":"C/O CORPORATION SERVICE COMPANY, 251 LITTLE FALLS DRIVE","legalFormAbbreviation":null,"legalFormCode":"HZEH","legalFormName":"Limited Liability Company","legalJurisdiction":"US-DE","legalName":"217-227 Haven Avenue, LLC","lei":"549300BNVICRVLB56N76","managingLou":"5493001KJTIIGC8Y1R12","managingLouName":"Bloomberg","managingLouWebsite":"http://lei.bloomberg.com","nextRenewalAt":"2017-07-19T16:23:00.000Z","otherLegalForm":null,"postalCode":"19808","region":"US-DE","registeredAt":"2015-06-27T01:37:00.000Z","registrationAuthorityId":"RA000602","registrationAuthorityName":"Division of Corporations, Department of State","registrationAuthorityWebsite":"https://corp.delaware.gov/","registrationNumber":"5177217","registrationNumberFormatted":"5177217","registrationStatus":"LAPSED","served":false,"successorLeis":[],"validationAuthorityEntityId":"5177217","validationAuthorityId":"RA000602","validationAuthorityName":"Division of Corporations, Department of State","validationSources":"FULLY_CORROBORATED"}