GARDEN CITY [Permits for GARDEN CITY]

101 - 115 of 115

MILLER & MILONE P.C.

Business

Inactive



PINO, JOSEPH

Individual

Active



HIGHLINE DESIGN, CORP.

Business

Active


GARDEN CITY DELI CORP.

Business

Inactive



ROYCE CUSTOM HOMES LTD

Business

Active


ANG LEGAL SERVICES CORP.

Business

Active


PROCESS ONE LTD

Business

Inactive


GARDEN CITY WINDOWS, INC.

Business

Active



CLASSIC WINDOWS & DOORS

Business

Inactive


ZAK CONTRACTOR, INC.

Business

Active


MR. STOOP, CASA BELLA

Business

Inactive


(default) 2 queries took 485 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 ( '(+GARDEN +CITY)' IN BOOLEAN MODE) LIMIT 100, 501515240
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+GARDEN +CITY)' IN BOOLEAN MODE)11245