UNION CITY [Permits for UNION CITY]

51 - 69 of 69

PELIT, SAFA

Individual

Inactive


FERNANDEZ, JEFF

Individual

Inactive


ESPINOSA, ALEJANDRO

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


BIO DYNAMIC TECHNOLOGIES

Business

Active



GUZENGE, MURAT

Individual

Active


TAPA, OZGUR

Individual

Active


SARIER, EMIR

Individual

Active


HANDSOME CAB TOURS LTD.

Business

Inactive


TAPA, GURKAN

Individual

Active


(default) 2 queries took 438 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 50, 501919221
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