JAMAICA

251 - 300 of 76122

BTON LLC

#0604969

EQUIPMENT

JAMAICA

QUEENS


CHRIS OWEN PLBG & HTG INC

#0001358

PLUMBING

JAMAICA

QUEENS


TRI BOROUGH SCAFFOLDING

#0606141

EQUIPMENT

JAMAICA

QUEENS


TRI BOROUGH SCAFFOLDING

#0606141

EQUIPMENT

JAMAICA

QUEENS


JJSL DEVELOPMENT INC

#0608082

NEW BUILDING

JAMAICA

QUEENS


JJSL DEVELOPMENT INC

#0608082

EQUIPMENT

JAMAICA

QUEENS


JJSL DEVELOPMENT INC

#0608082

EQUIPMENT

JAMAICA

QUEENS


JJSL DEVELOPMENT INC

#0608082

NEW BUILDING

JAMAICA

QUEENS


JJSL DEVELOPMENT INC

#0608082

ALTERATION

JAMAICA

QUEENS


JJSL DEVELOPMENT INC

#0608082

EQUIPMENT WORK

JAMAICA

QUEENS


LANDO & ASSOCIATES, INC

#0000934

EQUIPMENT WORK

JAMAICA

QUEENS


LANDO & ASSOCIATES, INC

#0002042

PLUMBING

JAMAICA

QUEENS


N & K PLBG AND HTG CORP

#0002209

PLUMBING

Jamaica

QUEENS


MRMD NY CORP

#0608799

NEW BUILDING

Jamaica

QUEENS


SKYWORX CONTRACTING INC

#0607709

EQUIPMENT

Jamaica

QUEENS


SKYWORX CONTRACTING INC

#0607709

EQUIPMENT

Jamaica

QUEENS


IDEAL BUILDERS AND CONSTR

#0032571

FOUNDATION

Jamaica

QUEENS


IDEAL BUILDERS AND CONSTR

#0032571

NEW BUILDING

Jamaica

QUEENS


IDEAL BUILDERS AND CONSTR

#0032571

FOUNDATION

Jamaica

QUEENS


IDEAL BUILDERS AND CONSTR

#0032571

EQUIPMENT

Jamaica

QUEENS


MCMILLAN PLBG & HTG.INC

#0001839

PLUMBING

Jamaica

QUEENS


AJIT ONE MECH&GENERAL CON

#0019001

EQUIPMENT

JAMAICA

QUEENS


AJIT ONE MECH&GENERAL CON

#0019001

EQUIPMENT

JAMAICA

QUEENS


MILTON CONSTRUCTION CORP

#0602702

EQUIPMENT WORK

JAMAICA

QUEENS


L&B CONSTRUCTION

#0003464

EQUIPMENT WORK

JAMAICA

QUEENS


L AND B CONSTRUCTION CO

#0003464

ALTERATION

JAMAICA

QUEENS


MBR CONTRACTING INC

#0025015

EQUIPMENT

JAMAICA

QUEENS


MBR CONTRACTING INC

#0025015

EQUIPMENT WORK

JAMAICA

QUEENS


M.B.R. CONTRACTING INC.

#0025015

EQUIPMENT WORK

JAMAICA

QUEENS


M.B.R. CONTRACTING INC.

#0025015

EQUIPMENT

JAMAICA

QUEENS


THE PLUMBING COMPANY, INC

#0000626

PLUMBING

JAMAICA

QUEENS



FAB-TEC CONSTRUCTION AND

#0038530

FOUNDATION

JAMAICA

QUEENS


FAB-TEC CONSTRUCTION AND

#0038530

FOUNDATION

JAMAICA

QUEENS


FAB-TEC CONSTRUCTION AND

#0038530

NEW BUILDING

JAMAICA

QUEENS


FAB-TEC CONSTRUCTION AND

#0038530

EQUIPMENT

JAMAICA

QUEENS


FAB-TEC CONSTRUCTION AND

#0038530

FOUNDATION

JAMAICA

QUEENS


FAB-TEC CONSTRUCTION AND

#0038530

FOUNDATION

JAMAICA

QUEENS


FAB-TEC CONSTRUCTION AND

#0038530

EQUIPMENT

JAMAICA

QUEENS


FAB-TEC CONSTRUCTION AND

#0038530

NEW BUILDING

JAMAICA

QUEENS


C & T PLUMBING & HTG INC

#0002025

PLUMBING

JAMAICA

QUEENS


C & T PLUMBING & HTG INC

#0002025

PLUMBING

JAMAICA

QUEENS


KDK CONSTRUCTION CORP

#0032221

FOUNDATION

Jamaica

QUEENS


KDK CONSTRUCTION CORP

#0032221

FOUNDATION

Jamaica

QUEENS


KDK CONSTRUCTION CORP

#0032221

NEW BUILDING

Jamaica

QUEENS


KDK CONSTRUCTION CORP

#0032221

FOUNDATION

Jamaica

QUEENS


KDK CONSTRUCTION CORP

#0032221

FOUNDATION

Jamaica

QUEENS


KDK CONSTRUCTION CORP

#0032221

NEW BUILDING

Jamaica

QUEENS


KDK CONSTRUCTION CORP

#0032221

EQUIPMENT

Jamaica

QUEENS


KDK CONSTRUCTION CORP

#0032221

EQUIPMENT

Jamaica

QUEENS


(default) 2 queries took 2455 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 250, 50505014
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`permits` AS `Permit` WHERE MATCH (License_Permit_Holder, City) AGAINST ( '(+JAMAICA)' IN BOOLEAN MODE)112441