Stoop Line Stand [Permits for Stoop Line Stand]

601 - 650 of 3412

FOOD UNIVERSE MARKETPLACE

Business

Active


LA HEROICA MEAT MARKET CORP

Business

Active


BUNNY DELI II INC

Business

Active


XING YAN GIFT STORE

Business

Active


3868 T.S. GROCERY, INC.

Business

Active


NEW PUNJAB GROCERY CORP.

Business

Active


ARTHUR AVENUE FLORAL

Business

Active


EL MERCADITO FOOD INC.

Business

Active


WHOLE FRUIT

Business

Active


LA MARKETA LATINA, CORP

Business

Active



PMP CONVENIENCE CORP.

Business

Active


TMW GROUP INC

Business

Active



SYK INC.

Business

Active


PARK PLACE FLORAL

Business

Active


ALI SUPERMARKET INC.

Business

Active





LI WANG COMPANY

Business

Active


LOS POBLANOS GROCERY CORP

Business

Active


GEORGE MEAT MARKET, INC.

Business

Active


JOEY EXPRESS DELI INC

Business

Active


TROPICAL DAIRY FARM CORP.

Business

Active



TRY FRUIT AND VEGATABLES

Business

Active


5 DE MAYO GROCERY CORP

Business

Active


L MAZZELA MARKET

Business

Active


FISH MARKET

Business

Active


DAS, NRIPENDRA

Business

Active


ECO FAMILY FOOD MART CORP

Business

Active


PITKIN PHARMACY & FOOD MART

Business

Active


A & D PRODUCE CORP.

Business

Active


CEPIN FOOD CORP.

Business

Active


H & W DELI GROCERY INC.

Business

Active



Candy Man

Business

Active


FRESH POINT MARKET INC.

Business

Active



BOON CHU THAI PLACE

Business

Active


MIGUEL CHACON

Business

Active



JE FRUIT & VEGETABLES, INC.

Business

Active





BROADWAY FRUIT & VEGIS INC

Business

Active


#1 FARMERS MARKET

Business

Active



(default) 2 queries took 253 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 600, 50505019
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)11234