SAINT ALBANS [Permits for SAINT ALBANS]

151 - 200 of 323

SKYERS, DANIEL

Individual

Active


SMITH, GHANI C

Individual

Active


WILLIAMS, JANTHA

Individual

Active


LINDEN 7 DAYS DELI & GRILL INC

Business

Inactive


MAJOR REMODELING SERVICES INC

Business

Inactive



JFP GROCERY & DELI, INC.

Business

Inactive


T MOBILE

Business

Active


FUNTIME PARTY EXPRESS LLC

Business

Inactive



CENTRAL PEDICAB

Business

Active


LSM CONSTRUCTION INC.

Business

Active


JSW HOME IMPROVEMENTS

Business

Active


786 FARMERS BLVD INC

Business

Active


Westbrook Home Improvement

Business

Active


HOME REVIVAL SERVICES INC.

Business

Inactive


NU WAY CONSTRUCTION, INC.

Business

Active


EDUARDO INFANTE GROCERY STORE

Business

Inactive


LINDEN FAMOUS DELI & GRILL INC

Business

Inactive


FAVORS & COMPANY INC

Business

Inactive



JIMMY CONSTRUCTION, INC.

Business

Active


UNLIMITED WIRELESS NY LLC

Business

Inactive


ISAAC GROCERY INC.

Business

Inactive


CASTOR AUTO SALES INC.

Business

Inactive


METRO LAUNDRY SERVICE INC.

Business

Inactive


NEW ROSARIO DELI GROCERY, CORP

Business

Inactive


FARMERS DELI GROCERY

Business

Active




Y & H DELI & GROCERY CORP.

Business

Inactive




UNLIMITED WIRELESS NY LLC

Business

Inactive


Y & M DELI & GROCERY CORP

Business

Active


BUDGET LAUNDROMAT

Business

Inactive


VINCENT, JOSEPH

Business

Active


GORDON, RALPH

Business

Active


LINDEN PAWN BROKERS INC

Business

Inactive


St. Albans Mini Mall

Business

Inactive


ISAAC GROCERY INC.

Business

Active


P&L HOME APPLIANCE CENTER

Business

Inactive


CLEARVIEW CONSTRUCTION INC.

Business

Active


DEANCO

Business

Active


199 LINDEN DELI GROCERY

Business

Active


BOUNCER

Business

Inactive



786 FARMERS BLVD INC

Business

Active




(default) 2 queries took 426 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 150, 505050143
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)11283