SAINT ALBANS [Permits for SAINT ALBANS]

201 - 250 of 323

STRONGMAN CONSTRUCTION INC.

Business

Active



96 PRO

Business

Active


LOTUS FARMERS BLVD GAS CORP

Business

Active



E BURTO TRUCKING

Business

Inactive


Ronald Griffith

Business

Active



L & J MINI MARKET

Business

Inactive


S.S.S. SERVICES INC.

Business

Inactive


METRO LAUNDRY SERVICE INC.

Business

Active


IN-STATE CONSTRUCTION LLC

Business

Inactive



JAMLECH CONSTRUCTION CO. INC.

Business

Inactive


LUCKY'S DELI & GRILL, CORP.

Business

Inactive


D & C MINI MARKET CORP.

Business

Active


BASCO DELI GROCERY CORP.

Business

Inactive


TAKATY DELI CORP

Business

Inactive


BBJ DELI & GROCERY CORP.

Business

Inactive


UNLIMITED WIRELESS NY LLC

Business

Inactive


MEJIAS DELI GROCERY

Business

Active


DIAL-A SERVICE

Business

Active


BARRY'S WORKSHOP

Business

Inactive


LINDEN CONVENIENCE CORP

Business

Active




E. BURTON TRUCKING

Business

Inactive


ELITE WIRELESS GROUP NY LLC

Business

Active


PCS Wireless Brooklyn Inc

Business

Inactive


JASLYNN LAUNDROMAT

Business

Active


WEJA VU DELI INC

Business

Active


J&T SUPERMARKET, INC.

Business

Active



JUBAN DELI & GROCERY CORP

Business

Active



SYDMAC PROPERTIES, INC.

Business

Inactive


STORE #29389

Business

Active



RED TIGER DELI GRILL INC

Business

Active


SPORT'S HOME IMPROVEMENT

Business

Active


BOUNCER HOUSE

Business

Inactive


205 DELI GROCERY CORP

Business

Inactive


LA MELLIZA MINI MARKET INC.

Business

Active


HOLLYWOOD ENTERPRISE, INC.

Business

Active


5 STAR DELI GROCERY

Business

Active



ROCKY I DELI GROCERY CORP.

Business

Active


TMZ WIRELESS

Business

Active


A & M DELI EXPRESS INC

Business

Inactive


WISDOM- 6365 CORP

Business

Active


(default) 2 queries took 428 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 200, 505050190
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)11238