FRESH MEADOWS

1 - 50 of 21262

TRIPLE 8 CONSTRUCTION INC

#0038667

EQUIPMENT WORK

FRESH MEADOWS

QUEENS


FRESH MEADOWS CUSTOM CONTRACTING

#0009804

EQUIPMENT WORK

NEW YORK

MANHATTAN


C & T PLUMBING & HTG INC

#0002025

PLUMBING

FRESH MEADOWS

QUEENS


NEW YORK

MANHATTAN


NEW YORK

MANHATTAN


NEW YORK

MANHATTAN


NEW YORK

MANHATTAN


FRESH MEADOWS CUSTOM CONTRACTING

#0009804

EQUIPMENT WORK


FRESH MEADOWS PAINTING CORP

#

EQUIPMENT WORK

NEW YORK

MANHATTAN


FRESH MEADOWS PAINTING CORP

#

EQUIPMENT WORK

NEW YORK

MANHATTAN


FRESH MEADOWS PAINTING CORP

#

EQUIPMENT WORK

NEW YORK

MANHATTAN


FRESH MEADOWS PAINTING CORP

#

EQUIPMENT WORK

NEW YORK

MANHATTAN


FRESH MEADOWS CORP

#0608346

EQUIPMENT WORK

NEW YORK

MANHATTAN


FRESH MEADOWS PAINTING CORP.

#

EQUIPMENT WORK

BRONX

BRONX


BRONX

BRONX


BRONX

BRONX



FRESH MEADOWS CORP

#0608346

EQUIPMENT WORK


FONG CONSTRUCTION CORP

#0033383

EQUIPMENT

FRESH MEADOWS

QUEENS


FONG CONSTRUCTION CORP

#0033383

EQUIPMENT

FRESH MEADOWS

QUEENS


FONG CONSTRUCTION CORP

#

FULL DEMOLITION

FRESH MEADOWS

QUEENS


FONGS CREATIVE CONST.CORP

#0009562

EQUIPMENT

FRESH MEADOWS

QUEENS


FONGS CREATIVE CONST.CORP

#0009562

EQUIPMENT

FRESH MEADOWS

QUEENS


FONGS CREATIVE CONST.CORP

#0009562

EQUIPMENT

FRESH MEADOWS

QUEENS


NEW HO XIN DEVELOPMENT

#0033599

EQUIPMENT

FRESH MEADOWS

QUEENS


NEW HO XIN DEVELOPMENT

#0033599

NEW BUILDING

FRESH MEADOWS

QUEENS


NEW HO XIN DEVELOPMENT

#0033599

FOUNDATION

FRESH MEADOWS

QUEENS


NEW HO XIN DEVELOPMENT

#0033599

NEW BUILDING

FRESH MEADOWS

QUEENS


NEW HO XIN DEVELOPMENT

#0033599

FOUNDATION

FRESH MEADOWS

QUEENS


NEW HO XIN DEVELOPMENT

#0033599

EQUIPMENT

FRESH MEADOWS

QUEENS


NEW HO XIN DEVELOPMENT

#0033599

NEW BUILDING

FRESH MEADOWS

QUEENS


ORBIT PLBG & HTG INC

#0000957

PLUMBING

FRESH MEADOWS

QUEENS


NEW HO XIN DEVELOPMENT IN

#0033599

EQUIPMENT

FRESH MEADOWS

QUEENS


NEW HO XIN DEVELOPMENT IN

#0033599

NEW BUILDING

FRESH MEADOWS

QUEENS


KINGS STAR CONSTRUCTION C

#0607573

ALTERATION

FRESH MEADOWS

QUEENS


LUSSO CONTRACTING CORP

#0601099

FOUNDATION

FRESH MEADOWS

QUEENS


LUSSO CONTRACTING CORP

#0601099

NEW BUILDING

FRESH MEADOWS

QUEENS


LUSSO CONTRACTING CORP

#0601099

EQUIPMENT

FRESH MEADOWS

QUEENS


LUSSO CONTRACTING CORP

#0601099

FOUNDATION

FRESH MEADOWS

QUEENS


LUSSO CONTRACTING CORP

#0601099

NEW BUILDING

FRESH MEADOWS

QUEENS


LUSSO CONTRACTING CORP

#0601099

EQUIPMENT

FRESH MEADOWS

QUEENS


D & G PLBG CO INC

#0001064

PLUMBING

FRESH MEADOWS

QUEENS


CHIEF FIRE CONTR. CO. INC

#0000319

EQUIPMENT WORK

FRESH MEADOWS

QUEENS


LUSSO CONTRACTING CORP

#0601099

EQUIPMENT

FRESH MEADOWS

QUEENS


LUSSO CONTRACTING CORP

#0601099

NEW BUILDING

FRESH MEADOWS

QUEENS


LUSSO CONTRACTING CORP

#0601099

EQUIPMENT

FRESH MEADOWS

QUEENS


LUSSO CONTRACTING CORP

#0601099

FOUNDATION

FRESH MEADOWS

QUEENS


LUSSO CONTRACTING CORP

#0601099

FOUNDATION

FRESH MEADOWS

QUEENS


LUSSO CONTRACTING CORP

#0601099

NEW BUILDING

FRESH MEADOWS

QUEENS


LUSSO CONTRACTING CORP

#0601099

FOUNDATION

FRESH MEADOWS

QUEENS


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