Sidewalk Cafe [Permits for Sidewalk Cafe]

151 - 200 of 2112

THE PENROSE

Business

Active


CHICK&CO LLC

Business

Inactive


ITALIAN WINE COMPANY LLC

Business

Active


HUDSON CLEARWATER

Business

Active


OTHELLO DELI

Business

Active


9 MONKEYS INC

Business

Active


VAI UWS, LLC

Business

Active


ROLL-N-ROASTER CORP.

Business

Active


SMORGAS CHEF

Business

Active


ALTA CALIDAD

Business

Active


SD26

Business

Active


MANCHESTER DINER

Business

Active


UPPER WEST HOSPITALITY LLC

Business

Active


HI LIFE BAR & GRILL

Business

Active


PANINO RUSTICO II CORP

Business

Inactive


BUTCHER BAR SMOKEHOUSE

Business

Active


AG KITCHEN

Business

Active


VIA VAI

Business

Active



RIZ BAGELS INC.

Business

Active



WAGAMAMA NY 55 3RD, LLC

Business

Inactive


FRESH SALT

Business

Active


PISELLINO

Business

Inactive


TABLE D' HOTE

Business

Active


MR. BIGGS BAR & GRILL

Business

Active


PATISSERIE DES AMBASSADES

Business

Active


PESCATORE

Business

Active


BACCHUS

Business

Active


PASTAI

Business

Active


BRIGITTE

Business

Inactive


ENTERPRISE RESTAURANT LLC

Business

Active


HARLEM SHAKE

Business

Active


THE MIDDLE, LLC

Business

Inactive


THE SPOTTED DOG

Business

Active


BAR PITTI

Business

Active


HOLLYWOOD DINER

Business

Active


UNO OF ASTORIA, INC.

Business

Inactive


SANT AMBROEUS COFFEE BAR

Business

Inactive


HOTEL PIERRE

Business

Active


STARBUCKS COFFEE COMPANY

Business

Active


VERNON GRILLE

Business

Inactive


JIN RAMEN

Business

Active


DUNKIN DONUTS

Business

Active


HAAGEN DAZS

Business

Active


AG KITCHEN

Business

Active


NELSON BLUE

Business

Active


DARLINGS

Business

Active


JASPERS TAPHOUSE & KITCHEN

Business

Active


EUGENE & CO

Business

Active


(default) 2 queries took 473 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 150, 50505059
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)11414