ELMONT [Permits for ELMONT]

51 - 100 of 185

scicchitano, pietro

Individual

Active


GELESTATHIS, ILIAS

Individual

Active


HAND PAINTING DESIGN CORP

Business

Active


GONZALEZ, HERMAN

Individual

Active


MCC GROUP CONSTRUCTION CORP

Business

Inactive



BOCAGE, CHRISTOPHER

Individual

Inactive


ANJUM, SHAZIA

Individual

Active


MANO HOME IMPROVEMENT, INC.

Business

Inactive


JODAN SERVICE CORP

Business

Inactive



PATRAS, KONSTANTINOS

Individual

Active


HERNANDEZ, JOSE

Individual

Active


SIERRA, JEFFREY W

Individual

Active


LOPEZ, ARMANDO

Individual

Active


SINGH, NAVDEEP

Individual

Active


FILAKOVSKY, JOHN

Individual

Active


MILLAMAR CONSTRUCTION CORP.

Business

Active


ORTHO-MED EQUIP INC

Business

Active


MARJENN CONSTRUCTION INC.

Business

Active


BROWN, MARQUES

Individual

Inactive


NOSWORTHY, KENROY W

Individual

Inactive


HALL, STANLEY

Individual

Active


ROBERTS, DELROY W

Individual

Inactive


REYES-RIVAS, KENIA

Individual

Inactive


SINGH, HARMAN

Individual

Active


ROBERTS, JOHN M

Individual

Inactive



ETIENNE, RONALD

Individual

Inactive


Jimenez, Juan

Individual

Active


L&M MORA FRAMING CORP

Business

Inactive


SIMPLE SOLUTIONS SERVICES INC.

Business

Inactive


YIN, CHIN YEN

Individual

Active


POPOOLA, SHERROL

Individual

Active


AFZAL, MOHAMMED

Individual

Active


Jones, Joseph

Individual

Active


ESCOBAR, LUIS

Individual

Active


YAHOO CONSTRUCTION CORP.

Business

Active


MANZANO, ERICK P

Individual

Inactive


HURT, DARNELL

Individual

Active


ESTELLE & CO. LLC

Business

Active


MCGUIRE, MORT K

Individual

Active


FOSTER, STEPHON

Individual

Active


KHAN, JENNIFER

Individual

Active


nuñez, JESUS

Individual

Active


MATARZYNSKI, EDWARD M

Individual

Active


CHO, SUNG M

Individual

Inactive


MORSE, ANTHONY

Individual

Active


LAGUERRE, WANDIE

Individual

Active


J & P POOL, INC.

Business

Active


(default) 2 queries took 437 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 50, 50505099
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)11338