Stoop Line Stand [Permits for Stoop Line Stand]

351 - 400 of 3412

LA FINCA FRUIT MARKET CORP.

Business

Inactive


COMPARE FOOD

Business

Inactive



BAO LONG TRADING INC

Business

Inactive


BLANCAS VARIETYS

Business

Inactive


TIN DUC FOOD MARKET, INC.

Business

Inactive


MANGO RICO INC.

Business

Inactive


186 GROCERY II CORP.

Business

Inactive


CHANG WANG FOOD MARKET INC.

Business

Inactive


SUPER HALAL MEAT MARKET INC

Business

Inactive


TORRES SUPERMARKET

Business

Inactive


MUZI DELI GROCERY, INC.

Business

Inactive





ZIAD FOOD CORP.

Business

Inactive


SHANGERILA RESTAURANT INC

Business

Inactive


GEM'S CIRCLE FARMS CORP.

Business

Inactive


MORELOS DELI & FRUIT

Business

Inactive


CONDOR RECORDS

Business

Inactive


LANGDON FLORIST

Business

Inactive


FRIENDS FOREVER GROCERY INC

Business

Inactive


FOOD FAIR 2, INC.

Business

Inactive


VERT FOODS CORP.

Business

Inactive


J & F FRUITS & VEGETABLES INC

Business

Inactive


S&M GROCERY STORE INC

Business

Inactive


FOOD SPOT INC.

Business

Inactive


CASTLE DELI CORP.

Business

Inactive


SHABA DELI & GROCERY CORP

Business

Inactive


NY GRAMBANGLA INC.

Business

Inactive


TROPICAL FANTASY MARKET INC.

Business

Inactive


FRESH FOOD DELI & GROCERY CORP

Business

Inactive




KHIMS ORGANIC INC.

Business

Inactive


SPRUCE USA, INC.

Business

Inactive


XIN GROCERY INC

Business

Inactive


HEALTH IS WEALTH

Business

Inactive



FORDHAM DELI # 2

Business

Inactive


JAMAICAN FLAVORS

Business

Inactive


BELLO'S DISCOUNT INC

Business

Inactive


H & K FOOD MARKET, INC.

Business

Inactive


A+ GOURMET DELI INC

Business

Inactive


A & H FOOD PLAZA, INC.

Business

Inactive


TRADE FAIR

Business

Inactive


MILDRED DELI GROCERY INC.

Business

Inactive


ARIZONA FRUTAS & VEGETABLES

Business

Inactive


TIN SANG MARKET INC.

Business

Inactive


KHAAMAR BAARI INC.

Business

Inactive


(default) 2 queries took 245 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 350, 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)11240