ASTORIA [Permits for ASTORIA]

451 - 500 of 2491

ROSNER CUSTOM SOUND INC.

Business

Active


SPRINT SPECTRUM L.P.

Business

Active


NACIRI, TAOUFIK

Individual

Active


MAGIC TELECOM

Business

Active


ESPINOZA, MANUEL

Individual

Active


GONZALES, ALFONSO A

Individual

Active


1-2-3 TOWING

Business

Active


KIMBERLY'S AUTOMOTIVE INC.

Business

Inactive


KRAVCHUK, VICTOR

Individual

Inactive


PIZZA PALACE

Business

Inactive


ECHEGARAY, JOSE ALVARO

Individual

Active


GAVALAS, STAMATIOS T

Individual

Active


BEAN'S & LAGER

Business

Inactive


JAOUAT, ADIL

Individual

Inactive


PEOPLENTECH, LLC

Business

Inactive


TIERRAS COLOMBIANAS II

Business

Inactive


LIGAS, PANAGIOTIS

Individual

Active


YILDIRIM, MERT

Individual

Active


P.L.E. TOWING INC.

Business

Inactive


PERRETTI, MICHAEL

Individual

Active


STOYANOV, VLADISLAV

Individual

Inactive


PRAYOSHA 3192 INC.

Business

Active


WRIGHT, STUART

Individual

Active


GOODMAN, LEO

Individual

Active


Haskel, Alex

Individual

Active



29-06 30th Ave

Business

Active


SPINA, SEBASTIANO

Individual

Active


EL HASSANI, CHOUAIB

Individual

Active


Krummenauer, Paulo

Individual

Inactive


TWINZ AUTO BODY INC

Business

Inactive


OZDEMIR, GOKHAN

Individual

Inactive


RITE AID STORE #1707

Business

Active


MICHOS, KONSTANTINOS

Individual

Active


BABA NEWSSTAND INC

Business

Active



BLUE WATER ASTORIA LLC

Business

Active


Warranty Logistics, LLC

Business

Active


SUPER ELITE PARKING INC

Business

Active


BEST NY BUILDERS, INC.

Business

Active


CRATER CANDY STORE CORP.

Business

Active


DI PAOLA, CHIARA

Individual

Active


KAMAR INC

Business

Active


ELYAMAMI, MHAMED

Individual

Active


NASR, ASHRAF

Individual

Active


UKATOSH CORPORATION

Business

Inactive


DANGELO, MARIO

Individual

Inactive


S.K. SEWING MACHINE SERVICE

Business

Active


AMERICAN COLLISION

Business

Inactive


KENINI, DHIONIS

Individual

Active


(default) 2 queries took 290 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 450, 50505045
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)11245