Description

This is one sweet Jeep, This lift kit was done right with the correct drop brakets to get the angles correct to make this thing handle and drive just awesome! Come check this thing out and take it for a test drive. Trades are always welcome!

Features
Backup camera
Air Conditioning
Remote Starter
Power Mirrors
Leather Steering Wheel
Digital Info Center
Fog Lights
Intermittent Wipers
Electric Mirrors
Antilock Brake System
Power Door Locks
Power Windows
Stability Control
Traction Control
Tire Pressure Monitoring System (TPMS)
Side-step running boards
Location

Jeep Wrangler Unlimited

2019
Sport Utility Vehicle
Gasoline

$35,495.00

$35,995.00

Make:
Jeep
Model:
Wrangler Unlimited
Exterior Color:
Silver
Interior Color:
Black
Transmission:
Automatic
Condition:
Used
Model Year:
2019
Fuel Type:
Gasoline
Odometer:
48,384mi
Doors:
4
Torque:
4800
Engine:
3.6L 6
Drive Train:
four wheel drive
Horse Power:
285
VIN:
1C4HJXEG0KW589369
715-660-****-reveal Send a message
Send a message
Forst Auto Sales
3417 W Veterans Parkway
More from this seller
Rod@badgerstateweb.com
715-660-****-reveal

Total execution time: 1715183933.7081 sec.

Framework 1.50 v3.00

Cpu Usage 8486 sec.

Memory Usage 770.93kB

POST:
Array
(
)

                         
GET:
Array
(
)

                         
Array
(
    [segment] => Array
        (
            [0] => listing
            [1] => 6675121
            [2] => 2019-jeep-wrangler-unlimited
        )

    [route] => /listing/6675121/2019-jeep-wrangler-unlimited
    [template] => front/themes/master/listing.tpl.php
)

1. select | total: 1
SELECT * FROM `settings` WHERE (`id` = 1) ;

2. SELECT | total: 1
SELECT li.model_name, li.condition_name, li.category_name, li.trans_name, li.location_name, li.fuel_name, li.fuel_name, li.make_slug, li.category_slug, li.fuel_name, li.make_name, li.feature_name, u.username, u.avatar, l.* FROM `listings` AS l LEFT JOIN `listings_info` AS li ON li.listing_id = l.id LEFT JOIN `members` AS u ON u.id = l.user_id WHERE l.status = 1 AND l.idx = 6675121 AND l.slug = "2019-jeep-wrangler-unlimited" ;

3. SELECT | total: 0
SELECT * FROM `stats` WHERE DATE(created) = "2024-05-08" AND listing_id = 11 LIMIT 1;

4. insert | total: 1
INSERT INTO `stats` (`created`,`visits`,`listing_id`) VALUES ("2024-05-08 10:58:53",1,11);

5. UPDATE | total: 1
UPDATE listings SET hits = hits+1 WHERE id = 11;

6. SELECT | total: 2
SELECT m.id, m.name, m.content_type, m.link, m.target, p.slug, p.type FROM `menus` AS m LEFT JOIN `pages` AS p ON p.id = m.page_id WHERE m.active = 1 ORDER BY m.sorting;

1. select | total: 1. SELECT * FROM `settings` WHERE (`id` = 1) ;
2. SELECT | total: 1.  SELECT li.model_name, li.condition_name, li.category_name, li.trans_name, li.location_name, li.fuel_name, li.fuel_name, li.make_slug, li.category_slug, li.fuel_name, li.make_name, li.feature_name, u.username, u.avatar, l.* FROM `listings` AS l LEFT JOIN `listings_info` AS li ON li.listing_id = l.id LEFT JOIN `members` AS u ON u.id = l.user_id WHERE l.status = 1 AND l.idx = 6675121 AND l.slug = "2019-jeep-wrangler-unlimited" ;
3. SELECT | total: 0. SELECT * FROM `stats` WHERE DATE(created) = "2024-05-08" AND listing_id = 11 LIMIT 1;
4. insert | total: 1. INSERT INTO `stats` (`created`,`visits`,`listing_id`) VALUES ("2024-05-08 10:58:53",1,11);
5. UPDATE | total: 1. UPDATE listings SET hits = hits+1 WHERE id = 11;
6. SELECT | total: 2.  SELECT m.id, m.name, m.content_type, m.link, m.target, p.slug, p.type FROM `menus` AS m LEFT JOIN `pages` AS p ON p.id = m.page_id WHERE m.active = 1 ORDER BY m.sorting;