{"action":"elsewhere","city":"Wallingford","companyRegistrationNumber":null,"conformityFlag":"NON_CONFORMING","country":"US","createdAt":"2023-01-12T00: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_PUBLIC"],"references":[]},{"category":"ULTIMATE_ACCOUNTING_CONSOLIDATION_PARENT","reasons":["NON_PUBLIC"],"references":[]}],"parents":[]},"headquartersAddress":"863 N Main St. Ext, Suite 200","headquartersCity":"Wallingford","headquartersCountry":"US","headquartersPostalCode":"06492","headquartersRegion":"US-CT","lastUpdatedAt":"2026-05-12T15:33:54.441Z","legalAddress":"C/O Justin Urbano, 863 N Main St. Ext, Suite 200","legalFormAbbreviation":"LLC","legalFormCode":"Y182","legalFormName":"Limited Liability Company","legalJurisdiction":"US-CT","legalName":"Comprehensive Real Estate LLC","lei":"254900R0S0OWVKUSR469","managingLou":"5493001KJTIIGC8Y1R12","managingLouName":"Bloomberg","managingLouWebsite":"http://lei.bloomberg.com","nextRenewalAt":"2027-05-22T15:38:51.640Z","otherLegalForm":null,"postalCode":"06492-2434","region":"US-CT","registeredAt":"2024-07-22T15:38:51.639Z","registrationAuthorityId":"RA000600","registrationAuthorityName":"Secretary of the State's Commercial Recording Division","registrationAuthorityWebsite":"http://www.concord-sots.ct.gov/CONCORD/online?sn=InquiryServlet&eid=99","registrationNumber":"2696609","registrationNumberFormatted":"2696609","registrationStatus":"ISSUED","served":false,"successorLeis":[],"validationAuthorityEntityId":"2696609","validationAuthorityId":"RA000600","validationAuthorityName":"Secretary of the State's Commercial Recording Division","validationSources":"FULLY_CORROBORATED"}