COLUMBUS [Permits for COLUMBUS]

1 - 50 of 85

CHOICE RECOVERY, INC.

Business

Active


COLUMBUS CLEANERS CORP.

Business

Inactive


PAYLIANCE

Business

Active


ASPEN CLEANERS

Business

Inactive


NEXTCLEANERS

Business

Inactive



980 COLUMBUS FOOD CORP.

Business

Active



AG KITCHEN

Business

Active


AG KITCHEN

Business

Active


OVER, THOMAS

Individual

Inactive


APELLES, L.L.C.

Business

Active



RANCH DELI

Business

Active


SHAKE SHACK

Business

Active


JAGR 187 COLUMBUS LLC

Business

Inactive


SCHUERGER II CO., LTD

Business

Active



DECKER, OLIVER A W

Individual

Inactive



Tek-Collect Incorporated

Business

Active







THE GRAHAM

Business

Inactive


RICHMOND HILL HALL CORP

Business

Active


LAWSON'S BUILDERS/COLUMBUS LLC

Business

Inactive


526 COLUMBUS MERCHANTS INC.

Business

Inactive




CASA POMONA

Business

Inactive


MUGHLAI INDIAN CUISINE

Business

Inactive


LURA

Business

Inactive


CAVALLARO KNIGHTS OF COLUMBUS

Business

Inactive



COLUMBUS 60TH REALTY LLC

Business

Active



IW COLUMBUS CENTRE LLC

Business

Active


513 COLUMBUS, LLC

Business

Active


NCO FINANCIAL SYSTEMS, INC.

Business

Inactive


ISABELLA'S

Business

Inactive


GOOD ENOUGH TO EAT

Business

Inactive


ISOLA

Business

Active



EXCLUSIVE WIRELESS NYC

Business

Inactive



ZUCKER'S BAGELS

Business

Active



(default) 2 queries took 407 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 505050190
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)11217