Home/
Search

Search Results

We have found a total of 7 vehicles matching your criteria.

Filters
Sorting Options
(0) Compare
Subaru Outback 12
Wagon

Subaru Outback

Air Conditioning • Heated Seat • Power Mirrors • Rear Defogger • Fog Lights

2011
Gasoline
Automatic
Red
Engine: 2.5L 4
156,737mi

Location: Marshfield, Wisconsin, United States

Sale Price

$8,995.00

$9,600.00

Subaru Legacy 6
Sedan

Subaru Legacy

Air Conditioning • Heated Seat • Power Mirrors • Rear Defogger • Intermittent Wipers

2012
Gasoline
Automatic
Red
Engine: 2.5L 4
164,548mi

Location: Marshfield, Wisconsin, United States

Sale Price

$8,500.00

$8,500.00

Toyota Rav4 5
Sport Utility Vehicle

Toyota Rav4

Blind-spot warning • Backup camera • Air Conditioning • Heated Seat • Power Mirrors

2020
Gasoline
Automatic
Black
Engine: 2.5L 4
97,402mi

Location: Marshfield, Wisconsin, United States

Sale Price

$23,995.00

$25,500.00

Chevrolet Traverse 3
Sport Utility Vehicle

Chevrolet Traverse

Backup camera • Air Conditioning • Remote Starter • Heated Seat • Power Mirrors

2016
Gasoline
Automatic
Gray
Engine: 3.6L 6
83,285mi

Location: Marshfield, Wisconsin, United States

Sale Price

$16,998.00

$16,998.00

Chevrolet Silverado Crew Cab 6
Pickup Truck

Chevrolet Silverado Crew Cab

Backup camera • Air Conditioning • Remote Starter • Power Mirrors • Digital Info Center

2021
Gasoline
Automatic
Black
Engine: 5.3L
94,903mi

Location: Marshfield, Wisconsin, United States

Sale Price

$31,795.00

$32,200.00

Jeep Wrangler Unlimited 5
Sport Utility Vehicle

Jeep Wrangler Unlimited

Backup camera • Air Conditioning • Remote Starter • Power Mirrors • Leather Steering Wheel

2019
Gasoline
Automatic
Silver
Engine: 3.6L 6
48,384mi

Location: Marshfield, Wisconsin, United States

Sale Price

$35,495.00

$35,995.00

Ford F 150 8
Pickup Truck

Ford F 150

Backup camera • Air Conditioning • Heated Seat • Power Mirrors • Leather Steering Wheel

2019
Gasoline
Automatic
White
Engine: 3.5 Eco Boost
135,249mi

Location: Marshfield, Wisconsin, United States

Sale Price

$27,490.00

$27,998.00

Total: 7 / Current Page: 1 of 1

Total execution time: 1734803643.484 sec.

Framework 1.50 v3.00

Cpu Usage 7241 sec.

Memory Usage 801.23kB

POST: 
Array
(
)
GET: 
Array
(
)

                         
Array
(
    [segment] => Array
        (
            [0] => search
        )

    [route] => /search
    [template] => front/themes/master/search.tpl.php
)

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

2. count | total: 7
SELECT COUNT(*) AS items FROM `listings` WHERE (`status` = 1) ;

3. SELECT | total: 7
SELECT li.model_name, li.condition_name, li.category_name, li.trans_name, li.fuel_name, li.color_name, l.id, l.thumb, l.idx, l.doors, l.nice_title, l.title, l.gallery, l.slug, l.price, l.price_sale, l.year, l.sold, l.engine, l.top_speed, l.created, l.mileage, l.featured, li.feature_name, li.location_name FROM `listings` AS l LEFT JOIN `listings_info` AS li ON l.id = li.listing_id WHERE l.status = 1 ORDER BY created DESC LIMIT 0,30; ;

4. select | total: 8
SELECT id, name FROM `categories`;

5. SELECT | total: 0
SELECT * FROM `advert` ORDER BY RAND() LIMIT 1;

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. count | total: 7. SELECT COUNT(*) AS items FROM `listings` WHERE (`status` = 1) ;
3. SELECT | total: 7.  SELECT li.model_name, li.condition_name, li.category_name, li.trans_name, li.fuel_name, li.color_name, l.id, l.thumb, l.idx, l.doors, l.nice_title, l.title, l.gallery, l.slug, l.price, l.price_sale, l.year, l.sold, l.engine, l.top_speed, l.created, l.mileage, l.featured, li.feature_name, li.location_name FROM `listings` AS l LEFT JOIN `listings_info` AS li ON l.id = li.listing_id WHERE l.status = 1 ORDER BY created DESC LIMIT 0,30; ;
4. select | total: 8. SELECT id, name FROM `categories`;
5. SELECT | total: 0. SELECT * FROM `advert` ORDER BY RAND() LIMIT 1;
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;