CRANFORD [Permits for CRANFORD]

1 - 50 of 65

Steinberg, Mitchell

Individual

Inactive


POWERS, LELAND J

Individual

Active


Braga, Robert

Individual

Active


Mencl, Paige

Individual

Active


RENEWAL BY ANDERSEN

Business

Active


Shemesh, Jacob

Individual

Active


TUORTO, WILLIAM J

Individual

Inactive


MADSEN, REMO

Individual

Active


REILLY, JR. THOMAS P

Individual

Inactive


Johnson, Jeffrey

Individual

Active


Guilford, Duane

Individual

Inactive


Walby, Eric

Individual

Inactive


Hasnat, Abul

Individual

Active


Edelson, Greg

Individual

Active


FULLAM, FRANK

Individual

Inactive


LYSAGHT, BRENDAN

Individual

Inactive


AFM FINANCIAL SERVICES LLC

Business

Inactive


Owitz, David

Individual

Inactive


Layden, Christopher

Individual

Active


Vallaro, Anthony

Individual

Active


CHOW, ANDREW

Individual

Inactive


Reigottie, John

Individual

Active


Doyen, Richard

Individual

Inactive


Pollard, Percy

Individual

Inactive


Gibriano, Joseph

Individual

Inactive


HENGERER, DAVID D

Individual

Active


DeBruyn, Charles

Individual

Active


FitzGerald, Dennis

Individual

Inactive


Genzale, Thomas

Individual

Inactive


Linares, Christopher

Individual

Active


Doyle, Kyle

Individual

Active


Abdelaziz, Helmey

Individual

Active


MADDISON, STANLEY

Individual

Active


Frigoletto, Paul

Individual

Active


Cesar, Emmanuel

Individual

Inactive


Puzia, Scott

Individual

Active


Giresi, Linda

Individual

Inactive


Tart, Larry

Individual

Active


Maloney, John

Individual

Active


FLORES, FRANCIS

Individual

Inactive


Carragher, Scott

Individual

Active


Shaw, Paul

Individual

Active


Baggio, Christopher

Individual

Active


Ramos, Marc

Individual

Active


Brown, William

Individual

Inactive


Lynn, Sean

Individual

Inactive


MONE, STEVEN

Individual

Inactive


Coppola, Margaret

Individual

Inactive


Morris, Monte

Individual

Inactive


Gay, Joseph

Individual

Inactive


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