COLTS NECK [Permits for COLTS NECK]

1 - 20 of 20

FERGUSON, ANDREW C

Individual

Inactive


MILLENIUM STONE WORKS

Business

Active


POLINO, THOMAS CARMINE

Individual

Active



GRECO INDUSTRIES, LLC

Business

Active


GRADY, JOSEPH

Individual

Active


Goodman, Tania

Individual

Active


GRECO, CAMILLE

Individual

Active


SHORT SLATE LLC

Business

Inactive


PERDELWITZ, KURTIS

Individual

Active


SHORT, CHRISTOPHER P

Individual

Active


NIERVA, CAROLINE

Individual

Inactive


VASTOLA, JOY

Individual

Inactive


BUONO, FRANK

Individual

Active


Majestic Exteriors LLC

Business

Active


MORREALE, ROBERT J

Individual

Active


NICOLETTI, JAMES

Individual

Active


CAPUTO, MICHAEL J

Individual

Inactive


FOLEY, ARTHUR C

Individual

Active


NICOLETTI, REMY

Individual

Active


(default) 1 query took 223 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 ( '(+COLTS +NECK)' IN BOOLEAN MODE) LIMIT 502020223