Stoop Line Stand [Permits for Stoop Line Stand]

251 - 300 of 3412

J & J HOOPER FOOD CORP.

Business

Inactive



BETHEL GOURMET FOOD CORP

Business

Inactive


NEW GREEN LEAF DELI

Business

Inactive




BEL AMI

Business

Inactive


POMELO FRUITS. INC.

Business

Inactive


J & C DELICIAS CORP

Business

Inactive



KEY FOOD

Business

Inactive



SHISHA DELI, INC.

Business

Inactive


LP CORNER DELI INC

Business

Inactive


BELL FARM

Business

Inactive


JUSTIN MEAT INC

Business

Inactive


GP SMOOTHIES & GIFTSHOP

Business

Inactive


CANCAS GROCERY CORP.

Business

Inactive


HONEY GARDEN FARM INC

Business

Inactive


EL RANCHO DELI GROCERY CORP.

Business

Inactive


ZEKE'S ROAST BEEF

Business

Inactive


F & R GROCERY

Business

Inactive


J.J.F. DELI & GROCERY INC.

Business

Inactive


KAWRAN BAZAR, INC.

Business

Inactive


LUCKY STORE GROCERY INC.

Business

Inactive


FINE FARE

Business

Inactive


CREATIVE FLOWERS & GIFT SHOP

Business

Inactive


KINGS FRUITS CO

Business

Inactive


DR PRODUCE CORP

Business

Inactive


JESSICA'S ENTERPRISE INC

Business

Inactive



PORTZ FLORAL MART, INC

Business

Inactive


LA LOMITA MEXICAN DELI CORP

Business

Inactive


LA NUEVA CANASTA

Business

Inactive


ZUDY 59 CORP

Business

Inactive


TRADE FAIR

Business

Inactive


GRAND 99 CENTS EMPORIUM

Business

Inactive


SHAHA & DHAR FOOD CORP.

Business

Inactive


NEW FANARA INC

Business

Inactive


GOODLUCK SUPERMARKET

Business

Inactive


57 BAYARD MEAT MARKET INC

Business

Inactive


ROOSEVELT GROCERY

Business

Active


ATE AND ATE, INC

Business

Inactive




BOROUGH PARK FOOD MART LLC

Business

Inactive


TAQUERIA CHILA CORP

Business

Inactive


CALIFORNIA DELI GROCERY CORP.

Business

Inactive


Robusta Espresso Bar LLC

Business

Inactive


PACIFICO FOOD CORP

Business

Inactive


(default) 2 queries took 242 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 250, 5050505
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)11237