LONG ISLAND CIT [Permits for LONG ISLAND CIT]

351 - 400 of 817

BEST BUY STORE #478

Business

Active


DOMUS SOLUTIONS CORP

Business

Active


Deli Rock

Business

Inactive


QUEENSBRIDGE PAWN SHOP

Business

Inactive


LM POWERHOUSE GARAGE LLC

Business

Active


14th Laundry

Business

Active



USACO

Business

Inactive



POSADA BROS. INC

Business

Inactive


SUPREME GLASS CO., INC.

Business

Active


INNOVATION AUTO BODY INC

Business

Active


NORTHSTAR KIA

Business

Active


PURVES CLEANERS INC.

Business

Active


DK CONSTRUCTION USA INC

Business

Active


Skyview Cleaners

Business

Inactive


TEITELBAUMS 1, INC.

Business

Active


TERRA GREENPOINT RETAIL CORP.

Business

Inactive


P.C. Richard & Son

Business

Active


T-MOBILE

Business

Active


DUNHILL AUTO BODY INC.

Business

Inactive



PM LEGAL, LLC

Business

Active


ONE SUNRISE

Business

Inactive



STONE & TERRAZZO WORLD INC

Business

Active


MOZART IRON CRAFT CORP.

Business

Active


Pacific Contracting

Business

Active


KENAN'S DELI & GROCERY CORP

Business

Active


CULTECH INC.

Business

Active


VAN GOGH CONTRACTING

Business

Active


STORE #812

Business

Active


WATERS EDGE RESTAURANT

Business

Inactive


STEINWAY VAN AND STORAGE CORP.

Business

Inactive



LUXURY OF QUEENS, INC.

Business

Active


CC INTERIOR CORPORATION

Business

Active



BEST BUY STORE #478

Business

Active


SUREN, ARIF

Business

Active



NESLE, INC.

Business

Active


CE SPACE PLANNING INC.

Business

Active


10-01 DELI AND FOOD CORP

Business

Inactive


JIN CONSTRUCTION INC.

Business

Active


QAZI & SONS USED PARTS INC.

Business

Inactive


GREENPOINT AUTO CORP

Business

Active


LIC STAR, INC.

Business

Active


LONG ISLAND CITY VOLKSWAGEN

Business

Active


Pacific Kitchen and Home

Business

Active


(default) 2 queries took 430 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 +ISLAND +CIT)' IN BOOLEAN MODE) LIMIT 350, 505050150
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+LONG +ISLAND +CIT)' IN BOOLEAN MODE)11280