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 No
Front Lowering Range No
Rear Lowering Range No

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']."
"; } }