PELHAM [Permits for PELHAM]

51 - 78 of 78

MERELAS, RAYMOND

Individual

Active


DODAJ HOME IMPROVEMENT

Business

Active



PELHAM FLAT FIX CORP.

Business

Active


AQUILINO, EDITH L

Individual

Active


EURO PAVERS CONTRACTOR

Business

Inactive


PELHAM GARAGE, INC.

Business

Active


231st street bingo corp

Business

Active


PELHAM GOLD BUYERS

Business

Inactive



PELHAM GARDENS CANDY CORP

Business

Active



PELHAM WIRELESS LLC

Business

Active




PELHAM WIRELESS LLC

Business

Active


WHALEN CONSTRUCTION, INC.

Business

Inactive


PELHAM FLAT FIX

Business

Inactive


PELHAM GARDEN DELI GROCERY

Business

Inactive


PELHAM WIRELESS LLC

Business

Inactive


NEW PELHAM CLEANER CORP.

Business

Active


PELHAM BAY GOLD BUYER

Business

Inactive


MAINTAIN-A-CHAIN CORP.

Business

Inactive



PELHAM FLAT FIX CORP.

Business

Inactive


PELHAM GOURMET DELI INC

Business

Active


ALB-BROS CONSTRUCTION CORP.

Business

Active


BRONXDALE HALL INC

Business

Active


(default) 2 queries took 622 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 ( '(+PELHAM)' IN BOOLEAN MODE) LIMIT 50, 502828259
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+PELHAM)' IN BOOLEAN MODE)11363