select `vehicles`.*, count(makes.id) as make_count, makes.make_name from `vehicles` inner join `users` on `vehicles`.`user_id` = `users`.`id` inner join `makes` on `vehicles`.`make_id` = `makes`.`id` where (`vehicles`.`status_id` = ? and `vehicles`.`created_at` > DATE_SUB(NOW(),INTERVAL 2 YEAR)) and `users`.`name` = ? and `makes`.`make_name` != ? group by `makes`.`make_name` order by `make_count` desc
Array ( [0] => 1 [1] => Niagara Motors - NEW [2] => )
394.92
select `vehicles`.*, count(fuel_types.id) as fuel_count, fuel_types.fuel_type from `vehicles` inner join `users` on `vehicles`.`user_id` = `users`.`id` inner join `fuel_types` on `vehicles`.`fuel_id` = `fuel_types`.`id` where (`vehicles`.`status_id` = ? and `vehicles`.`created_at` > DATE_SUB(NOW(),INTERVAL 2 YEAR)) and `users`.`name` = ? and `fuel_types`.`fuel_type` != ? group by `fuel_types`.`fuel_type` order by `fuel_count` desc
Array ( [0] => 1 [1] => Niagara Motors - NEW [2] => )
326.13
select *, (select count(*) from `vehicles` inner join `users` on `users`.`id` = `vehicles`.`user_id` where `provinces`.`id` = `users`.`province_id` and `vehicles`.`status_id` = ? and `vehicles`.`created_at` > DATE_SUB(NOW(),INTERVAL 2 YEAR)) as `vehicles_count` from `provinces` order by `province_name` asc
Array ( [0] => 1 )
2519.09
select `makes`.* from `makes` inner join `vehicles` on `vehicles`.`make_id` = `makes`.`id` group by `makes`.`id`
Array ( )
573.39
select count(*) as aggregate from `vehicles` inner join `users` on `vehicles`.`user_id` = `users`.`id` where (`vehicles`.`status_id` = ? and `vehicles`.`created_at` > DATE_SUB(NOW(),INTERVAL 2 YEAR)) and `users`.`name` = ? and `vehicles`.`created_at` > DATE_SUB(NOW(),INTERVAL 2 YEAR)
Array ( [0] => 1 [1] => Niagara Motors - NEW )
268.64
select `vehicles`.* from `vehicles` inner join `users` on `vehicles`.`user_id` = `users`.`id` where (`vehicles`.`status_id` = ? and `vehicles`.`created_at` > DATE_SUB(NOW(),INTERVAL 2 YEAR)) and `users`.`name` = ? and `vehicles`.`created_at` > DATE_SUB(NOW(),INTERVAL 2 YEAR) order by `vehicles`.`created_at` desc limit 15 offset 90
Array ( [0] => 1 [1] => Niagara Motors - NEW )
449.08
select `vehicles`.* from `vehicles` inner join `users` on `vehicles`.`user_id` = `users`.`id` where (`vehicles`.`status_id` = ? and `vehicles`.`created_at` > DATE_SUB(NOW(),INTERVAL 2 YEAR)) and `users`.`name` = ? and (`users`.`featured` = ? or `vehicles`.`featured` = ?) order by RAND() limit 8
Array ( [0] => 1 [1] => Niagara Motors - NEW [2] => 1 [3] => 1 )
326
Used Cars Preowned Vehicles
Filter

Quick Search

Close

Used Cars Preowned Vehicles

Search

Filters Applied

  • dealer : Niagara Motors - NEW

Select Province

Condition

Seller

Select Make

Select Fuel

Transmission

Filter by Price

$ — $

Filter by Odometer

Km — Km

Filter by Year

—

Sort By
Date
Price
Odometer
Year

2024 select * from `makes` where `makes`.`id` = ? limit 1
Array ( [0] => 8 )
2.75
Buick select * from `models` where `models`.`id` = ? limit 1
Array ( [0] => 2677 )
0.27
ENVISION PREFERRED AWD - select * from `users` where `users`.`id` = ? limit 1
Array ( [0] => 1816 )
3.13
select * from `cities` where `cities`.`id` = ? limit 1
Array ( [0] => 195 )
0.31
Virgil, select * from `provinces` where `provinces`.`id` = ? limit 1
Array ( [0] => 6 )
3.25
Ontario

Virgil, Ontario

Added 3 months ago

select * from `body_style_groups` where `body_style_groups`.`id` = ? limit 1
Array ( [0] => 7 )
0.43
Wagon | select * from `colors` where `colors`.`id` = ? limit 1
Array ( [0] => 11191 )
0.4
GEJ Cinnabar Metallic | auto

Niagara Motors - NEW

  • $45,394
  • 6KM

  • --

