LYNBROOK [Permits for LYNBROOK]

1 - 50 of 91

Tiago, Leonardo

Individual

Active


NIKA, NIKO

Individual

Active


SANCHEZ, VICTOR

Individual

Active


FAROOQ, BILAL

Individual

Active


CONN, SHELLY G

Individual

Active


CLIFFORD, JOHN R

Individual

Active


PRITSINEVELOS, CYNTHIA M.

Individual

Active


JOHNSON, WILLIAM N

Individual

Active


HERNANDEZ, OSCAR

Individual

Inactive


SINGH, PAUL

Individual

Active


AGID, BRIAN H

Individual

Active


JESTCOR CONTRACTING INC.

Business

Active


SABAS NY SERVICES INC

Business

Active


primeau, rusty

Individual

Active


AMMP Home Improvements LLC

Business

Inactive


CAPOBIANCO, RICHARD J.

Individual

Active


DIMARCO, KEVIN

Individual

Inactive




FREDERICKS, MICHAEL

Individual

Inactive


ALMANZAR, HUMBERTO

Individual

Inactive


TAMEER INC.

Business

Active


ELLER, STAURT

Individual

Inactive


Showercrafters

Business

Inactive


KIRALY, RICHARD

Individual

Active


HENRY CONSTRUCTION INC

Business

Active


YARD, KENNETH

Individual

Active



BAGLIETTO, JARED

Individual

Inactive



DHAMI ENTERPRISES INC.

Business

Active


RECOMMENDED WOODWORK LLC

Business

Inactive


SHEHU, SHAMO

Individual

Active


MOSHE, MEIR

Individual

Inactive


ANGELOPOULOS, PRODROMOS

Individual

Active


TECHNOMEN NY INC

Business

Active


PIPPA INTERIORS LLC

Business

Inactive


DVORAK, VICTOR

Individual

Inactive



LUKOVENKO, GEORGE

Individual

Active


MORREN, MARSHA

Individual

Active


JT KITCHENS AND BATHS, INC.

Business

Inactive





KAUR, KAMALJIT

Individual

Active


PIAZZA, FRANK

Individual

Inactive


PILNACEK, CHARLES E

Individual

Active


MARTINEZ, JOSE A

Individual

Inactive


MELENTEV, VITALI

Individual

Active


(default) 2 queries took 312 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 ( '(+LYNBROOK)' IN BOOLEAN MODE) LIMIT 50505067
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+LYNBROOK)' IN BOOLEAN MODE)11245