query
RESULTSET
query
  DTISTOPDATE LNGMODELYEAR PK_AUTSFINCENTIVEID TXTMAKE TXTMODEL
CACHED false
EXECUTIONTIME 15
SQL SELECT TOP 1 tblSFIncentives.PK_autSFIncentiveID, tblSFIncentives.lngModelYear, tblSFIncentives.txtMake, tblSFIncentives.txtModel, tblSFIncentives.dtiStopDate FROM DSP_Control.dbo.tblSFIncentives tblSFIncentives LEFT JOIN DSP_Control.dbo.tblSFIncentiveCodeLink tblSFIncentiveCodeLink ON tblSFIncentives.PK_autSFIncentiveID = tblSFIncentiveCodeLink.FK_lngSFIncentiveID AND tblSFIncentiveCodeLink.txtStyleID = ? WHERE tblSFIncentives.FK_lngDealerID = ? AND tblSFIncentives.lngModelYear = '2017' AND tblSFIncentives.txtMake = 'Ram' AND (tblSFIncentives.txtVehicleHints LIKE '%CYLINDER_QUANTITY:6%' OR tblSFIncentives.txtVehicleHints NOT LIKE '%CYLINDER_QUANTITY:%') AND ( tblSFIncentives.txtVehicleHints LIKE '%FUEL_TYPE:G[,}]%' OR tblSFIncentives.txtVehicleHints NOT LIKE '%FUEL_TYPE:%' ) AND ( tblSFIncentives.txtVehicleHints LIKE '%BODY_TYPE:Crew Cab[,}]%' OR tblSFIncentives.txtVehicleHints NOT LIKE '%BODY_TYPE:%' ) AND (tblSFIncentiveCodeLink.txtStyleID IS NOT NULL OR ( tblSFIncentives.lngModelYear = '2017' AND tblSFIncentives.txtMake = 'Ram' AND ( tblSFIncentives.txtModel = '1500' OR ( (tblSFIncentives.txtVehicleHints LIKE '%MODEL:1500,%' OR tblSFIncentives.txtVehicleHints LIKE '%MODEL:1500}%') AND ( (tblSFIncentives.txtVehicleHints LIKE '%TRIM:Express,%' OR tblSFIncentives.txtVehicleHints LIKE '%TRIM:Express}%') OR ( tblSFIncentives.txtVehicleHints NOT LIKE '%TRIM:%' AND (tblSFIncentives.txtVehicleHintsForExclusion NOT LIKE '%TRIM:Express,%' OR tblSFIncentives.txtVehicleHintsForExclusion NOT LIKE '%TRIM:Express}%') ) ) ) ) ) ) AND tblSFIncentives.ysnActive = 1 AND tblSFIncentives.dtiStopDate >= Convert(DateTime, Floor(Convert(Float, getdate()))) AND tblSFIncentives.txtMake IN ('Ford','Lincoln','Chrysler','Dodge','Ram','Jeep') ORDER BY CASE WHEN tblSFIncentiveCodeLink.PK_autSFIncentiveCodeLinkID IS NULL THEN 2 ELSE 1 END, tblSFIncentives.lngTotalCash
SQLPARAMETERS
array
1 386869
2 29
Used 2017 Ram 1500 Express - Dick Edwards Auto Plaza

2017 Ram 1500 Express

2017 Ram 1500 Express
Dick's Price:
$28,995
Style/Trim: Crew Cab Pickup
Exterior: Delmonico Red Pearlcoat
Interior: Diesel Gray/Black
Mileage: 14,818 Miles
Engine: V6 Cylinder Engine
Transmission: 8-Speed Automatic w/OD
Fuel Type: Gasoline Fuel
Stock: JT18170B
VIN: 1C6RR7KG9HS764758
Estimate Your Payment
CITY MPG:
16
HWY MPG:
23
Actual rating will vary with options, driving conditions, habits and vehicle condition.
Apply for Credit Online
Leave this field empty
View Additional Vehicle Features

CPOS PKG

  • QUICK ORDER PACKAGE 22J EXPRESS
    • Engine: 3.6l v6 24v vvt
    • Transmission: 8-speed automatic (845re)
    • Fog lamps
    • Ram 1500 express
    • Body color grille
    • Body color rear bumper w/step pads
    • Front & rear floor mats
    • Body color front fascia

WHEELS

  • WHEELS: 17" X 7" ALUMINUM
  • (STD)

TIRES

  • TIRES: P265/70R17 BSW AS
  • (STD)

PRIMARY PAINT

  • DELMONICO RED PEARLCOAT

ADDITIONAL EQUIPMENT

  • ADD CLASS IV RECEIVER HITCH
  • SINGLE DISC REMOTE CD PLAYER
Gas Calculator

Request a Quote
Leave this field empty
Schedule Test Drive
Leave this field empty
Value Your Trade

ENTERTAINMENT

  • Radio: Uconnect 3.0
  • Radio w/Seek-Scan, Clock and Radio Data System
  • Fixed Antenna
  • 6 Speakers
  • Media Hub (USB, AUX)

