FLORAL PK [Permits for FLORAL PK]

151 - 200 of 261

SIDHU, BALVIR SINGH

Individual

Active


MALPIEDI, CHARLES

Individual

Active


AC & APPLIANCES GROUP CORP.

Business

Active


WALKER, ADAM S

Individual

Inactive


Duffner, Charles

Individual

Active


SINGH, SUKHJINDER

Individual

Inactive


Israeli, Elaad

Individual

Active


SINGH, GURDEEP

Individual

Active



LAM, GEORGE

Individual

Active


ALPHA CONSTRUCTION NY INC

Business

Active



SHAFIQUE, BILAL

Individual

Inactive


MACH GROUP INC.

Business

Active


DIGUGLIELMO, ANTHONY

Individual

Active



PRICE, JOHN

Individual

Active


APICELLO, STEVEN

Individual

Active


LAUREANO, RONALD L

Individual

Active


PABLA, AMRIK SINGH

Individual

Active


GOMBO, JOSHUA A

Individual

Active


SINGH, MASTAN

Individual

Active


PHONES R US INC.

Business

Inactive



SINGH, SATNAM

Individual

Active


FLORAL PARK HVAC CORP.

Business

Active


RIZZO & ASSOCIATES CONTRACTORS

Business

Inactive



SINGH, GURPINDER

Individual

Active


RERA, GARY

Individual

Active


COVELLI, ALBERTINO

Individual

Active


DOYLE, JAMES

Individual

Active


ABDEBAYO, SUSAN

Individual

Inactive


KRAWEC, JOHN

Individual

Active


URENA, ROBERTO

Individual

Active


SINGH, JATINDERPAL

Individual

Active


SINGH, MAKHAN

Individual

Active


CHAND, HARMESH

Individual

Active


TOLOZA, MAURICIO

Individual

Active


Ohayon, Hadas

Individual

Active




SHOWTIME AMUSEMENTS INC.

Business

Inactive



AT&T

Business

Active



RETROFIX CONTRACTING INC

Business

Active


DENNIS RIGAS FLORAL CREATIONS

Business

Inactive



BLOSSOMS FLORAL DESIGNS

Business

Inactive


(default) 2 queries took 427 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 150, 505050178
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)11249