ELMONT [Permits for ELMONT]

151 - 185 of 185

PARIS, DAVE A

Individual

Inactive


CEFAI, CARMEL

Individual

Active




ROBLES, EDY O

Individual

Active


MEDCO TECH INC.

Business

Inactive


POPOOLA, GANIYU

Individual

Active


BATTLE, THEODORE

Individual

Inactive


BYRNE, FRANK, J

Individual

Active


AMPARADO, AHRILLEO

Individual

Active


Segarra, Louis

Individual

Active


NSOUGAN, LAURENT

Individual

Active


BLUE PORT CONSTRUCTION INC.

Business

Active


CHASSEDIN, WLADIMIR N

Individual

Inactive


911 HOMESAVERS, LLC

Business

Active


GARCIA, GLADYS M

Individual

Active


Dennberg, Daniel

Individual

Active


DES RON, ALEXANDER

Individual

Active


AGUDELO, ROBINSON

Individual

Active


RODNEY, DARRIEN M.

Individual

Active


SIRA CONSTRUCTION, INC.

Business

Active


ESPAILLAT, ALEJANDRO

Business

Active


JOSE LANDSCAPING

Business

Active


MICHEL, ALAIN

Individual

Active


CHAUDHRY, QURBAN A

Individual

Active


SINGH, KULDIP

Individual

Active




NESCO CONSTRUCTION INC.

Business

Inactive


SEVERE BUILDERS LLC

Business

Inactive



C.E.M. DYNASTY CORP.

Business

Inactive


HOME IMPROVEMENT BY JMCA INC.

Business

Inactive


HAPPY CONSTRUCTION INC.

Business

Inactive


SUPREME JUDGMENT RECOVERY II

Business

Inactive


(default) 2 queries took 717 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 150, 503535368
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)11349