SUPERIOR [Permits for SUPERIOR]

51 - 98 of 98

SUPERIOR CONTRACTING

Business

Active


SUPERIOR MARKETS

Business

Active





Superior Debt Recovery LLC

Business

Inactive


SUPERIOR MARKET

Business

Active


SUPERIOR COOLING CORP.

Business

Inactive




SUPERIOR ROOFING CO

Business

Active



SUPERIOR PAWNBROKERS INC

Business

Inactive


SUPERIOR GRILL & DELI INC.

Business

Inactive


SUPERIOR STRUCTURES LLC

Business

Inactive




SUPERIOR MARKET STORE

Business

Inactive



SUPERIOR FOOD IV INC

Business

Inactive


7TH AVE SUPERIOR MARKET INC

Business

Active




SUPERIOR APPLIANCE INC.

Business

Active


SISCO TEK

Business

Inactive


SUPERIOR DELI & GRILL

Business

Active






SUPERIOR REGROUTING INC.

Business

Active


98-02 SUPERIOR DELI CORP.

Business

Inactive


SUPERIOR BUILDERS II INC.

Business

Active


SUPERIOR DELI GROCERY CORP

Business

Active


SUPERIOR MARKET 104, INC.

Business

Inactive



SUPERIOR TIRE AND WHEEL INC.

Business

Inactive


SUPERIOR TELECOM, INC

Business

Active


SUPERIOR HALF HOUR LAUNDRY

Business

Active




NOSTRAND SUPERIOR MARKET CORP

Business

Inactive


SUPERIOR PARKING LLC

Business

Active




Superior Laundromat

Business

Active


SUPERIOR MARKETS

Business

Active


SUPERIOR PAWNBROKERS INC

Business

Inactive


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