FLORAL PK [Permits for FLORAL PK]

201 - 250 of 261

SRK BUILDERS CORP

Business

Inactive


WAHALA CONSTRUCTION CORP.

Business

Active


STM IMPROVEMENT INC.

Business

Active


CIVITANO, FRANCIS

Business

Inactive




WINDOL INTERNATIONAL WHOLESALE

Business

Inactive


PATTI CONSTRUCTION, CORP.

Business

Inactive


YOUNG I CORP.

Business

Active


SHOWTIME AMUSEMENTS INC.

Business

Inactive


IJAZ, TALAL

Individual

Active


RADIOSHACK CORPORATION

Business

Inactive


ETHAN DRUG CORP.

Business

Inactive


NORTH SHORE VALET, LLC

Business

Active


KAIZEN CONSTRUCTION CORP.

Business

Active




BHAGAT AUTO REPAIR INC

Business

Active


ASPEN CONTRACTING INC.

Business

Inactive


TOWER CONSTRUCTION OF NY INC.

Business

Inactive



LINCOLN CONSTRUCTION CO., INC.

Business

Inactive


FLORAL 26 PARKING LLC

Business

Active



PATTI CONTRACTORS CORP

Business

Active



GRB CONSTRUCTION

Business

Inactive


AEG RESTORATION CORP.

Business

Active



T. BASH CONSTRUCTION, INC.

Business

Active


MADISON FLORAL CORP.

Business

Active


NEW YORKER CONTRACTORS INC

Business

Active


CHAND CONSTRUCTION COMPANY

Business

Active


MANOR CONSTRUCTION GROUP INC.

Business

Inactive


FLORAL HEIGHTS INC

Business

Active


TARI RESTORATION, INC.

Business

Inactive


AT&T MOBILE SOLUTIONS

Business

Inactive


LIA & MIA FLORAL DESIGNS

Business

Inactive


ARNIBINA HOME IMPROVEMENT INC.

Business

Inactive


SCORCIA & ASSOCIATES INC.

Business

Inactive


B & S HARRY DESIGN INC.

Business

Inactive


K & K INTERIOR DESIGN LLC

Business

Inactive



SAVVY BUILDERS, LLC

Business

Inactive



MARWAHA TRADING INC

Business

Active



NINO STONE CARE

Business

Active


FARAN CONSTRUCTION INC.

Business

Active


SAM GENERAL CONSTRUCTION CORP.

Business

Inactive


(default) 2 queries took 436 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 200, 505050218
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)11218