KEW GARDENS [Permits for KEW GARDENS]

501 - 534 of 534

RADIOSHACK STORE #2662

Business

Inactive


FANCY PANTS DRY CLEANERS

Business

Active


SK MART CONVENIENCE, INC.

Business

Active






VICTORIAN GARDENS

Business

Inactive


ADM LANDSCAPE CORP.

Business

Active


SAIFUL DELI GROCERY INC.

Business

Active




8168 LAUNDRY SERVICES LLC

Business

Active


JONG KI LEE

Business

Inactive



VULAJ RESTORATION

Business

Inactive


ROLDAN CONTRACTING CORP.

Business

Active



NELSON'S AUTO SALVAGE, INC.

Business

Active


VICTORIAN GARDENS

Business

Inactive



MAJOR HOMES CORP.

Business

Active



TOWN & GARDENS, LTD.

Business

Active



MAJESTIC TILE

Business

Active


VICTORIAN GARDENS

Business

Inactive


MD GARDENS CORP

Business

Active


T-MOBILE

Business

Inactive


AIRPORT FLEET MAINTENCE

Business

Active



lxc construction inc.

Business

Active


MX GROUP INC

Business

Active


BURKARDT, CHRISTA M

Individual

Active


(default) 2 queries took 460 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 500, 503434245
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)11215