south ozone park [Permits for south ozone park]

451 - 493 of 493

VINTY'S LAUNDRY INC

Business

Active


TECH WIRELESS INC

Business

Active


DJ&H PROCESS SERVICE, INC.

Business

Active


One Touch Wire Inc

Business

Active


LA VISION CLARA III LLC

Business

Active


HOME DEPOT

Business

Active



LIBERTY DEVELOPER USA, INC.

Business

Active




Nelson H Improvements INC

Business

Active




SONU CONSTRUCTION CORP

Business

Active


MIR CONSTRUCTION

Business

Active


CROWN REMODELING INC.

Business

Active


B-MAIN CONSTRUCTION CORP

Business

Active




ARUN NEWSSTAND INC.

Business

Active


ALL OVER CONSTRUCTION CORP

Business

Active


UK 2 CONSTRUCTION, CORP.

Business

Active


AREA APPLIANCE SERVICE INC.

Business

Active




LOU LAUNDROMAT

Business

Inactive


SHAPE CONSTRUCTION INC

Business

Active


S N AUTO REPAIRS INC.

Business

Active


JBH CONSTRUCTION INC.

Business

Inactive


RNK 2 WIRELESS INC

Business

Active


TULSI CONSTRUCTION CORP

Business

Active






AC CONTRACTORS 01 LLC

Business

Active


NYC CRYSTAL BUILDERS CORP

Business

Inactive


AAA ROCKAWAY GAS INC

Business

Active


111 AVENUE LAUNDROMAT CORP.

Business

Inactive



NOVELTY CONSTRUCTION CORP

Business

Active


BLUE BIRD LAUNDROMAT INC.

Business

Active


MARCOS J CORP.

Business

Active


(default) 2 queries took 681 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 450, 504343357
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)11324