FLORAL PK [Permits for FLORAL PK]

51 - 100 of 261

PAN, KITTY

Individual

Inactive



RUPP, JOE

Individual

Active


SCACCIA, JORDAN D

Individual

Inactive


NYC FLORAL DECORATORS

Business

Active


REHMAN, AZIZ U

Individual

Active


SINGH, SUKHJINDER

Individual

Inactive


WHITE, JOHN D

Individual

Inactive


TUSH, ADAM

Individual

Active


URSU, CRISTIAN

Individual

Active


GREENE, OMAR

Individual

Active


SINGH, SURJIT

Individual

Inactive


SINGH, GURVINDER

Individual

Active


Lakeville Truck Sales

Business

Inactive


LANE, JOSEPH R

Individual

Active


MEYERS, AL

Individual

Inactive


CASTILLO, YORYI R

Individual

Active


C. MALPIEDI, INC.

Business

Active


RERA, MICHAEL

Individual

Active


PIAZZA, ANTHONY

Individual

Active


JZANUS LTD.

Business

Active


SCAGLIONE, JAMES A

Individual

Active


MCGUIRE, CHRISTOPHER

Individual

Active


COSCIA, ANTHONY J

Individual

Active


REISCH, STUART

Individual

Active


DHALIWAL, RUPINDER

Individual

Active


WONG, WAI M

Individual

Active



RAHMAN, ABDUL

Individual

Active


Oommen, Wilson

Individual

Active


IAFFALDANO, FRANK, A.

Individual

Active



IANNELLO, PATRICK J

Individual

Inactive


EDEN ORTHO SUPPLY LTD

Business

Active


SINGH, HARJIT

Individual

Active


CIVITANO, FRANCIS

Individual

Inactive


SINGH, BRYAN JASVINDER

Individual

Active


SINGH, RAJINDER

Individual

Active


KHAN, ZESHAN A

Individual

Active


MOHAMMAD, ANJUM

Individual

Active


HARRY, BIBI S

Individual

Inactive



SOULAS, NIKOLAOS

Individual

Active


SM CONTRACTORS CORP

Business

Inactive


DILLMAN, DOUGLAS

Individual

Active


SPRICE CONTRACTING, INC.

Business

Active


SECILMIS, ZEKERIYA

Individual

Active


PERSICHILLI, MICHAEL

Individual

Active


Costello Construction Corp

Business

Active


GOLDSMITH, ADAM H.

Individual

Active


(default) 2 queries took 279 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 ( '(+FLORAL +PK)' IN BOOLEAN MODE) LIMIT 50, 50505064
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+FLORAL +PK)' IN BOOLEAN MODE)11215