LONG IS CITY [Permits for LONG IS CITY]

101 - 150 of 920

LUCKETT, VINCENT K

Individual

Active


PERISAN, ENES

Individual

Inactive


PEDERSEN, YASMINE

Individual

Inactive


SMOKE BIZARRE CORP

Business

Active


FRITMAN-ORTIZ, PAULA

Individual

Active


ARCAK, CAGLAR

Individual

Active


THE LUEDTKE AGENCY, LLC

Business

Active


FILLAS, CHRISTOPHER

Individual

Active


MR. TIRE SHOP

Business

Active


LONG ISLAND CITY FOOD CORP

Business

Active



LIC HOTEL INC

Business

Active


7 ELEVEN STORE #39222A

Business

Active


MENDEZ, ROSARIO A

Individual

Active


7 ELEVEN STORE 35314A

Business

Active


Zierman, Roger

Individual

Active


NB NET SOLUTIONS 4 INC

Business

Active


7-ELEVEN STORE 35314A

Business

Active


UNO OF ASTORIA, INC.

Business

Inactive


LUCKETT, VINCENT K.

Individual

Inactive


VERNON GRILLE

Business

Inactive


SUSSMAN, DONALD

Individual

Active


MADERA PIZZA & GRILL INC

Business

Inactive


SIMS METAL

Business

Active


MEFTUN, FERIDUN BATU

Individual

Inactive


786 PARKING CORP

Business

Inactive


CHRAIBI MIOU, NACER

Individual

Inactive


ALMIROUDIS, KONSTANTINOS

Individual

Active


INDIE LIC LLC

Business

Inactive


LAR WEN ASSOCIATES INC.

Business

Active


SARDAR JI TOWING INC

Business

Inactive


EPIC TOWING INC

Business

Inactive



BEST CARE AT HOME

Business

Inactive


KONTOS, CHRISTOS

Individual

Inactive


QUIK PARK CRESCENT LLC

Business

Active


AUTO IMAGE

Business

Inactive


STEWART, COTTRELL

Individual

Inactive


MBA WIRELESS

Business

Active


TEAM SYSTEMS CORP.

Business

Inactive


T & N AUTO DEALERSHIP CORP

Business

Active


PALIOURAS, DIMITRIOS

Individual

Active


HAGIAS, KONSTADINOS

Individual

Active


SINGH TOWING INC.

Business

Inactive


MASTERMIND TOWING, INC.

Business

Inactive


MCGILL, CLAYTON

Individual

Inactive


SUPER FAST TOWING, INC.

Business

Inactive


GULINO, SALVATORE

Individual

Active


DIFINZO, MICHAEL

Individual

Active


23RD STREET PARKING INC.

Business

Active


(default) 2 queries took 496 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 ( '(+LONG +IS +CITY)' IN BOOLEAN MODE) LIMIT 100, 50505077
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+LONG +IS +CITY)' IN BOOLEAN MODE)11419