ISLIP [Permits for ISLIP]

101 - 146 of 146

Ashlar Contracting LLC

Business

Inactive


Daniels, Series

Individual

Active


BOROWIEC, BRIAN

Individual

Active



D.A.D.C. COMPANY

Business

Active


OZZIE'S HOME IMPROVEMENT

Business

Inactive


MILI, GJOVALIN

Individual

Inactive


HENRY, PETER

Individual

Active


LAPIDUS, MARTY I

Individual

Inactive


LICHTENSTEIN, SEYMOUR

Individual

Inactive



CORREA VENTURA, ANEUDY

Individual

Active


TRIGLIA, JOSEPH

Individual

Inactive



LOFFREDO, JOHN

Individual

Active


ALLEN, DUDLEY

Individual

Active


CONWAY, RICHARD

Individual

Inactive


PERNA CONTRACTING, LLC

Business

Active


OZKOKTEM, ERKAN

Individual

Active


CORNIELLE, CRISTOBAL

Individual

Inactive


SEECHARAN, LESLIE

Individual

Active



ZECCHINI, MATTHEW

Individual

Active


KURKELA, SCOTT A

Individual

Inactive


JOHNSON, JOHN M

Individual

Active


GREENGROW INC

Business

Active


LOMOT, BRIAN

Individual

Active


PATSOS, GEORGE M

Individual

Active


SEECHARAN, LESLIE

Individual

Inactive


MONTALBANO, JON

Individual

Active


SAMARU, AVIENASH

Individual

Active


FOUROUNJIAN, THOMAS

Individual

Active


AVELAR, JOSE

Individual

Active


RICE, JEFFREY

Individual

Active


KENNEDY, JOHN

Individual

Inactive


TAGGART, JD

Individual

Active


POHORELEC, ANTHONY

Individual

Active


EHLERT, DENNIS

Individual

Active


RODACK, JACK

Individual

Active




MAXXUM CONSTRUCTION CORP.

Business

Active


REAL ESTATE ADVENTURES LLC

Business

Inactive


HUANG, TONY

Individual

Active


SUNWOOD TECHNOLOGY, INC

Business

Inactive


LAMBROS HOME DESIGN, INC.

Business

Inactive


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