FLORAL PARK [Permits for FLORAL PARK]

201 - 241 of 241

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



PATTI CONTRACTORS CORP

Business

Active



GRB CONSTRUCTION

Business

Inactive


AEG RESTORATION CORP.

Business

Active



T. BASH CONSTRUCTION, INC.

Business

Active


NEW YORKER CONTRACTORS INC

Business

Active


CHAND CONSTRUCTION COMPANY

Business

Active


MANOR CONSTRUCTION GROUP INC.

Business

Inactive


TARI RESTORATION, INC.

Business

Inactive


AT&T MOBILE SOLUTIONS

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


GOLDEN INTERIORS INC

Business

Active


SUNNY IMPROVEMENT INC.

Business

Inactive


SHOWTIME AMUSEMENTS INC.

Business

Inactive


BM VALUE CONSTRUCTION INC.

Business

Inactive


SHOWTIME AMUSEMENTS INC.

Business

Inactive



NEW PAL CONSTRUCTION CORP.

Business

Inactive


WALLET RECOVERY LTD.

Business

Inactive


SHOWTIME AMUSEMENTS INC.

Business

Inactive


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