SELECT * FROM web1 where modelbrand = 'TOYOTA' And MODELGROUPDESC = 'YARIS' order by MODELYEAR desc
1
2
img

YARIS

  • Year 2017
  • KM 83179
  • Gear AUTOMATIC

R.O. 3650

View Details
img

YARIS

  • Year 2017
  • KM 121113
  • Gear STEPTRONIC

R.O. 4200

View Details
img

YARIS

  • Year 2016
  • KM 130600
  • Gear AUTOMATIC

R.O. 3500

View Details
img

YARIS

  • Year 2016
  • KM 39714
  • Gear AUTOMATIC

R.O. 4100

View Details
img

YARIS

  • Year 2016
  • KM 56841
  • Gear MANUAL

R.O. 2850

View Details
img

YARIS

  • Year 2016
  • KM 93850
  • Gear AUTOMATIC

R.O. 3100

View Details
img

YARIS

  • Year 2015
  • KM 132026
  • Gear AUTOMATIC

R.O. 3300

View Details
img

YARIS

  • Year 2014
  • KM 121998
  • Gear AUTOMATIC

R.O. 3350

View Details
img

YARIS

  • Year 2019
  • KM 16260
  • Gear AUTOMATIC

R.O. 4800

View Details
img

YARIS

  • Year 2019
  • KM 55400
  • Gear AUTOMATIC

R.O. 4700

View Details
Budget to Luxury cars     Showroom Timings: Sunday - Thursday - 9.00am - 8.00pm. Saturday 5.00pm to 8.00pm. Friday Closed.     We buy cars for cash     Oman`s preferred Pre-owned multi-brand automobile outlets     Showroom Timings: Sunday - Thursday - 9.00am - 8.00pm. Saturday 5.00pm to 8.00pm. Friday Closed.     Your search for a car ends here     Showroom Timings: Sunday - Thursday - 9.00am - 8.00pm. Saturday 5.00pm to 8.00pm. Friday Closed.