S OZONE PARK [Permits for S OZONE PARK]

251 - 300 of 1718

WALGREENS STORE #04445

Business

Active


BUS MAINTENANCE II LLC

Business

Inactive


SEWLOCHAN, HARRYNARINE

Individual

Active


FUENTES, ONEL

Individual

Active


PAULICH, KEVIN

Individual

Active



SINGH, JASVIR

Individual

Active


BISSOONDIAL, SUNNY J

Individual

Inactive


O.Z. AUTO BODY INC.

Business

Inactive


Technocrats Solutions LLC

Business

Active


RATTU, SONIA

Individual

Inactive


Pena, Joseph

Individual

Active



CHANKAR SINGH, RAMDEO

Individual

Active


85 COLLISION CORP

Business

Inactive


JAHAWIR, PARMANAND

Individual

Active


DUBAI SUPERMARKET

Business

Active


ONE SHOT RECOVERY CORP.

Business

Inactive


CONSTRUCTION HEADS INC

Business

Active


NORTHSIDE AUTO TOWING INC.

Business

Inactive


SPEEDWAY #07815

Business

Active


BUS MAINTENANCE CORP.

Business

Inactive


CHENG, KAM

Individual

Active


85 COLLISION CONCEPTS INC.

Business

Inactive


CRUZ, RAUL JR.

Individual

Active


SINGH, RAWINDER

Individual

Active



KERR, ROBERT T

Individual

Active


URENA, ODALIS A

Individual

Active



SPEEDWAY #07828

Business

Active


choon, intiaz

Individual

Active


ali, safraz

Individual

Active


BAILON, EDBER

Individual

Active


T-Mobile

Business

Active




UDDIN, MOHAMMED

Individual

Active


HABIBI GOURMET DELI 1 CORP

Business

Active


ARCHIE, EDWARD

Individual

Active


E Z PAWN CORP.

Business

Active


ROSARIO, LUIS

Individual

Inactive


DINGHOOR, THAKOOR

Individual

Active


JAGROOP, AMYAN

Individual

Active


DREPAUL, RICHARD S

Individual

Active


LEDBETTER, GERALD A

Individual

Active



SHEEBLE, MOHAMMED M.

Individual

Active


O.Z. AUTO BODY & TOWING INC.

Business

Inactive


P.C. RICHARD & SON

Business

Active


(default) 2 queries took 287 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 250, 50505045
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)11242