KEYPORT [Permits for KEYPORT]

1 - 13 of 13

O'REGAN, TERENCE

Individual

Active


J&S FlOORING

Business

Active


O'REAGANS SEAMLESS GULTERS

Business

Active


OROPALLO, MICHAEL

Individual

Active


TURK COLLECTORS, INC.

Business

Active



JUNG, ASJA

Individual

Active


CJ'S HOME IMPROVEMENT'S

Business

Inactive


WALKER, JOHN

Individual

Active


WALKER, JOHN

Individual

Inactive


WALKER, CAROLINE

Individual

Active


CAPONETTO, CHAD

Individual

Active


DZAKULIN, MIOMIR

Individual

Active


(default) 1 query took 213 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 ( '(+KEYPORT)' IN BOOLEAN MODE) LIMIT 501313213