Stoop Line Stand [Permits for Stoop Line Stand]

201 - 250 of 3412


INTERNATIONAL FUSION INC

Business

Inactive


MB NYC FLOWERSHOP CORP.

Business

Inactive


COLLAGE AVE DELI & MARKET INC

Business

Inactive


R & R FRUIT & PRODUCE, LLC

Business

Inactive


VARIETY CENTER SHOP INC

Business

Inactive


YOGI CONVENIENCE

Business

Inactive


JUQUILA GREEN MARKET CORP

Business

Inactive


smart deli grocery inc

Business

Inactive


LILY ORIENTAL FOOD

Business

Inactive


G 200 GROCERY INC.

Business

Inactive


GOOD FOR LIFE BY 81, INC.

Business

Inactive


HP 42ND FRUIT STORE INC

Business

Inactive


QUALITY NEWS INC.

Business

Inactive


CHRISTOPHER MINI MARKET, CORP.

Business

Inactive





WOODSIDE 52 DELI & GROCERY LLC

Business

Inactive


FLOWERS BY SUN JA KANG

Business

Inactive




WEST INDIAN FRESH INC

Business

Inactive


PORTOKALI GOURMET CORP.

Business

Inactive


AU PETIT MARCHE

Business

Inactive


HEALTH FOOD INC.

Business

Inactive


Natural Juice

Business

Inactive


NANI CONVENIENCE STORE INC.

Business

Inactive



SAN LIANG MARKET INC.

Business

Inactive


AGRANOVSKY, YURI

Business

Inactive


LA CALENITA BAKERY

Business

Inactive


CANE GROVE BAKERY INC

Business

Inactive


HOMEY SUPERMARKET, INC.

Business

Inactive


KINGS FOOD & GRILL CORP.

Business

Inactive


NEW GREENPOINT FARM LLC

Business

Inactive


FRESH STOP INC.

Business

Inactive


WONG TAT MARKET INC

Business

Inactive


MANHATTAN FLORIST.COM, LTD.

Business

Inactive


LOS VECINOS MINI MARKET INC

Business

Inactive


BROADWAY PIZZA

Business

Inactive


HOTW, LLC

Business

Inactive


MR MELON

Business

Inactive


POP'S FRESH MARKET LTD

Business

Inactive



Cookie DO, Inc.

Business

Inactive



STN GLOBAL LLC

Business

Inactive


Rent Ride Return, LLC

Business

Inactive


A.G.J. METRO DELI CORP.

Business

Inactive


(default) 2 queries took 274 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 ( '(+Stoop +Line +Stand)' IN BOOLEAN MODE) LIMIT 200, 5050504
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+Stoop +Line +Stand)' IN BOOLEAN MODE)11270