south ozone park [Permits for south ozone park]

401 - 450 of 493

T & M REFRIGERATION INC

Business

Inactive


UNIT AUTO INC

Business

Active







T-MOBILE #8154

Business

Inactive




BADSHAW LAUNDROMAT LLC

Business

Inactive


127 DELI GROCERY INC

Business

Inactive


RAMBALLY, INC.

Business

Inactive


META DOMEO INC

Business

Active


HOME IQ INC

Business

Active



triple s developers, llc

Business

Inactive


H AND B TIRE SHOP INC.

Business

Active


SUKHOO, LAKHANLALL

Business

Inactive


GEREBUZZA CONSTRUCTION INC

Business

Active


PERSAUD, PRIYA

Business

Inactive


M & B LAUNDROMAT CORP.

Business

Active


ANTILLANA BEST GROCERY CORP

Business

Active


RED EAGLE HOME IMPROVEMENT

Business

Active


DAVE CONSTRUCTION CORP

Business

Active


HUGHES CONTRACTORS INC

Business

Active


MARBE GROUP

Business

Inactive



VAN WYCK FLAT FIX

Business

Active





JOHNEY CONSTRUCTION CORP

Business

Active


RSK 2 WIRLESS INC

Business

Active


LIBERTY PRODUCE, INC.

Business

Active



BEER HOME IMP CO

Business

Active


SANYO P CONSTUCTION CORP.

Business

Active


D & Y LAUNDROMAT INC.

Business

Active


WILLIAM, MOVIKA G

Business

Inactive



HAWKINS, JULIAN

Business

Inactive


P 786 INC

Business

Active



Mike's Deli

Business

Active




RAJAN CONSTRUCTION CORP.

Business

Active



JSA NYC CONSTRUCTION INC.

Business

Active


(default) 2 queries took 657 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 ( '(+south +ozone +park)' IN BOOLEAN MODE) LIMIT 400, 505050343
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+south +ozone +park)' IN BOOLEAN MODE)11314