ASTORIA [Permits for ASTORIA]

301 - 350 of 2491

CIGAR WAREHOUSE INC.

Business

Active


CHRISTOS STEAK HOUSE

Business

Inactive


PINGUIL, MANUEL

Individual

Active



PANTEROV, TEODOR

Individual

Inactive


SENDROW, JENNIFER K

Individual

Active


SINGH, AMARDEEP

Individual

Inactive


LUKOLIC, MUSA

Individual

Active


ASTORIA GOURMET DELI NY INC

Business

Active


NAULA, NORBERTO J

Individual

Active


NURIKYAN, ANTOAN

Individual

Active


ADDIR, ANOUAR

Individual

Inactive


MADHU CORP.

Business

Active


THE CITY VAPER LTD.

Business

Active


FUCCILO, VALERIO

Individual

Active


MARIA DELI & GROCERY

Business

Active


RACHEL, SCHENK

Individual

Active


GJELOSHAJ, PREL

Individual

Active


KASTRAT, ANESS

Individual

Inactive


NAIMA AGENCY INC

Business

Active


Loizzo, Irina

Individual

Inactive


Best Today's Laundromat

Business

Active


Garcia Chamorro, Claudio

Individual

Active


HIRANI CORPORATION

Business

Active




SION GROCERY CORP

Business

Active


TURAN ENTERPRISE

Business

Active


FOGARTY, KATHRYN

Individual

Inactive


OFF THE HOOK

Business

Active


FERRINI, ANGELA R

Individual

Active


CHERGUI, YOUCEF

Individual

Active


KLM DELI GROCERY INC.

Business

Active


DEMERGIS, STEVE

Individual

Active


ASTORIA CARD PLUS

Business

Active


DESS, ZACHARY

Individual

Active


KENT, CLIFF

Individual

Inactive


ELI'S DELI & GROCERY INC.

Business

Active


NN GROCERY INC.

Business

Active


MOONLIGHT DELI GROCERY INC.

Business

Inactive


TSETSEKAS, EDDIE

Individual

Active


KNAPP, INES

Individual

Inactive



ROSSELLI, RICCARDO A

Individual

Active


HIRIZA, CALINA

Individual

Active


MILO CAFE, CORP.

Business

Inactive


FLEMING, SEAN W

Individual

Inactive


VENETIS, STELIOS

Individual

Active


RUBY'S CANDY & GROCERY INC

Business

Active


LAKIN, PHILIP

Individual

Active


(default) 2 queries took 250 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 300, 50505027
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)11223