REGO PARK [Permits for REGO PARK]

251 - 300 of 489

A.M.V. DOORS INC.

Business

Active


ANITA HOLDING LLC

Business

Active


NASA CONSTRUCTION CORP.

Business

Active


ALEXPCS OF NY INC

Business

Active


METROPOLITAN MEDIA QUEENS INC.

Business

Inactive


City Rx Pharmacy

Business

Active


WIRELESS ADVOCATES, LLC

Business

Active


VECTOR SLEEP LLC

Business

Inactive


SUPER LUCKY LAUNDROMAT INC.

Business

Active



FOREST HILLS BUILDERS, LLC

Business

Active


LUCKY STORE GROCERY INC.

Business

Active


AUSTIN K & A LAUNDRY INC

Business

Active


P.C. Richard & Son

Business

Active



WIRELESS ADVOCATES, LLC

Business

Inactive


B & X 99 CENTS & UP INC.

Business

Active


YOGI 97 CORP.

Business

Active


7-ELEVEN STORE 29937C

Business

Active


NAZAROV, MAKSUD

Business

Active


RINALDO RENDI RAY CORP

Business

Inactive


URTECHO, JORGE

Business

Active



MARUTINANDAN TRADING, INC.

Business

Inactive


MBI CONSTRUCTION

Business

Active



NEW TECH GROUP INCORPORATED

Business

Inactive


DUANE READE

Business

Active


IMPARK QB LLC

Business

Active


JUST FOR YOU ONLY INC.

Business

Active



8925 MOBILE 4 U INC.

Business

Active


KRISTIC, INC.

Business

Inactive


ARJAY WIRELESS

Business

Inactive


AAA WASH & CLEAN

Business

Active



SIMON & SONS JEWELRY, LLC

Business

Active


SHAH, LEENA

Business

Active


T-MOBILE

Business

Active


IZZY'S REMODELING

Business

Inactive


AUTIN A & C LAUNDRY

Business

Inactive


ESA MEDICAL SUPPLY INC

Business

Inactive


NASIMJON, SAIDOV

Business

Active


QUEENS LOBBY NEWSTAND INC

Business

Active


YUAN'S RENOVATIONS

Business

Active


RADHIKA CONVENIENCE SHOP

Business

Active



FLOORING AND PAINTING INC

Business

Active


SILKROAD WIRELESS INC

Business

Active



(default) 2 queries took 363 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 ( '(+REGO +PARK)' IN BOOLEAN MODE) LIMIT 250, 505050141
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+REGO +PARK)' IN BOOLEAN MODE)11222