
TEL: 201-933-4300
FAX: 201-933-4339
Email: [email protected]
We are open Monday through Saturday from 8:30am-5:00pm. An appointment is recommended.
S&H Rugs
40 Universal Place, Carlstadt, NJ 07072
We have kept customer satisfaction as its number one priority. We specialize in one-of-a-kind precious hand knotted and hand woven Oriental rugs, imported from Persia, Pakistan, China and India. We cater to the dealer and interior design industry as well as various auction houses and department stores.
Copyright © 1990-2026 S&H Rugs, Inc. All rights reserved.
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `Domain`.`id` FROM `1800getarug`.`domains` AS `Domain` WHERE `Domain`.`title` = 'shrugs.com' LIMIT 1 | 1 | 1 | 0 | |
| 2 | SELECT `Dimension`.`id`, `Dimension`.`title`, `Dimension`.`type`, `Dimension`.`parent_id`, `Dimension`.`slug`, `Dimension`.`term`, CONVERT(SUBSTRING_INDEX(LOWER(`Dimension`.`title`),'x',1),UNSIGNED INTEGER) as fr, CONVERT(SUBSTRING_INDEX(LOWER(`Dimension`.`title`),'x',-1),UNSIGNED INTEGER) as sr FROM `1800getarug`.`dimensions` AS `Dimension` WHERE `Dimension`.`status` = 1 AND `Dimension`.`parent_id` = 20 ORDER BY `fr` asc, `sr` asc | 126 | 126 | 1 | |
| 3 | SELECT `Sptconfig`.`id`, `Sptconfig`.`title`, `Sptconfig`.`value`, `Sptconfig`.`slug`, `Sptconfig`.`type` FROM `1800getarug`.`sptconfigs` AS `Sptconfig` WHERE 1 = 1 | 20 | 20 | 0 | |
| 4 | SELECT `Recentsoldconfig`.`id`, `Recentsoldconfig`.`title`, `Recentsoldconfig`.`value`, `Recentsoldconfig`.`slug` FROM `1800getarug`.`recentsoldconfigs` AS `Recentsoldconfig` WHERE 1 = 1 | 1 | 1 | 0 | |
| 5 | SELECT `Color`.`id`, `Color`.`title`, `Color`.`slug` FROM `1800getarug`.`colors` AS `Color` WHERE `Color`.`status` = 1 ORDER BY `title` asc | 15 | 15 | 0 | |
| 6 | SELECT `Dimension`.`id`, `Dimension`.`title`, `Dimension`.`type`, `Dimension`.`slug` FROM `1800getarug`.`dimensions` AS `Dimension` WHERE `Dimension`.`status` = 1 AND `parent_id` = 0 ORDER BY `sort` asc | 57 | 57 | 1 | |
| 7 | SELECT `Dimension`.`id`, `Dimension`.`title`, `Dimension`.`type`, `Dimension`.`slug`, `Dimension`.`parent_id` FROM `1800getarug`.`dimensions` AS `Dimension` WHERE `Dimension`.`status` = 1 AND `parent_id` = 0 AND `is_large_runner` = 0 ORDER BY FIELD(type, "1", "3", "2", "4") ASC, `sort` asc | 40 | 40 | 1 | |
| 8 | SELECT `Dimension`.`id`, `Dimension`.`title`, `Dimension`.`type`, `Dimension`.`slug`, `Dimension`.`parent_id`, CONVERT(SUBSTRING_INDEX(LOWER(`Dimension`.`title`),'x',1),UNSIGNED INTEGER) as fr, CONVERT(SUBSTRING_INDEX(LOWER(`Dimension`.`title`),'x',-1),UNSIGNED INTEGER) as sr FROM `1800getarug`.`dimensions` AS `Dimension` WHERE `Dimension`.`status` = 1 ORDER BY FIELD(type, "1", "3", "2", "4") ASC, `fr` asc, `sr` asc | 183 | 183 | 1 | |
| 9 | SELECT `Category`.`id`, `Category`.`title`, `Category`.`image`, `Category`.`term` FROM `1800getarug`.`categories` AS `Category` WHERE `Category`.`status` = 1 AND `id` != 88 ORDER BY `title` asc | 20 | 20 | 0 | |
| 10 | SELECT `Dimension`.`id`, `Dimension`.`title`, `Dimension`.`type`, `Dimension`.`slug`, `Dimension`.`term`, `Dimension`.`parent_id` FROM `1800getarug`.`dimensions` AS `Dimension` WHERE `Dimension`.`status` = 1 AND `parent_id` = 0 AND `is_large_runner` = 0 AND `type` = 3 ORDER BY `sort` desc LIMIT 1 | 1 | 1 | 0 | |
| 11 | SELECT `Dimension`.`id`, `Dimension`.`title`, `Dimension`.`type`, `Dimension`.`slug`, `Dimension`.`term`, `Dimension`.`parent_id` FROM `1800getarug`.`dimensions` AS `Dimension` WHERE `Dimension`.`status` = 1 AND `parent_id` = 0 AND `is_large_runner` = 1 ORDER BY `slug` asc | 17 | 17 | 0 | |
| 12 | SELECT `Product`.`id`, `Product`.`product_name`, `Product`.`slug`, `Product`.`shrugs_product_name`, `Product`.`shrugs_slug`, `Product`.`new_image_name`, `Product`.`category_image_name`, `Product`.`product_new_sku`, `Product`.`product_qty`, `Product`.`created`, `Product`.`modified`, `Product`.`sold_date`, `Product`.`product_weight`, `Product`.`product_description`, `Product`.`product_description_new`, `Product`.`product_rugfoundation`, `Product`.`product_rugpile`, `Product`.`product_rugfield_color`, `Product`.`exact_field_color`, `Product`.`product_rugborder_color`, `Product`.`product_sku`, `Product`.`product_publish_to`, `Product`.`product_unit`, `Product`.`product_flat_ship`, `Product`.`product_free_ship`, `Product`.`free_ship_status`, `Product`.`product_measurement_unit`, `Product`.`status`, `Product`.`sold_status`, `Product`.`is_featured`, `Product`.`add_to_homepage`, `Product`.`add_to_homepage_shrugs`, `Product`.`1800_program_rug_page1`, `Product`.`1800_program_rug_page2`, `Product`.`1800_program_rug_page3`, `Product`.`1800_program_rug_page4`, `Product`.`shrugs_program_rug_page1`, `Product`.`shrugs_program_rug_page2`, `Product`.`shrugs_program_rug_page3`, `Product`.`shrugs_program_rug_page4`, `Product`.`product_ordered`, `Product`.`product_discount_type`, `Product`.`product_cat`, `Product`.`metatags`, `Product`.`meta_keywords`, `Product`.`product_viewed`, `Product`.`product_dimension`, `Product`.`product_secondary_dimension`, `Product`.`product_sub_dimension`, `Product`.`dimension_1feet`, `Product`.`dimension_1inch`, `Product`.`dimension_2feet`, `Product`.`dimension_2inch`, `Product`.`other_color`, `Product`.`amazon_title`, `Product`.`amazon_sku`, `Product`.`ebay_style`, `Product`.`group_by_title`, `Product`.`ebay_title_old`, `Product`.`ebay_title`, `Product`.`ebay_brand`, `Product`.`ebay_room`, `Product`.`ebay_room_other`, `Product`.`ebay_pattern`, `Product`.`ebay_pattern_other`, `Product`.`ebay_regional_design`, `Product`.`ebay_regional_design_other`, `Product`.`ebay_country`, `Product`.`type`, `Product`.`ebay_description`, `Product`.`make_offer`, `Product`.`ship_international`, `Product`.`piece_price`, `Product`.`cost_per_square_feet`, `Product`.`price`, `Product`.`msrp`, `Product`.`pad_cost`, `Product`.`pad_price`, `Product`.`product_primary_cat`, `Product`.`age`, `Product`.`condition`, `Product`.`product_age_other`, `Product`.`total_sq_fet`, `Product`.`width_cm`, `Product`.`length_cm`, `Product`.`publish_to_ebay`, `Product`.`ebay_publish_status`, `Product`.`publish_to_amazon`, `Product`.`created_by`, `Product`.`updated_by`, `Product`.`vendor`, `Product`.`is_consignment`, `Product`.`origin`, `Product`.`location`, `Product`.`UUID`, `Product`.`sold_to`, `Product`.`consignee`, `Product`.`consignee_date`, `Product`.`dealer_compny_name`, `Product`.`seller`, `Product`.`cost_square_feet`, `Product`.`cost_per_price`, `Product`.`ebay_id`, `Product`.`deal_of_day`, `Product`.`is_ended`, `Product`.`overstock_price`, `Product`.`overstock_size`, `Product`.`overstock_style`, `Product`.`overstock_material`, `Product`.`overstock_pattern`, `Product`.`overstock_weavetype`, `Product`.`overstock_productfeatures`, `Product`.`overstock_rugtype`, `Product`.`overstock_rugbyroom`, `Product`.`overstock_color`, `Product`.`overstock_shape`, `Product`.`overstock_othersizes`, `Product`.`overstock_exactcolor`, `Product`.`overstock_origin`, `Product`.`overstock_productdimension`, `Product`.`overstock_shippingcost`, `Product`.`overstock_pileheight`, `Product`.`overstock_producttype`, `Product`.`overstock_pd_summary`, `Product`.`overstock_pd_features1`, `Product`.`overstock_pd_features2`, `Product`.`overstock_pd_material`, `Product`.`overstock_pd_latex`, `Product`.`overstock_pd_pileheight`, `Product`.`overstock_pd_style`, `Product`.`overstock_pd_primarycolor`, `Product`.`overstock_pd_secondarycolor`, `Product`.`overstock_pd_pattern`, `Product`.`overstock_productname`, `Product`.`overstock_textpileheight`, `Product`.`group_name`, `Product`.`return_shipping_paid_by`, `Product`.`shipping_method`, `Product`.`is_special_offer`, `Product`.`published_date`, `Product`.`ebay_international_shipping`, `Product`.`top_down_image`, `Product`.`futurearrivals`, `Product`.`search_title` FROM `1800getarug`.`products` AS `Product` WHERE `Product`.`id` = 958344 LIMIT 1 | 1 | 1 | 1 |