LONG IS CITY [Permits for LONG IS CITY]

351 - 400 of 920

TIDYUPNYC, LLC

Business

Active



CHAMPION PARKING NORTH LLC

Business

Inactive


STOJKOV, IGOR

Business

Inactive


ARISAM INC

Business

Inactive


LUXOR MOTOR CARS INC

Business

Active


NOOR DELI & GROCERY INC

Business

Active


QB DELI GROCERY CORP

Business

Inactive


SRN HOME IMPROVEMENT, LLC

Business

Active


HARLEY DAVIDSON OF NYC

Business

Active


PIATTO

Business

Inactive


NEW YORK HONDA YAMAHA

Business

Active


47 operating llc

Business

Active


SMARTALK XII CORP.

Business

Inactive


SICULA RENOVATIONS INC.

Business

Active




CW CUSTOM INC

Business

Inactive


SHREE BHADRA INC.

Business

Inactive


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


E-Z STATION, INC.

Business

Active


JJ MIKE INC

Business

Inactive


DK CONSTRUCTION USA INC

Business

Active


Skyview Cleaners

Business

Inactive


TEITELBAUMS 1, INC.

Business

Active


TERRA GREENPOINT RETAIL CORP.

Business

Inactive


HAM N EGGERY DELI INC.

Business

Inactive


T-MOBILE

Business

Active


DUNHILL AUTO BODY INC.

Business

Inactive



PM LEGAL, LLC

Business

Active


ONE SUNRISE

Business

Inactive


JACKSON GOURMET DELI CORP.

Business

Inactive


CALAMARAS REALTY CORPORATION

Business

Inactive


MEGA MECHANICAL INC.

Business

Inactive


STONE & TERRAZZO WORLD INC

Business

Active


MOZART IRON CRAFT CORP.

Business

Active


Pacific Contracting

Business

Active


(default) 2 queries took 491 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 350, 505050187
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)11304