FRESH MEADOWS [Permits for FRESH MEADOWS]

351 - 400 of 548

WALDBAUM'S STORE #295

Business

Inactive


AT&T MOBILITY

Business

Active




SD CONSTRUCTION COMPANY

Business

Active


SURAJ CONSTRUCTION INC.

Business

Active


I. TENERIFE CORP.

Business

Active




JANG, YONG-KUK

Business

Active



TD DELI INC

Business

Inactive


ROOTS N' SHRUBS GARDEN DESIGNS

Business

Inactive


HOPE CONSTRUCTION CO

Business

Active


FRESHSTRAW, INC.

Business

Inactive


AT&T MOBILITY

Business

Inactive


DURAN KAROLYVANY

Business

Inactive


HOLLIS NYC CONSTRUCTION INC

Business

Active


N.Y.G.B., INC.

Business

Inactive


WONDERLAND MIDWAY CORP.

Business

Inactive


PARSONS TIRES, INC.

Business

Active


ALAGO'S REMODELING, CORP.

Business

Inactive


VULCAN BASEMENT CO

Business

Active



J SPINDLE LLC

Business

Active


KANG SAN CONSTRUCTION, INC.

Business

Active


KADINSKY, SERGEY A

Individual

Active


CS RENOVATION INC

Business

Active



ROMERO, HECTOR

Business

Inactive


MAX CONSTRUCTION CORP

Business

Active


COHEN BUILDERS LLC

Business

Active


BEST CONTRACTOR, INC.

Business

Inactive


FRESH MEADOWS CORP.

Business

Active


MOT NEW YORK INC.

Business

Active


SALONI STATIONERY INC.

Business

Active


FLAHIVE CONTRACTING INC.

Business

Active


A S CONVENIENCES INC.

Business

Active


DA FU MAINTENANCE CORP.

Business

Inactive


UTOPIA CONTRACTORS INC

Business

Active


TECH ELECTRONICS SHOP INC.

Business

Active


HI-RITE CONSTRUCTION INC.

Business

Active


FRESH MEADOWS NATURAL INC.

Business

Active


AVENUE CONTRACTING INC.

Business

Active


JIANXIN XIE

Business

Active



MEADOW TRADING INC.

Business

Active


T-Mobile

Business

Active


KATANOV, MARKIEL

Business

Inactive


P&M CONVENIENCE STORE INC.

Business

Active


(default) 2 queries took 406 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 ( '(+FRESH +MEADOWS)' IN BOOLEAN MODE) LIMIT 350, 505050180
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+FRESH +MEADOWS)' IN BOOLEAN MODE)11226