• : Call Us
  • Stock #
    VIN
    Body Style
    Engine
    Transmission
    Drivetrain
    Miles 0 mi.
    Ext | Interior |
    Door | Passenger |
    Get Pre-Approved Now 435-634-4465
    Query Failed: SELECT v.StockNumber, v.VIN, v.nu, v.Vehicle, v.ModelYear, v.Make, v.Model, v.Odometer, p.ListPrice, p.AskingPrice, v.Body, v.CertifiedUsedCar, v.PhotoURLs FROM website_vehicles v LEFT JOIN website_vehicles_pricing p ON p.StockNumber = v.StockNumber WHERE v.ModelYear BETWEEN - 1 AND + 1 AND v.Make = '' AND v.Body LIKE '%%' AND (p.AskingPrice BETWEEN * .75 AND * 1.25 OR p.ListPrice BETWEEN * .75 AND * 1.25) AND v.StockNumber <> '' ORDER BY RAND() LIMIT 8