2025 select * from `makes` where `makes`.`id` = ? limit 1
Array ( [0] => 8 )
1.92
Buick select * from `models` where `models`.`id` = ? limit 1
Array ( [0] => 5655 )
0.24
Encore GX Sport Touring - AWD - select * from `users` where `users`.`id` = ? limit 1
Array ( [0] => 1816 )
3.68
select * from `cities` where `cities`.`id` = ? limit 1
Array ( [0] => 195 )
3.74
Virgil, select * from `provinces` where `provinces`.`id` = ? limit 1
Array ( [0] => 6 )
0.21
Ontario

Virgil, Ontario

Added 3 months ago

select * from `body_style_groups` where `body_style_groups`.`id` = ? limit 1
Array ( [0] => 7 )
0.3
Wagon | select * from `colors` where `colors`.`id` = ? limit 1
Array ( [0] => 304 )
0.28
Summit White | auto

Niagara Motors - NEW

  • $37,694
  • 0KM

  • --

2024 select * from `makes` where `makes`.`id` = ? limit 1
Array ( [0] => 8 )
0.17
Buick select * from `models` where `models`.`id` = ? limit 1
Array ( [0] => 2677 )
2.31
ENVISION PREFERRED AWD - select * from `users` where `users`.`id` = ? limit 1
Array ( [0] => 1816 )
0.24
select * from `cities` where `cities`.`id` = ? limit 1
Array ( [0] => 195 )
0.17
Virgil, select * from `provinces` where `provinces`.`id` = ? limit 1
Array ( [0] => 6 )
0.16
Ontario

Virgil, Ontario

Added 3 months ago

select * from `body_style_groups` where `body_style_groups`.`id` = ? limit 1
Array ( [0] => 7 )
0.46
Wagon | select * from `colors` where `colors`.`id` = ? limit 1
Array ( [0] => 13950 )
10.65
GE8 White Frost Tricoat | auto

Niagara Motors - NEW

  • $46,094
  • 0KM

  • --

2023 select * from `makes` where `makes`.`id` = ? limit 1
Array ( [0] => 19 )
0.36
GMC select * from `models` where `models`.`id` = ? limit 1
Array ( [0] => 333 )
0.3
Savana - select * from `users` where `users`.`id` = ? limit 1
Array ( [0] => 1816 )
0.31
select * from `cities` where `cities`.`id` = ? limit 1
Array ( [0] => 195 )
0.22
Virgil, select * from `provinces` where `provinces`.`id` = ? limit 1
Array ( [0] => 6 )
0.21
Ontario

Virgil, Ontario

Added 3 months ago

select * from `body_style_groups` where `body_style_groups`.`id` = ? limit 1
Array ( [0] => 22 )
3.53
Commercial | select * from `colors` where `colors`.`id` = ? limit 1
Array ( [0] => 41 )
8.42
| auto

Niagara Motors - NEW

  • $0
  • 2,347KM

  • --

Sponsored Advertisement

Auto Loan Canada

100% credit acceptance

Easy 60-Second Application

APPLY NOW

2024 select * from `makes` where `makes`.`id` = ? limit 1
Array ( [0] => 19 )
1.79
GMC select * from `models` where `models`.`id` = ? limit 1
Array ( [0] => 5510 )
0.42
Canyon AT4 Crew Cab 4WD - select * from `users` where `users`.`id` = ? limit 1
Array ( [0] => 1816 )
0.29
select * from `cities` where `cities`.`id` = ? limit 1
Array ( [0] => 195 )
0.27
Virgil, select * from `provinces` where `provinces`.`id` = ? limit 1
Array ( [0] => 6 )
0.21
Ontario

Virgil, Ontario

Added 3 months ago

select * from `body_style_groups` where `body_style_groups`.`id` = ? limit 1
Array ( [0] => 6 )
5.78
Truck | select * from `colors` where `colors`.`id` = ? limit 1
Array ( [0] => 9750 )
0.39
GTL Desert Sand Metallic | auto

Niagara Motors - NEW

  • $60,239
  • 0KM

  • --

2024 select * from `makes` where `makes`.`id` = ? limit 1
Array ( [0] => 19 )
0.4
GMC select * from `models` where `models`.`id` = ? limit 1
Array ( [0] => 6079 )
0.34
Hummer EV 3X SUV - select * from `users` where `users`.`id` = ? limit 1
Array ( [0] => 1816 )
14.24
select * from `cities` where `cities`.`id` = ? limit 1
Array ( [0] => 195 )
0.38
Virgil, select * from `provinces` where `provinces`.`id` = ? limit 1
Array ( [0] => 6 )
0.27
Ontario

Virgil, Ontario

Added 3 months ago

