ELMONT [Permits for ELMONT]

1 - 50 of 185

CORDOBA, FROILAN

Individual

Inactive



NAISSANT, HENRY

Individual

Active


AMIN, CHOUDRY M

Individual

Active


FOLTA, LUKASZ

Individual

Active


ZORIA CONSTRUCTION NY INC.

Business

Active


ACUNA, WILMAN

Individual

Active


SEVERE, WILDE O

Individual

Inactive


BESS, GREGORY

Individual

Active


RED STAR CONSTRUCTION CORP

Business

Inactive


VERNI, FRANK

Individual

Active



SERAFIN, LESZEK

Individual

Inactive



AVILA, JOSE A

Individual

Active


HENRY NAISSANT

Business

Active


COIMIN, DAVID

Individual

Active


ALUNIQUE CONSTRUCTION CORP.

Business

Active


FREDERIQUE, CLEASIN

Individual

Active


M & Z WIRELESS NYC CORP

Business

Active


CIMA CONTRACTOR INC.

Business

Active


LIBQUAL FENCE CO., INC.

Business

Active


VIV'S CONSTRUCTION CO. INC.

Business

Active


GIANNOUSIS, EVANGELOS

Individual

Active


REFIT CONSTRUCTION CORP.

Business

Active


STRIANESE, ANTHONY L

Individual

Active


CHEN, ZHEN JING

Individual

Active


800 ELMONT RD

Business

Active


COREAS, OSMIN

Individual

Active



SINGH, GURDIT

Individual

Active



PACIFIC LAWN SPRINKLERS

Business

Active


PLATT, KEVIN

Individual

Inactive


MORRIS, CALVIN

Individual

Active


ASIF, CHOUDHARY

Individual

Inactive


ARCH 2 STUDIO LLC

Business

Inactive


CLOWNS.COM, INC.

Business

Active



CLOWNS.COM, INC.

Business

Active


CLOWNS.COM, INC.

Business

Active


BARNES, JOHN

Individual

Inactive


YIN, SUSAN

Individual

Inactive


STAN'S WINDOW SERVICE, INC.

Business

Active


WAAG, RONALD O

Individual

Inactive


ESPAILLAT, ALEJANDRO

Individual

Active


SEVERE, WILDE O

Individual

Active


SINGH, NAVNEET

Individual

Active


PLATERO, JOSE

Individual

Active


URUVIP HOME IMPROVEMENT CORP

Business

Inactive


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