LAURELTON [Permits for LAURELTON]

1 - 50 of 145

JJ&C SUPERMARKET CORP.

Business

Inactive


Jeannot, Dieufort

Individual

Active


MERRICK LAUNDROMAT, LLC

Business

Inactive


FENTY, WALTER D

Individual

Inactive


DAISY FRESH DRIVE IN CLEANER

Business

Inactive


PURR-FECT CLEANERS, INC.

Business

Inactive


ADAMS, VERONICA

Individual

Active


ADAMS, JOSEPH

Individual

Inactive


FRANKLIN, OMAR

Individual

Active


LAURELTON LAUNDROMAT

Business

Inactive


SMITH, RICHARD A

Individual

Active


DEBOSE, JARIAN

Individual

Active


STEPHENS, DERRICK

Individual

Inactive


THOMAS, ROLANDO

Individual

Active


DIXON, ERIC R

Individual

Active


3 HANDS DELI & GRILL CORP

Business

Active


FAMILY DOLLAR #7029

Business

Inactive




TOWNSLEY, REUBEN

Individual

Inactive


G&S DYNAMICS, CORP.

Business

Active


THOMAS, COLLIN S

Individual

Inactive


WALGREENS STORE #05051

Business

Active


SAMARIA, ALBERT

Individual

Active


Morgan, Timothy

Individual

Active



GANSA TIRE SHOP INC

Business

Active


COTHIA, SYLVIA

Individual

Active


ALL CITY FENCE INC

Business

Active


SABRINA COMMUNICATIONS INC.

Business

Active


THOMAS, AINSWORTH

Individual

Inactive


PORTER, EARL W

Individual

Inactive


BALCOMBE, HUGH

Individual

Inactive


STEWART, MICHAEL

Individual

Active


WARREN, ALLAN K

Individual

Active


JEFFRIES, FREDERICA E

Individual

Active


SAMARIA, ALBERT

Individual

Active


FELDER, JACK

Individual

Inactive


BETTON, PHILLIP

Individual

Active


WARREN, GREGORY

Individual

Inactive


HOLLAND, KHARY

Individual

Inactive


THOMAS, COLLIN S

Individual

Active


TWITTY, THEOPHLISE

Individual

Inactive


CAMPBELL, RICARDO T

Individual

Active


HARRIPERSAD, NAMDEO

Individual

Active


WHITE, KEITH

Individual

Inactive


BETHEA, ANTHONY

Individual

Active


HICKMON, SHAUN

Individual

Inactive


AMBERS, EDWIN

Individual

Active


SAUNDERS, LEACROFT

Individual

Active


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