HOLLIS

1 - 50 of 9031

#0001485

PLUMBING

HOLLIS

QUEENS


HOLLIS TYLER INC

#

EQUIPMENT WORK

NEW YORK

MANHATTAN


HOLLIS TYLER INC

#

EQUIPMENT WORK

NEW YORK

MANHATTAN


HOLLIS TYLER INC

#

ALTERATION


AJS CONSTRUCTION CORP.

#0035797

NEW BUILDING

HOLLIS

QUEENS


AJS CONSTRUCTION CORP.

#0035797

EQUIPMENT

HOLLIS

QUEENS


AJS CONSTRUCTION CORP.

#0035797

EQUIPMENT

HOLLIS

QUEENS


AJS CONSTRUCTION CORP.

#0035797

NEW BUILDING

HOLLIS

QUEENS


FAB-TEC CONSTRUCTION AND

#0038530

NEW BUILDING

Hollis

QUEENS


FAB-TEC CONSTRUCTION AND

#0038530

EQUIPMENT

Hollis

QUEENS


ALL TIME CONSTRUCTION INC

#0600268

NEW BUILDING

Hollis

QUEENS


ALL TIME CONSTRUCTION INC

#0600268

EQUIPMENT

Hollis

QUEENS


ALL TIME CONSTRUCTION INC

#0600268

EQUIPMENT

Hollis

QUEENS


ALL TIME CONSTRUCTION INC

#0600268

NEW BUILDING

Hollis

QUEENS


MRM DEVELOPMENT CORP

#0031889

NEW BUILDING

Hollis

QUEENS


MRM DEVELOPMENT CORP

#0031889

EQUIPMENT

Hollis

QUEENS


MRM DEVELOPMENT CORP

#0031889

NEW BUILDING

Hollis

QUEENS


MRM DEVELOPMENT CORP

#0031889

EQUIPMENT

Hollis

QUEENS


FAB-TEC CONSTRUCTION AND

#0038530

EQUIPMENT

Hollis

QUEENS


FAB-TEC CONSTRUCTION AND

#0038530

NEW BUILDING

Hollis

QUEENS


FAB-TEC CONSTRUCTION AND

#0038530

NEW BUILDING

Hollis

QUEENS


EXCAVATING INDUSTRIES INC

#0039202

EQUIPMENT

HOLLIS

QUEENS


REMODELERS AND FINISHING

#0606885

EQUIPMENT

HOLLIS

QUEENS


PRO STAR PLBG AND HTG INC

#0000500

EQUIPMENT WORK

HOLLIS

QUEENS


FAB-TEC CONSTRUCTION AND

#0038530

NEW BUILDING

HOLLIS

QUEENS


MRM DEVELOPMENT CORP

#0031889

NEW BUILDING

HOLLIS

QUEENS


MRM DEVELOPMENT CORP

#0031889

NEW BUILDING

HOLLIS

QUEENS


FAB-TEC CONSTRUCTION AND

#0038530

NEW BUILDING

HOLLIS

QUEENS


M. SPINELLI PLB & HTG INC

#0002111

PLUMBING

HOLLIS

QUEENS


PRO STAR PLBG AND HTG INC

#0001223

PLUMBING

HOLLIS

QUEENS


MAJOR HOMES CORP.

#0001496

ALTERATION

HOLLIS

QUEENS


SVJ CONSTRUCTION INC

#0029385

EQUIPMENT WORK

HOLLIS

QUEENS


SVJ CONSTRUCTION INC

#0029385

EQUIPMENT

HOLLIS

QUEENS


OWNER

#

ALTERATION

HOLLIS

QUEENS


N/A

#999994

FULL DEMOLITION

HOLLIS

QUEENS


CORE CONTINENTAL CONST 3

#0038904

NEW BUILDING

HOLLIS

QUEENS


C2 PLUMBING CORP

#0000474

PLUMBING

HOLLIS

QUEENS


J & V HOME IMPROVEMENT CO

#0600704

EQUIPMENT WORK

HOLLIS

QUEENS


J & V HOME IMPROVEMENT.CO

#0600704

EQUIPMENT WORK

HOLLIS

QUEENS


J & V HOME IMPROVEMENT.CO

#0600704

EQUIPMENT

HOLLIS

QUEENS


J & V HOME IMPROVEMENT.CO

#0600704

EQUIPMENT

HOLLIS

QUEENS


J & V HOME IMPROVEMENT.CO

#0600704

EQUIPMENT WORK

HOLLIS

QUEENS


DELTA DEMO OF NY INC

#0027401

EQUIPMENT

HOLLIS

QUEENS


DELTA DEMO OF NY INC

#0027401

FULL DEMOLITION

HOLLIS

QUEENS


THE PLUMBING & HTG SPECIA

#0002161

PLUMBING

HOLLIS

QUEENS


GEORGE P. GOLOVCHENKO, P.E.

#0039481

ALTERATION

HOLLIS

QUEENS


B H P & H CORP

#0001350

PLUMBING

HOLLIS

QUEENS


B.H. PLUMBING & HEATING CORP

#0001350

PLUMBING

HOLLIS

QUEENS


A.H. BUILDING

#0035409

ALTERATION

HOLLIS

QUEENS


N/A

#0999994

FULL DEMOLITION

HOLLIS

QUEENS


(default) 2 queries took 681 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 ( '(+HOLLIS)' IN BOOLEAN MODE) LIMIT 5050505
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`permits` AS `Permit` WHERE MATCH (License_Permit_Holder, City) AGAINST ( '(+HOLLIS)' IN BOOLEAN MODE)11676