ROYAL COLLECTION

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

Summary Information

There are a total of 109 bills of lading on file for Royal Collection between May 26th, 2019 and November 7th, 2024.

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

Total Records109
Shipper Records108
Consignee Records1
Notify Party Records1
First Shipment on FileMay 26th, 2019
Most Recent Shipment on FileNov 7th, 2024
Records in Last 30 Days2
Records in Last 90 Days5
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.

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 LLCOct 20243,01723
WALTER E SMITHENov 202435422
MERCANA FURNITURE & DECOR LTDNov 20241,15015
MOE'S HOME COLLECTION INC.Nov 20244,25711
SUNPAN TRADING & IMPORTING INCNov 20241,98610
VANGUARD FURNITURE COMPANY INC.Nov 20246814
CURREY & CONov 20241,1784
SONDER USA INCJun 20244403
SAGEBROOK HOME LLCNov 20241,7733
ME SALVE INC.Nov 20241,7373
WALTER E.SMITHE-ITASCA WHSEAug 2024201
May 202411
VASU IMPORTS INCNov 20242221
SOCIETY OF LIFESTYLE US INCNov 20233281
QINGDAO BESTYDECOR CO.,LTDSep 2024291
NORCAL IMPORTSNov 2024111
LIVING SPACES FURNITURE LLCNov 202466,1241
HD BUTTERCUPDec 20223731

Other Companies Listed Alphabetically

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

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-09-05HLCUBO12406ASHC017W32Regular BillHLCU9193305SEOUL EXPRESS2024-09-04HOUSTON, TEXASVALENCIA SPAIN318 PCS9,394 KHouse to HouseROYAL COLLECTIONSUNPAN TRADING & IMPORTING USA INCMOHAWK GLOBAL LOGISTICSINDIAN IRON & MANGO WOOD CONTAINING THREE HUNDRED EIGHTEEN CASES INDIAN IRON & MARBLE FURNITURE ITEMS S.B. NO 1901344
2024-09-05HLCUBO12406ASHD017W32Regular BillHLCU9193305SEOUL EXPRESS2024-09-04HOUSTON, TEXASVALENCIA SPAIN207 PCS6,980 KHouse to HouseROYAL COLLECTIONSUNPAN TRADING & IMPORTING USA INCMOHAWK GLOBAL LOGISTICSINDIAN IRON & MARBLE 207 CASES CONTAINING TWO HUNDRED SEVEN CASES INDIAN IRON & MARBLE,GLASS FURNITURE ITEMS S.B. NO 1896736
2024-07-31HLCUBO12405ATRR916W27Regular BillHLCU9143544KOBE EXPRESS2024-07-30HOUSTON, TEXASVALENCIA SPAIN190 PCS6,694 KHouse to HouseROYAL COLLECTIONSUNPAN TRADING & IMPORTING USA INCMOHAWK GLOBAL LOGISTICSINDIAN IRON,MARBLE & GLASS 190 CASES CONTANING ONE HUNDRED NINETY CASES INDIAN IRON, MARBLE & GLASS FURNITURE ITEMS
2024-07-19ONEYDELE24405400ONEYDELE24405A01001EHouse BillONEY9305659HYUNDAI BUSAN2024-07-18SAVANNAH, GEORGIAMUNDRA INDIA50 PKG747 KGContainer YardROYAL COLLECTIONCURREY & COMPANY, INC.CURREY & COMPANY, INC.INDIAN IRON & MARBLE FURNITURE ITEMS

Sample Bill of Lading

Relevant Dates

Run Date2024-09-23
Estimated Arrival Date2024-09-24
Actual Arrival Date2024-09-21
Trade Update Date2024-08-21

Bill of Lading Overview

Master BOL #HLCUBO12407AYBY6
House BOL #
Manifest Number000001
Bill TypeRegular Bill
Carrier CodeHLCU
Voyage #5WB35
IMO #9143568
Vessel NameLONDON 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
Weight5570 K
Weight in KG5,570 KG
Quantity95 PCS
Volume
Record StatusNew Record
In-bond Entry Type
Transportation ModeVessel, containerized
Container TLLU5316868
Commodity Description FURNITURE ITEMS 95 CASES CONTAINING NINETY FIVE CASES INDIAN IRON , MARBLE FURNITURE ITEMS S.B. NO 2482803

Shipper

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

Consignee

Consignee 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

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 TLLU5316868

Container NumberTLLU5316868
Seal Number 16029016
Seal Number 16029016
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 1FURNITURE ITEMS 95 CASES CONTAINING NINETY FIVE CASES INDIAN IRON , MARBLE FURNITURE ITEMS S.B. NO 2482803
Additional Cargo 1S.B DT. 17.07.2024 IEC NO AAZFR8226J INVOICE NO RC/E/24-25/031 INVOICE DT 16.07.2024 HS CODE 940320/940389/ 830249 PO NO 203248 NET WT 4068.520 KGS
Additional Cargo 2SHIP-TO ADDRESS SUNPAN TRADING & IMPORTING USA INC. (SUNPAN BAYTOWN WAREHOUSE) 2540 SOUTH FARM-TO-MARKET 565 RD, BAYTOWN, TEXAS, 77523, USA HELENASUNPAN.COM;
Additional Cargo 3SISISUNPAN.COM; TEL 416-736-0094 1-800-787-1019
Marks and Numbers 101 TO 05, 07 TO 96 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, Texas352024-09-23
Norfolk, Virginia182023-12-25
Seattle, Washington112024-06-24
Newark, New Jersey112024-02-10
Charleston, South Carolina82024-02-29
Tacoma, Washington82022-10-05
San Juan, Puerto Rico42024-11-08
Savannah, Georgia42024-11-02
New York, New York42024-06-08
Long Beach, California32023-09-12

ROYAL COLLECTION Top Foreign Ports

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

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-09-233
ROYAL COLLECTION2024-02-292
ROYAL COLLECTION2024-11-082
ROYAL COLLECTION2024-06-292
ROYAL COLLECTION2024-11-021
ROYAL COLLECTION2024-07-191
ROYAL COLLECTION2024-05-211