S.OZONE PARK [Permits for S.OZONE PARK]

151 - 200 of 4129

COCONUT TREE ROCKWALL

Business

Active


Nuvision, inc.

Business

Active


AQUA EXTREME

Business

Active



SUDS YA DUDS II LAUNDROMAAT

Business

Inactive


Park Ave Laundromat

Business

Inactive


KISIALA, MILAN

Individual

Active



OXFORD CLEANERS

Business

Inactive


RADIOSHACK CORPORATION

Business

Inactive


FINE CLEANERS

Business

Inactive


WINDSOR PARK CLEANERS

Business

Inactive


PROSPERITY CLEANERS

Business

Inactive


Y K PARK CLEANERS

Business

Inactive


EXPRESS LAUNDRY SERVICE, LTD

Business

Inactive


BEROTTI, RICHARD T

Individual

Active


WONG, SUHARTONO

Individual

Inactive


XING BIN LAUNDROMAT INC.

Business

Inactive


DE LEON, EVELYN

Individual

Active


AGOSTINELLI, LOUIS

Individual

Active


JAZI'S DRY CLEANING INC

Business

Inactive


WILLIAMS-SINGH, ANGELISE

Individual

Active



LUXURY LAUNDRY & WASH

Business

Inactive


GRYZELKO, ZBIGNIEW

Individual

Active


INFLATABLE LEARNING CENTER

Business

Active


MELENDEZ, GABRIEL A

Individual

Active


Byrd, Brandon

Individual

Active


SALAM, MOHAMMED A

Individual

Inactive


KIM'S RAINBOW CLEANERS, INC.

Business

Inactive


SHARMA, HAMAT

Individual

Active


VELCRO WALL

Business

Active


BHATTI, PAL

Individual

Inactive


ROKIB, MOHAMMED

Individual

Active


GUBAREFF, KIRILL

Individual

Active


SAE JIN YI

Business

Inactive



CIUFFO, GARY M

Individual

Active


ROSE & TOM'S LAUNDROMAT, INC.

Business

Inactive


DRY CLEANING DEPOT

Business

Inactive


NORTH SHORE VALET, LLC

Business

Inactive


DOUBLE SLIP 'N' SLIDE COMBO

Business

Active


THUNDER FORCE

Business

Active


AHMAD CLEANERS

Business

Inactive


ZACHARIASEN, JEAN PIERRE

Individual

Active


NU-BATH, INC.

Business

Inactive


MARK'S DRY CLEANING INC

Business

Inactive


SINGH, SUKHWINDER

Individual

Inactive


PARK PLACE FLORAL

Business

Active


MODA CAR PARK LLC

Business

Active


(default) 2 queries took 234 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 ( '(+S.OZONE +PARK)' IN BOOLEAN MODE) LIMIT 150, 50505011
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+S.OZONE +PARK)' IN BOOLEAN MODE)11223