)
View Larger Image
Over 200,000 Towbars, Towbar Accessories, Brake Systems, Carriers & Bike Racks sold!
My Shopping Cart
Acclaim Tow Bar, Class III
(1x) $428.95
Towing Accessories Kit, MH Mount Tow Bar
(1x) $168.95
Immobilizer III for 2 Inch Receiver Hitch
(1x) $27.95
My Vehicle
Tow Bars
Tow Bar Accessories
Carriers
Rock Guards
General Towing
Dealer Information
Blue Ox Diamond Goosenecks
| Your Price: | $282.95 - $282.95 |
| List Price: |
Blue Ox Diamond Goosenecks are vehicle specific. To find the correct product please choose your vehicle below.
 |
 |
Why Shop With Us?
98% Of All Orders Ship Within 24 Hours!
Towing Experts
We have over 30+ years experience in the towing industry! We are the experts! Towing Experts...
Lifetime Guarantee
We are the only tow bar company online that offers you a Lifetime Guarantee on all of the products that we offer. Lifetime Tow Bar Guarantee...
Secure Shopping
This site is tested and certified daily to pass the HACKER SAFE Security Scan.
110% Price Protection
Find the exact same product bought from us for a lower price on another web site, we will refund you 110% of the difference between the lower price and our price. 110% Price Protection...
Easy Returns
If you need to exchange a product that you ordered from us please contact us via our telephone number to work out the exchange - without any hassles or headaches. Easy Returns...
Knowledgeable Support
Call 817-488-1526 for expert advice on everything we offer.
Customer Service Hours
M - F: 8am to 5pm (CST)
 |
 |
 |
 |
 |
 |
 |
 |
