ELMONT [Permits for ELMONT]

101 - 150 of 185


RABER, EDWARD C.

Individual

Active



PRZYKUTA, JOHN J

Individual

Active


ESMEN, NURTAN N

Individual

Inactive


SMITH, RICHARD

Individual

Active


911 HOMESAVERS, LLC

Business

Inactive


BEJARANO, OSCAR

Individual

Active


SMITH JR, JOSEPH C.

Individual

Active


ACEVEDO, GIOVANNY

Individual

Active


SEVERE BUILDERS LLC

Business

Active


COCHA, EDISSON

Individual

Active


NAEEM, MOHAMMAD

Individual

Active


SINGH, SWARAN

Individual

Active


RIVERA, WILFREDO

Individual

Active


BAJNO, JERZY

Individual

Inactive


GREGORY, TUCKER

Business

Inactive


KAUR, KULVIR

Individual

Active



BAICHU, SATHURAN

Individual

Inactive


SCIPIO, WAYNE

Individual

Active


360 TRANSFER CONTRACTING CORP

Business

Inactive


CHOUDHRY BUILDERS INC

Business

Active


VCT CONTRACTING

Business

Active


NEW WAY REMODELING INC.

Business

Active


YENZER, JOHN

Individual

Active


BUDHU, ROGER

Individual

Active


N & T CONTRACTORS CORP

Business

Active


FARTSALAS, PANTELIS

Individual

Active


HAYES, ANTHONY

Individual

Active


ADVANCED CARE

Business

Active


AVICENNA CONSTRUCTION INC

Business

Active


BROWN, SHAUN

Individual

Active


SMITH, OCTAVIS E

Individual

Active



KING, LESLIE M

Individual

Inactive


THE HOME DEPOT

Business

Active


Tharani, Mohammed

Individual

Active


MAMMONE, JAMES

Individual

Active


NUBIA INC.

Business

Inactive



JC KING'S HOME IMPROVEMENT INC

Business

Inactive


TIP TOP HOME IMPROVEMENTS

Business

Inactive


TARIQ, JAVEED

Individual

Active


NILES, STEVEN

Individual

Inactive


TUCKER, GREGORY

Individual

Inactive


VENTURA, RAFFAELE

Individual

Active


KHAN, HASRATH

Individual

Active


GOTHAM CONSTRUCTION NY CORP

Business

Active


WEBNEST CONSTRUCTION CO.

Business

Active


(default) 2 queries took 376 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 100, 505050131
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)11245