Trailer Hitches
Trailer Hitch Accessories
Electrical Wiring
Cargo Management
Bike Racks
Blue Ox Products
Vehicle Accessories
Trailer Accessories
Learning Center
Dealer Info
LeBra Hood Protectors
Your Price:
$45.95 - $45.95
List Price:
$64.33 - $64.33
LeBra Hood Protectors are vehicle specific. To find the correct product please choose your vehicle below.
Description
Some of the best reasons to buy a car cover are ones you might not even think about. LeBra Custom Front End Covers are designed for hundreds of different applications. They are very popular for the variety of protection it offers your vehicle. This product is unique, giving each cover an individually tailored look. Want style? Order your cover today!
Specs
Material Leather Grain Vinyl
Features
Custom designed for hundreds of applications Individually tailored it fit your vehicle Full front end protection Very durable; high quality leather grain vinyl Breathable Vinyl dries itself while you drive The LeBra design allows the hood to open without removing the cover Installs in less than 5 minutes
My Shopping Cart
My Vehicle
Why Shop With Us?
Towing Experts
We have over 30+ years experience in the towing industry! We are the experts! Towing Experts...
Lifetime Guarantee
We are the only hitch company online that offers you a Lifetime Guarantee on all of the products that we offer. Lifetime Hitch 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 toll-free telephone number to work out the exchange - without any hassles or headaches. Easy Returns...
Array
(
[0] => Array
(
[total_queries] => 21
[total_query_time] => 0.012389
[1] => Array
(
[query] => SHOW TABLES FROM `figaro_ecommerce`;
[result] => Resource id #18
[query_time] => 0.002589
[error] =>
[rows] => 80
[fields] => 1
[insert_id] =>
)
[2] => Array
(
[query] => SELECT `iq_user_vehicles`.`vehicle_id` FROM `iq_user_vehicles` WHERE user_id =
[result] =>
[query_time] => 0.000309
[error] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[rows] =>
[fields] =>
[insert_id] =>
)
[3] => Array
(
[query] => SELECT `figaro_group_products`.`product_id` FROM `figaro_group_products` WHERE group_id = 873
[result] => Resource id #29
[query_time] => 0.002413
[error] =>
[rows] => 524
[fields] => 1
[insert_id] =>
)
[4] => Array
(
[query] => SELECT DISTINCT `iq_vehicles`.`year` FROM `iq_vehicles` WHERE 1 = 1 ORDER BY year DESC
[result] => Resource id #31
[query_time] => 0.000588
[error] =>
[rows] => 77
[fields] => 1
[insert_id] =>
)
[5] => Array
(
[query] => SELECT `figaro_product_prices`.`list_price`, `figaro_product_prices`.`your_price` FROM `figaro_product_prices` WHERE product_id IN (11440,11441,11442,11443,11444,11445,11446,11447,11448,11449,11450,11451,11452,11453,11454,11455,11456,11457,11458,11459,11460,11461,11462,11463,11464,11465,11466,11467,11468,11469,11470,11471,11472,11473,11474,11475,11476,11477,11478,11479,11480,11481,11482,11483,11484,11485,11486,11487,11488,11489,11490,11491,11492,11493,11495,11496,11497,11498,11499,11500,11501,11502,11503,11504,11505,11506,11507,11508,11509,11510,11511,11512,11513,11514,11515,11517,11518,11519,11520,11521,11522,11523,11524,11525,11526,11527,11528,11529,11530,11531,11532,11533,11534,11535,11536,11537,11538,11539,11540,11541,11542,11543,11544,11545,11546,11547,11548,11549,11550,11551,11552,11553,11554,11555,11556,11557,11558,11559,11560,11561,11562,11563,11564,11565,11566,11567,11568,11569,11570,11571,11572,11573,11574,11575,11576,11577,11578,11579,11580,11581,11582,11583,11584,11585,11586,11587,11588,11589,11590,11591,11592,11593,11594,11595,11596,11597,11598,11599,11600,11601,11602,11603,11604,11605,11606,11607,11608,11609,11610,11611,11612,11613,11614,11615,11616,11617,11618,11619,11620,11621,11622,11623,11624,11625,11626,11627,11628,11629,11630,11631,11632,11633,11634,11635,11636,11637,11638,11639,11640,11641,11642,11643,11644,11645,11646,11647,11648,11649,11650,11651,11652,11653,11654,11655,11656,11657,11658,11659,11660,11661,11662,11663,11664,11665,11666,11667,11668,11669,11670,11671,11672,11673,11674,11675,11676,11677,11678,11679,11680,11681,11682,11683,11684,11685,11686,11687,11688,11689,11690,11691,11692,11693,11694,11695,11696,11697,11698,11699,11700,11701,11702,11703,11704,11705,11706,11707,11708,11709,11710,11711,11712,11713,11714,11715,11716,11717,11718,11719,11720,11721,11722,11723,11724,11725,11726,11727,11728,11729,11730,11731,11732,11733,11734,11735,11736,11737,11738,11739,11740,11741,11742,11743,11744,11745,11746,11747,11748,11749,11750,11751,11752,11753,11754,11755,11756,11757,11758,11759,11760,11761,11762,11763,11764,11765,11766,11767,11768,11769,11770,11771,11772,11773,11774,11775,11776,11777,11778,11779,11780,11781,11782,11783,11784,11785,11786,11787,11788,11789,11790,11791,11792,11793,11794,11795,11796,11797,11798,11799,11800,11801,11802,11803,11804,11805,11806,11807,11808,11809,11810,11811,11812,11813,11814,11815,11816,11817,11818,11819,11820,11821,11822,11823,11824,11825,11826,11827,11828,11829,11830,11831,11832,11833,11834,11835,11836,11837,11838,11839,11840,11841,11842,11843,11844,11845,11846,11847,11848,11849,11850,11851,11852,11853,11854,11855,11856,11857,11858,11859,11860,11861,11862,11863,11864,11865,11866,11867,11868,11869,11870,11871,11872,11873,11874,11875,11876,11877,11878,11879,11880,11881,11882,11883,11884,11885,11886,11887,11888,11889,11890,11891,11892,11893,11894,11895,11896,11897,11898,11899,11900,11901,11902,11903,11904,11905,11906,11907,11908,11909,11910,11911,11912,11913,11914,11915,11916,11917,11918,11919,11920,11921,11922,11923,11924,11925,11926,11927,11928,11929,11930,11931,11932,11933,11934,11935,11936,11937,11938,11939,11940,11941,11942,11943,11944,11945,11946,11947,11948,11949,11950,11951,11952,11953,11954,11955,11956,11957,11958,11959,11960,11961,11962,11963,11964,11965) AND store_id = 2
[result] => Resource id #32
[query_time] => 0.002564
[error] =>
[rows] => 524
[fields] => 2
[insert_id] =>
)
[6] => 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 = 11440
[result] => Resource id #33
[query_time] => 0.000325
[error] =>
[rows] => 1
[fields] => 4
[insert_id] =>
)
[7] => 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 = 11440 AND store_id = 2
[result] => Resource id #34
[query_time] => 0.000207
[error] =>
[rows] => 1
[fields] => 3
[insert_id] =>
)
[8] => Array
(
[query] => select p.id,
p.partnumber,
p.name,
pt.id AS type_id,
pt.name AS type_name,
p.description,
p.created,
p.updated,
pw.weight,
pb.id AS brand_id,
b.name AS brand_name,
g.name AS group_name,
gp.group_id AS group_id,
AVG(pr.review_score) AS average_score
from figaro_products p
left join figaro_product_types pt on pt.id = p.product_type_id
left join figaro_product_weights pw on pw.product_id = p.id
left join figaro_product_brands pb on pb.product_id= p.id
left join figaro_brands b on b.id = pb.brand_id
left join figaro_product_reviews pr on pr.partnumber = p.partnumber
left join figaro_group_products gp on gp.product_id = p.id
left join figaro_groups g on g.id = gp.group_id
where p.id = 11440
GROUP BY p.id
[result] => Resource id #35
[query_time] => 0.000271
[error] =>
[rows] => 1
[fields] => 14
[insert_id] =>
)
[9] => Array
(
[query] => SELECT `figaro_products`.`product_type_id` FROM `figaro_products` WHERE id = 11440
[result] => Resource id #36
[query_time] => 0.000202
[error] =>
[rows] => 1
[fields] => 1
[insert_id] =>
)
[10] => 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 = 253 ORDER BY rank ASC
[result] => Resource id #37
[query_time] => 0.000253
[error] =>
[rows] => 1
[fields] => 6
[insert_id] =>
)
[11] => 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 = 11440
[result] => Resource id #38
[query_time] => 0.00025
[error] =>
[rows] => 1
[fields] => 6
[insert_id] =>
)
[12] => 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 = 253 ORDER BY rank ASC
[result] => Resource id #39
[query_time] => 0.00025
[error] =>
[rows] => 0
[fields] => 7
[insert_id] =>
)
[13] => 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 = 11440 ORDER BY rank ASC
[result] => Resource id #40
[query_time] => 0.000266
[error] =>
[rows] => 7
[fields] => 6
[insert_id] =>
)
[14] => 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 = 253 ORDER BY rank ASC
[result] => Resource id #41
[query_time] => 0.000243
[error] =>
[rows] => 0
[fields] => 6
[insert_id] =>
)
[15] => 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 = 11440 ORDER BY rank ASC
[result] => Resource id #42
[query_time] => 0.000229
[error] =>
[rows] => 1
[fields] => 6
[insert_id] =>
)
[16] => 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 = 253 ORDER BY rank ASC
[result] => Resource id #43
[query_time] => 0.000267
[error] =>
[rows] => 0
[fields] => 6
[insert_id] =>
)
[17] => 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 = 11440 ORDER BY rank ASC
[result] => Resource id #44
[query_time] => 0.000216
[error] =>
[rows] => 0
[fields] => 6
[insert_id] =>
)
[18] => 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 = 11440 ORDER BY rank ASC
[result] => Resource id #45
[query_time] => 0.000218
[error] =>
[rows] => 0
[fields] => 6
[insert_id] =>
)
[19] => Array
(
[query] => select sql_no_cache user_id, product_id, quantity, bundle_id from figaro_user_carts where user_id = order by id
[result] =>
[query_time] => 0.000311
[error] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by id' at line 1
[rows] =>
[fields] =>
[insert_id] =>
)
[20] => 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 () AND store_id = 2
[result] =>
[query_time] => 0.000257
[error] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND store_id = 2' at line 1
[rows] =>
[fields] =>
[insert_id] =>
)
[21] => Array
(
[query] => select sql_no_cache * from figaro_orders_live where user_id =
[result] =>
[query_time] => 0.000161
[error] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[rows] =>
[fields] =>
[insert_id] =>
)
)
)
)
