SAINT ALBANS [Permits for SAINT ALBANS]

301 - 323 of 323

THE BEST GROCERY CORP.

Business

Active




LINDEN DELI & GROCERY

Business

Active



LINDEN PAWN BROKERS INC

Business

Inactive




QUEST, ERROL

Business

Active



LINDEN PAWN BROKERS INC

Business

Active



JAMANA INC.

Business

Active


CUTTING EDGE REMODELLING

Business

Inactive



DEJA VU DELI CORP

Business

Inactive



MULLINGS, SIMNEL

Business

Active


VOA INC.

Business

Active



T-MOBILE

Business

Inactive


ST ALB ANS MINI MALL

Business

Inactive


T-MOBILE

Business

Inactive


(default) 2 queries took 521 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 ( '(+SAINT +ALBANS)' IN BOOLEAN MODE) LIMIT 300, 502323236
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+SAINT +ALBANS)' IN BOOLEAN MODE)11285