Sidewalk Cafe [Permits for Sidewalk Cafe]

351 - 400 of 2112

THE ODEON, INC.

Business

Active


RDV

Business

Inactive


BISTRO NOMAD

Business

Active


NUMERO 28

Business

Inactive


BAIT & HOOK

Business

Active



IL CARINO RESTAURANT

Business

Inactive


PASCALOU

Business

Active


ORSAY RESTAURANT

Business

Active


CELESTE

Business

Active




VYNL

Business

Active


NARGIS CAFE

Business

Active


THE THIRSTY KOALA

Business

Active


JG MELON

Business

Active


CIEN FUEGOS

Business

Active


PRIME ONE 16 E.HARLEM NYC

Business

Active


THE KING OF TACOS HOUSE, INC

Business

Inactive


CANTINA TAQUERIA & TEQUILA BAR

Business

Inactive


SLJ BAR LLC

Business

Active


SHADY LADY

Business

Active


HILL & BAY

Business

Active


POLLOS MARIO

Business

Active


STANTON RESTAURANT CORP.

Business

Inactive



DURDEN

Business

Active


GENUINE GRAND ST NYC LLC

Business

Inactive


GINO SORBILLO

Business

Inactive


DZIUPLA

Business

Active


KIWIANA

Business

Active


THAFATH, INC.

Business

Active


CANTEEN 82 INC.

Business

Inactive


CAFE BOULUD

Business

Active


COPPELIA

Business

Active


MACCHINA

Business

Inactive


THE RANDOLPH AT BROOME

Business

Active


953 ASSOCIATES LLC

Business

Inactive


THE DEAD POET

Business

Active


CORNERSTONE CAFE

Business

Active


TONELLI RESTAURANT LLC

Business

Inactive


STEAK N SHAKE INC

Business

Inactive


CLEM'S

Business

Active


THE FAT MONK

Business

Inactive


BREAD BROTHERS BAGEL CAFE

Business

Active


PINK NORI

Business

Active


PIATTO

Business

Inactive


MADAME SOUSOU

Business

Inactive


PARS GRILL HOUSE & BAR

Business

Inactive


364 GSR, LLC

Business

Inactive


(default) 2 queries took 630 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 350, 505050228
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)11402