S RICHMOND HILL [Permits for S RICHMOND HILL]

501 - 550 of 1451

MATHEWS, KENNETH

Individual

Inactive


FORDHAM, REGINALD

Individual

Inactive


Netram, Kamy

Individual

Inactive


ORDONEZ, JORGE

Individual

Inactive


NARRACCI, SAL

Individual

Active


LU, RAYMOND

Individual

Active


RAGOONATH, MAHADEO

Individual

Active


KHAN, RASAL

Individual

Inactive


GARCIA, OSCAR H

Individual

Inactive


SINGH, ASHPREET

Individual

Inactive


MOHAMMED, SEAN

Individual

Inactive


ELIAS, JOSE R

Individual

Active


SINGH, AMANDEEP

Individual

Active


SINGH, ISHWAR

Individual

Active


MOHAMMED, KAZIM

Individual

Active


SINGH, BHUPINDER

Individual

Active


KHAN, WAZIR

Individual

Active


SINGH, SURINDERPAL

Individual

Inactive


SEENARINE, NFN

Individual

Active


COVINGTON, KEITH

Individual

Inactive


Netram, Kamy

Individual

Active


SINGH, GURMIT

Individual

Active


CASTANEDA, PERLA

Individual

Active


SINGH, JANPAL

Individual

Active


SINGH, HARPAL

Individual

Active


SINGH, AVTAR

Individual

Inactive


GAFUR, WAZIM

Individual

Active


VISHNUDAT, PARMANAND

Individual

Active


MUNOZ, HECTOR

Individual

Active


SINGH, HARNAM

Individual

Active


Taschereau, Joseph

Individual

Active


ALAQMAR SOLUTIONS INC.

Business

Active


YU FORTUNE LAUNDROMAT

Business

Inactive


SWEETY DELI & GROCERY INC

Business

Inactive


OCEAN LAWN SPRINKLERS

Business

Inactive


LEFFERTS CELLULAR, INC.

Business

Active


120 KING PRODUCE, INC

Business

Active


KAP RES INC

Business

Active


VIBE RIGHT ENTERTAINMENT CORP.

Business

Inactive


JEETA CONSTRUCTION CORP.

Business

Active


TIMES WIRELESS INC

Business

Active


A & H FARM CORP.

Business

Active


TOTO DISTRIBUTOR INC.

Business

Inactive


ID AUTO MALL

Business

Active


O.M. CONSTRUCTION CORP.

Business

Active


CROWN GOLD EXCHANGE

Business

Inactive


85 Collision Concepts Inc

Business

Active


DYNAMIC ADIV SETHI CORP

Business

Active


FIXJOINT INC

Business

Active


PARK GREEN CONSTRUCTION INC

Business

Active


(default) 2 queries took 374 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 ( '(+S +RICHMOND +HILL)' IN BOOLEAN MODE) LIMIT 500, 505050121
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+S +RICHMOND +HILL)' IN BOOLEAN MODE)11253