SAINT ALBANS [Permits for SAINT ALBANS]

251 - 300 of 323

ELITE WIRELESS GROUP NY LLC

Business

Active


D.W.P. MAINTENANCE CORP.

Business

Active


FARMERS BOULEVARD FOOD CORP

Business

Active


R.B.C CONSTRUCTION

Business

Active


MILLICENT, DECOTEAU

Business

Inactive


FUNTIME PARTY EXPRESS LLC

Business

Inactive


LINDEN GOLD RUSH INC

Business

Inactive


JONES JR., OSSIE L

Business

Inactive


ASHISH DELI & GROCERY INC

Business

Inactive


BURT'S WORKS

Business

Active


LINDEN PAWN BROKERS INC

Business

Active


AUDIO AT IT'S BEST LLC

Business

Inactive


DARALIZ MINI MARKET CORP.

Business

Inactive


FARMERS DELI GROCERY

Business

Active


CARIBBEAN CONTRACTING CORP.

Business

Active


P&L HOME APPLIANCE CENTER

Business

Active


LINDEN LAUNDROMAT, INC.

Business

Active


L.P. MINI MARKET CORP

Business

Inactive


MANSOOR DELI & GROCERY CORP

Business

Active


SD CONSTRUCTION CORPORATION

Business

Active


ERIC ARTHUR SCHRADER

Business

Active


COLORFUL LAKE INC.

Business

Active



CUPIE CONSTRUCTION

Business

Active


UNITED R GROCERY

Business

Active


S V S LAUNDROMAT INC.

Business

Active


NEB DEVELOPMENT,CO.LLC

Business

Active


UNLIMITED WIRELESS NY LLC

Business

Inactive


HOLLIS ISLAND CORP.

Business

Active


DALEY, DONOVAN B

Business

Active



M & T AUTO COLLISION, INC.

Business

Active



QUEST, ERROL

Business

Inactive


P & L HOME APPLIANCE CENTER

Business

Inactive


MANGUAL, MICHAEL

Individual

Active


NEW GROUND CONSTRUCTION, INC.

Business

Inactive


MURDOCK LAUNDROMAT INC.

Business

Active


TOTAL TECH SOLUTIONS, LLC

Business

Active


4 KINGS CONSTRUCTION INC.

Business

Inactive


P & L HOME APPLIANCE CENTER

Business

Inactive



ELITE WIRELESS GROUP NY LLC

Business

Active


LINDEN LAUNDROMAT

Business

Active


LINDEN 2 GUYS DELI INC

Business

Active


T-MOBILE #8154

Business

Inactive




LOC CONTRACTORS

Business

Inactive


JOE'S MUSIC STORE

Business

Active


(default) 2 queries took 519 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 250, 505050264
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)11255