Login
Register

ROYAL COLLECTION

C-97 (A), M.I.A, BASNI 2ND PHASE, JODHPUR, RAJASTHAN 342005 GSTIN UIN 08AAZFR8226J1ZB

Summary Information

There are a total of 106 bills of lading on file for Royal Collection between May 26th, 2019 and September 4th, 2024.

Of those 106 bills of lading, 2 were within the past 30 days and 6 were within the past 90 days.

Total Records106
Shipper Records105
Consignee Records1
Notify Party Records1
First Shipment on FileMay 26th, 2019
Most Recent Shipment on FileSep 4th, 2024
Records in Last 30 Days2
Records in Last 90 Days6
Records in the Past Year25

Bills of Lading by Month for Royal Collection

Register Now for Comprehensive Access

Subscribe now for unlimited access to all manifests, vessels, shippers, consignees, and more for ROYAL COLLECTION.

Create Your Account Today

Sankey Diagram of Associated Companies

Below is a Sankey Diagram of the top 18 companies associated with Royal Collection, and the top 4 companies associated with those associations.

Associated Companies

Below are the top 18 companies associated with Royal Collection in terms of total bills of lading. Total Records are based on data obtained since March 1st, 2019.

Company Name Recent Shipment Total Records Associations
FOUR HANDS LLCJun 20243,01623
WALTER E SMITHESep 202434622
MERCANA FURNITURE & DECOR LTDSep 20241,11115
MOE'S HOME COLLECTION INC.Sep 20244,22311
SUNPAN TRADING & IMPORTING INCSep 20241,8739
VANGUARD FURNITURE COMPANY INC.Sep 20246284
SONDER USA INCJun 20244403
SAGEBROOK HOME LLCSep 20241,7653
CURREY & COSep 20241,1333
ME SALVE INC.Sep 20241,6682
WALTER E.SMITHE-ITASCA WHSEAug 2024201
May 202411
VASU IMPORTS INCSep 20242201
SOCIETY OF LIFESTYLE US INCNov 20233281
QINGDAO BESTYDECOR CO.,LTDSep 2024291
Sep 2024101
LIVING SPACES FURNITURE LLCSep 202463,6771
HD BUTTERCUPDec 20223731

Other Companies Listed Alphabetically

Below are other companies when arranged alphabetically. There is not neccessarily any association to Royal Collection.

