AURORA

1 - 50 of 1085

AURORA P & H CONT INC

#0001626

PLUMBING

SUNNYSIDE

QUEENS


AURORA CONTRACTERS INC

#0004063

ALTERATION

NEW YORK

MANHATTAN


AURORA CONTRACTORS INC

#0004063

EQUIPMENT WORK

NEW YORK

MANHATTAN


AURORA CONTRACTORS INC

#

EQUIPMENT WORK

NEW YORK

MANHATTAN


NEW YORK

MANHATTAN


AURORA CONTRACTORS INC

#

EQUIPMENT WORK

NEW YORK

MANHATTAN


AURORA CONTRACTORS INC

#

EQUIPMENT WORK

NEW YORK

MANHATTAN


AURORA CONTRACTORS INC

#

EQUIPMENT WORK

NEW YORK

MANHATTAN


AURORA CONTRACTORS INC

#

EQUIPMENT WORK

NEW YORK

MANHATTAN


AURORA CONSTRACTORS INC

#

EQUIPMENT WORK

NEW YORK

MANHATTAN


AURORA CONSTRACTORS INC

#

EQUIPMENT WORK

NEW YORK

MANHATTAN


AURORA CONSTRACTORS INC

#

EQUIPMENT WORK

NEW YORK

MANHATTAN


NEW YORK

MANHATTAN


NEW YORK

MANHATTAN


AURORA CONSTRACTORS INC

#

EQUIPMENT WORK

NEW YORK

MANHATTAN


AURORA PLUMB HEAT. CONTR INC.

#0001626

PLUMBING

NEW YORK

MANHATTAN


AURORA PLBG & HTG CONTRACTORS

#0001626

EQUIPMENT WORK

NEW YORK

MANHATTAN


AURORA PLUMB HEAT. CONTR. INC.

#0001626

EQUIPMENT WORK

NEW YORK

MANHATTAN


AURORA CONTRACTERS INC

#0004063

EQUIPMENT WORK

NEW YORK

MANHATTAN


AURORA CONTRACTORS INC

#

EQUIPMENT WORK

NEW YORK

MANHATTAN


AURORA CONTRACTORS INC

#

EQUIPMENT WORK

NEW YORK

MANHATTAN


AURORA CONTRACTORS INC

#

EQUIPMENT WORK

NEW YORK

MANHATTAN


AURORA CONTRACTORS INC

#

EQUIPMENT WORK

NEW YORK

MANHATTAN


AURORA CONTRACTORS INC

#0004063

EQUIPMENT WORK

NEW YORK

MANHATTAN


AURORA CONTRACTORS INC

#0004063

EQUIPMENT WORK

NEW YORK

MANHATTAN


AURORA CONTRACTORS INC

#0004063

EQUIPMENT

NEW YORK

MANHATTAN


AURORA P & H CONT INC

#0001626

PLUMBING

NEW YORK

MANHATTAN


AURORA P & H CONT INC

#0001626

PLUMBING

NEW YORK

MANHATTAN


AURORA P & H CONT INC

#0001626

EQUIPMENT WORK

NEW YORK

MANHATTAN


AURORA CONTRACTORS ,INC.

#

EQUIPMENT WORK

NEW YORK

MANHATTAN


AURORA CONTRACTORS ,INC.

#

EQUIPMENT WORK

NEW YORK

MANHATTAN


AURORA KAY INC.

#0034002

EQUIPMENT WORK

NEW YORK

MANHATTAN


AURORA P & H CONT INC

#0001626

PLUMBING

CORONA

QUEENS


AURORA CONTRACTING INC

#0004063

ALTERATION


AURORA GLOBAL ENTERP INC

#0012693

EQUIPMENT WORK

NEW YORK

MANHATTAN


CAFE AURORA PIZZERIA REST

#0021058

EQUIPMENT WORK

NEW YORK

MANHATTAN


AURORA P & H CONT INC

#0001626

PLUMBING

BROOKLYN

BROOKLYN


AURORA P & H CONT INC

#0001626

PLUMBING

BROOKLYN

BROOKLYN


AURORA MECH SVCS

#0013612

EQUIPMENT WORK

BROOKLYN

BROOKLYN


AURORA MECHANICAL SERVICES

#0013632

ALTERATION

BROOKLYN

BROOKLYN


AURORA CONSTRUCTION INC

#0004628

ALTERATION

STATEN ISLAND

STATEN ISLAND


AURORA CONSTRUCTION INC.

#0004628

ALTERATION

STATEN ISLAND

STATEN ISLAND


AURORA CONSTRUCTION INC.

#0004628

ALTERATION

STATEN ISLAND

STATEN ISLAND


AURORA P & H CONT INC

#0001626

PLUMBING

STATEN ISLAND

STATEN ISLAND


AURORA P & H CONT INC

#0001626

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


AURORA CONTRCTORS, INC.

#

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


AURORA CONTRCTORS, INC.

#

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


AURORA CONTRACTORS INC

#0004063

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


AURORA CONTRACTORS INC

#0004063

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


AURORA CONSTRUCTION INC.

#0004628

NEW BUILDING

STATEN ISLAND

STATEN ISLAND


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