Home/Subaru/
Subaru Legacy
Description

Very clean, great little gas saver. Has AWD and heated seats. Just serviced and ready to hit the road. Trades Welcome

Features
Air Conditioning
Heated Seat
Power Mirrors
Rear Defogger
Intermittent Wipers
Electric Mirrors
Antilock Brake System
Power Door Locks
Power Drivers Seat
Power Windows
Stability Control
Traction Control
All wheel drive
Location

Subaru Legacy

2012
Sedan
Gasoline

$8,500.00

$8,500.00

Make:
Subaru
Model:
Legacy
Exterior Color:
Red
Interior Color:
Black
Transmission:
Automatic
Condition:
Used
Model Year:
2012
Fuel Type:
Gasoline
Odometer:
164,548mi
Doors:
4
Torque:
4000
Engine:
2.5L 4
Drive Train:
all wheel drive
Horse Power:
170
VIN:
4S3BMCC69C3020667
715-660-****-reveal
Chat via WhatsApp
Send a message
Send a message
Forst Auto Sales
3417 W Veterans Parkway
More from this seller
Rod@badgerstateweb.com
715-660-****-reveal
Pickup Truck
Pickup Truck (2)
Sedan
Sedan (1)
Sport Utility Vehicle
Sport Utility Vehicle (3)
Wagon
Wagon (1)
Chevrolet
Chevrolet (2)
Ford
Ford (1)
Jeep
Jeep (1)
Subaru
Subaru (2)
Toyota
Toyota (1)

Total execution time: 1734845485.3825 sec.

Framework 1.50 v3.00

Cpu Usage 4336 sec.

Memory Usage 783.6kB

POST: 
Array
(
)
GET: 
Array
(
)

                         
Array
(
    [segment] => Array
        (
            [0] => listing
            [1] => 7739374
            [2] => 2012-subaru-legacy
        )

    [route] => /listing/7739374/2012-subaru-legacy
    [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 = 7739374 AND l.slug = "2012-subaru-legacy" ;

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

4. insert | total: 1
INSERT INTO `stats` (`created`,`visits`,`listing_id`) VALUES ("2024-12-21 23:31:25",1,16);

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

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 = 7739374 AND l.slug = "2012-subaru-legacy" ;
3. SELECT | total: 0. SELECT * FROM `stats` WHERE DATE(created) = "2024-12-21" AND listing_id = 16 LIMIT 1;
4. insert | total: 1. INSERT INTO `stats` (`created`,`visits`,`listing_id`) VALUES ("2024-12-21 23:31:25",1,16);
5. UPDATE | total: 1. UPDATE listings SET hits = hits+1 WHERE id = 16;
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;