INTERIOR

  • 4-Way Driver Seat
    • Manual Recline and Fore/Aft Movement
  • 4-Way Passenger Seat
    • Manual Recline and Fore/Aft Movement
  • Vinyl Rear Seat
  • Manual Tilt Steering Column
  • Gauges
    • Speedometer, Odometer, Voltmeter, Oil Pressure, Engine Coolant Temp, Tachometer, Oil Temperature, Transmission Fluid Temp, Engine Hour Meter and Trip Odometer
  • Power Rear Windows
  • Rear Folding Seat
  • Rear Cupholder
  • Cruise Control w/Steering Wheel Controls
  • Manual Air Conditioning
  • HVAC
    • Underseat Ducts and Console Ducts
  • Glove Box
  • Interior Trim
    • Deluxe Sound Insulation, Metal-Look Instrument Panel Insert and Chrome/Metal-Look Interior Accents
  • Full Cloth Headliner
  • Urethane Gear Shift Knob
  • Heavy Duty Vinyl 40/20/40 Split Bench Seat
  • Day-Night Rearview Mirror
  • Fade-To-Off Interior Lighting
  • Carpet Floor Covering
  • Cargo Area Concealed Storage
  • Storage Tray
  • Pickup Cargo Box Lights
  • Audio Jack Input for Mobile Devices
  • Remote USB Port
  • Electronic Shift
  • Instrument Panel Bin, Dashboard Storage, Driver / Passenger And Rear Door Bins and 2nd Row Underseat Storage
  • Delayed Accessory Power
  • Power 1st Row Windows w/Driver And Passenger 1-Touch Up/Down
  • Power Door Locks
  • Systems Monitor
  • Analog Display
  • Seats w/Vinyl Back Material
  • Manual Adjustable Front Head Restraints and Manual Adjustable Rear Head Restraints
  • Rear Center Armrest
  • 40/20/40 Split Bench Seat
  • Front Armrest w/3 Cupholders
  • Sentry Key Engine Immobilizer
  • 2 12V DC Power Outlets

EXTERIOR

  • Wheels: 17" x 7" Aluminum
  • Tires: P265/70R17 BSW AS
  • Regular Box Style
  • Center Hub
  • Steel Spare Wheel
  • Full-Size Spare Tire Stored Underbody w/Crankdown
  • Clearcoat Paint
  • Black Side Windows Trim and Black Front Windshield Trim
  • Black Door Handles
  • Power Side Mirrors w/Manual Folding
  • Black Exterior Mirrors
  • Exterior Mirrors w/Heating Element
  • Fixed Rear Window
  • Variable Intermittent Wipers
  • Deep Tinted Glass
  • Galvanized Steel/Aluminum Panels
  • Front License Plate Bracket
  • Active Grille Shutters
  • Delete Spray In Bedliner
  • Tailgate Rear Cargo Access
  • Manual Tailgate/Rear Door Lock
  • Cargo Lamp w/High Mount Stop Light
  • Fully Automatic Aero-Composite Halogen Headlamps w/Delay-Off
  • Tip Start

MECHANICAL

  • Engine: 3.6L V6 24V VVT
    • Flex fuel capable
  • Transmission: 8-Speed Automatic (845RE)
  • 3.21 Rear Axle Ratio
  • GVWR: 6,800 lbs
  • 50 State Emissions
  • Transmission w/Driver Selectable Mode and Oil Cooler
  • Black Rotary Shifter
  • Electronic Transfer Case
  • Part-Time Four-Wheel Drive
  • Engine Oil Cooler
  • 730CCA Maintenance-Free Battery
  • 160 Amp Alternator
  • Towing w/Harness and Trailer Sway Control
  • Delete Class IV Receiver Hitch
  • 1660# Maximum Payload
  • HD Shock Absorbers
  • Front And Rear Anti-Roll Bars
  • Electric Power-Assist Steering
  • 26 Gal. Fuel Tank
  • Single Stainless Steel Exhaust
  • Auto Locking Hubs
  • Short And Long Arm Front Suspension w/Coil Springs
  • Multi-Link Rear Suspension w/Coil Springs
  • 4-Wheel Disc Brakes w/4-Wheel ABS, Front Vented Discs, Brake Assist and Hill Hold Control

SAFETY

  • Electronic Stability Control (ESC)
  • ABS And Driveline Traction Control
  • Side Impact Beams
  • Dual Stage Driver And Passenger Seat-Mounted Side Airbags
  • Tire Specific Low Tire Pressure Warning
  • Dual Stage Driver And Passenger Front Airbags
  • Airbag Occupancy Sensor
  • Curtain 1st And 2nd Row Airbags
  • Rear Child Safety Locks
  • Outboard Front Lap And Shoulder Safety Belts
    • Rear Center 3 Point, Height Adjusters and Pretensioners

Prices

All advertised prices exclude government fees and taxes, any finance charges, any dealer document preparation charge, and any emission testing charge. All vehicles are subject to prior sale. We strive for accuracy, but this pricing information may be different from actual dealer price. Price includes VIP and Loyalty rebates in lieu of special financing. Please check with dealer for actual pricing and availability. Not responsible for typographical errors or other errors. We strive for accuracy, but the equipment and options shown may be different than what is actually on the vehicle. We are not responsible for missing equipment and options, incorrect prices or other errors.

Estimated Payment

Payments calculated at $3000 down, 72 month term at 3.9% APR. With approved Credit. Subject to qualification. Not all buyers will qualify. See dealer for details

Pictures

Graphics are representational only. All photos may not depict actual vehicles and may be a stock photo provided by manufacturer or other third party.

Rebates, Special Offers and Financing

Credit approval based on lender criteria, not all customers will qualify. The payment calculator is only to give you a comparison. The calculated payment may not be your actual payment. All terms and rates are subject to lender credit approval. Some rates and rebates are subject to Special offers are time sensitive and may be limited to specified vehicles and not all customer will qualify. All manufacturer rebates applied in lieu of special financing. Price includes VIP and Loyalty rebates in lieu of special financing. Not all customers will qualify. Check with dealer for verification.