RONKONKOMA [Permits for RONKONKOMA]

1 - 50 of 91

DEAK, DAVID G

Individual

Inactive


ELLENBERGER SERVICES, INC.

Business

Inactive


WOJCIK, WOJCIECH

Individual

Active


NASO, RYAN R

Business

Active


ROCKMORE CONTRACTING CORP.

Business

Active



NECKAMEYER, DONALD

Individual

Inactive


BORRUTO, MICHAEL

Individual

Active


CIAMPINI, EDWARD J

Individual

Inactive


FORIER, DOUGLAS

Individual

Active


FINN, JOHN

Individual

Active


SARDONE, MICHAEL

Individual

Active


SAREYANI, STEVE P

Individual

Inactive


DELLASALLE, ROBERT A

Individual

Inactive


PIANO, JOHN

Individual

Active


LEONARD, JOHN

Individual

Active




KINSELLA, EUGENE A

Individual

Inactive


Impastato, Peter

Individual

Active


WOOD & CO.

Business

Active


YAKER, DAVID

Individual

Active


CARRINO, KIM.

Individual

Active


LJG CONSTRUCTION, LLC

Business

Active


ISLAND APPLIANCE INC.

Business

Active



UNGUR, DAN

Individual

Active



GUIDA, JOHN

Individual

Inactive


AFANASEWICZ, ERIC M

Individual

Inactive


LONGO, PHILLIP

Individual

Inactive



LAPOLLA, JOHN

Individual

Active


RIBEIRO, LEONARDO

Individual

Active


CHU, ARTHUR

Individual

Active


CORAM GLASS AMD MIRROR INC.

Business

Active


CARPENTER, JAMES

Individual

Active


YIBASI, OSMAN

Individual

Inactive


ADVANCED CHIMNEY, INC.

Business

Active


HOME WORKS HOME IMPROVEMENT

Business

Active


Valenti Flooring, Inc.

Business

Active


VOITEK CONSTRUCTION

Business

Active


HOFFMANN, CHRISTOPHER

Individual

Active



D.B.L. ASSOCIATES, INC.

Business

Active


WANG, CHENG

Individual

Active


ERGONIC REMODELING INC

Business

Active


POLICASTRO, ANTHONY J.

Individual

Active


LAPOLLA METRO INC.

Business

Active



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