RED HOOK

1 - 50 of 1622

RED HOOK CONSTRUC. GROUP

#0023225

FULL DEMOLITION

MANHATTAN

RED HOOK CONSTRUC. GROUP

#0023225

EQUIPMENT

MANHATTAN

RED HOOK SIGN AND ELECT

#0000197

SIGN

MANHATTAN

RED HOOK SIGN AND ELECT

#0000197

SIGN

MANHATTAN

RED HOOK CONSTRUCTION GROUP I-LL

#0023225

EQUIPMENT WORK

LONG ISLAND CITY

QUEENS

RED HOOK CONSTRUCTION GROUP I-LL

#0023225

ALTERATION

LONG ISLAND CITY

QUEENS

RED HOOK CONSTRUCTION GROUP I-LL

#0023225

EQUIPMENT

LONG ISLAND CITY

QUEENS

RED HOOK CONSTRUCTION GROUP I-LL

#0023225

ALTERATION

LONG ISLAND CITY

QUEENS

RED HOOK CONSTRUCTION GROUP I-LL

#0023225

EQUIPMENT

LONG ISLAND CITY

QUEENS

RED HOOK CONSTRUCTION GROUP I-LL

#0023225

EQUIPMENT

LONG ISLAND CITY

QUEENS

RED HOOK CONST GROUP-II,L

#0608102

EQUIPMENT WORK

MANHATTAN

RED HOOK CONST GROUP-II,L

#0608102

EQUIPMENT WORK

MANHATTAN

RED HOOK CONSTRUCTION GROUP ONE

#0023225

EQUIPMENT

MANHATTAN

RED HOOK CONSTR. GROUP ONE LLC

#0023225

EQUIPMENT

MANHATTAN

RED HOOK CONSTR. GROUP ONE LLC

#0023225

FULL DEMOLITION

MANHATTAN

RED HOOK CONSTR GROUP 1LLC

#0023225

EQUIPMENT

MANHATTAN

RED HOOK CONSTR GROUP 1LLC

#0023225

EQUIPMENT

MANHATTAN

RED HOOK CONSTR GROUP 1LLC

#0023225

FULL DEMOLITION

MANHATTAN

RED HOOK CONSTRUCTION GROUP

#0023225

EQUIPMENT WORK

RED HOOK CONSTRUCTION GROUP

#0023225

EQUIPMENT WORK

RED HOOK CONSTRUCTION GROUP

#0023225

EQUIPMENT WORK

RED HOOK CONSTRUCTION GROUP

#0023225

EQUIPMENT WORK

RED HOOK CONSTRUCTION GROUP

#0023225

ALTERATION

RED HOOK CONSTRUCTION GROUP

#0023225

ALTERATION

RED HOOK CONSTRUCTION LLC

#0023225

EQUIPMENT WORK

RED HOOK CONSTRUCTION LLC

#0023225

ALTERATION

RED HOOK CONSTRUCTION LLC

#0023225

ALTERATION

RED HOOK CONSTRUCTION LLC

#0023225

EQUIPMENT WORK

RED HOOK CONSTRUCTION LLC

#0023225

EQUIPMENT WORK

RED HOOK CONSTRUCTION LLC

#0023225

EQUIPMENT WORK

RED HOOK CONST GROUP-II,L

#0608102

EQUIPMENT WORK

MANHATTAN

RED HOOK CONST GROUP

#0023225

EQUIPMENT

RED HOOK CONST GROUP

#0023225

EQUIPMENT

RED HOOK CONST GROUP

#0023225

EQUIPMENT

RED HOOK CONSTRUCTION GROUP I LL

#0023225

EQUIPMENT

RED HOOK CONST-GROUP I LLC

#0023225

ALTERATION

RED HOOK CONST. GROUP I LLC

#0023225

EQUIPMENT

RED HOOK CONST. GROUP I LLC

#0023225

EQUIPMENT

RED HOOK CONST. GROUP I LLC

#0023225

EQUIPMENT

RED HOOK CONST. GROUP I LLC

#0023225

FULL DEMOLITION

RED HOOK CONST. GROUP I LLC

#0023225

EQUIPMENT

RED HOOK CONST. GROUP I LLC

#0023225

EQUIPMENT

RED HOOK CONST. GROUP I LLC

#0023225

FULL DEMOLITION

RED HOOK CONST. GROUP I LLC

#0023225

EQUIPMENT

RED HOOK CONST-GROUP I, LLC.

#0023225

EQUIPMENT

MANHATTAN

RED HOOK CONST-GROUP I, LLC.

#0023225

EQUIPMENT

MANHATTAN

RED HOOK CONST-GROUP I, LLC.

#0023225

EQUIPMENT

MANHATTAN

RED HOOK CONST-GROUP I, LLC.

#0023225

FULL DEMOLITION

MANHATTAN

RED HOOK CONST-GROUP I, LLC.

#0023225

EQUIPMENT

MANHATTAN

RED HOOK CONST GROUP-II,L

#0608102

EQUIPMENT WORK

(default) 2 queries took 207 ms
Nr	Query	Error	Affected	Num. rows	Took (ms)
1	SELECT `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 ( '(+RED +HOOK)' IN BOOLEAN MODE) LIMIT 50		50	50	5
2	SELECT COUNT(*) AS `count` FROM `nyc_business`.`permits` AS `Permit` WHERE MATCH (License_Permit_Holder, City) AGAINST ( '(+RED +HOOK)' IN BOOLEAN MODE)		1	1	202