COLUMBUS [Permits for COLUMBUS]

51 - 85 of 85

LOKAL

Business

Active



JUMBO BAGEL

Business

Inactive


236 COLUMBUS FARM

Business

Inactive


ARTE AROUND THE CORNER

Business

Inactive


FRESHY'S GROCERY

Business

Active


YUNHUA ON COLUMBUS INC.

Business

Active



COLUMBUS GOURMET FOOD

Business

Active



ST. ATHANASIUS CHURCH

Business

Inactive




THE MOBILE SHOP

Business

Active


78 COLUMBUS DELI INC.

Business

Active



COLUMBUS 95 PARKING LLC

Business

Active


COLUMBUS AVENUE FOOD CORP.

Business

Active


FAESHYS GROCERY

Business

Active



MOBILE SHOP

Business

Active


236 COLUMBUS FARM

Business

Inactive


Tek-Collect Incorporated

Business

Inactive



MAURICE JEWELERS

Business

Inactive


COLUMBUS COMM INC

Business

Inactive


901 COLUMBUS DELI CORP

Business

Active



COLUMBUS COMM INC

Business

Inactive


BLOSSOM ON COLUMBUS

Business

Inactive


946 COLUMBUS LLC

Business

Inactive


WIRELESS ON COLUMBUS INC.

Business

Active


LEVY & ASSOCIATES, LLC

Business

Inactive


VIVE LA CREPE

Business

Active



(default) 2 queries took 1261 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 ( '(+COLUMBUS)' IN BOOLEAN MODE) LIMIT 50, 503535863
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+COLUMBUS)' IN BOOLEAN MODE)11398