FAIR LAWN [Permits for FAIR LAWN]

1 - 34 of 34

VAZIRALLI, RAHEEM

Individual

Active


ERGAS, SHIMON

Individual

Active


KAPLAN, BRUCE

Individual

Inactive


BOUSSI, SAMUEL

Individual

Active


YEHUDIEL, YESASKR

Individual

Active


SHAVIT, SHAI

Individual

Active


RINDZUNER, HOWARD M

Individual

Inactive


PARK, JOHN Y

Individual

Active


PORTNOY, ALEKSANDR

Individual

Active


ZLIKA, EZRA

Individual

Active


GRINBERG, YEFIM

Individual

Active


KALININA, MARIA V.

Individual

Inactive


KONYO, ZOHAR

Individual

Inactive


WOLFELD, JEFFREY

Individual

Active


ERLEMEIER-GERALD, IRIS

Individual

Active


DADON, AVRAHAM

Individual

Active


SURIS, LILIYA

Individual

Active


KADOSH, YOSEF

Individual

Inactive


WOLFELD, ELLEN

Individual

Active


BARRON, MITCHELL

Individual

Inactive


ALMOSNINO, GAL

Individual

Active


ALL US DOORS NJ LLC

Business

Active


MENABDE, BESIK

Individual

Active


COHEN, YOSEF

Individual

Active


KENNEDY, LINDSAY

Individual

Inactive


DOINY, EZEQUIEL

Individual

Inactive


VELEZ, LUIS

Individual

Inactive


BISSOR, YOSEF

Individual

Active


UMSTEAD, MICHAEL

Individual

Active


PLAZA, DAVID J

Individual

Active


REGAL COLLECTIONS

Business

Inactive


STD ENTERPRISES, INC.

Business

Active


RINDE DESIGN AND CONSTRUCTION

Business

Inactive



(default) 1 query took 239 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 ( '(+FAIR +LAWN)' IN BOOLEAN MODE) LIMIT 503434239