Filters

Best Car Deals of The Month

Jeep Wrangler Unlimited
Jeep Wrangler Unlimited
$35,995.00
2019
Automatic
Gasoline
four wheel drive
$35,995.00
Ford F 150
Ford F 150
$27,998.00
2019
Automatic
Gasoline

Our Most Popular Brands

Jeep Wrangler Unlimited
2019
$35,995.00
Ford F 150
2019
$27,998.00
See All Offers

Our Most Popular Brands

Browse inventory by Brand Name

Subaru
Ford
Toyota
Jeep
Chevrolet

Why choose us?

achievement
Wide range of brands

We can help with your financing plan, we can offer some tips and tricks. Drive off with this dream car of yours regardless of your credit history.

trust
Trusted by our clients

We can help with your financing plan, we can offer some tips and tricks. Drive off with this dream car of yours regardless of your credit history.

finance
Fast & easy financing

We can help with your financing plan, we can offer some tips and tricks. Drive off with this dream car of yours regardless of your credit history.

Total execution time: 1734788546.7542 sec.

Framework 1.50 v3.00

Cpu Usage 3271 sec.

Memory Usage 743.09kB

POST: 
Array
(
)
GET: 
Array
(
)

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

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

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

2. select | total: 1
SELECT title, body, keywords, description FROM `pages` WHERE (`type` = "home") and (`active` = 1) ;

3. select | total: 0
SELECT thumb, body, caption, url FROM `slider` ORDER BY `sorting` ASC;

4. SELECT | total: 2
SELECT l.id, l.idx, l.nice_title, l.slug, l.price, l.price_sale, l.thumb, l.year, l.sold, l.drive_train, t.name AS transmission, f.name AS fuel FROM `listings` AS l LEFT JOIN `transmissions` AS t ON t.id = l.transmission LEFT JOIN `fuel` AS f ON f.id = l.fuel WHERE l.featured = 1 AND l.status = 1 ORDER BY RAND () LIMIT 5;

5. SELECT | total: 2
SELECT c.id, c.name, c.slug, c.image, COUNT(l.id) AS listings FROM `categories` AS c LEFT JOIN `listings` AS l ON l.category = c.id WHERE l.status = 1 AND l.featured = 1 GROUP BY c.id LIMIT 50;

6. SELECT | total: 2
SELECT idx, nice_title, slug, thumb, year, price, sold FROM `listings` WHERE status = 1 AND featured = 1 ORDER BY created DESC LIMIT 0, 50;

7. SELECT | total: 5
SELECT m.name, m.id, COUNT(m.id) as items FROM `makes` AS m INNER JOIN `listings` AS l ON l.make_id = m.id WHERE l.status = 1 GROUP BY m.id ORDER BY RAND() LIMIT 8;

8. SELECT | total: 0
SELECT r.*, CONCAT(m.fname,' ',m.lname) as name, m.avatar, m.id AS uid FROM `reviews` AS r LEFT JOIN `members` AS m ON m.id = r.user_id WHERE r.status = 1 ORDER BY r.created DESC;

9. 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 title, body, keywords, description FROM `pages` WHERE (`type` = "home") and (`active` = 1) ;
3. select | total: 0. SELECT thumb, body, caption, url FROM `slider` ORDER BY `sorting` ASC;
4. SELECT | total: 2.  SELECT l.id, l.idx, l.nice_title, l.slug, l.price, l.price_sale, l.thumb, l.year, l.sold, l.drive_train, t.name AS transmission, f.name AS fuel FROM `listings` AS l LEFT JOIN `transmissions` AS t ON t.id = l.transmission LEFT JOIN `fuel` AS f ON f.id = l.fuel WHERE l.featured = 1 AND l.status = 1 ORDER BY RAND () LIMIT 5;
5. SELECT | total: 2.  SELECT c.id, c.name, c.slug, c.image, COUNT(l.id) AS listings FROM `categories` AS c LEFT JOIN `listings` AS l ON l.category = c.id WHERE l.status = 1 AND l.featured = 1 GROUP BY c.id LIMIT 50;
6. SELECT | total: 2. SELECT idx, nice_title, slug, thumb, year, price, sold FROM `listings` WHERE status = 1 AND featured = 1 ORDER BY created DESC LIMIT 0, 50;
7. SELECT | total: 5.  SELECT m.name, m.id, COUNT(m.id) as items FROM `makes` AS m INNER JOIN `listings` AS l ON l.make_id = m.id WHERE l.status = 1 GROUP BY m.id ORDER BY RAND() LIMIT 8;
8. SELECT | total: 0.  SELECT r.*, CONCAT(m.fname,' ',m.lname) as name, m.avatar, m.id AS uid FROM `reviews` AS r LEFT JOIN `members` AS m ON m.id = r.user_id WHERE r.status = 1 ORDER BY r.created DESC;
9. 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;