S.OZONE PARK [Permits for S.OZONE PARK]

701 - 750 of 4129


AYON CONSTRUCTION

Business

Active


GOLDEN HAMMER HOME IMPRV

Business

Active


SHAH, FAZIM

Individual

Active


CRUZ, PORFIRIO

Individual

Active


SANTIAGO, HARRY

Individual

Active


LOPEZ, ROSA MARIA

Business

Active


LAZAR, DANIEL

Individual

Active



BPPM CONSTRUCTION, INC.

Business

Active


P&D MERCHANDISE CORP

Business

Inactive


311 DELI & GRILL CORP

Business

Inactive


ROCKWELL CAR PARK LLC

Business

Inactive


LIBERTY PAWN IT INC

Business

Active


RITE AID STORE #4866

Business

Active


Park, Matthew

Individual

Active



RITE AID STORE #7930

Business

Active


UNCLE NEIL'S II, INC.

Business

Inactive



MULTANI, AMARJIT S

Individual

Active


JEFF BLOCH'S AMP &

Business

Active


AUTO QUEENS TOWING CORP.

Business

Inactive


NAUTH, NANDRANIE

Individual

Inactive


T-MOBILE

Business

Active


RUPP, JOE

Individual

Active




AINSWORTH, NEIL

Individual

Inactive


Church Avenue Park, LLC.

Business

Active


RUNWAY TOWING CORP.

Business

Inactive


PARK 115TH LLC

Business

Active



LOJA, MARIA

Individual

Active


GOODWILL MASON INC

Business

Active


SP PLUS CORPORATION

Business

Active


MRC RESTORATION CORP.

Business

Active


IMBRIALE, ANTHONY

Individual

Active


SINGH, SUKHWINDER

Individual

Active


OBIDOV, OTABEK

Individual

Inactive


SHANY, SOLOMON

Individual

Active


FIRE ENGINE SLIDE

Business

Active


SELL AND PAWN INC.

Business

Inactive


PROGRESS SERVICE, INC

Business

Active


ZHENG, YU LAN

Individual

Inactive


JINDAL, SANJEEV

Individual

Inactive


MANTEC, INC

Business

Active


HABIBI GOURMET DELI 1 CORP

Business

Active


MARTINEZ, JOSEFINA

Individual

Active


A & R COLLISION EXPERTS CORP

Business

Inactive


(default) 2 queries took 378 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 ( '(+S.OZONE +PARK)' IN BOOLEAN MODE) LIMIT 700, 50505037
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+S.OZONE +PARK)' IN BOOLEAN MODE)11341