{"action":"elsewhere","city":"Clifton Park","companyRegistrationNumber":null,"conformityFlag":"NON_CONFORMING","country":"US","createdAt":"2006-07-25T00:00:00.000Z","entityCategory":"GENERAL","entityStatus":"ACTIVE","entitySubCategory":null,"expirationReason":null,"expiredAt":null,"family":{"children":[],"childrenTotal":0,"exceptions":[{"category":"DIRECT_ACCOUNTING_CONSOLIDATION_PARENT","reasons":["NATURAL_PERSONS"],"references":[]},{"category":"ULTIMATE_ACCOUNTING_CONSOLIDATION_PARENT","reasons":["NATURAL_PERSONS"],"references":[]}],"parents":[]},"headquartersAddress":"3 Cemetery Road","headquartersCity":"Clifton Park","headquartersCountry":"US","headquartersPostalCode":"12065","headquartersRegion":"US-NY","lastUpdatedAt":"2025-11-11T20:13:14.159Z","legalAddress":"3 Cemetery Road","legalFormAbbreviation":null,"legalFormCode":"SDX0","legalFormName":"Limited Liability Company","legalJurisdiction":"US-NY","legalName":"The Shops At Halfmoon, LLC","lei":"549300C4H7Z67VOSUE59","managingLou":"5493001KJTIIGC8Y1R12","managingLouName":"Bloomberg","managingLouWebsite":"http://lei.bloomberg.com","nextRenewalAt":"2014-10-04T18:54:00.000Z","otherLegalForm":null,"postalCode":"12065","region":"US-NY","registeredAt":"2013-10-08T03:03:00.000Z","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":"3392537","registrationNumberFormatted":"3392537","registrationStatus":"LAPSED","served":false,"successorLeis":[],"validationAuthorityEntityId":"3392537","validationAuthorityId":"RA000628","validationAuthorityName":"Corporation and Business Entity Database (Division of Corporations, State Records and UCC, Department of State)","validationSources":"FULLY_CORROBORATED"}