FRESH MEADOWS [Permits for FRESH MEADOWS]

251 - 300 of 548

WONG, WAI WO

Individual

Inactive


WANG, YILI

Individual

Active


FERNANDES, RONALD

Individual

Inactive


KHAN, MD

Individual

Active


MARMO, AMANDA

Individual

Active


EISINGER, JOSEPH E

Individual

Inactive


ZURIK, MICHAEL P

Individual

Active


HUANG, CHING

Individual

Inactive


YANG, LE R

Individual

Active


MOLINA, ARNOLDO

Individual

Active


LIN, YONG

Individual

Inactive


TORO, DARIO

Individual

Active


JIANG, WANLI

Individual

Active


BACELO, NELSON T

Individual

Active


AAA Fresh Meadows Gas, Inc

Business

Active


RAGA CONSTRUCTION LLC

Business

Active


WIND-LOCK CONSTRUCTION INC

Business

Inactive


AERUS ELECTROLUX

Business

Active


NY PRO ENTERPRISES INC

Business

Active



DY EXPRESS LAUNDROMAT, INC.

Business

Active



NEW LUCKYSTAR LAUNDROMAT INC

Business

Inactive


SUN COAST COLLECTIONS, LLC

Business

Active


BOBBY J. ENTERPRISE, INC.

Business

Active


CHDFF (OA)

Business

Active


SPRINT SPECTRUM L.P.

Business

Inactive


A.G.S. IMPROVEMENTS INC

Business

Active


Remodel Magic

Business

Active


YANG, XIAO Z

Business

Active


LUCKYSTAR LAUNDROMAT INC.

Business

Inactive



ISLAND OF GOLD SUPERMARKET INC

Business

Inactive



158 LAUNDROMAT CORP.

Business

Active


HAPPY LAUNDRY INC.

Business

Active


ALLSTYLEPAINTING CORP

Business

Inactive


S&S WIRELESS CORP.

Business

Active


ARNOLDO'S GARDENING, INC.

Business

Active



T-MOBILE

Business

Inactive


GAMESTOP STORE #1036

Business

Active


GAMESTOP, INC.

Business

Active




VERIZON WIRELESS-FRESH MEADOWS

Business

Inactive


AVELLINO CONSTRUCTION CORP.

Business

Active


WOOD FLOOR MASTER INC.

Business

Active


QU STYLE CONSTRUCTION INC.

Business

Active


GOOD LIFE EQUIPMENT INC.

Business

Inactive


(default) 2 queries took 401 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 250, 505050115
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)11286