Sidewalk Cafe [Permits for Sidewalk Cafe]

101 - 150 of 2112

MCONDO 502

Business

Active


STREET TACO

Business

Active


ENOLOGO

Business

Inactive


HORUS CORP.

Business

Active



OTTO'S TACOS

Business

Inactive


UBER CAFFE, LLC

Business

Inactive


FRANNY'S

Business

Inactive


CEBU

Business

Inactive


THINK COFFEE

Business

Inactive


polpette

Business

Inactive


EAT MADISON 91 LLC

Business

Active


DYCKMAN EXPRESS RESTAURANT

Business

Inactive


MICKEY SPILLANE'S KITCHEN

Business

Active


CARMINE'S PIZZA

Business

Inactive


BILLS BAR & BURGER

Business

Inactive


GENESIS

Business

Active


BURKINABE ENTERTAINMENT LLC

Business

Inactive


IL MELOGRANO

Business

Active


MAD HATTER

Business

Inactive


VINO LEVANTINO

Business

Active



POST OFFICE

Business

Inactive


ABA TURKISH RESTAURANT LLC

Business

Inactive


CALYER

Business

Active


MAISON KAYSER BAKERY

Business

Inactive


BLUESTONE LANE

Business

Inactive


TABLAO

Business

Inactive


SERAFINA MEATPACKING LLC

Business

Active


FREUD

Business

Inactive


OFF THE HOOK

Business

Active


THE QUARTER

Business

Inactive


RED FARM

Business

Active


LAND THAI KITCHEN

Business

Active


GROOVE

Business

Active


1 HOTEL CENTRAL PARK

Business

Active


523 9TH AVENUE INC.

Business

Inactive


PJ CHARLTON

Business

Inactive


THREE DECKER RESTAURANT

Business

Active


HUMMUS PLACE

Business

Inactive


THE HAAB

Business

Inactive


JUICERIE

Business

Active


YATENGA

Business

Inactive


YUMMY THAI

Business

Inactive


MILO CAFE, CORP.

Business

Inactive


LITTLE TONG NOODLE SHOP

Business

Active


VIDA MEXICANA INC.

Business

Active


MARCO POLO RISTORANTE

Business

Active


THE MARSHALL

Business

Active


BEACH CAFE

Business

Active


(default) 2 queries took 44 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 100, 50505044
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)110