{"action":"elsewhere","city":"Pittsburgh","companyRegistrationNumber":null,"conformityFlag":"NON_CONFORMING","country":"US","createdAt":"1992-08-03T00: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":"1 Commerce Dr","headquartersCity":"Pittsburgh","headquartersCountry":"US","headquartersPostalCode":"15239","headquartersRegion":"US-PA","lastUpdatedAt":"2025-05-02T13:12:16.743Z","legalAddress":"1 Commerce Dr","legalFormAbbreviation":null,"legalFormCode":"8888","legalFormName":null,"legalJurisdiction":"US-PA","legalName":"Aqua Realty Holdings","lei":"549300ZKJEL5WRQ19S11","managingLou":"5493001KJTIIGC8Y1R12","managingLouName":"Bloomberg","managingLouWebsite":"http://lei.bloomberg.com","nextRenewalAt":"2014-10-01T20:05:00.000Z","otherLegalForm":"COMPANY","postalCode":"15239","region":"US-PA","registeredAt":"2013-10-03T03:07:00.000Z","registrationAuthorityId":"RA000632","registrationAuthorityName":"Pennsylvania Department of State","registrationAuthorityWebsite":"https://www.corporations.pa.gov/Search/corpsearch","registrationNumber":"2101226","registrationNumberFormatted":"2101226","registrationStatus":"LAPSED","served":false,"successorLeis":[],"validationAuthorityEntityId":"2101226","validationAuthorityId":"RA000632","validationAuthorityName":"Pennsylvania Department of State","validationSources":"FULLY_CORROBORATED"}