SOUTH OZONE PK [Permits for SOUTH OZONE PK]

351 - 400 of 500

RNK 2 WIRELESS INC

Business

Active


DAVIN'S CONSTRUCTION, INC.

Business

Active


AMARI, YANOUF A

Business

Inactive


TUNIN LLC

Business

Active


HERMAN CONSTRUCTION INC.

Business

Active


JOSHUA CONSTRUCTION CORP.

Business

Active





CHETRAM, OUTRAM

Business

Active


R B CONSTRUCTION

Business

Inactive



TIK TAC TOWS INC.

Business

Inactive




R A CONTRACTING CO

Business

Active


JAGGI0988@GMAIL.COM

Business

Active


ANVIEN CONSTRUCTION, LLC

Business

Active


JRD BROTHERS INC

Business

Active


CHAND CONSTRUCTION

Business

Active



B.M. KHERA CONSTRUCTION, INC.

Business

Inactive


MYRTLE CONSTRUCTION INC.

Business

Active


QUICKSAVE DELI GROCERY CORP.

Business

Inactive



GMG GEN CONSTRUCTION CORP.

Business

Active





JULIO'S IRON WORKS, INC.

Business

Active



KNICKSILVER WHEEL PROS

Business

Inactive




FIVE ELEVEN CONVENIENCE INC.

Business

Inactive


RSK 2 WIRELESS

Business

Active


NY IDEAL CONSTRUCTION INC

Business

Active



VP CONSTRUCTION

Business

Active


APNA SOHNA BAZAR INC.

Business

Active


ICONIC DEVELOPMENT GROUP LLC

Business

Inactive


L L G CONSTRUCTION INC.

Business

Active


Light Supplies USA Inc.

Business

Active


SELL AND PAWN INC.

Business

Inactive


E & J LAUNDROMAT INC

Business

Active


MOREA PAWNBROKERS LLC

Business

Inactive


T & M REFRIGERATION INC

Business

Inactive





(default) 2 queries took 401 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 ( '(+SOUTH +OZONE +PK)' IN BOOLEAN MODE) LIMIT 350, 505050180
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+SOUTH +OZONE +PK)' IN BOOLEAN MODE)11221