query
RESULTSET
query
  DTISTOPDATE LNGMODELYEAR PK_AUTSFINCENTIVEID TXTMAKE TXTMODEL
1 2019-07-21 00:00:00.0 2019 1540 ford Fiesta SE
CACHED false
EXECUTIONTIME 0
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 = '2019' AND tblSFIncentives.txtMake = 'Ford' AND ( tblSFIncentives.txtVehicleHints LIKE '%FUEL_TYPE:G[,}]%' OR tblSFIncentives.txtVehicleHints NOT LIKE '%FUEL_TYPE:%' ) AND (tblSFIncentiveCodeLink.txtStyleID IS NOT NULL OR ( tblSFIncentives.lngModelYear = '2019' AND tblSFIncentives.txtMake = 'Ford' AND ( tblSFIncentives.txtModel = 'Fiesta' OR ( (tblSFIncentives.txtVehicleHints LIKE '%MODEL:Fiesta,%' OR tblSFIncentives.txtVehicleHints LIKE '%MODEL:Fiesta}%') AND ( (tblSFIncentives.txtVehicleHints LIKE '%TRIM:SE,%' OR tblSFIncentives.txtVehicleHints LIKE '%TRIM:SE}%') OR ( tblSFIncentives.txtVehicleHints NOT LIKE '%TRIM:%' AND (tblSFIncentives.txtVehicleHintsForExclusion NOT LIKE '%TRIM:SE,%' OR tblSFIncentives.txtVehicleHintsForExclusion NOT LIKE '%TRIM:SE}%') ) ) ) ) ) ) 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 402223
2 29
New 2019 Ford Fiesta SE - Dick Edwards Auto Plaza

2019 Ford Fiesta SE

2019 Ford Fiesta SE
MSRP:
$17,460
Dick's Discount:
- $500
Rebate:
- $2,500
You Pay:
$14,460
Style/Trim: 4dr Car
Exterior: Magnetic Metallic
Interior: CLOTH SEATS SE CHARCOAL B
Engine: 4 Cylinder Engine
Transmission: Auto-Shift Manual w/OD,Manual w/OD
Fuel Type: Gasoline Fuel
Stock: JC19128
VIN: 3FADP4BJ8KM120029
View Window Sticker
Estimate Your Payment
Apply for Credit Online
Leave this field empty
View Additional Vehicle Features

PRIMARY PAINT

  • MAGNETIC METALLIC
Gas Calculator

Request a Quote
Leave this field empty
Schedule Test Drive
Leave this field empty
Value Your Trade
Est. Finance Rates
3.9
%
APR
*
for
36
Months
OR
$3000 Factory Rebate
* On Approved Credit. Price, terms and vehicle availability may vary. Not all customers will qualify. See your participating dealer for details. Special APR not available with factory rebates. Expires: 07/21/2019
Est. Finance Rate(APR) Months
3.9% 36
4.9% 48
5.9% 60
7.9% 72
8.9% 75
* On Approved Credit • Expires: 07/21/2019
+
Available Offers
Farm Bureau Association Conquest Offer
$500 Rebate
Farm Bureau Association Conquest Offer (37264). Customers may enroll via their Farm Bureau member websites. Their membership ID is required for online enrollment only. Additionally, eligible Farm Bureau members may contact Farm Bureau Customer Service @ 1-888-322-5862 if they need assistance processing their e-Certificate. Farm Bureau members should present their e-Certificate to the Ford Dealership at time of purchase.
Select Inventory Retail Customer Cash
$500 Rebate
Select Inventory Retail Customer Cash (13566). Consumers will receive Select Inventory Retail Customer Cash on select new vehicles. Take new retail delivery from dealer stock by 09/30/19. Residency restrictions apply. See dealer for qualifications and complete details.
Tier 3-5 Ford Credit Retail Bonus Customer Cash
$500 Rebate
Tier 3-5 Ford Credit Retail Bonus Customer Cash (13410).
2019 American Quarter Horse Member Offer
$500 Rebate
2019 American Quarter Horse Member Offer CUSTOMER ELIGIBILITY - Eligible customers must be a member of AQHA for at least 60 days prior to the purchase of an eligible vehicle to qualify for this offer. Previous purchases will not be eligible for this incentive. The AQHA member links to http://www.fordspecialoffer.com/aqha from the AQHA website (www.aqha.com). They login to the website using their AQHA Member ID # and Zip Code (as printed on their AQHA Membership Card). AQHA members may contact AQHA Customer Service @ (806) 376-4811 if they need assistance processing their e-Certificate. AQHA members should present their e-Certificate to the Ford Dealership at time of purchase.
2019 College Student Purchase Program
$500 Rebate
2019 College Student Purchase Program
2019 First Responder Bonus Cash Direct Offer
$500 Rebate
2019 First Responder Bonus Cash Direct Offer - Bonus Cash offer exclusively for First Responders serving communities with the following jobs: Eligible Customers: Police - Police Officer - Sheriff/Sheriffx2019s Deputy - Correctional Officer - State Trooper - Federal Law Enforcement officer (Example: Customs, Homeland and Security, etc.) Fire Department - Career Firefighter - Volunteer Firefighter EMT - EMT - Paramedic - Customers will now be directed to www.fordspecialoffer.com/firstresponders to register and be validated online for their First Responders eligibility according to the program rules PRIOR to purchasing their vehicle.
2019 Military Appreciation Bonus Cash
$500 Rebate
2019 Military Appreciation Bonus Cash - $500 Bonus Cash offer exclusively for members of the following US Military Branches: Eligible Customers: - Active Military Personnel in the Army, Navy, Air Force, Marines, Coast Guard, National Guard - Reservists serving on Active Duty and members of the Delayed Entry/Enlistment Program (DEP) - Veterans within 2 years of separation - Retirees - Spouse/Surviving Spouse and other household members
Farm Bureau Association eCertificate Offer
$500 Rebate
Farm Bureau Association eCertificate Offer Customers may enroll via their Farm Bureau member websites. Their membership ID is required for online enrollment only. Additionally, eligible Farm Bureau members may contact Farm Bureau Customer Service @ 1-888-322-5862 if they need assistance processing their e-Certificate. Farm Bureau members should present their e-Certificate to the Ford Dealership at time of purchase.

