ASTORIA [Permits for ASTORIA]

51 - 100 of 2491

TRADE FAIR

Business

Inactive


MELNICK, RICHARD J

Individual

Inactive


Krukovich, Artsem

Individual

Active


Padgett, Michael

Individual

Inactive


NAIMOV, FAZLIDDIN

Individual

Active


OLMSTEAD, PATRICIA LYNN

Individual

Active


NASSIS, DIMITRIOS

Individual

Active


RILEY, KASHIMIR

Individual

Inactive


BELGUENDOUZ, AMEL

Individual

Inactive


Graney, Benjamin

Individual

Active


HUSSAIN, SHABBIR

Individual

Active


SCATOLONI, LEANNA

Individual

Inactive


GAVALAS, STAMATIOS T

Individual

Inactive


NEW MARGARITA GROCERY INC.

Business

Inactive


FARDOUS, SAMIHM

Individual

Active


JANAH, ABDELLATIF

Individual

Inactive


Zivney, Teresa

Individual

Active


WILLIAMS, ERIC

Individual

Inactive


VANVOORHIS, JUSTIN

Individual

Active


BIKERMAN, TANIA

Individual

Inactive


RICCARDO'S CATERING INC.

Business

Inactive


BARTHELEMY, GILBERT

Individual

Active


MCEWAN, PATRICK J.

Individual

Active


NISHIMURA, ERIN

Individual

Inactive


RILEY, LAURA

Individual

Inactive


NOVELTY & GROCERY HALAL MEAT

Business

Inactive


LIPEDE, RORY

Individual

Inactive



31-18 BROADWAY CORP.

Business

Active


GLO-BRITE LAUNDROMAT INC

Business

Inactive


UCKAR, DANILO

Individual

Inactive


AZUL-34 LLC

Business

Inactive


MACIN, BRUCE

Individual

Active


LOMBARDI, CRISTINA

Individual

Inactive


GVD DRY CLEANERS INC.

Business

Inactive


JIMMY'S CLEANERS

Business

Inactive


21 AVENUE LAUNDROMAT CORP.

Business

Inactive


TESKA, JENNIFER

Individual

Inactive


PORCHE, LAURE

Individual

Inactive


GALLINARI, PETER

Individual

Active


MIAO'S BROTHERS INC.

Business

Inactive




NEW ET LAUNDROMAT, INC.

Business

Inactive


GILL, SEAN

Individual

Active


RIM'S LAUNDROMAT

Business

Inactive


RICCARDO'S CATERING INC.

Business

Inactive


36 QB LAUNDROMAT INC.

Business

Inactive


K.J.M. FAMOUS CLEANERS CORP.

Business

Inactive


VERIZON WIRELESS

Business

Active


(default) 2 queries took 227 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 50, 50505017
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)11210