select * from `body_style_groups` where `body_style_groups`.`id` = ? limit 1
Array ( [0] => 7 )
0.29
Wagon | select * from `colors` where `colors`.`id` = ? limit 1
Array ( [0] => 15638 )
0.23
GLG Neptune Blue Matte | auto

Niagara Motors - NEW

  • $184,888
  • 0KM

  • --

2024 select * from `makes` where `makes`.`id` = ? limit 1
Array ( [0] => 19 )
0.17
GMC select * from `models` where `models`.`id` = ? limit 1
Array ( [0] => 5460 )
0.17
Sierra 1500 Crew Elevation 4WD - select * from `users` where `users`.`id` = ? limit 1
Array ( [0] => 1816 )
0.23
select * from `cities` where `cities`.`id` = ? limit 1
Array ( [0] => 195 )
0.17
Virgil, select * from `provinces` where `provinces`.`id` = ? limit 1
Array ( [0] => 6 )
0.17
Ontario

Virgil, Ontario

Added 3 months ago

select * from `body_style_groups` where `body_style_groups`.`id` = ? limit 1
Array ( [0] => 6 )
7.8
Truck | select * from `colors` where `colors`.`id` = ? limit 1
Array ( [0] => 1677 )
0.23
Gba Onyx Black | auto

Niagara Motors - NEW

  • $79,114
  • 0KM

  • --

2024 select * from `makes` where `makes`.`id` = ? limit 1
Array ( [0] => 8 )
0.19
Buick select * from `models` where `models`.`id` = ? limit 1
Array ( [0] => 2677 )
0.17
ENVISION PREFERRED AWD - select * from `users` where `users`.`id` = ? limit 1
Array ( [0] => 1816 )
0.23
select * from `cities` where `cities`.`id` = ? limit 1
Array ( [0] => 195 )
2.22
Virgil, select * from `provinces` where `provinces`.`id` = ? limit 1
Array ( [0] => 6 )
0.17
Ontario

Virgil, Ontario

Added 3 months ago

select * from `body_style_groups` where `body_style_groups`.`id` = ? limit 1
Array ( [0] => 7 )
0.19
Wagon | select * from `colors` where `colors`.`id` = ? limit 1
Array ( [0] => 15908 )
0.23
G88 Smokey Amethyst Metallic | auto

Niagara Motors - NEW

  • $47,119
  • 0KM

  • --

2024 select * from `makes` where `makes`.`id` = ? limit 1
Array ( [0] => 19 )
0.16
GMC select * from `models` where `models`.`id` = ? limit 1
Array ( [0] => 342 )
1.88
Terrain - select * from `users` where `users`.`id` = ? limit 1
Array ( [0] => 1816 )
0.24
select * from `cities` where `cities`.`id` = ? limit 1
Array ( [0] => 195 )
0.17
Virgil, select * from `provinces` where `provinces`.`id` = ? limit 1
Array ( [0] => 6 )
0.17
Ontario

Virgil, Ontario

Added 3 months ago

select * from `body_style_groups` where `body_style_groups`.`id` = ? limit 1
Array ( [0] => 5 )
3.7
SUV | select * from `colors` where `colors`.`id` = ? limit 1
Array ( [0] => 41 )
2.48
| auto

Niagara Motors - NEW

  • $0
  • 10,880KM

  • --

2024 select * from `makes` where `makes`.`id` = ? limit 1
Array ( [0] => 19 )
8.58
GMC select * from `models` where `models`.`id` = ? limit 1
Array ( [0] => 5996 )
11.54
Yukon SLT 4WD - select * from `users` where `users`.`id` = ? limit 1
Array ( [0] => 1816 )
6.94
select * from `cities` where `cities`.`id` = ? limit 1
Array ( [0] => 195 )
5.18
Virgil, select * from `provinces` where `provinces`.`id` = ? limit 1
Array ( [0] => 6 )
0.96
Ontario

Virgil, Ontario

Added 3 months ago

select * from `body_style_groups` where `body_style_groups`.`id` = ? limit 1
Array ( [0] => 7 )
0.24
Wagon | select * from `colors` where `colors`.`id` = ? limit 1
Array ( [0] => 13678 )
0.24
G6N Frosted Pine Metallic | auto

Niagara Motors - NEW

  • $96,424
  • 0KM

  • --

2024 select * from `makes` where `makes`.`id` = ? limit 1
Array ( [0] => 19 )
0.21
GMC select * from `models` where `models`.`id` = ? limit 1
Array ( [0] => 4679 )
0.23
GMC Sierra 1500 PRO 2WD - select * from `users` where `users`.`id` = ? limit 1
Array ( [0] => 1816 )
0.31
select * from `cities` where `cities`.`id` = ? limit 1
Array ( [0] => 195 )
0.21
Virgil, select * from `provinces` where `provinces`.`id` = ? limit 1
Array ( [0] => 6 )
0.21
Ontario

