ASTORIA [Permits for ASTORIA]

351 - 400 of 2491

BAIG, AZAM

Individual

Active


JABAR, GOWKARRAN

Individual

Active


OTHELLO DELI

Business

Active


KEYFOOD

Business

Active



CON ED

Business

Active



KJ ASTORIA GOURMET INC

Business

Active


BUTCHER BAR SMOKEHOUSE

Business

Active


KEY FOOD

Business

Active


DEGAICHIA, ISHAK

Individual

Active


VIA VAI

Business

Active


MEGA ELECTRONICS

Business

Active


Plieninger, Marcus

Individual

Inactive


KJ ASTORIA GOURMET INC

Business

Active


LONG ISLAND CITY FOOD CORP

Business

Active


YILDIRIM, AHMET

Individual

Active


SILVERSTEIN, ANDREW L

Individual

Active



YAMAN, MURAT

Individual

Inactive


FANA DELI GROCERY

Business

Active


MC DELI GROCERY

Business

Active


AHMAD, MOHAMAD K

Individual

Active


BROADWAY CORNER STORE CORP.

Business

Active


A & E CLEANERS CORP

Business

Active


REIS, TOLGAY

Individual

Active


IVANOV, DENIS

Individual

Active


T. & P. AUTO BODY REPAIRS INC

Business

Inactive


KATECHIS, DEMETRIOS S

Individual

Active


PAINT POWER

Business

Active


Campbell, Emilie

Individual

Active


MANOLIS, SPIRIDON D

Individual

Active


BOUTIEROS, NIKOLITSA

Individual

Active




UNO OF ASTORIA, INC.

Business

Inactive


LEONEL, SANTIAGO

Individual

Active


FS LAUNDRY CORP

Business

Inactive


DELLAMORE, PATRICK

Individual

Inactive


48 BODEGA INC

Business

Active


SULLIVAN, STEVEN

Individual

Active


BIRBAS, HARRY

Individual

Inactive


AF FOOD CORP.

Business

Active


BROADWAY CAFE

Business

Active


48 BODEGA INC

Business

Inactive


LUCERO, MARCO

Individual

Inactive


OKSAYAN, BURAK

Individual

Active



ARCENTALES, SAIDA

Individual

Active


KHODJAEV, MUZAFFAR M.

Individual

Active


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