CRESSKILL [Permits for CRESSKILL]

1 - 9 of 9

A.B.M. CONSTRUCTION INC.

Business

Active


Rael, Nikolaz

Individual

Active


HAXHAJ, FARUK

Individual

Active


SIGCHA, EDDY

Individual

Active


Savas, Kathleen

Individual

Active


Gutman, Erez

Individual

Active


MRANTZ, RONNIE

Individual

Active


MURRAY, JOHN

Individual

Inactive


LEE, CHUL SOO

Individual

Active


(default) 1 query took 225 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 ( '(+CRESSKILL)' IN BOOLEAN MODE) LIMIT 5099225