Sidewalk Cafe [Permits for Sidewalk Cafe]

301 - 350 of 2112

BOCADO BAKERY CAFE

Business

Active


WILLIAMSBURGER

Business

Inactive


SOFREH RESTAURANT, NYC

Business

Inactive


LE SOUK HAREM

Business

Inactive


VAP UNION SQUARE, LLC

Business

Active


KEN & COOKS RESTAURANT

Business

Active


FUSHA FUSION RESTAURANT INC

Business

Inactive


BLUE WATER ASTORIA LLC

Business

Active


THE GREEK KITCHEN

Business

Inactive


SCHATZIE PRIME MEATS

Business

Active



TWO HANDS

Business

Active


SAN LOCO

Business

Active


FIRST, LLC

Business

Inactive


IL VIOLINO

Business

Inactive


UKATOSH CORPORATION

Business

Inactive


TAPROOM 307

Business

Active


DALLAS BBQ

Business

Active


3 IN 1 KITCHEN

Business

Active


ONE AND ONE

Business

Active


ABRIL NY CORPORATION

Business

Active


EPHESUS CORP

Business

Inactive


HUDSON CAFE

Business

Active


KETTLE BLACK

Business

Inactive


ELLA NYC

Business

Active



SURFISH BISTRO II INC

Business

Inactive


THE STAGECOACH

Business

Inactive


658-660 AMSTERDAM CORP.

Business

Active


ROGUE

Business

Active


SHAKE SHACK

Business

Active


GINA LA FORNARINA

Business

Active


CAFE SELECT

Business

Active


00 + CO

Business

Active


DAILY ROADSIDE LLC

Business

Active


ALA TURK INC

Business

Active


ON 54TH LLC

Business

Active


AN CHOI

Business

Active


ISG RESTAURANT LLC

Business

Active


AGNANTI

Business

Inactive


COURT DELI

Business

Active


JIN JIN HONG KONG CAFE

Business

Active


JAGR 187 COLUMBUS LLC

Business

Inactive


BAROSA INC.

Business

Inactive


COPPOLAS

Business

Active


UNCLE BOONS SISTER

Business

Active


PICANTE MEXICAN RESTAURANT

Business

Active


LAMARCA CHEESE SHOP

Business

Active


LENWICH

Business

Active


SUSHI D INC

Business

Active


(default) 2 queries took 566 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 300, 505050123
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)11443