MANHATTAN [Permits for MANHATTAN]

151 - 193 of 193


THE SHADE COMPANY

Business

Active




MANHATTAN PAWN SHOP LLC

Business

Inactive


MANHATTAN MOTORCARS, INC.

Business

Active



MANHATTAN GROCERY CORP.

Business

Active




437 MANHATTAN DELI CORP.

Business

Inactive


MANHATTAN AVE. GARAGE CORP.

Business

Active





INFINITI OF MANHATTAN, INC.

Business

Inactive


MANHATTAN JEWELERS

Business

Active



SKKY WIRELESS OF MANHATTAN LLC

Business

Inactive


MANHATTAN DELI STORE CORP

Business

Active


MANHATTAN FRUIT 678 INC.

Business

Active


VAPE NY

Business

Active


MANHATTAN EXPRESS DELI GROCERY

Business

Inactive




MANHATTAN RENOVATIONS, INC.

Business

Active


MANHATTAN CLOSET DESIGN

Business

Active



Manhattan Surgical Supply

Business

Active


UPPER MANHATTAN PARKING LLC

Business

Active



FINE CLEANERS

Business

Active





Jaguar Land Rover Manhattan

Business

Inactive


Manhattan Music LLC

Business

Inactive


manhattan elite contracting

Business

Active



MERCEDES-BENZ MANHATTAN INC

Business

Active



MANHATTAN JEEP EAGLE, INC.

Business

Inactive



(default) 2 queries took 489 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 ( '(+MANHATTAN)' IN BOOLEAN MODE) LIMIT 150, 504343251
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+MANHATTAN)' IN BOOLEAN MODE)11238