SPRINGFIELD GARDENS [Permits for SPRINGFIELD GARDENS]

1 - 50 of 145

BROWNELL, LOCKSLEY S

Individual

Active


PIERRE, JOSUE

Individual

Inactive


JONES, BRIGITTE

Individual

Inactive


JEAN-PIERRE, ANTOINE

Individual

Active


LASHLEY, COREY

Individual

Inactive


YANG HING LAUNDROMAT INC

Business

Inactive


SPRINGFIELD LAUNDROMAT INC.

Business

Inactive


6 MEN ENTERPRISE INC

Business

Inactive


WASH AND FOLD SUPER LAUNDRY

Business

Inactive


ROLDAN, DOMINGO

Individual

Inactive


WIRELESS 1 OF NY INC.

Business

Inactive


WIRELESS 1 OF SPRINGFIELD

Business

Inactive


JACKMAN, TERRYANNE

Individual

Active


T-Mobile

Business

Active



ADEOLA, MABIFA

Individual

Active


NELSON'S AUTO SALVAGE, INC.

Business

Inactive


S. GARDENS DELI INC.

Business

Active


QUEENS VILLAGE TOWING INC.

Business

Inactive


SHAWN TOWING INC

Business

Active


CLIMACO AUTOBODY INC.

Business

Active


JYD TOWING LLC

Business

Inactive


WALKER, EDWARD

Individual

Active




D MACARTHUR AUTO BODY LTD

Business

Active


NELSON, CLOVIS

Individual

Inactive


LANG, ROY

Individual

Active


SAMB, ELHADJI

Individual

Active



A & A MOTORS AND TOWING, INC.

Business

Inactive


T-Mobile

Business

Active



M A C TOWING LTD

Business

Active


SEECOOMAR, ALENE

Individual

Active


Fields, Keyantha

Individual

Active


SANDY-BERAN, NATASHA

Individual

Active


Sprint

Business

Active


WILLIAMS, CAMERON K.

Individual

Inactive


Washington, Linnea

Individual

Inactive


SPANO, JOSEPH F

Individual

Active


CESAR, WILSON

Individual

Active


TOLLIVER, DEAN

Individual

Inactive


ADEKANMBI, FUNMI

Individual

Inactive


OLIVRY, RAUL

Individual

Active


RICHARDS, DAMION

Individual

Inactive


DOUGLAS, DAVID A

Individual

Active


DUNKLEY JR, JAMES E

Individual

Active


RAMJATTAN, CHRIS

Individual

Active


ONWUEGBUZIE, STANLEY

Individual

Inactive


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