MASPETH [Permits for MASPETH]

401 - 450 of 745


EXECUTIVE TRUCK SALES, INC

Business

Inactive


T-MOBILE

Business

Inactive


CARLOS HANDYMAN

Business

Inactive


GARET MOTORS INC.

Business

Active


QUESTART CONSTRUCTION

Business

Active


U.S INTERIORS LLC

Business

Active



K.F. PERFECT CONSTRUCTION CO.

Business

Inactive


TRI STATE APPLIANCE SERVICE

Business

Inactive



FRIENDZ DELI & GROCERY INC

Business

Active


GRAND AVE. PHARMACY, INC.

Business

Active


MDD BROTHERS CORP.

Business

Inactive



GEMELLI JEWELERS L.L.C.

Business

Active


J. COTOIA CONSTRUCTION INC.

Business

Active



DUBSON ROOFING

Business

Active


VERIZON WIRELESS

Business

Active


IRISH MIST CONTRACTING

Business

Active


OMAR MILK CORP.

Business

Inactive




MARIA'S DELI

Business

Inactive


PLATHO DELI GROCERY, INC.

Business

Active


MUKTI 66 PETROLEUM INC

Business

Active


FRANK CONSTRUCTION CORP

Business

Inactive


P.K. CONSTRUCTION NY INC.

Business

Active


MAURICE SERVICES, INC.

Business

Inactive



E.B. MECHANICAL, INC.

Business

Inactive



D & T RESTORATION INC

Business

Active



J & P CONSTRUCTION I, INC.

Business

Inactive


MALPOL CONSTRUCTION CORP

Business

Active



PAVING THE WAY, INC.

Business

Active


MASPETH ROOFING SIDING

Business

Active


LUIGI CALIENDO & SONS, INC.

Business

Active


RK PRECISION, LLC

Business

Active


CHEITO DURAN DELI GROCERY

Business

Inactive


BLATTWORLD INC

Business

Active


MASPETH FOOD CORP

Business

Active


SG RENOVATION INC.

Business

Inactive


JOINAVIEW, INC.

Business

Inactive


JEREMY CORPORATION

Business

Active


ROOFUS RESTORATION LLC

Business

Inactive



(default) 2 queries took 358 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 400, 505050142
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)11216