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

201 - 250 of 4129

MALAVE, MICHAEL ANTHONY

Individual

Active


BEACH CLEANERS & TAILORS

Business

Inactive



WIECH, MAREK

Individual

Active


E & R LAUNDROMAT, INC.

Business

Inactive


SHINY & NEW USA INC

Business

Inactive


V&G Laundromat

Business

Inactive


ZGOMBIC, JOHN

Individual

Active


DING'S LAUNDROMAT

Business

Inactive


MARINE PARK LAUNDROMAT, INC.

Business

Inactive


PAUL'S SUNSHINE CLEANERS INC.

Business

Inactive



16X16 DELUXE MOONWALK

Business

Active


HI-TOP CLEANERS

Business

Inactive


UDDIN, MOHAMMED

Individual

Active



PARK, SE WOONG

Business

Inactive


E & J LAUNDROMAT INC

Business

Inactive


INFLATABLE WATERMAN

Business

Active



WHIRLEY BIRD

Business

Active


YANG, CANDACE X

Individual

Active


SINGH, PALWINDER

Individual

Active



khvostov, maxim

Individual

Active


DOMCO LAWN SPRINKLERS

Business

Active


BROADWAY PARK LAUNDROMAT LLC

Business

Inactive


CUENCA LAUNDROMAT INC.

Business

Active


SOSA, ANTHONY J

Individual

Inactive


SINGH, HEMANT

Individual

Inactive


PARK AVE CLEANERS

Business

Inactive


BISNAUTH, VADEWATIE

Individual

Active


ANW DELI & FRUIT LLC

Business

Active


K&N SUPER SUDS, INC.

Business

Inactive


WATERBALL SLIDE

Business

Active


FRUSTACI, JOHN

Individual

Active


S & L LAUNDROMAT INC.

Business

Inactive


HELICOPTER

Business

Active


SCHOLZ, GERDA H

Individual

Inactive


HONG XIANG LAUNDROMAT, INC.

Business

Inactive


CROSS BAY CLEANERS

Business

Inactive


IHOME REHAB LLC

Business

Active


MIRANDA JR, RUBEN

Individual

Active


ROCKAWAY WASH & DRY

Business

Inactive



THE WILD ONE

Business

Active


LEE'S FIVE STAR LAUNDROMAT

Business

Inactive


GOLDEN HANGER

Business

Inactive


AAA WASH & CLEAN

Business

Inactive


SINGH, PRITAM

Individual

Active


(default) 2 queries took 240 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 200, 50505013
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)11227