KEW GARDENS [Permits for KEW GARDENS]

51 - 100 of 534

BAYSIDE SMOKE SHOP

Business

Active


WIRELESS 1 OF NY INC.

Business

Inactive


WIRELESS 1 OF SPRINGFIELD

Business

Inactive


W. SWEET ALIZA INC.

Business

Active


URIBE, ELIZABETH

Individual

Active


SANAT CARDS & GIFTS, INC.

Business

Active


MEYEROWITZ, RONALD

Individual

Inactive


GROSSO, LAWRENCE

Individual

Active


RED ARROW STORE

Business

Active


BAYSIDE SUPPLY, INC.

Business

Active


JACKMAN, TERRYANNE

Individual

Active



Ping, Laura

Individual

Active


T-Mobile

Business

Active


AGUAYZA MAYNCELA, LORENZO

Individual

Active


KYLTESHOV, OLZHAS

Individual

Inactive


Cui, Hong

Individual

Active


ALILI, SURJAN

Individual

Active



GAETA, JEROME

Individual

Inactive



KEW Convenience Store, Inc.

Business

Active


LI, MATTHEW

Individual

Active


ADEOLA, MABIFA

Individual

Active


NELSON'S AUTO SALVAGE, INC.

Business

Inactive


S. GARDENS DELI INC.

Business

Active


QUEENS VILLAGE TOWING INC.

Business

Inactive


SHAWN TOWING INC

Business

Active


RAHIMAN, FARHAD

Individual

Active


REJIN CONSTRUCTION LLC

Business

Active


LAVITHIS, ANTHONY

Individual

Active


CLIMACO AUTOBODY INC.

Business

Active


FANG, JIN

Individual

Active


JYD TOWING LLC

Business

Inactive



TUCKER, CHANEL

Individual

Inactive


WALKER, EDWARD

Individual

Active





RICATTO, MICHAEL P

Individual

Active


KUBATOV, RINAT

Individual

Inactive


D MACARTHUR AUTO BODY LTD

Business

Active


RAHMAN, SYED

Individual

Inactive


MX GROUP INC

Business

Active


Till Gardens LLC

Business

Active


NELSON, CLOVIS

Individual

Inactive


LEE, JONG KI

Individual

Active


LANG, ROY

Individual

Active


D'ORIO, JACK J

Individual

Active


(default) 2 queries took 299 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 ( '(+KEW +GARDENS)' IN BOOLEAN MODE) LIMIT 50, 50505062
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+KEW +GARDENS)' IN BOOLEAN MODE)11237