Sidewalk Cafe [Permits for Sidewalk Cafe]

51 - 100 of 2112

ANGELETTO 2ND AVE INC

Business

Inactive


THE HALAL GUYS

Business

Inactive


DBGB

Business

Inactive


GELATERIA GENTILE

Business

Inactive


STROKOS GOURMET DELI INC

Business

Active


WALLFLOWER

Business

Active


CAFE ARGENTINO

Business

Active


CARA MIA

Business

Active


OLIVE TREE CAFE

Business

Active


DALLAS BBQ

Business

Active



CHELA

Business

Inactive


ETHOS

Business

Active


PICCOLO CAFE

Business

Inactive


VARRIO 408

Business

Inactive


JPS VENTURES INC.

Business

Active


CALEDONIA

Business

Inactive


TUE THAI FOOD

Business

Active


ROW HOUSE

Business

Active


PASQUALE JONES

Business

Active


2A

Business

Active



44 SOUTHWEST

Business

Active


MAISON KAYSER BAKERY

Business

Active


VIRAGE

Business

Active


BLACK FOREST BROOKLYN

Business

Active


KO SUSHI

Business

Inactive


BASIL

Business

Active


THE KITCHEN SINK

Business

Active


SUPREME PROVISIONS

Business

Active


BABALU, LLC

Business

Active


LOVERBOY

Business

Inactive


PATRICIAS MORRIS PARK CORP.

Business

Active


2nd CITY WEST VILLAGE LLC

Business

Active


IANO CORP.

Business

Active


ATRIUM DUMBO

Business

Active


OFF CUTS, LLC

Business

Inactive



THE BODEGA

Business

Inactive


ZUTTO

Business

Inactive


PATHOS

Business

Inactive


VIETNAAM LLC

Business

Inactive


FLAT TOP

Business

Active


CHRISTOS STEAK HOUSE

Business

Inactive


HARLEM FOOD BAR

Business

Active


SWEETGREEN 75TH & AMSTERDAM

Business

Active


TOR RESTAURANT LLC

Business

Active


KENT ALE HOUSE

Business

Active


BEN & JACK'S STEAKHOUSE

Business

Inactive


Starbucks Coffee Company

Business

Active


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