SEATTLE [Permits for SEATTLE]

1 - 20 of 20

PEARA, MARY

Individual

Active


CILICI, LLC

Business

Active


PANATTE, LLC

Business

Active


ALTA CHUTES I, LLC

Business

Active


CERASTES, LLC

Business

Active


CANDICA, LLC

Business

Inactive


PALLIDA, LLC

Business

Active


VANDA, LLC

Business

Active


ANTHIUM, LLC

Business

Active


TRIFERA, LLC

Business

Active


LAELIA, LLC

Business

Active


WEINSTEIN & RILEY, P.S.

Business

Active


RONEN, LLC

Business

Active


PALLIDA, LLC

Business

Inactive


CANDICA, LLC

Business

Active


NATIONAL SERVICE BUREAU

Business

Active


MORIO, LLC

Business

Inactive


DODEKA OF NEW YORK LLC

Business

Inactive


PHARIA, L.L.C.

Business

Inactive


CANDICA, LLC

Business

Inactive


(default) 1 query took 241 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Record`.`id`, `Record`.`DCA_License_Number`, `License Type`, `License Expiration Date`, `License Status`, `License Creation Date`, `Record`.`Industry`, `Record`.`Business_Name`, `Record`.`Business_Name_2`, `Address Building`, `Address Street Name`, `Secondary Address Street Name`, `Record`.`Address_City`, `Address State`, `Address ZIP`, `Contact Phone Number`, `Address Borough`, `Borough Code`, `Community Board`, `Council District`, `Record`.`BIN`, `Record`.`BBL`, `Record`.`NTA`, `Census Tract`, `Record`.`Detail`, `Record`.`Longitude`, `Record`.`Latitude`, `Record`.`Location`, `Record`.`description` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+SEATTLE)' IN BOOLEAN MODE) LIMIT 502020241