UNION [Permits for UNION]

1 - 50 of 155

PIKUNICH, NEDO

Individual

Active


VELOZ, ALBERTO A

Individual

Active


SMITH, GREGORY D.

Individual

Inactive


MCMULLAN, KEVIN

Individual

Inactive


MULLEN, JODY DANIEL

Individual

Inactive


JUAREZ, OMAR

Individual

Active



ABOAL, YOSELIN

Individual

Inactive


O'MEARA, JOHN F

Individual

Inactive


UNION TOP CLEAN INC.

Business

Inactive


DIFAZIO, GINA M

Individual

Active


KAPORCH, GEORGE J.

Individual

Active


BIYIKOGLU, OMER

Individual

Active


OSEKI-ODIGIE, AIWANSOSA

Individual

Active


UNION PAWN STORE

Business

Active


UNION EXPRESS LAUNDROMAT INC.

Business

Inactive


UNION SQUARE FOODS INC.

Business

Active


ANNA'S POOL DECK, LLC

Business

Active


SALTO, ANGEL

Individual

Active


UNION MARKET

Business

Active


BERROA, WESTER

Individual

Inactive



MARTINEZ, JASON

Individual

Active


PAZDEN, DAVID

Individual

Active


PAZDEN, DAVID

Individual

Active


TUGAY, ALI

Individual

Active


PAZDEN, DAVID

Business

Active


ATMACA, NIHAT

Individual

Active


SIERRA, ANGELO

Individual

Active


BAUMGARTEN, MARION C

Individual

Active


DMITRY KUPRIN

Business

Active


JUAREZ, OMAR

Individual

Inactive


BENRIALA, ABDERRAHIM

Individual

Active


CEVIK, SERDAR

Individual

Inactive


LEONOR, HEATCLIFF

Individual

Active


Marmion, Daniel

Individual

Active


TOMINI, HAMIT

Individual

Inactive


VAP UNION SQUARE, LLC

Business

Active



Costa, Joao

Individual

Active


INANIR, TUNAHAN

Individual

Inactive


ANTIQUES IN UNION INC

Business

Inactive


TAPIA, BERKYS

Individual

Inactive


Ryan Inc

Business

Active


NURKENOV, BERIK

Individual

Inactive


ATMACA NIHAT

Business

Active



ROBLES, CESAR

Individual

Inactive


OSARENKHOE, OSAYUWAMEN

Individual

Active


BERROA, WESTER

Individual

Active


(default) 2 queries took 314 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 ( '(+UNION)' IN BOOLEAN MODE) LIMIT 50505063
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+UNION)' IN BOOLEAN MODE)11251