888-230-1288CONTACT US
0item(s)

You have no items in your shopping cart.

Part Finder

Product was successfully added to your shopping cart.

Street Edge Coilover System for 04-10 Chrysler 300 / 300C (all models) 2WD all (incl. SRT) Coilover System

SKU: SE801014 | Manufacturer:Street Edge

Be the first to review this product

Quick Overview

Street Edge Coilover System SE801014

Availability: In stock

Regular Price: $699.99

Special Price $629.10

Details

Street Edge Coilover System for 04-10 Chrysler 300 / 300C (all models) 2WD all (incl. SRT) Coilover System

Additional Information

Free Shipping N/A
Front Lowering Range N/A
Rear Lowering Range N/A

Product Tags

Use spaces to separate tags. Use single quotes (') for phrases.

  1. Be the first to review this product

Write Your Own Review

$product_id = Mage::registry('current_product')->getId(); $pid = $product_id; //echo $pid; $db = Mage::getSingleton('core/resource')->getConnection('core_write'); $query = 'SELECT `afv1`.`name` as `name1`,`afv2`.`name` as `name2`, `afm`.`value_id` as `resid` FROM `am_finder_map` as `afm`'. 'INNER JOIN `am_finder_value` as `afv1` ON `afv1`.`value_id` = `afm`.`value_id`'. 'INNER JOIN `am_finder_value` as `afv2` ON `afv2`.`value_id` = `afv1`.`parent_id`'. 'WHERE `pid` = '.$pid; $finders = $db->fetchAll($query); if(empty($finders)) { echo"".$this->__('Er zijn geen modellen gevonden.').""; }else{ foreach ($finders as $finder){ $link = 'http://exacmple.com/part?find='; $link .= strtolower(preg_replace('/[^\da-zA-Z]/', '-', $finder['name2'])) . '-'.strtolower(preg_replace('/[^\da-zA-Z]/', '-', $finder['name1'])) . '-'.$finder['resid']; echo "".$finder['name2']." - ".$finder['name1']."
"; } }