MASPETH [Permits for MASPETH]

551 - 600 of 745

NEW MAURICE DELI INC.

Business

Active


VILLAGE GREEN LAND INC

Business

Active


BUDIMEX GROUP INC.

Business

Inactive


DIGICOMNY INC

Business

Active


MATTONE'S CONSTRUCTION

Business

Active


ACE TENTS AMUSEMENT CORP

Business

Inactive


JIA WEI CONSTRUCTION INC.

Business

Active



A & J MARKET INC.

Business

Inactive


a plus construction inc

Business

Active


KRISPO CONSTRUCTION CORP.

Business

Active


CRAFTSMEN CONSTRUCTION INC.

Business

Inactive


AMG PETROLEUM 101 LLC

Business

Inactive



RDM RENOVATION, CORP.

Business

Active


GEE BEE AND SONS LLC

Business

Active


MASPETH DELI AND GROCERY INC

Business

Inactive


WINDUSTRIES LLC

Business

Inactive


AQUA CLEAN LAUNDROMAT INC.

Business

Active


CHRISPOL HOME IMPROVEMENT INC.

Business

Inactive


MASPETH AUTO CARE, INC.

Business

Inactive


SEBKO CONSTRUCTION CORP.

Business

Inactive


GEE BEE AND SONS LLC

Business

Inactive


PINEWOOD CONTRACTING INC.

Business

Inactive



MASPETH MINI MART

Business

Active


HEALY WOODWORKS INC.

Business

Active




MISTRETTA, GASPARE

Business

Active



BUILDING MAINTENANCE CORP

Business

Active


J B AUTO REPAIR

Business

Active


MIDDLE VILLAGE FARM, INC.

Business

Inactive


E & E SOPHIA FARMS CORP.

Business

Active


J & J CUSTOM DUCTWORK CORP.

Business

Active


T-MOBILE

Business

Inactive


PFL REMODELING CORP.

Business

Active


ZANKO RENOVATION CORP.

Business

Inactive


APEX HARDWOOD FLOORS LLC

Business

Active


FINE BUILDERS GROUP NY LTD.

Business

Inactive




JB AUTO REPAIR

Business

Active


BM AUTO COLLISION, INC.

Business

Inactive



NEW MK MOBILE INC.

Business

Active


ELLI N.Y. DESIGN CORP.

Business

Active


2K-CONSTRUCTION CORP

Business

Active



(default) 2 queries took 405 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 550, 505050198
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)11207