WOODHAVEN [Permits for WOODHAVEN]

251 - 300 of 564

PLAZA DELI & GROCERY

Business

Inactive



LAUNDRY HAVEN ONE LLC

Business

Inactive


SAMS NY FOOD MART INC

Business

Inactive


LOPEZ & DAUGHTER CORPORATION

Business

Inactive



86 GROCERY AND DELI INC

Business

Active


C - TOWN

Business

Active


INTEGRO, INC.

Business

Active


T & J COMMUNICATIONS

Business

Inactive


L & Y DELI & GROCERY INC.

Business

Inactive


S & D DELI AND GROCERY CORP

Business

Active


PEDRO WIRELESS

Business

Active


JUNAID CONSTRUCTION CO

Business

Active


PAN LAUNDROMAT INC.

Business

Inactive


Laundry Haven One LLC

Business

Inactive


SEAPOD CAPITAL GROUP, LLC

Business

Inactive


PIN DELI & GROCERY CORP

Business

Inactive


RNIEL BROS PROPERTY INC

Business

Inactive


MOBILETALK LLC

Business

Active


HEALTHMAX PHARMACY

Business

Active


LEYTON, ALFREDO A

Business

Active


FAMOUS SMOKE SHOP

Business

Active


ELDERT LANE GRILL CORP

Business

Inactive


WATER SLIDE

Business

Inactive


MEDEX PHARMACY

Business

Active


NEW YORK SOUND & SECURITY LLC

Business

Inactive


T-Mobile

Business

Inactive



MODULE COMBO 4

Business

Inactive


MOBILETALK LLC

Business

Active



T & Q GROCERY DELI, INC.

Business

Inactive


XHAL CONSTRUCTION INC

Business

Inactive



WOODHAVEN PETROLEUM LLC

Business

Inactive



FAST EDDIE HOME IMPROVEMENT

Business

Inactive


ORBITRON AUDIO VIDEO

Business

Active



JIANG'S WASHBASKET, INC.

Business

Active



H & K GROCERY STORE INC

Business

Inactive


JNS CONTRACTOR LLC

Business

Active


SOHAIB CONTRACTING, INC.

Business

Inactive


T-Mobile

Business

Inactive


PREVENT INC.

Business

Active


D & B UNIVERSAL MOTORS INC

Business

Inactive


ALI DELI INC

Business

Active


FRANK LABOY COMPANY

Business

Active


(default) 2 queries took 233 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 ( '(+WOODHAVEN)' IN BOOLEAN MODE) LIMIT 250, 505050233
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+WOODHAVEN)' IN BOOLEAN MODE)110