MASPETH [Permits for MASPETH]

501 - 550 of 745


P D CONSTRUCTION GROUP INC

Business

Active


IDEAL CONSTRUCTION NY, INC.

Business

Active


SKYLINE AUTOMOTIVE INC

Business

Active



ASPIRO GOURMET FOOD CORP.

Business

Inactive


RIDGEWOOD PHARMACY-2

Business

Active


GRAND MINI MART LLC

Business

Active



LIPAROTO CONSTRUCTION LLC

Business

Active


MCK RENOVATION

Business

Active


C & M GENERAL CONTRACTING INC.

Business

Inactive


CUSTOM INDUSTRIAL DESIGN INC

Business

Inactive



MASPETH DRY CLEANERS

Business

Inactive


MEATHWAY CONTRACTING, INC.

Business

Active



UNIVERSAL WINDOW COMPANY

Business

Active


RELIABLE BUILD INC

Business

Active




WXF INC

Business

Active


TIM TIM LAUNDROMAT INC

Business

Active


DUCK'S AUTO SALES

Business

Active



ZHI YING INC.

Business

Active


MASPETH LAUNDROMAT INC.

Business

Active



ALLFORM CONSTRUCTION, LLC

Business

Active


RADIOSHACK STORE #2749

Business

Inactive




MP RENOVATIONS INC

Business

Active


KG CONSTRUCTION CORP.

Business

Inactive


TOWER CONTRACTING CORP.

Business

Active


DUCK'S AUTO SALES

Business

Active


ERO INTERIOR RENOVATIONS

Business

Active


RAMPEZT CONTRACTING COMPANY

Business

Inactive





PROBUILD CONTRACTING, INC.

Business

Active


BONILLA & SONS, INC.

Business

Active



MASPETH DRY CLEANERS

Business

Active


A1 LAUNDRY INC.

Business

Inactive


KAOTIC MOTOR SPORTS

Business

Inactive


KELLY, JOHN

Individual

Active


KARO RENOVATION CORP.

Business

Active



(default) 2 queries took 460 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Record`.`id`, `Record`.`DCA_License_Number`, `License Type`, `License Expiration Date`, `License Status`, `License Creation Date`, `Record`.`Industry`, `Record`.`Business_Name`, `Record`.`Business_Name_2`, `Address Building`, `Address Street Name`, `Secondary Address Street Name`, `Record`.`Address_City`, `Address State`, `Address ZIP`, `Contact Phone Number`, `Address Borough`, `Borough Code`, `Community Board`, `Council District`, `Record`.`BIN`, `Record`.`BBL`, `Record`.`NTA`, `Census Tract`, `Record`.`Detail`, `Record`.`Longitude`, `Record`.`Latitude`, `Record`.`Location`, `Record`.`description` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+MASPETH)' IN BOOLEAN MODE) LIMIT 500, 505050201
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+MASPETH)' IN BOOLEAN MODE)11259