Sidewalk Cafe [Permits for Sidewalk Cafe]

201 - 250 of 2112

AGAVE

Business

Active



SAVANN

Business

Active


PORTO BELLO RESTAURANT

Business

Inactive


CHOSHI JAPANESE RESTAURANT

Business

Active


C & V 77 ENTERPRISES, LLC

Business

Inactive


THE GRANGE BAR & EATERY

Business

Active


RIKO

Business

Active


MADERA PIZZA & GRILL INC

Business

Inactive


MALATESTA TRATTORIA

Business

Active


753 WASHINGTON TRATTORIA INC.

Business

Inactive


ONE STOP BEER SHOP LLC

Business

Active


SALUMERIA ROSI

Business

Inactive


TRIBECAS KITCHEN

Business

Inactive


ERV'S ON BEEKMAN

Business

Inactive


FIAT CAFE

Business

Active


SEAMORE'S

Business

Inactive



RITZ DINER

Business

Inactive


Gracie's on 2nd Diner

Business

Active


GRASS ROOTS JUICERY

Business

Inactive


NLAM INC.

Business

Active


CLARKS RESTAURANT

Business

Active


ARTOPOLIS CAFE LTD.

Business

Active


86 SOUTH PORTLAND, LLC

Business

Inactive



MCDONALD'S RESTAURANT

Business

Active


BE TEMERARIO GROUP, LLC

Business

Active


INDIE LIC LLC

Business

Inactive


STARBUCKS CORPORATION

Business

Active


BOQUERIA

Business

Inactive


FIVE MILE STONE

Business

Inactive


SAGE

Business

Active


BEER SHOP

Business

Active


SAC'S PLACE

Business

Inactive


ALA TURK INC

Business

Active


THE VIAND DINER & BAR

Business

Inactive


MEME

Business

Active


Cascabel Taqueria

Business

Active


QUEEN'S ROOM

Business

Inactive


LENOX SAPHIRE

Business

Inactive


MAMA'S BAR

Business

Active


SIGNATURE & FABERGE

Business

Active


PENCIL FACTORY

Business

Active


920 AVENUE TAVERN CORP.

Business

Active


TAP NYC LLC

Business

Inactive


KILO ASTORIA INC

Business

Inactive


BECO

Business

Active


CLEOPATRAS NEEDLE

Business

Active


BELLINI

Business

Inactive


(default) 2 queries took 495 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 200, 50505053
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)11442