WEST BABYLON [Permits for WEST BABYLON]

51 - 79 of 79

CIAR ARANN CORP

Business

Active


FAJARDO, RODOLFO R

Individual

Active


STALLONE, THOMAS F

Individual

Active


CRONIN, DANIEL

Individual

Active


EMG INDUSTRIAL CHIMNEY INC

Business

Active


FINISHLINE CARTING CORP.

Business

Active


MEHMOOD, IMRAN

Individual

Active


STALLWORTH, CHRISTOPHER

Individual

Active


FURNITURE TECH USA

Business

Inactive


MCELEARNEY, ELIZABETH ANN

Individual

Active


GRAHAM, WESLEY

Individual

Inactive


PATRIQUIN, THOMAS G

Individual

Active


MARTIN, BRIAN G.

Individual

Active


BAGGIO, PETER

Business

Active


MICHAEL J. MARRA INC.

Business

Active


BELCZYNSKI, MAREK

Individual

Inactive


M.I.K. ENTERPRISES

Business

Active



K.B.C. CONSTRUCTION, CORP.

Business

Active


2 FINE LINE INC.

Business

Active


PATRIOT MOBILITY INC.

Business

Active


MARZANO, GARY R

Individual

Active


OROZCO, DANIEL G

Individual

Active


Erden, Mert

Individual

Inactive


S & S FUEL CO., INC.

Business

Inactive



A.P. SIDING & WINDOW CORP.

Business

Active


MARCOR CONSTRUCTION INC.

Business

Active


HOMECARE USA, INC.

Business

Inactive


(default) 2 queries took 448 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 ( '(+WEST +BABYLON)' IN BOOLEAN MODE) LIMIT 50, 502929230
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+WEST +BABYLON)' IN BOOLEAN MODE)11218