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

601 - 650 of 4129


SIT AND SPIN

Business

Active



DERVISEVIC, ASMIR

Individual

Active


PARK, PETER C

Individual

Active


DEVITA, FRANK A

Individual

Active


GGMC

Business

Inactive



SINGHAM, NALA

Individual

Active




E Z PAWN CORP.

Business

Active


DELAURENTIS, KEN A

Individual

Active


MARINO, ANTHONY M

Individual

Inactive


GAMPERO, LOUIS C.

Individual

Active


QUIK PARK TRIBECA II LLC

Business

Active




SAVAGE, EDWARD

Individual

Active


MYFAVE HOME IMPROVEMENT INC

Business

Active


UNDER THE SEA

Business

Active


K V R CONSTRUCTION INC

Business

Inactive


BUKOWSKI, MICHAEL

Individual

Active


V & I CARIBBEAN MARKET LLC

Business

Active


AMIGO CONSTRUCTION INC

Business

Active


NYACK, RISHI

Individual

Inactive


SD26

Business

Active



STYLIANOU, IOANNIS D.

Individual

Active


JOUST

Business

Active


The Milk Farm

Business

Active


PARK, ANTHONY

Individual

Active


OCHRE CAR PARK, LLC

Business

Active


COMPLEX CONSTRUCTION INC

Business

Active


HUMAN BOWLING

Business

Active


ELIM TRADING CORP.

Business

Active


CATALANI, PHILLIP

Individual

Inactive


SHAZEEM, ABDOOL

Individual

Active


WRECKING BALL

Business

Active




JAGNANAN, BRIAN

Individual

Inactive


Leal, Leo Paolo

Individual

Active


AHMED, JAMEEL

Individual

Active



Sukhram, Dianne

Individual

Active


KNOCKOUT MASONRY CORP.

Business

Active



TROPICAL RUSH

Business

Active


JANI USA INC.

Business

Active


(default) 2 queries took 290 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 600, 50505036
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)11254