UNION [Permits for UNION]

51 - 100 of 155


BECKER, SCOTT

Individual

Active


JUAREZ, MERCEDES

Individual

Active


MALEKMARZBAN, FARZAD

Individual

Inactive


PORTSCHE, MELANIE

Individual

Inactive


GABEL, WILLIAM J.

Individual

Inactive


AGD CONTRACTING CORP.

Business

Active


Goliath Woodworking LLC

Business

Active



KEANE, DECLAN P

Individual

Active


LLANES, ROGER T

Individual

Inactive


SCHWARTZ, HARVEY A

Individual

Inactive


OTABOR, OSARUMEN

Individual

Active


VAN ONSELEN, YVONNE

Individual

Active


ROSADO, LUIZ PAULO

Individual

Active


UNSAL, ISMAIL

Individual

Active


PRIOLA, THOMAS JOSEPH

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




YAKUBU, HAMZA

Individual

Inactive


D'ALESSANDRO, ALFRED J

Individual

Active


CHIOBI, EMMANUEL

Individual

Active


VAN ONSELEN DESIGN LLC

Business

Inactive



CERPA, RICHARD

Individual

Active


PELIT, SAFA

Individual

Inactive


NAHACZEWSKI, JOHN

Individual

Active


SIRIGNANO, JAMES

Individual

Active


FERNANDEZ, JEFF

Individual

Inactive


SHEPPARD, KEVIN

Individual

Active


ESPINOSA, ALEJANDRO

Individual

Active


SCHMIDT, STEVEN

Individual

Active


OLIYNYK, ANDRIY

Individual

Active


JOSEPH, ESTHER

Individual

Active


REYES, DAVID

Individual

Active



MARTIN, ANTHONY

Individual

Inactive


WILSON, AUGUSTUS

Individual

Inactive


WILSON, AUGUSTUS

Individual

Active


AKSOY, ENIS

Individual

Active


CRUZADO, RONNY S

Individual

Active


SINIBALDI, RONALD A

Individual

Active


UNION WIRELESS CORPORATION

Business

Active


COSTEIRA, MICHAEL

Individual

Active



(default) 2 queries took 320 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 50, 505050104
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)11216