Company Name Recent Shipment Total Records Past 90 Days
ROYAL CARGO MEXICO S.A. DE C.V.Aug 20201870
ROYAL CARIBBEAN CELEBRITY (LOST ANDSep 202411,206864
ROYAL CARIBBEAN CRUISE LINESSep 202448424
ROYAL CARIBBEAN CRUISES LTD.Sep 202451,6412,973
ROYAL CARIBBEAN PRODUCTIONSSep 202425813
ROYAL CASTLE LIMITEDSep 202429212
ROYAL CASTOR PRODUCTS LIMITED.Sep 202444030
ROYAL CLASSIC MILLS (P) LTDSep 20242,77124
ROYAL COFFEE INC.Sep 20246,090298
ROYAL COFFEE NEW YORK, INC.Mar 20241,4200
ROYAL CONCEPT INDUSTRIAL LIMITEDMay 20243740
ROYAL CONNEXIONS PRIVATE LIMITEDSep 202415914
ROYAL CONNEXIONS PVT LTDJun 20211180
ROYAL CONSUMER INFORMATION PRODUCTSSep 202434939
ROYAL CORINTHIAN VIETNAM CORPORATIONSep 202467060
ROYAL CRYSTAL JOINT STOCK COMPANYSep 202487780
ROYAL DE REE HOLLAND B.V.Sep 202439210
ROYAL DELUXE ACCESSORIES LLCJul 20238620
ROYAL DISTRIBUTINGSep 202410011
ROYAL DUTCH DISTILLERS INC.Jan 20242980

25 Most Recent Bills of Lading

Run Date Master BOL House BOL Voyage # Bill Type Carrier Code IMO # Vessel Name Arrival Date US Port Foreign Port Quantity Weight Type of Service Shipper Consignee Notify Party Commodity
2024-07-19ONEYDELE24405400ONEYDELE24405A01001EHouse BillONEY9305659HYUNDAI BUSAN2024-07-18SAVANNAH, GEORGIAMUNDRA INDIA50 PKG747 KGContainer YardROYAL COLLECTIONCURREY & COMPANY, INC.CURREY & COMPANY, INC.INDIAN IRON & MARBLE FURNITURE ITEMS
2024-06-29COSU63825072600PGI1Regular BillCOSU9967433MH PERSEUS2024-06-28HOUSTON, TEXASYANGSHAN CHINA (MAINLAND)103 PKG5,535 KGHouse to HouseROYAL COLLECTIONSUNPAN TRADING & IMPORTING USA INCMOHAWK GLOBAL LOGISTICS CORP.IRON TABLE WITH MARBLE TOP IRON HARDWARE KIT
2024-06-24OOLU2738399870TXSLHQD240505810TNCYHouse FROBTXSL9951549CMA CGM ENDURANCE2024-06-23SEATTLE, WASHINGTONPUSAN SOUTH KOREA144 CTN5,000 KGHouse to HouseQINGDAO BESTYDECOR CO.,LTDROYAL COLLECTIONSROYAL COLLECTIONSDECORATIVE MIRROR
2024-06-11HLCUMA32403445242421SRegular BillHLCU9203502MAIRA2024-06-08SAN JUAN, PUERTO RICOCAUCEDO DOMINICAN REPUBLIC183 PCS2,078 KHouse to HouseROYAL COLLECTIONME SALVE INC.DCR US CUSTOMS BROKERSMENS WOVEN BOXER SHORTS XXXPR 00920 CONTACT DIEGO DINZEY RODRIGUEZ 787-792-4855 787-431-7270 EMAILS DDINZEYDCRCHB.NET

Sample Bill of Lading

View Full Manifest

Relevant Dates

Run Date2024-07-31
Estimated Arrival Date2024-07-29
Actual Arrival Date2024-07-30
Trade Update Date2024-07-10

Bill of Lading Overview

Master BOL #HLCUBO12405ATRR9
House BOL #
Manifest Number000001
Bill TypeRegular Bill
Carrier CodeHLCU
Voyage #16W27
IMO #9143544
Vessel NameKOBE EXPRESS
Vessel CountryBM
Place of ReceiptMUNDRA, IN
Foreign Port of LadingVALENCIA SPAIN (47094)
Port of UnladingHOUSTON, TEXAS (5301)
Port of Destination
Foreign Port of Destination
Weight6694 K
Weight in KG6,694 KG
Quantity190 PCS
Volume
Record StatusNew Record
In-bond Entry Type
Transportation ModeVessel, containerized
Container CAAU6724091
Commodity Description INDIAN IRON,MARBLE & GLASS 190 CASES CONTANING ONE HUNDRED NINETY CASES INDIAN IRON, MARBLE & GLASS FURNITURE ITEMS

Shipper

Shipper NameROYAL COLLECTION
Address Line 1C-97 (A), M.I.A, BASNI 2ND PHASE,
Address Line 2JODHPUR, RAJASTHAN 342005
Address Line 3GSTIN/UIN 08AAZFR8226J1ZB

Consignee

Consignee NameSUNPAN TRADING & IMPORTING USA INC
Address Line 1211 E. COMMERCE AVE. HIGH POINT, NC
Address Line 227260 USA
Address Line 3TEL 1-800-787-1019,
Address Line 4EIN 61-1935373-00

Notify Parties

Notify Party NameMOHAWK GLOBAL LOGISTICS
Address Line 1220 FERNWOOD AVE. EDISON,
Address Line 2NJ 08837 UNITED STATES
Address Line 3NJIMPORTSMOHAWKGLOBAL.COM;
Address Line 4PHONE 732-603-1973 EIN16-1444116
Notify Party NameSUNPAN TRADING & IMPORTING USA INC
Address Line 1211 E. COMMERCE AVE. HIGH POINT, NC
Address Line 227260 USA TEL 1-800-787-1019,
Address Line 3EIN 61-1935373-00
Address Line 4LOGISTICSSUNPAN.COM

#1 -- Container CAAU6724091

Container NumberCAAU6724091
Seal Number 1HLG6020355
Seal Number 1HLG6020355
Equipment Description CodeCN
Equipment DescriptionContainer
Container Length40ft 0in (04000)
Container Height9ft 0in (00000900)
Container Width8ft 0in (00000800)
Container Type4510
Load StatusLoaded
Type of ServiceHouse to House
Cargo Description 1INDIAN IRON,MARBLE & GLASS 190 CASES CONTANING ONE HUNDRED NINETY CASES INDIAN IRON, MARBLE & GLASS FURNITURE ITEMS
Additional Cargo 1S.B. NO 1184108 S.B DT. 27.05.2024 IEC NO AAZFR8226J INVOICE NO RC/E/24-25/015 INVOICE DT 25.05.2024 HS CODE 940320/940389/ 830249 PO NO 200251
Additional Cargo 2NET WT 5399.60 KGS SHIP-TO ADDRESS SUNPAN TRADING & IMPORTING USA INC . (SUNPAN BAYTOWN WAREHOUSE) 2540 SOUTH FARM-TO-MARKET 565 RD, BAYTOWN, TEXAS, 77523, USA
Additional Cargo 3HELENASUNPAN.COM; SISISUNPAN.COM; TEL 416-736-0094 | 1-800-787-1019
Marks and Numbers 101 TO 190 CASES . . . . . . .
Marks and Numbers 2. . . . . . . .
Marks and Numbers 3. . . . . . . .
Marks and Numbers 4. . .

Map of Activity by Port

ROYAL COLLECTION Top US Ports

Port of Unlading Total Records Recent Shipment
Houston, Texas342024-09-05
Norfolk, Virginia182023-12-25
Seattle, Washington112024-06-24
Newark, New Jersey112024-02-10
Charleston, South Carolina82024-02-29
Tacoma, Washington82022-10-05
New York, New York42024-06-08
Savannah, Georgia32024-07-19
San Juan, Puerto Rico32024-06-11
Long Beach, California32023-09-12

ROYAL COLLECTION Top Foreign Ports

Port of Lading Total Records Recent Shipment
Mundra India682024-07-19
Valencia Spain62024-09-05
Shanghai China (Mainland)52024-05-01
Pipavav India52023-01-30
Colombo Sri Lanka42023-10-09
Singapore Singapore42022-02-22
Pusan South Korea32024-06-24
Kaohsiung China (Taiwan)22021-07-05
Yangshan China (Mainland)12024-06-29
Caucedo Dominican Republic12024-06-11

ROYAL COLLECTION Address and Name Permutations

Below are the top 10 company names and addresses for Royal Collection that were combined to create this record. While we try to make sure everything is as accurate as possible we can't guarantee complete accuracy for all records so please notify us of any errors.

Company Name Address Last Record Records
ROYAL COLLECTIONC-97, A, M.I.A, BASNI 2ND PHASE JODHPUR IN2024-06-084
ROYAL COLLECTIONC-97 (A), M.I.A, BASNI 2ND PHASE, JODHPUR, RAJASTHAN 342005 GSTIN UIN 08AAZFR8226J1ZB2024-07-314
ROYAL COLLECTION2024-02-143
ROYAL COLLECTION2024-02-292
ROYAL COLLECTION2023-09-302
ROYAL COLLECTION2024-06-292
ROYAL COLLECTION2024-09-052
ROYAL COLLECTION2024-07-191
ROYAL COLLECTION2023-09-211
ROYAL COLLECTION2024-05-211
© 2024 ImportInfo.com | All Rights Reserved
Privacy Policy | Terms of Use | F.A.Q.