ENTERTAINMENT

  • Radio w/Seek-Scan, Clock, Speed Compensated Volume Control and Radio Data System
  • Automatic Equalizer
  • Digital Signal Processor
  • Integrated Roof Antenna
  • 1 LCD Monitor In The Front

INTERIOR

  • Driver Seat
  • Passenger Seat
  • 60-40 Folding Bench Front Facing Fold Forward Seatback Premium Cloth Rear Seat
  • Manual Tilt/Telescoping Steering Column
  • Front Cupholder
  • Rear Cupholder
  • Compass
  • Cruise Control w/Steering Wheel Controls
  • HVAC
    • Underseat Ducts
  • Glove Box
  • Driver Foot Rest
  • Full Cloth Headliner
  • Cloth Door Trim Insert
  • Urethane Gear Shift Knob
  • Interior Trim
    • Piano Black Instrument Panel Insert, Metal-Look Console Insert and Metal-Look Interior Accents
  • Day-Night Rearview Mirror
  • Driver And Passenger Visor Vanity Mirrors
  • Full Floor Console w/Storage, Mini Overhead Console w/Storage and 1 12V DC Power Outlet
  • Fade-To-Off Interior Lighting
  • Front And Rear Map Lights
  • Carpet Floor Trim and Carpet Trunk Lid/Rear Cargo Door Trim
  • Cargo Space Lights
  • FOB Controls
    • Trunk/Hatch/Tailgate
  • Instrument Panel Bin, Driver And Passenger Door Bins
  • Analog Display
  • Systems Monitor
  • Seats w/Cloth Back Material
  • Manual Adjustable Rear Head Restraints
  • 1 Seatback Storage Pocket
  • Front Center Armrest
  • Perimeter Alarm
  • Securilock Anti-Theft Ignition (pats) Engine Immobilizer
  • 1 12V DC Power Outlet
  • Air Filtration

EXTERIOR

  • Tires: P185/60R15 BSW
  • Steel Spare Wheel
  • Compact Spare Tire Mounted Inside Under Cargo
  • Clearcoat Paint
  • Body-Colored Front Bumper
  • Body-Colored Rear Bumper w/Black Bumper Insert
  • Black Side Windows Trim and Black Front Windshield Trim
  • Body-Colored Door Handles
  • Body-Colored Power Side Mirrors w/Convex Spotter and Manual Folding
  • Fixed Rear Window w/Defroster
  • Light Tinted Glass
  • Variable Intermittent Wipers
  • Fully Galvanized Steel Panels
  • Chrome Grille
  • Trunk Rear Cargo Access
  • Perimeter/Approach Lights
  • Fully Automatic Aero-Composite Halogen Daytime Running Headlamps w/Delay-Off

MECHANICAL

  • 50-State Emissions System
  • Front-Wheel Drive
  • 4.07 Axle Ratio
  • 500CCA Maintenance-Free Battery w/Run Down Protection
  • Gas-Pressurized Shock Absorbers
  • Front Anti-Roll Bar
  • Electric Power-Assist Speed-Sensing Steering
  • 12.4 Gal. Fuel Tank
  • Single Stainless Steel Exhaust
  • Strut Front Suspension w/Coil Springs
  • Torsion Beam Rear Suspension w/Coil Springs
  • Front Disc/Rear Drum 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
  • Low Tire Pressure Warning
  • Dual Stage Driver And Passenger Front Airbags
  • Curtain 1st And 2nd Row Airbags
  • Airbag Occupancy Sensor
  • Driver Knee Airbag
  • Rear Child Safety Locks
  • Outboard Front Lap And Shoulder Safety Belts
    • Rear Center 3 Point, Height Adjusters and Pretensioners
  • Mykey System
    • Top Speed Limiter, Audio Volume Limiter, Early Low Fuel Warning, Programmable Sound Chimes and Beltminder w/Audio Mute
  • Back-Up Camera

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.

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.