LYNBROOK

1 - 50 of 53

LYNBROOK CONSTRUCTION CORP

#0009307

EQUIPMENT WORK


LYNBROOK CONSTRUCTION CORP

#0009307

EQUIPMENT WORK


LYNBROOK GLASS ARCHITECT

#0008178

ALTERATION

WHITESTONE

QUEENS


LYNBROOK GLASS & ARCHITECTURAL M

#0008178

ALTERATION

WHITESTONE

QUEENS


LYNBROOK CONSTRUCTION

#

EQUIPMENT WORK

NEW YORK

MANHATTAN


LYNBROOK CONSTRUCTION

#

EQUIPMENT WORK

NEW YORK

MANHATTAN






WHITESTONE

QUEENS









JDJ LYNBROOK LLC

#0001658

PLUMBING

NEW YORK

MANHATTAN


JDJ LYNBROOK LLC

#0001658

PLUMBING

BRONX

BRONX


JDJ LYNBROOK LLC

#0000716

EQUIPMENT WORK

NEW YORK

MANHATTAN


JDJ LYNBROOK LLC

#0000716

EQUIPMENT WORK


JDJ LYNBROOK LLC

#0000716

EQUIPMENT WORK

NEW YORK

MANHATTAN


JDJ LYNBROOK LLC

#0000716

EQUIPMENT WORK

NEW YORK

MANHATTAN


JDJ LYNBROOK LLC

#0000716

EQUIPMENT WORK

NEW YORK

MANHATTAN


JDJ LYNBROOK LLC

#0000716

EQUIPMENT WORK


JDJ LYNBROOK LLC

#0000716

EQUIPMENT WORK

NEW YORK

MANHATTAN


JDJ LYNBROOK LLC

#0000716

EQUIPMENT WORK

NEW YORK

MANHATTAN


JDJ LYNBROOK LLC

#0000716

EQUIPMENT WORK

NEW YORK

MANHATTAN


JDJ LYNBROOK LLC

#0000716

EQUIPMENT WORK


JDJ LYNBROOK LLC

#0001658

PLUMBING


JDJ LYNBROOK LLC

#0000716

EQUIPMENT WORK

NEW YORK

MANHATTAN



JDJ LYNBROOK LLC

#0000716

EQUIPMENT WORK

NEW YORK

MANHATTAN


JDJ LYNBROOK LLC

#0001658

PLUMBING

BROOKLYN

BROOKLYN


HOLLIS

QUEENS



JDJ LYNBROOK LLC

#0001658

PLUMBING

BROOKLYN

BROOKLYN


JDJ LYNBROOK LLC

#0001658

EQUIPMENT WORK

BROOKLYN

BROOKLYN


JDJ LYNBROOK LLC

#0001658

PLUMBING


JDJ LYNBROOK LLC

#0001658

PLUMBING

EAST ELMHURST

QUEENS


JDJ LYNBROOK LLC

#0000716

EQUIPMENT WORK


JDJ LYNBROOK LLC

#0000716

EQUIPMENT WORK


JDJ LYNBROOK LLC

#0000716

EQUIPMENT WORK

HOWARD BEACH

QUEENS


JDJ LYNBROOK LLC

#0000716

EQUIPMENT WORK

NEW YORK

MANHATTAN


JDJ LYNBROOK LLC

#0000716

EQUIPMENT WORK


JDJ LYNBROOK LLC

#0001658

EQUIPMENT WORK

NEW YORK

MANHATTAN


JDJ LYNBROOK LLC

#0001658

PLUMBING

NEW YORK

MANHATTAN


JDJ LYNBROOK LLC

#0001658

PLUMBING


JDJ LYNBROOK LLC

#0001658

PLUMBING

RICHMOND HILL

QUEENS


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