Virgil, Ontario

Added 3 months ago

select * from `body_style_groups` where `body_style_groups`.`id` = ? limit 1
Array ( [0] => 6 )
0.54
Truck | select * from `colors` where `colors`.`id` = ? limit 1
Array ( [0] => 7313 )
0.32
G7C Cardinal Red | auto

Niagara Motors - NEW

  • $52,554
  • 0KM

  • --

2024 select * from `makes` where `makes`.`id` = ? limit 1
Array ( [0] => 19 )
0.4
GMC select * from `models` where `models`.`id` = ? limit 1
Array ( [0] => 5378 )
0.32
Canyon Denali Crew 4WD - select * from `users` where `users`.`id` = ? limit 1
Array ( [0] => 1816 )
0.39
select * from `cities` where `cities`.`id` = ? limit 1
Array ( [0] => 195 )
0.29
Virgil, select * from `provinces` where `provinces`.`id` = ? limit 1
Array ( [0] => 6 )
0.26
Ontario

Virgil, Ontario

Added 3 months ago

select * from `body_style_groups` where `body_style_groups`.`id` = ? limit 1
Array ( [0] => 6 )
0.3
Truck | select * from `colors` where `colors`.`id` = ? limit 1
Array ( [0] => 1677 )
3.08
Gba Onyx Black | auto

Niagara Motors - NEW

  • $63,699
  • 0KM

  • --

2024 select * from `makes` where `makes`.`id` = ? limit 1
Array ( [0] => 19 )
3.82
GMC select * from `models` where `models`.`id` = ? limit 1
Array ( [0] => 5510 )
0.19
Canyon AT4 Crew Cab 4WD - select * from `users` where `users`.`id` = ? limit 1
Array ( [0] => 1816 )
3.67
select * from `cities` where `cities`.`id` = ? limit 1
Array ( [0] => 195 )
0.3
Virgil, select * from `provinces` where `provinces`.`id` = ? limit 1
Array ( [0] => 6 )
3.07
Ontario

Virgil, Ontario

Added 3 months ago

select * from `body_style_groups` where `body_style_groups`.`id` = ? limit 1
Array ( [0] => 6 )
0.19
Truck | select * from `colors` where `colors`.`id` = ? limit 1
Array ( [0] => 12928 )
0.19
GLT Dynamic Blue Metallic | auto

Niagara Motors - NEW

  • $57,299
  • 0KM

  • --

2024 select * from `makes` where `makes`.`id` = ? limit 1
Array ( [0] => 19 )
0.17
GMC select * from `models` where `models`.`id` = ? limit 1
Array ( [0] => 5550 )
0.16
Canyon Elevation Crew Cab 4WD - select * from `users` where `users`.`id` = ? limit 1
Array ( [0] => 1816 )
0.22
select * from `cities` where `cities`.`id` = ? limit 1
Array ( [0] => 195 )
0.16
Virgil, select * from `provinces` where `provinces`.`id` = ? limit 1
Array ( [0] => 6 )
0.16
Ontario

Virgil, Ontario

Added 4 months ago

select * from `body_style_groups` where `body_style_groups`.`id` = ? limit 1
Array ( [0] => 6 )
0.8
Truck | select * from `colors` where `colors`.`id` = ? limit 1
Array ( [0] => 127 )
0.36
Onyx Black | auto

Niagara Motors - NEW

  • $56,214
  • 0KM

  • --

2024 select * from `makes` where `makes`.`id` = ? limit 1
Array ( [0] => 19 )
0.27
GMC select * from `models` where `models`.`id` = ? limit 1
Array ( [0] => 2851 )
0.34
TERRAIN SLE AWD - select * from `users` where `users`.`id` = ? limit 1
Array ( [0] => 1816 )
0.4
select * from `cities` where `cities`.`id` = ? limit 1
Array ( [0] => 195 )
1.22
Virgil, select * from `provinces` where `provinces`.`id` = ? limit 1
Array ( [0] => 6 )
0.51
Ontario

Virgil, Ontario

Added 4 months ago

select * from `body_style_groups` where `body_style_groups`.`id` = ? limit 1
Array ( [0] => 7 )
0.32
Wagon | select * from `colors` where `colors`.`id` = ? limit 1
Array ( [0] => 304 )
4.7
Summit White | auto

Niagara Motors - NEW

  • $38,620
  • 50KM

  • --

Sponsored Advertisement

Auto Loan Canada

100% credit acceptance

Easy 60-Second Application

APPLY NOW