Jamaica

301 - 350 of 76122

NYC DEPARTMENT OF ENVIRON

#0035939

ALTERATION

JAMAICA

QUEENS


KADAR ELITE CNSTR INC

#0600713

EQUIPMENT

JAMAICA

QUEENS


KADAR ELITE CNSTR INC

#0600713

NEW BUILDING

JAMAICA

QUEENS


KADAR ELITE CNSTR INC

#0600713

EQUIPMENT WORK

JAMAICA

QUEENS


STRAIGHT LINE CONSTR COR*

#0602844

FOUNDATION

JAMAICA

QUEENS


STRAIGHT LINE CONSTR COR*

#0602844

NEW BUILDING

JAMAICA

QUEENS


STRAIGHT LINE CONSTR COR*

#0602844

EQUIPMENT

JAMAICA

QUEENS


STRAIGHT LINE CONSTR COR*

#0602844

FOUNDATION

JAMAICA

QUEENS


STRAIGHT LINE CONSTR COR*

#0602844

EQUIPMENT

JAMAICA

QUEENS


JTP PLBING CONTRACTOR, LT

#0001637

PLUMBING

JAMAICA

QUEENS


DOUG'S PLBG & HTG SERV CO

#0000760

EQUIPMENT WORK

JAMAICA

QUEENS


ACE HIGH CRANES INC.

#0000160

SIGN

JAMAICA

QUEENS


ACE HIGH CRANES INC.

#0000160

SIGN

JAMAICA

QUEENS


ACE HIGH CRANES INC.

#0000160

SIGN

JAMAICA

QUEENS


ISLAND PUMP AND TANK CORP

#0001202

EQUIPMENT WORK

JAMAICA

QUEENS


ISLAND PUMP AND TANK CORP

#0001202

EQUIPMENT

JAMAICA

QUEENS


ACE HIGH CRANES INC.

#0000160

SIGN

JAMAICA

QUEENS


ACE HIGH CRANES INC.

#0000160

SIGN

JAMAICA

QUEENS


ACE HIGH CRANES INC.

#0000160

SIGN

JAMAICA

QUEENS


ACE HIGH CRANES INC.

#0000160

SIGN

JAMAICA

QUEENS


ISLAND PUMP & TANK CORP

#0001202

EQUIPMENT WORK

JAMAICA

QUEENS


LAKHI GENERAL CONTRACT IN

#0001390

NEW BUILDING

JAMAICA

QUEENS


LAKHI GENERAL CONTRACT IN

#0001390

EQUIPMENT

JAMAICA

QUEENS


LAKHI GENERAL CONTRACT IN

#0001390

NEW BUILDING

JAMAICA

QUEENS


LAKHI GENERAL CONTRACT IN

#0001390

EQUIPMENT

JAMAICA

QUEENS


LAKHI GENERAL CONTRACT IN

#0001390

FOUNDATION

JAMAICA

QUEENS


LAKHI GENERAL CONTRACT IN

#0001390

FOUNDATION

JAMAICA

QUEENS


LAKHI GENERAL CONTRACT IN

#0001390

EQUIPMENT WORK

JAMAICA

QUEENS


LAKHI GENERAL CONTRACTOR

#0001390

EQUIPMENT WORK

JAMAICA

QUEENS


LAKHI GENERAL CONTRACTOR

#0001390

EQUIPMENT

JAMAICA

QUEENS


DOUG'S PLBG & HTG SERV CO

#0001730

PLUMBING

JAMAICA

QUEENS


DOUG'S PLBG & HTG SERV CO

#0001730

PLUMBING

JAMAICA

QUEENS


AL-PROS CONST INC

#0007158

ALTERATION

JAMAICA

QUEENS


YOLAND CONSTRUCTION & MET

#0002444

EQUIPMENT WORK

JAMAICA

QUEENS


GMP CONSTRUCTION SOLUTION

#0036849

NEW BUILDING

JAMAICA

QUEENS


GMP CONSTRUCTION SOLUTION

#0036849

EQUIPMENT

JAMAICA

QUEENS


C & T PLUMBING & HTG INC

#0002025

PLUMBING

JAMAICA

QUEENS


RAPID CONST.AND RENOV OF

#0034862

EQUIPMENT

JAMAICA

QUEENS


RAPID CONST.AND RENOV OF

#0034862

NEW BUILDING

JAMAICA

QUEENS


RAPID CONST.AND RENOV OF

#0034862

EQUIPMENT

JAMAICA

QUEENS


RAPID CONST.AND RENOV OF

#0034862

NEW BUILDING

JAMAICA

QUEENS


PRO STAR PLBG AND HTG INC

#0001223

PLUMBING

JAMAICA

QUEENS


PRO STAR PLBG AND HTG INC

#0001223

PLUMBING

JAMAICA

QUEENS


S HOME IMPROVEMENT INC

#0030399

EQUIPMENT

JAMAICA

QUEENS


S HOME IMPROVEMENT INC

#0030399

NEW BUILDING

JAMAICA

QUEENS


THREE STAR CONSTRUCTION C

#0028689

EQUIPMENT

JAMAICA

QUEENS


THREE STAR CONSTRUCTION C

#0028689

NEW BUILDING

JAMAICA

QUEENS


FIRST CHOICE PLUMBING COR

#0001210

PLUMBING

JAMAICA

QUEENS


S HOME IMPROVEMENT

#0030399

ALTERATION

JAMAICA

QUEENS


NY FIRE LLC

#0000504

EQUIPMENT WORK

JAMAICA

QUEENS


(default) 2 queries took 2644 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Permit`.`id`, `Permit`.`Source`, `Permit`.`License_Permit_Holder`, `Permit`.`Business_Description`, `Permit`.`License/Permit_Number`, `Permit`.`Permit_Type_Description`, `Permit`.`Permit_Subtype_Description`, `Permit`.`Permit_Issuance_Date`, `Permit`.`Permit_Expiration_Date`, `Permit`.`Permit_Status_Date`, `Permit`.`Permit_Status_Description`, `Permit`.`Address`, `Permit`.`Street`, `Permit`.`City`, `Permit`.`Zip_Code`, `Permit`.`Borough`, `Permit`.`Building_ID_No`, `Permit`.`Borough_Block_Lot`, `Permit`.`Latitude_WGS84`, `Permit`.`Longitude_WGS84`, `Permit`.`License/Permit_Holder_Name`, `Permit`.`DOB_Skilled_Trades_Lic_Num`, `Permit`.`DOB_Skilled_Trades_Lic_Type` FROM `nyc_business`.`permits` AS `Permit` WHERE MATCH (License_Permit_Holder, City) AGAINST ( '(+Jamaica)' IN BOOLEAN MODE) LIMIT 300, 50505011
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`permits` AS `Permit` WHERE MATCH (License_Permit_Holder, City) AGAINST ( '(+Jamaica)' IN BOOLEAN MODE)112633