ALPINE

401 - 450 of 582

OGDEN FOOD SERVICE CORP.ALPINE

#

FOOD SERVICE EST.

BROOKLYN

GOURMET FOODS I ALPINE

#

FOOD SERVICE EST.

MANHATTAN

SWISS ALPINE DAIRIES, INC

#

N/A

BROOKLYN

ALPINE GOURMET SALAD, INC.

#

RETAIL FOOD PROCESS

PROVIDENT ALPINE PARTNER L.P.

#

INCORRECT LICENSE

ALPINE ENTERPRISES NY LTD

#0617065

EQUIPMENT WORK

ALPINE BEST FOOD CORP

#

FOOD SERVICE EST.

BROOKLYN

ALPINE REFRIGERATION CO

#0001088

PLUMBING

MANHATTAN

ALPINE REFRIGERATION CO

#0001088

PLUMBING

ALPINE ENTERPRISES NY LTD

#0617065

EQUIPMENT WORK

MANHATTAN

ALPINE CORPORATION

#

FOOD SERVICE EST.

BROOKLYN

ALPINE CINEMAS

#

TEMP FOOD SERV ESTAB

GOURMET FOODS I ALPINE

#

FOOD SERVICE EST.

MANHATTAN

ALPINE ENTERPRISES NY LTD

#0617065

EQUIPMENT WORK

ALPINE GOURMET SALAD, INC.

#

RETAIL FOOD PROCESS

ALPINE MEAT AND SAUSAGE CO. INC.

#

WATER POTABILITY

SOUTH RICHMOND HILL

QUEENS

ALPINE THEATRE CORP.

#

FOOD SERVICE EST.

BROOKLYN

ALPINE GOURMET DELI, INC.

#

MANUF FROZEN DESSERT

MANHATTAN

ALPINE BEST FOOD CORP

#

FOOD SERVICE EST.

BROOKLYN

ALPINE REFRIGERATION CO

#0001088

PLUMBING

MANHATTAN

ALPINE ELECTRICAL INC

#0601406

EQUIPMENT WORK

BROOKLYN

ALPINE CONST & REN CORP

#0611641

EQUIPMENT WORK

BRONX

ALPINE CONSTRUCTION SERVI

#0039851

EQUIPMENT WORK

MANHATTAN

ALPINE REFRIGERATION CO

#0001088

PLUMBING

OAKLAND GARDENS

QUEENS

ALPINE CONST & REN CORP

#0611641

EQUIPMENT WORK

BRONX

ALPINE WINDOW & DOORS, IN

#0616396

EQUIPMENT WORK

MANHATTAN

ALPINE GOURMET DELI INC.

#

FULL TERM MFV PERMIT

ALPINE ENTERPRISES NY LTD

#0617065

EQUIPMENT WORK

STATEN ISLAND

OGDEN FOOD SERVICE CORP.ALPINE

#

FOOD SERVICE EST.

BROOKLYN

ALPINE GOURMET DELI, INC.

#

RETAIL FOOD PROCESS

MANHATTAN

ALPINE CONSTRUCTION SERVI

#0039851

EQUIPMENT WORK

MANHATTAN

ALPINE CONSTRUCTION SERVI

#0039851

EQUIPMENT WORK

MANHATTAN

ALPINE CONSTRUCTION SERVI

#0039851

EQUIPMENT WORK

MANHATTAN

ALPINE CONSTRUCTION SERVI

#0039851

EQUIPMENT WORK

MANHATTAN

ALPINE CONSTRUCTION SERVI

#0039851

EQUIPMENT WORK

MANHATTAN

ALPINE GOURMET FOODS, INC.

#

RETAIL FOOD PROCESS

MANHATTAN

ALPINE REFRIGERATION CO

#0001088

PLUMBING

ALPINE AFFILIATES

#

INCORRECT LICENSE

ALPINE CONSTRUCTION SERVI

#0039851

EQUIPMENT WORK

MANHATTAN

ALPINE GOURMET SALAD, INC.

#

RETAIL FOOD PROCESS

ALPINE HVAC SERVICES INC

#0609216

EQUIPMENT WORK

ALPINE REFRIGERATION CO

#0001088

PLUMBING

MANHATTAN

ALPINE REFRIGERATION CO

#0001088

PLUMBING

MANHATTAN

ALPINE REFRIGERATION CO

#0001088

PLUMBING

MANHATTAN

ALPINE REFRIGERATION CO

#0001088

PLUMBING

MANHATTAN

ALPINE CONSTRUCTION SERVI

#0039851

EQUIPMENT WORK

BROOKLYN

ALPINE CONSTRUCTION SERVI

#0039851

EQUIPMENT WORK

MANHATTAN

ALPINE CONSTRUCTION SERVI

#0039851

EQUIPMENT WORK

MANHATTAN

ALPINE CONSTRUCTION SERVI

#0039851

EQUIPMENT WORK

MANHATTAN

ALPINE CONSTRUCTION SERVI

#0039851

EQUIPMENT WORK

MANHATTAN

prev
1
4
5
6
7
8
9
10
11
12
next

(default) 2 queries took 103 ms
Nr	Query	Error	Affected	Num. rows	Took (ms)
1	SELECT `Permit`.`id`, `Permit`.`Source`, `Permit`.`License_Permit_Holder`, `Permit`.`Business_Description`, `Permit`.`License/Permit_Number`, `Permit`.`Permit_Type_Description`, `Permit`.`Permit_Subtype_Description`, `Permit`.`Permit_Issuance_Date`, `Permit`.`Permit_Expiration_Date`, `Permit`.`Permit_Status_Date`, `Permit`.`Permit_Status_Description`, `Permit`.`Address`, `Permit`.`Street`, `Permit`.`City`, `Permit`.`Zip_Code`, `Permit`.`Borough`, `Permit`.`Building_ID_No`, `Permit`.`Borough_Block_Lot`, `Permit`.`Latitude_WGS84`, `Permit`.`Longitude_WGS84`, `Permit`.`License/Permit_Holder_Name`, `Permit`.`DOB_Skilled_Trades_Lic_Num`, `Permit`.`DOB_Skilled_Trades_Lic_Type` FROM `nyc_business`.`permits` AS `Permit` WHERE MATCH (License_Permit_Holder, City) AGAINST ( '(+ALPINE)' IN BOOLEAN MODE) LIMIT 400, 50		50	50	51
2	SELECT COUNT(*) AS `count` FROM `nyc_business`.`permits` AS `Permit` WHERE MATCH (License_Permit_Holder, City) AGAINST ( '(+ALPINE)' IN BOOLEAN MODE)		1	1	52