Sidewalk Cafe [Permits for Sidewalk Cafe]

401 - 450 of 2112

MIDNIGHT EXPRESS

Business

Inactive


Caffe Palermo

Business

Active


HARU

Business

Inactive


TRIBECA GRAND HOTEL, INC.

Business

Inactive


THE GEM SALOON

Business

Active



PRET A MANGER

Business

Inactive


CAFE REGGIO

Business

Active


DKALABASH

Business

Active


NATSUMI

Business

Active


FABIANE'S CAFE & PASTRY

Business

Active


SUSHI GAMA CORP

Business

Active


MIDAN REST., INC.

Business

Inactive


VIDA ENTERPRISES, INC.

Business

Inactive


PICK A BAGEL

Business

Active


LAFAYETTE

Business

Active


PROSPECT

Business

Inactive


THE DUPLEX

Business

Active



FLORIO'S RESTAURANT

Business

Inactive


NEW MEKONG RESTAURANT CORP.

Business

Inactive


MASAL CAFE & LOUNGE

Business

Inactive


KOSUSHI JAPANESE RESTAURANT

Business

Inactive


THE GRAHAM

Business

Inactive


THE TANGLED VINE

Business

Inactive


SWEETGREEN 71ST & 1ST

Business

Active


BELLINI

Business

Inactive


VICTORY SWEET SHOP, LTD.

Business

Active


VIVOLO

Business

Inactive


NY BRAT FACTORY

Business

Active


THE SKYLARK

Business

Active


PRIME MEAT

Business

Active


BAR 180

Business

Inactive


CAFE K

Business

Inactive


SIDEBAR

Business

Inactive


BAR 43

Business

Inactive



LOCAL 92

Business

Inactive


ALLIGATOR LOUNGE

Business

Active


OLIVERS

Business

Inactive


NEAR&FAR

Business

Inactive


CHIRPING CHICKEN

Business

Active


CAFE ALTRO PARADISO

Business

Active


LENOX SOCIAL

Business

Active


FIGARO VILLAGGIO INC.

Business

Inactive


BABU FOODS INC.

Business

Active


PIAZZA PIZZA

Business

Inactive


MOONSTRUCK DINER

Business

Active


MARCO POLO TAKE OUT LLC

Business

Active



(default) 2 queries took 609 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 400, 505050202
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)11407