Array
(
[0] => Array
(
[total_queries] => 52
[total_query_time] => 0.023412
[1] => Array
(
[query] => SHOW TABLES FROM `figaro_ecommerce`;
[result] => Resource id #18
[query_time] => 0.002521
[error] =>
[rows] => 80
[fields] => 1
[insert_id] =>
)
[2] => Array
(
[query] => select sql_no_cache token from figaro_users where id = 2615469
[result] => Resource id #29
[query_time] => 0.000601
[error] =>
[rows] => 1
[fields] => 1
[insert_id] =>
)
[3] => Array
(
[query] => DESCRIBE `figaro_users` `token`
[result] => Resource id #30
[query_time] => 0.001533
[error] =>
[rows] => 1
[fields] => 6
[insert_id] =>
)
[4] => Array
(
[query] => DESCRIBE `figaro_users` `updated`
[result] => Resource id #31
[query_time] => 0.001508
[error] =>
[rows] => 1
[fields] => 6
[insert_id] =>
)
[5] => Array
(
[query] => UPDATE `figaro_users` SET `token` = '7d13f77b2bdbe0e9cfc0eba6eaba375d',`updated` = '1284031567' WHERE id = 2615469
[result] => 1
[query_time] => 0.00267
[error] =>
[rows] => 1
[fields] =>
[insert_id] =>
)
[6] => Array
(
[query] => SELECT `iq_user_vehicles`.`vehicle_id` FROM `iq_user_vehicles` WHERE user_id = 2615469
[result] => Resource id #32
[query_time] => 0.000222
[error] =>
[rows] => 0
[fields] => 1
[insert_id] =>
)
[7] => Array
(
[query] => SELECT `figaro_group_products`.`product_id` FROM `figaro_group_products` WHERE group_id = 951
[result] => Resource id #33
[query_time] => 0.000258
[error] =>
[rows] => 12
[fields] => 1
[insert_id] =>
)
[8] => Array
(
[query] => SELECT DISTINCT `iq_vehicles`.`year` FROM `iq_vehicles` WHERE 1 = 1 ORDER BY year DESC
[result] => Resource id #35
[query_time] => 0.00064
[error] =>
[rows] => 77
[fields] => 1
[insert_id] =>
)
[9] => Array
(
[query] => SELECT `figaro_product_prices`.`list_price`, `figaro_product_prices`.`your_price` FROM `figaro_product_prices` WHERE product_id IN (17949,17950,17951,17952,17953,17954,17955,17956,17957,17987,17988,17989) AND store_id = 6
[result] => Resource id #37
[query_time] => 0.000327
[error] =>
[rows] => 12
[fields] => 2
[insert_id] =>
)
[10] => Array
(
[query] => SELECT `figaro_products`.`id`, `figaro_products`.`product_type_id`, `figaro_products`.`partnumber`, `figaro_products`.`name`, `figaro_products`.`description`, `figaro_products`.`created`, `figaro_products`.`updated` FROM `figaro_products` WHERE id = 17949
[result] => Resource id #38
[query_time] => 0.000255
[error] =>
[rows] => 1
[fields] => 7
[insert_id] =>
)
[11] => Array
(
[query] => SELECT `figaro_product_brands`.`brand_id` FROM `figaro_product_brands` WHERE product_id = 17949
[result] => Resource id #39
[query_time] => 0.000206
[error] =>
[rows] => 0
[fields] => 1
[insert_id] =>
)
[12] => Array
(
[query] => SELECT `figaro_product_types`.`id`, `figaro_product_types`.`name` FROM `figaro_product_types` WHERE id = 269
[result] => Resource id #40
[query_time] => 0.00021
[error] =>
[rows] => 1
[fields] => 2
[insert_id] =>
)
[13] => Array
(
[query] => SELECT `figaro_product_weights`.`package_number`, `figaro_product_weights`.`weight` FROM `figaro_product_weights` WHERE product_id = 17949
[result] => Resource id #41
[query_time] => 0.000217
[error] =>
[rows] => 1
[fields] => 2
[insert_id] =>
)
[14] => Array
(
[query] => select figaro_brands.id, figaro_brands.name from figaro_product_brands join figaro_brands on figaro_brands.id = figaro_product_brands.brand_id where figaro_product_brands.product_id = 17949
[result] => Resource id #42
[query_time] => 0.000196
[error] =>
[rows] => 0
[fields] => 2
[insert_id] =>
)
[15] => Array
(
[query] => SELECT `figaro_product_images`.`id`, `figaro_product_images`.`product_id`, `figaro_product_images`.`image`, `figaro_product_images`.`primary_image` FROM `figaro_product_images` WHERE product_id = 17949
[result] => Resource id #43
[query_time] => 0.000255
[error] =>
[rows] => 1
[fields] => 4
[insert_id] =>
)
[16] => Array
(
[query] => SELECT `figaro_product_prices`.`list_price`, `figaro_product_prices`.`your_price`, `figaro_product_prices`.`bundle_savings` FROM `figaro_product_prices` WHERE product_id = 17949 AND store_id = 6
[result] => Resource id #44
[query_time] => 0.000253
[error] =>
[rows] => 1
[fields] => 3
[insert_id] =>
)
[17] => Array
(
[query] => SELECT `figaro_products`.`product_type_id` FROM `figaro_products` WHERE id = 17949
[result] => Resource id #45
[query_time] => 0.000217
[error] =>
[rows] => 1
[fields] => 1
[insert_id] =>
)
[18] => Array
(
[query] => SELECT `figaro_product_type_specifications`.`id`, `figaro_product_type_specifications`.`product_type_id`, `figaro_product_type_specifications`.`rank`, `figaro_product_type_specifications`.`name`, `figaro_product_type_specifications`.`default_value`, `figaro_product_type_specifications`.`snapshot` FROM `figaro_product_type_specifications` WHERE product_type_id = 269 ORDER BY rank ASC
[result] => Resource id #46
[query_time] => 0.000266
[error] =>
[rows] => 0
[fields] => 6
[insert_id] =>
)
[19] => Array
(
[query] => SELECT `figaro_product_specifications`.`id`, `figaro_product_specifications`.`product_id`, `figaro_product_specifications`.`product_type_specification_id`, `figaro_product_specifications`.`value`, `figaro_product_specifications`.`created`, `figaro_product_specifications`.`updated` FROM `figaro_product_specifications` WHERE product_id = 17949
[result] => Resource id #47
[query_time] => 0.00026
[error] =>
[rows] => 0
[fields] => 6
[insert_id] =>
)
[20] => Array
(
[query] => SELECT `figaro_product_type_features`.`id`, `figaro_product_type_features`.`product_type_id`, `figaro_product_type_features`.`rank`, `figaro_product_type_features`.`feature`, `figaro_product_type_features`.`snapshot`, `figaro_product_type_features`.`created`, `figaro_product_type_features`.`updated` FROM `figaro_product_type_features` WHERE product_type_id = 269 ORDER BY rank ASC
[result] => Resource id #48
[query_time] => 0.000253
[error] =>
[rows] => 0
[fields] => 7
[insert_id] =>
)
[21] => Array
(
[query] => SELECT `figaro_product_features`.`id`, `figaro_product_features`.`product_id`, `figaro_product_features`.`rank`, `figaro_product_features`.`feature`, `figaro_product_features`.`created`, `figaro_product_features`.`updated` FROM `figaro_product_features` WHERE product_id = 17949 ORDER BY rank ASC
[result] => Resource id #49
[query_time] => 0.000258
[error] =>
[rows] => 0
[fields] => 6
[insert_id] =>
)
[22] => Array
(
[query] => SELECT `figaro_product_type_included`.`id`, `figaro_product_type_included`.`product_type_id`, `figaro_product_type_included`.`rank`, `figaro_product_type_included`.`value`, `figaro_product_type_included`.`created`, `figaro_product_type_included`.`updated` FROM `figaro_product_type_included` WHERE product_type_id = 269 ORDER BY rank ASC
[result] => Resource id #50
[query_time] => 0.00025
[error] =>
[rows] => 0
[fields] => 6
[insert_id] =>
)
[23] => Array
(
[query] => SELECT `figaro_product_included`.`id`, `figaro_product_included`.`product_id`, `figaro_product_included`.`rank`, `figaro_product_included`.`value`, `figaro_product_included`.`created`, `figaro_product_included`.`updated` FROM `figaro_product_included` WHERE product_id = 17949 ORDER BY rank ASC
[result] => Resource id #51
[query_time] => 0.00025
[error] =>
[rows] => 0
[fields] => 6
[insert_id] =>
)
[24] => Array
(
[query] => SELECT `figaro_product_type_not_included`.`id`, `figaro_product_type_not_included`.`product_type_id`, `figaro_product_type_not_included`.`rank`, `figaro_product_type_not_included`.`value`, `figaro_product_type_not_included`.`created`, `figaro_product_type_not_included`.`updated` FROM `figaro_product_type_not_included` WHERE product_type_id = 269 ORDER BY rank ASC
[result] => Resource id #52
[query_time] => 0.000253
[error] =>
[rows] => 0
[fields] => 6
[insert_id] =>
)
[25] => Array
(
[query] => SELECT `figaro_product_not_included`.`id`, `figaro_product_not_included`.`product_id`, `figaro_product_not_included`.`rank`, `figaro_product_not_included`.`value`, `figaro_product_not_included`.`created`, `figaro_product_not_included`.`updated` FROM `figaro_product_not_included` WHERE product_id = 17949 ORDER BY rank ASC
[result] => Resource id #53
[query_time] => 0.000238
[error] =>
[rows] => 0
[fields] => 6
[insert_id] =>
)
[26] => Array
(
[query] => SELECT `figaro_product_footnotes`.`id`, `figaro_product_footnotes`.`product_id`, `figaro_product_footnotes`.`rank`, `figaro_product_footnotes`.`footnote`, `figaro_product_footnotes`.`created`, `figaro_product_footnotes`.`updated` FROM `figaro_product_footnotes` WHERE product_id = 17949 ORDER BY rank ASC
[result] => Resource id #54
[query_time] => 0.000228
[error] =>
[rows] => 0
[fields] => 6
[insert_id] =>
)
[27] => Array
(
[query] => select sql_no_cache user_id, product_id, quantity, bundle_id from figaro_user_carts where user_id = 2615469 order by id
[result] => Resource id #60
[query_time] => 0.002098
[error] =>
[rows] => 3
[fields] => 4
[insert_id] =>
)
[28] => Array
(
[query] => SELECT `figaro_product_prices`.`product_id`, `figaro_product_prices`.`list_price`, `figaro_product_prices`.`your_price`, `figaro_product_prices`.`bundle_savings` FROM `figaro_product_prices` WHERE product_id IN (5977,6835,6814) AND store_id = 6
[result] => Resource id #61
[query_time] => 0.000269
[error] =>
[rows] => 3
[fields] => 4
[insert_id] =>
)
[29] => Array
(
[query] => select sql_no_cache * from figaro_orders_live where user_id = 2615469
[result] => Resource id #62
[query_time] => 0.001099
[error] =>
[rows] => 0
[fields] => 46
[insert_id] =>
)
[30] => Array
(
[query] => select sql_no_cache promo_id from figaro_user_promos where user_id = 2615469
[result] => Resource id #63
[query_time] => 0.000336
[error] =>
[rows] => 0
[fields] => 1
[insert_id] =>
)
[31] => Array
(
[query] => SELECT `figaro_products`.`id`, `figaro_products`.`product_type_id`, `figaro_products`.`partnumber`, `figaro_products`.`name`, `figaro_products`.`description`, `figaro_products`.`created`, `figaro_products`.`updated` FROM `figaro_products` WHERE id = 5977
[result] => Resource id #64
[query_time] => 0.000293
[error] =>
[rows] => 1
[fields] => 7
[insert_id] =>
)
[32] => Array
(
[query] => SELECT `figaro_product_brands`.`brand_id` FROM `figaro_product_brands` WHERE product_id = 5977
[result] => Resource id #65
[query_time] => 0.000225
[error] =>
[rows] => 1
[fields] => 1
[insert_id] =>
)
[33] => Array
(
[query] => SELECT `figaro_brand_stores_blacklist`.`brand_id` FROM `figaro_brand_stores_blacklist` WHERE store_id = 6
[result] => Resource id #66
[query_time] => 0.000308
[error] =>
[rows] => 24
[fields] => 1
[insert_id] =>
)
[34] => Array
(
[query] => SELECT `figaro_product_types`.`id`, `figaro_product_types`.`name` FROM `figaro_product_types` WHERE id = 72
[result] => Resource id #67
[query_time] => 0.00022
[error] =>
[rows] => 1
[fields] => 2
[insert_id] =>
)
[35] => Array
(
[query] => SELECT `figaro_product_weights`.`package_number`, `figaro_product_weights`.`weight` FROM `figaro_product_weights` WHERE product_id = 5977
[result] => Resource id #68
[query_time] => 0.000223
[error] =>
[rows] => 1
[fields] => 2
[insert_id] =>
)
[36] => Array
(
[query] => select figaro_brands.id, figaro_brands.name from figaro_product_brands join figaro_brands on figaro_brands.id = figaro_product_brands.brand_id where figaro_product_brands.product_id = 5977
[result] => Resource id #69
[query_time] => 0.000205
[error] =>
[rows] => 1
[fields] => 2
[insert_id] =>
)
[37] => Array
(
[query] => SELECT `figaro_product_images`.`id`, `figaro_product_images`.`product_id`, `figaro_product_images`.`image`, `figaro_product_images`.`primary_image` FROM `figaro_product_images` WHERE product_id = 5977
[result] => Resource id #70
[query_time] => 0.000245
[error] =>
[rows] => 1
[fields] => 4
[insert_id] =>
)
[38] => Array
(
[query] => SELECT `figaro_product_prices`.`list_price`, `figaro_product_prices`.`your_price`, `figaro_product_prices`.`bundle_savings` FROM `figaro_product_prices` WHERE product_id = 5977 AND store_id = 6
[result] => Resource id #71
[query_time] => 0.000226
[error] =>
[rows] => 1
[fields] => 3
[insert_id] =>
)
[39] => Array
(
[query] => SELECT `figaro_products`.`id`, `figaro_products`.`product_type_id`, `figaro_products`.`partnumber`, `figaro_products`.`name`, `figaro_products`.`description`, `figaro_products`.`created`, `figaro_products`.`updated` FROM `figaro_products` WHERE id = 6835
[result] => Resource id #72
[query_time] => 0.000277
[error] =>
[rows] => 1
[fields] => 7
[insert_id] =>
)
[40] => Array
(
[query] => SELECT `figaro_product_brands`.`brand_id` FROM `figaro_product_brands` WHERE product_id = 6835
[result] => Resource id #73
[query_time] => 0.000228
[error] =>
[rows] => 1
[fields] => 1
[insert_id] =>
)
[41] => Array
(
[query] => SELECT `figaro_product_types`.`id`, `figaro_product_types`.`name` FROM `figaro_product_types` WHERE id = 77
[result] => Resource id #74
[query_time] => 0.000244
[error] =>
[rows] => 1
[fields] => 2
[insert_id] =>
)
[42] => Array
(
[query] => SELECT `figaro_product_weights`.`package_number`, `figaro_product_weights`.`weight` FROM `figaro_product_weights` WHERE product_id = 6835
[result] => Resource id #75
[query_time] => 0.00022
[error] =>
[rows] => 1
[fields] => 2
[insert_id] =>
)
[43] => Array
(
[query] => select figaro_brands.id, figaro_brands.name from figaro_product_brands join figaro_brands on figaro_brands.id = figaro_product_brands.brand_id where figaro_product_brands.product_id = 6835
[result] => Resource id #76
[query_time] => 0.000203
[error] =>
[rows] => 1
[fields] => 2
[insert_id] =>
)
[44] => Array
(
[query] => SELECT `figaro_product_images`.`id`, `figaro_product_images`.`product_id`, `figaro_product_images`.`image`, `figaro_product_images`.`primary_image` FROM `figaro_product_images` WHERE product_id = 6835
[result] => Resource id #77
[query_time] => 0.000234
[error] =>
[rows] => 1
[fields] => 4
[insert_id] =>
)
[45] => Array
(
[query] => SELECT `figaro_product_prices`.`list_price`, `figaro_product_prices`.`your_price`, `figaro_product_prices`.`bundle_savings` FROM `figaro_product_prices` WHERE product_id = 6835 AND store_id = 6
[result] => Resource id #78
[query_time] => 0.000226
[error] =>
[rows] => 1
[fields] => 3
[insert_id] =>
)
[46] => Array
(
[query] => SELECT `figaro_products`.`id`, `figaro_products`.`product_type_id`, `figaro_products`.`partnumber`, `figaro_products`.`name`, `figaro_products`.`description`, `figaro_products`.`created`, `figaro_products`.`updated` FROM `figaro_products` WHERE id = 6814
[result] => Resource id #79
[query_time] => 0.000279
[error] =>
[rows] => 1
[fields] => 7
[insert_id] =>
)
[47] => Array
(
[query] => SELECT `figaro_product_brands`.`brand_id` FROM `figaro_product_brands` WHERE product_id = 6814
[result] => Resource id #80
[query_time] => 0.000229
[error] =>
[rows] => 1
[fields] => 1
[insert_id] =>
)
[48] => Array
(
[query] => SELECT `figaro_product_types`.`id`, `figaro_product_types`.`name` FROM `figaro_product_types` WHERE id = 75
[result] => Resource id #81
[query_time] => 0.000229
[error] =>
[rows] => 1
[fields] => 2
[insert_id] =>
)
[49] => Array
(
[query] => SELECT `figaro_product_weights`.`package_number`, `figaro_product_weights`.`weight` FROM `figaro_product_weights` WHERE product_id = 6814
[result] => Resource id #82
[query_time] => 0.000233
[error] =>
[rows] => 1
[fields] => 2
[insert_id] =>
)
[50] => Array
(
[query] => select figaro_brands.id, figaro_brands.name from figaro_product_brands join figaro_brands on figaro_brands.id = figaro_product_brands.brand_id where figaro_product_brands.product_id = 6814
[result] => Resource id #83
[query_time] => 0.000221
[error] =>
[rows] => 1
[fields] => 2
[insert_id] =>
)
[51] => Array
(
[query] => SELECT `figaro_product_images`.`id`, `figaro_product_images`.`product_id`, `figaro_product_images`.`image`, `figaro_product_images`.`primary_image` FROM `figaro_product_images` WHERE product_id = 6814
[result] => Resource id #84
[query_time] => 0.000242
[error] =>
[rows] => 1
[fields] => 4
[insert_id] =>
)
[52] => Array
(
[query] => SELECT `figaro_product_prices`.`list_price`, `figaro_product_prices`.`your_price`, `figaro_product_prices`.`bundle_savings` FROM `figaro_product_prices` WHERE product_id = 6814 AND store_id = 6
[result] => Resource id #85
[query_time] => 0.000255
[error] =>
[rows] => 1
[fields] => 3
[insert_id] =>
)
)
)