UNION CITY [Permits for UNION CITY]

1 - 50 of 69

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


BIYIKOGLU, OMER

Individual

Active


SALTO, ANGEL

Individual

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


INANIR, TUNAHAN

Individual

Inactive


TAPIA, BERKYS

Individual

Inactive


NURKENOV, BERIK

Individual

Inactive


ATMACA NIHAT

Business

Active


ROBLES, CESAR

Individual

Inactive


BERROA, WESTER

Individual

Active



BECKER, SCOTT

Individual

Active


JUAREZ, MERCEDES

Individual

Active


MALEKMARZBAN, FARZAD

Individual

Inactive


PORTSCHE, MELANIE

Individual

Inactive


GABEL, WILLIAM J.

Individual

Inactive


Goliath Woodworking LLC

Business

Active


KEANE, DECLAN P

Individual

Active


VAN ONSELEN, YVONNE

Individual

Active


UNSAL, ISMAIL

Individual

Active


HERNANDEZ, FRANCOIS

Individual

Inactive


GUALLPA, JOSE

Individual

Active


HANDSOME CAB TOURS LTD.

Business

Active


CONSEC BUILDERS CORPORATION

Business

Inactive


DSC CONSTRUCTION GROUP LLC

Business

Active



VAN ONSELEN DESIGN LLC

Business

Inactive



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