HOWARD BEACH [Permits for HOWARD BEACH]

251 - 300 of 372

BAGEL BARISTA CORP

Business

Inactive


PCV INC

Business

Inactive


F1 CONSTRUCTION INC.

Business

Inactive


CSO SUPPLY CORP

Business

Active


SUBWAY SHOP

Business

Inactive


PREDATOR PEST CONTROL INC.

Business

Active



RID-WAY ENTERPRISES, LLC

Business

Active


ARJAY WIRELESS

Business

Inactive





T-MOBILE NORTHEAST LLC

Business

Active


Stop & Shop Store # 2591

Business

Active



RYAN'S HOME IMPROVEMENT

Business

Active


EXCLUSIVE HOME DESIGN, INC.

Business

Active


KRATZER, JOSHUA

Business

Inactive


MASTRANGELO CONSTRUCTION

Business

Active



SAL'S FOOD MARKET

Business

Inactive


ACCARDI CONSTRUCTION CORP.

Business

Active



L.W. CONTRACTING

Business

Active


A-Z LAUNDRY SERVICE, INC

Business

Inactive



ASHOKA GASOLINE

Business

Inactive



Perfectionist Painting

Business

Active



JB EXT & INT DESIGNS CORP.

Business

Active


LINDENWOOD FUEL INC

Business

Active


Hess Express #32502

Business

Inactive



HB LAUNDRY EXPRESS INC.

Business

Active


KNICKERBOCKER DISCOUNT INC

Business

Active




SMART RENOVATION INC.

Business

Inactive



RL LA PUMA CONSTRUCTION LLC

Business

Active



CASH FOR JUNK CARS INC

Business

Active


RAO WIRELESS INC.

Business

Inactive



ON THE HOOK INC.

Business

Inactive


ARJAY WIRELESS

Business

Inactive



HOWARD BEACY APOTHECARY

Business

Active


HOWARD BEACH DELI

Business

Active


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