Min Price 0 500 1000 2000 3000 4000 5000 6000 7000 8000 9000 10000 11000 12000 13000 14000 15000 16000 17000 18000 19000 20000 22500 25000 27500 30000 40000 50000 75000 100000 250000 500000

Max Price 500 1000 2000 3000 4000 5000 6000 7000 8000 9000 10000 11000 12000 13000 14000 15000 16000 17000 18000 19000 20000 22500 25000 27500 30000 40000 50000 75000 100000 250000 500000 1000000

Mileage (Any)

No. of Doors (Any)

Private and Trade

Range (Any) SELECT range FROM products WHERE range != '' AND category_id='28' GROUP BY range