NORTH HILLS

1 - 50 of 73

NORTH SHORE NEON SIGN CO., INC.

#

SIGN

QUEENS

NORTH SHORE NEON SIGN CO.,INC.

#

SIGN

QUEENS

NORTH SHORE NEON SIGN CO.,INC.

#

SIGN

QUEENS

NORTH SHORE NEON SIGN CO.,INC.

#

SIGN

QUEENS

NORTH ROLE AIRCONDITIONING

#0033337

EQUIPMENT WORK

QUEENS

NORTH SHORE NEON SIGN CO INC

#0000157

SIGN

QUEENS

NORTH SHORE NEON SIGN CO., INC.

#0000157

SIGN

QUEENS

NORTH SHORE NEON SIGN CO. INC.

#

SIGN

QUEENS

NORTH SHORE NEON SIGN CO., INC

#0000157

SIGN

QUEENS

NORTH SHORE NEON SIGN CO INC

#0000157

SIGN

QUEENS

NORTH SHORE NEON SIGN CO INC

#0000157

SIGN

QUEENS

NORTH SHORE SIGN CO.INC

#0000157

SIGN

QUEENS

NORTH SHORE NEON SIGN CO

#0001709

ALTERATION

QUEENS

NORTH SHORE NEON SIGN CO.INC.

#0000157

SIGN

QUEENS

NORTH SHORE NEON SIGN CO INC

#0000172

SIGN

QUEENS

NORTH SHORE NEON SIGN CO

#

SIGN

QUEENS

NORTH SHORE NEON SIGN CO. , INC

#0000157

SIGN

QUEENS

NORTH SHORE NEON SIGN CO., INC.

#0000157

SIGN

QUEENS

NORTH SHORE NEON SIGN CO.,INC.

#0000157

SIGN

QUEENS

NORTH SHORE NEON SIGN CO.

#

SIGN

QUEENS

NORTH SHORE NEON SIGN CO.

#

ALTERATION

QUEENS

NORTH SHORE NEON SIGN CO.

#

SIGN

QUEENS

NORTH SHORE NEON SIGN CO.

#

SIGN

QUEENS

NORTH SHORE NEON SIGN CO. INC.

#

SIGN

QUEENS

NORTH SHORE NEON SIGN CO. INC.

#

SIGN

QUEENS

NORTH SHORE NEON SIGN CO. INC.

#0000172

SIGN

QUEENS

NORTH SHORE UNIVERSITY HOSPITAL AT FOREST HILLS

#

PHYSICIAN

NORTH SHORE UNIVERSITY HOSPITAL AT FOREST HILLS

#

PHYSICIAN

NORTH SHORE UNIVERSITY HOSPITAL AT FOREST HILLS

#

PHYSICIAN

HILLS NORTH CONDO

#

BATHING POOL ESTAB.

HILLS NORTH CONDO

#

BATHING POOL ESTAB.

HILLS NORTH CONDO

#

BATHING POOL ESTAB.

NORTH HILLS ROASTERS, INC

#

FOOD SERVICE EST.

HILLS NORTH CONDO

#

BATHING POOL ESTAB.

NORTH SHORE UNIVERSITY HOSPITAL AT FOREST HILLS

#

FOOD SERVICE EST.

HILLS NORTH CONDOMINIUM

#

BATHING POOL ESTAB.

HILLS NORTH CONDOMINIUM

#

BATHING POOL ESTAB.

HILLS NORTH CONDOMINI

#

BATHING POOL ESTAB.

HILLS NORTH CONDO

#

BATHING POOL ESTAB.

OAKWOOD NORTH SOUTH OWNERS CORP

#

INCORRECT LICENSE

QUEENS

HILLS NORTH CONDO

#

BATHING POOL ESTAB.

NORTH SHORE UNIVERSITY HOSPITAL AT FOREST HILLS

#

FOOD SERVICE EST.

HILLS NORTH CONDO

#

BATHING POOL ESTAB.

UNIVERSITY HOSPITAL AT FOREST HILLS NORTH SHORE

#

PHYSICIAN

SHORE UNIVERSIT NORTH

#

PHYSICIAN

QUEENS

NORTH SHORE UNIVERSITY HOSPITAL AT FOREST HILLS

#

FOOD SERVICE EST.

NORTH SHORE UNIVERSITY HOSPITAL AT FOREST HILLS

#

FOOD SERVICE EST.

SHORE UNIVERSIT NORTH

#

PHYSICIAN

QUEENS

UNIVERSITY HOSPITAL AT FOREST HILLS NORTH SHORE

#

PHYSICIAN

UNIVERSITY HOSPITAL AT FOREST HILLS NORTH SHORE

#

PHYSICIAN

(default) 2 queries took 43 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 ( '(+NORTH +HILLS)' IN BOOLEAN MODE) LIMIT 50		50	50	27
2	SELECT COUNT(*) AS `count` FROM `nyc_business`.`permits` AS `Permit` WHERE MATCH (License_Permit_Holder, City) AGAINST ( '(+NORTH +HILLS)' IN BOOLEAN MODE)		1	1	16