ASTORIA [Permits for ASTORIA]

1 - 50 of 2491

IKONOMAKIS, SPIROS

Individual

Inactive


VASQUEZ, JORGE A

Individual

Active


Kegel, Brigid

Individual

Inactive


DITMARS NATURAL CORP

Business

Inactive


GUNDERSON, KEVIN

Individual

Active


Elder, Kaleb

Individual

Active



argenas, katina

Individual

Inactive


LAURONI, FRANCESCO

Individual

Inactive


Meyer, Samuel

Individual

Inactive


COMPARE

Business

Inactive


MZN DELI & GROCERY INC

Business

Inactive


Belyayeva, Elena

Individual

Inactive


TOLBERT, ALLYSON

Individual

Inactive


POURNELLE, JOHN D

Individual

Inactive


ALMIROUDIS, ADAMANTIOS

Individual

Active


SWEENEY, TIMOTHY

Individual

Active


60 BEANS

Business

Inactive


RHANOR, RENEE

Individual

Inactive


KANELLOU CORP

Business

Inactive


CHRISTODOLIDES, THEO

Individual

Active


NEW HAPPY DELI & GROCERY, INC.

Business

Inactive


ABRAHAMS, LITAL

Individual

Inactive


MALIS, DIMITRIOS

Individual

Inactive


CIORNEI, FRANK C

Individual

Inactive


GEORGE'S

Business

Active


29 FRUIT MARKET INC.

Business

Inactive


5 STAR GROCERY STORE INC

Business

Inactive


DEMIRKAN, ERDEM

Individual

Active


POLITO'S PIZZA

Business

Inactive


BRIK LOUNGE AND KITCHEN

Business

Active


BISCUITERIA LLC

Business

Active


WHALEN, JORDAN

Individual

Active


STN GLOBAL LLC

Business

Inactive


FILIPOV, FILIP PETYOV

Individual

Inactive


ZINCHENKO, VITALY

Individual

Active


DELELLIS, GIANCARLO

Individual

Inactive


RUGGIERI, RICHARD

Individual

Inactive


ROSS, NEIL

Individual

Inactive


PARK, NICHOLAS

Individual

Active


XPRESS DELI & GROCERY INC

Business

Active


TRADE FAIR

Business

Inactive


CYCLONE APPLIANCE SERVICES LLC

Business

Inactive


PAHOLAK, WILLIAM W

Individual

Inactive


D'OTTAVIO, ERNEST

Individual

Active


BURRAI, MIRIAM

Individual

Inactive


ZIAD FOOD CORP.

Business

Inactive


MARQUIS, TIMOTHY

Individual

Inactive


Todic, Mujo

Individual

Inactive


GIBSON, ROJE

Individual

Inactive


(default) 2 queries took 301 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 5050509
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)11292