query
RESULTSET
query
  DTISTOPDATE LNGMODELYEAR PK_AUTSFINCENTIVEID TXTMAKE TXTMODEL
CACHED false
EXECUTIONTIME 16
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:8%' 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:Big Horn%' OR tblSFIncentives.txtVehicleHints LIKE '%TRIM:Big Horn}%') OR ( tblSFIncentives.txtVehicleHints NOT LIKE '%TRIM:%' AND (tblSFIncentives.txtVehicleHintsForExclusion NOT LIKE '%TRIM:Big Horn,%' OR tblSFIncentives.txtVehicleHintsForExclusion NOT LIKE '%TRIM:Big Horn}%') ) ) ) ) ) ) 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 386872
2 29
Used 2017 Ram 1500 Big Horn - Dick Edwards Auto Plaza

2017 Ram 1500 Big Horn

2017 Ram 1500 Big Horn
Dick's Price:
$34,995
Style/Trim: Crew Cab Pickup
Exterior: Blue Streak Pearlcoat
Interior: Diesel Gray/Black
Mileage: 19,899 Miles
Engine: 8 Cylinder Engine
Transmission: Automatic w/OD
Fuel Type: Gasoline Fuel
Stock: PT10897
VIN: 1C6RR7LT1HS699724
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

ENGINE

  • ENGINE: 5.7L V8 HEMI MDS VVT
    • Electronically controlled throttle
    • Hemi badge
    • Next generation engine controller
    • Heavy duty engine cooling
    • Heavy duty transmission oil cooler
    • Engine oil heat exchanger

PRIMARY PAINT

  • BLUE STREAK PEARLCOAT

SEAT TYPE

  • DIESEL GRAY/BLACK, PREMIUM CLOTH 40/20/40 BENCH SEAT
    • Power lumbar adjust
    • Folding flat load floor storage
    • 115v auxiliary power outlet
    • Front center seat cushion storage
    • Rear 60/40 split folding seat
    • Power 10-way driver seat
Gas Calculator

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

ENTERTAINMENT

  • Radio w/Seek-Scan, Clock, Voice Activation and Radio Data System
  • Streaming Audio
  • Fixed Antenna
  • 6 Speakers

INTERIOR

  • 4-Way Driver Seat
    • Manual Recline and Fore/Aft Movement
  • 4-Way Passenger Seat
    • Manual Recline and Fore/Aft Movement
  • Manual Tilt Steering Column
  • Rear Cupholder
  • Compass
  • Valet Function
  • Cruise Control w/Steering Wheel Controls
  • HVAC
    • Underseat Ducts and Console Ducts
  • Glove Box
  • Full Cloth Headliner
  • Vinyl Door Trim Insert
  • Urethane Gear Shift Knob
  • Interior Trim
    • Deluxe Sound Insulation, Metal-Look Instrument Panel Insert, Metal-Look Door Panel Insert and Chrome/Metal-Look Interior Accents
  • Day-Night Rearview Mirror
  • Front Map Lights
  • Fade-To-Off Interior Lighting
  • Cargo Area Concealed Storage
  • Storage Tray
  • FOB Controls
    • Trunk/Hatch/Tailgate
  • ParkSense Front/Rear Park Assist System
  • GPS Antenna Input
  • ParkView Rear Back-Up Camera
  • Instrument Panel Bin, Dashboard Storage, Driver / Passenger And Rear Door Bins and 2nd Row Underseat Storage
  • Delayed Accessory Power
  • Systems Monitor
  • Redundant Digital Speedometer
  • Outside Temp Gauge
  • Analog Display
  • Seats w/Cloth Back Material
  • Manual Adjustable Front Head Restraints and Manual Adjustable Rear Head Restraints
  • Armrests w/Storage and Rear Center Armrest
  • Front Armrest w/3 Cupholders
  • Sentry Key Engine Immobilizer

EXTERIOR

  • Wheels: 20" x 8" Aluminum Chrome Clad
  • Tires: P275/60R20 BSW AS
  • Regular Box Style
  • Center Hub
  • Aluminum Spare Wheel
  • Spare Tire Stored Underbody w/Crankdown
  • Clearcoat Paint
  • Chrome Front Bumper w/Body-Colored Rub Strip/Fascia Accent
  • Chrome Rear Step Bumper
  • Black Side Windows Trim and Black Front Windshield Trim
  • Chrome Door Handles
  • Black Exterior Mirrors
  • Power Rear Window
  • Variable Intermittent Wipers
  • Deep Tinted Glass
  • Galvanized Steel/Aluminum Panels
  • Front License Plate Bracket
  • Active Grille Shutters
  • Tailgate Rear Cargo Access
  • Fully Automatic Aero-Composite Halogen Headlamps w/Delay-Off
  • Fog Lamps
  • Tip Start

MECHANICAL

  • 3.21 Rear Axle Ratio
  • GVWR: 6,800 lbs
  • 50 State Emissions
  • Transmission w/Driver Selectable Mode and Oil Cooler
  • Black Rotary Shifter
  • Four-Wheel Drive
  • Engine Oil Cooler
  • 730CCA Maintenance-Free Battery
  • 160 Amp Alternator
  • Towing Equipment
    • Harness and Trailer Sway Control
  • Class IV Receiver Hitch
  • 1630# 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

  • 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.