STANTON [Permits for STANTON]

1 - 13 of 13

STANTON ST. CLEANERS INC.

Business

Inactive



ROCHE, KEVIN

Individual

Active


SARJEANT, STANTON A

Individual

Active


STANTON, RICHARD

Individual

Inactive


STANTON, JONATHAN

Individual

Inactive


STANTON RESTAURANT CORP.

Business

Inactive


STANTON, CHRISTINA R.

Individual

Active


STANTON, MICHAEL

Individual

Active



STANTON ST. CLEANERS INC.

Business

Active


NY UNDER CONSTRUCTION

Business

Inactive



(default) 1 query took 237 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 ( '(+STANTON)' IN BOOLEAN MODE) LIMIT 501313237