Filters

Best Car Deals of The Month

Ford F 150
Ford F 150
$27,998.00
2019
Automatic
Gasoline
4wd
$27,998.00
Jeep Wrangler Unlimited
Jeep Wrangler Unlimited
$35,995.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

Jeep
Toyota
Subaru
Ford
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: 1732170375.192 sec.

Framework 1.50 v3.00

Cpu Usage 6410 sec.

Memory Usage 745.63kB

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;